RQ11901 - Software Developer - Senior
Posted Updated 45
views
Description
Description:
- Develop coding, testing, and debugging to support existing
extensions/tools such as IRT, De-Dup, OIA, Immunization Forecaster and PR
Upload
- Conduct technical analysis, preparation of detailed
programming specifications, program design, writing and/or generating code, and
conduct unit tests
- Translate technical specifications for sustainment and
upgrade into working, tested applications
- Undertake proof of technology with test data to simulate
application load and performance tuning related applications
- Provide software expertise in various computing platforms,
operating systems, database technology, communication protocols, middleware and
gateways
- Provide impact analysis, effort estimate and solution
design/development for supported solutions due to DHIR solution upgrades,
software upgrades or any new requirements (e.g. Panorama 4.4 upgrades, PHU
merge and more)
- Provide application programming support for incident
management, application functionality sustainment, performance tuning and
technical documentation
- Work with Quality Assurance (QA) to code, test, and debug
extensions/tools integration services
- Maintain Development environments and continue continuous
Integration (CI) practice
- Improve the quality and accuracy of the data collected for
the approximately 34 PHUs and 2282 PHU users
- Ensure availability of the DHIR extensions/tools for use by
all Ontarians.
Requirements
Experience and Skill Set Requirements:
Must Have:
- Design and development of Oracle(12c) for OLAP and OLTP
applications, including PL/SQL, Oracle stored procedure, packages, functions,
triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
- Advanced SQL skills, optimized database queries, and data
architecture, database design, database modeling
- Data Warehouse design and development, Database performance
tuning, Automation
- Working with business analysts to translate the business
requirements and functional specifications into an application design
appropriate to meet the business and operational/IT needs
Skill Set Requirements:
Public Sector Experience:
- Experience working with federal/provincial/broader
public-sector healthcare providers
- Knowledge of the provincial immunization system and OPS
large complex IT Health related projects or equivalent
- Experience with integration of Clinical IT Systems such as
Client and Provider Registries
- Knowledge of OPS Enterprise Architecture artifacts (or
similar), processes and practices, and ability to produce technical
documentation that comply with industry standard practices
- Knowledge of industry standard such as Project Management
Institute (PMI)
- Experience adopting and adhering to OPS Unified I&IT
Project Methodology, OPS Enterprise Architecture and OPS Gating process, and
OPS Standard Systems Development Methodologies.
Technical Skills:
10+ years of experience with:
- Design and development of Oracle(12c) for OLAP and OLTP
applications, including PL/SQL, Oracle stored procedure, packages, functions,
triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
- Demonstrated ability to create normalized database schemas
utilizing data modeling discipline. Understanding of normalization,
de-normalization, and the difference between the two. Ability to create schemas
for both OLTP and OLAP databases.
- Advanced SQL skills, optimized database queries, and data
architecture, database design, database modeling
- Data Warehouse design and development, Database performance
tuning, Automation
- Unix/Linux Shell Scripting
- Informatica for data extraction, transformation, and
loading, initial setup and other data management purposes
- Cognos report design and development, Framework manager,
Query Studio, Reports Studio, creation of dashboards, etc. Other reporting
tools would also be an asset, particularly Crystal Reports and Business Objects
- Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful
web services
- Knowledge of the provincial immunization system.
Core Skills and Experience:
10+ years of experience with:
- Working with business analysts to translate the business
requirements and functional specifications into an application design
appropriate to meet the business and operational/IT needs
- Working with technical systems specifications and
translating them into working, tested applications for large, complex, mission
critical applications
- Analysis, design and development work on complex, multi-tier
web-based applications, micro-services architecture, mobile, and off-the-shelf
solutions
- Proven technical leadership skills with ability to identify
areas for improvement, and recommend solutions
- Designing, developing and implementing applications that
work across modern browsers and various platforms, and mobile devices
- Using and applying extensive knowledge of User Interface
(UI) design principles across a variety of applications, platforms and devices
- Technical analysis, program code, detailed programming and
reports specifications, program design, writing and/or generating code, and
conducting tests
- Developing and maintaining system design models, technical
documentation and specifications
- Conducting technical evaluation and assessment of options
for technical design issues, application figuration aspects and integration
capabilities, related tools and utilities, gap analysis of integration
components to technical requirements/specifications/documentation
- Developing medical and clinical based systems
- Web performance optimization
- Various computing platforms, operating systems, database
technology, communication protocols, middleware and gateways
- Conducting technical analysis, trouble-shooting, and issue
resolutions for production operational support of reports, and other components
and utilities
- Knowledge of recognized accessibility laws, regulations, and
standards (e.g., W3C, WCAG) or other specific accessibility standards, and
experience in usability, accessibility and compliance testing
- Ensuring compliance with architecture framework and system
standards, and Agile Development Methodology
- Project management practices, and ability to contribute to
design/development project plans, including work breakdown, resource estimates,
and status reports
- Experience with Software Development Lifecycle (SDLC)
- Continuous Integration (CI) practice and DEVOPS
methodologies and technologies
- Knowledge and experience with leading-edge technologies,
design criteria including usability, security, and privacy for web and mobile
applications.
General Skills:
- Demonstrated strong leadership and people management skills
- Exceptional analytical, problem solving and decision-making
skills
- Demonstrated strong interpersonal, verbal and written
communication, and presentation skills
- Proven troubleshooting and critical thinking experience
- Demonstrated ability to apply strong listening skills to
facilitate issue resolution
- Effective consulting skills to engage with all stakeholders
with proven track record for building strong working relationships
- Excellent customer service skills, including tact and
diplomacy to ensure client needs are managed effectively
- A motivated, flexible, detail-oriented and creative team
player with perseverance, excellent organization and multi-tasking abilities,
and a proven track record for meeting strict deadlines.
Skills
Sign in to read and join the discussion.