Software Developer - Senior

Job Overview

The Health Services Cluster is seeking Senior Software Developers to support the Voluntary Mergers of Public Health Units (PHUs) initiative.

The selected resources will be responsible for designing, developing, testing, debugging, maintaining, and enhancing existing applications and extensions supporting the provincial immunization system and related healthcare solutions.

The role involves working with Oracle databases, PL/SQL, data warehousing, application integration, performance optimization, and continuous integration practices to ensure the availability, accuracy, and reliability of critical healthcare applications used across Ontario.

Key Responsibilities

• Develop, code, test, and debug existing extensions and tools, including IRT, De-Dup, OIA, Immunization Forecaster, and PR Upload.

• Conduct technical analysis, prepare detailed programming specifications, design programs, write and generate code, and perform unit testing.

• Translate technical specifications for application sustainment and upgrades into functional, tested applications.

• Conduct proof-of-technology exercises using test data to simulate application load and support performance tuning.

• Provide software development expertise across computing platforms, operating systems, database technologies, communication protocols, middleware, and gateways.

• Perform impact analysis, effort estimation, and solution design and development for system upgrades and new business requirements.

• Support DHIR solution upgrades, including Panorama upgrades and Public Health Unit mergers.

• Provide application programming support for incident management, application functionality, sustainment, performance tuning, and technical documentation.

• Collaborate with Quality Assurance teams to code, test, and debug application extensions and integration services.

• Maintain development environments and support Continuous Integration (CI) practices.

• Improve the quality and accuracy of data collected across approximately 34 Public Health Units and their users.

• Ensure the availability and reliability of DHIR extensions and tools for use by Ontarians.

Experience and Skill Set Requirements

Public Sector and Healthcare Experience

• Experience working with federal, provincial, or broader public-sector healthcare providers.

• Knowledge of provincial immunization systems and large, complex OPS healthcare IT projects or equivalent.

• Experience integrating clinical IT systems, including Client and Provider Registries.

• Knowledge of OPS Enterprise Architecture artifacts, processes, and practices, with the ability to produce technical documentation aligned with industry standards.

• Knowledge of Project Management Institute (PMI) standards and practices.

• Experience adopting and adhering to OPS Unified I&IT Project Methodology, OPS Enterprise Architecture, OPS Gating processes, and OPS Standard Systems Development Methodologies.

Technical Skills and Database Development

• Ten or more years of experience designing and developing Oracle 12c databases for OLAP and OLTP applications.

• Strong expertise in PL/SQL, Oracle stored procedures, packages, functions, triggers, ref cursors, dynamic SQL, and DBMS packages.

• Demonstrated ability to create normalized database schemas using established data modelling disciplines.

• Strong understanding of database normalization, denormalization, and schema design for OLTP and OLAP databases.

• Advanced SQL skills, including query optimization, data architecture, database design, and database modelling.

• Experience in data warehouse design and development, database performance tuning, and automation.

• Experience with Unix/Linux shell scripting.

• Experience using Informatica for data extraction, transformation, loading, initial setup, and data management.

• Experience with Cognos report design and development, including Framework Manager, Query Studio, Report Studio, and dashboard development.

• Knowledge of other reporting tools such as Crystal Reports and Business Objects is an asset.

• Knowledge of Java, JSON, XML, API calls, HL7/FHIR, and RESTful web services.

• Knowledge of provincial immunization systems.

Core Development Skills and Experience

• Ten or more years of experience translating business requirements and functional specifications into application designs that meet business, operational, and IT needs.

• Experience translating technical system specifications into working, tested applications for large, complex, mission-critical systems.

• Experience in technical analysis, design, and development of complex, multi-tier web-based applications, microservices architectures, mobile applications, and off-the-shelf solutions.

• Proven technical leadership skills, including identifying areas for improvement and recommending appropriate solutions.

• Experience designing, developing, and implementing applications across modern browsers, platforms, and mobile devices.

• Strong understanding of User Interface (UI) design principles across different applications, platforms, and devices.

• Experience preparing technical analyses, programming specifications, report specifications, program designs, code, and test cases.

• Experience developing and maintaining system design models, technical documentation, and specifications.

• Ability to conduct technical evaluations and assess options for technical design issues, application configuration, and integration capabilities.

• Experience performing gap analysis of integration components against technical requirements, specifications, and documentation.

• Experience developing medical and clinical-based systems.

• Knowledge of web performance optimization techniques.

• Strong understanding of computing platforms, operating systems, database technologies, communication protocols, middleware, and gateways.

• Experience troubleshooting and resolving production support issues involving reports, applications, components, and utilities.

• Knowledge of accessibility laws, regulations, and standards, including W3C and WCAG.

• Experience with usability, accessibility, and compliance testing.

• Experience ensuring compliance with enterprise architecture frameworks and system standards.

• Experience working with Agile Development Methodologies.

• Knowledge of project management practices, including work breakdown structures, resource estimation, project plans, and status reporting.

• Strong understanding of Software Development Life Cycle (SDLC).

• Experience with Continuous Integration (CI), DevOps methodologies, and related technologies.

• Knowledge of modern technologies and design principles, including usability, security, and privacy for web and mobile applications.

General Skills

• Strong leadership and people management skills.

• Exceptional analytical, problem-solving, and decision-making abilities.

• Excellent interpersonal, verbal, written communication, and presentation skills.

• Strong troubleshooting and critical-thinking capabilities.

• Effective listening skills to facilitate issue resolution.

• Strong consulting skills and the ability to engage stakeholders and build effective working relationships.

• Excellent customer service skills, tact, and diplomacy when managing client requirements.

• Ability to work independently and collaboratively as a team player.

• Flexible, motivated, detail-oriented, and creative approach to work.

• Strong organizational and multitasking abilities.

• Proven ability to meet strict deadlines.

Mandatory / Must-Have Skills

Candidates must demonstrate strong hands-on experience in the following areas:

• Oracle 12c database design and development for OLAP and OLTP applications.

• PL/SQL, stored procedures, packages, functions, triggers, ref cursors, dynamic SQL, and DBMS packages.

• Advanced SQL, optimized database queries, data architecture, database design, and database modelling.

• Data warehouse design and development.

• Database performance tuning and automation.

• Translating business requirements and functional specifications into appropriate application designs in collaboration with Business Analysts.