Client: Ministry of Public and Business Service Delivery and Procurement – RQ11901
We are seeking a highly experienced Senior Software Developer with strong expertise in Oracle Database (12c), PL/SQL, SQL development, data warehousing, database architecture, performance tuning, and enterprise application development. The ideal candidate will have extensive experience designing, developing, maintaining, and optimizing complex OLAP and OLTP applications, including Oracle stored procedures, packages, functions, triggers, ref cursors, dynamic SQL, and DBMS packages. The successful candidate will support the development, enhancement, integration, and maintenance of healthcare-related applications and tools, ensuring data accuracy, system availability, application performance, and compliance with Ontario Public Service (OPS) standards and methodologies.
Role Snapshot
-
Job Title: RQ11901 – Software Developer – Senior
-
Client: Ministry of Public and Business Service Delivery and Procurement
-
Work Location: Toronto, Ontario, Canada
-
Work Arrangement: Onsite – 5 Days per Week
-
Estimated Start Date: December 14, 2026
-
Estimated End Date: March 7, 2028
-
Business Days: 305.00
-
Extension: Probable after the initial mandate
-
Hours: 7.25 hours per day
-
Working Schedule: Monday to Friday, between 8:00 AM and 5:00 PM, excluding lunch breaks
-
Security Level: CRJMC
Must Have
-
Design and development of Oracle (12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedures, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
-
Advanced SQL skills, optimized database queries, data architecture, database design, and database modelling.
-
Data Warehouse design and development, database performance tuning, and automation.
-
Experience working with business analysts to translate business requirements and functional specifications into application designs appropriate to meet business and operational/IT needs.
Description
The successful candidate will be responsible for developing, enhancing, supporting, and maintaining existing healthcare application extensions and tools, ensuring their performance, reliability, and availability.
Key responsibilities include:
-
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 upgrades 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 estimates, 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 approximately 34 PHUs and 2,282 PHU users.
-
Ensure availability of the DHIR extensions/tools for use by all Ontarians.
Experience and Skill Set Requirements
1. Public Sector Experience – 5 Points
-
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 complies with industry-standard practices.
-
Knowledge of industry standards 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.
2. Technical Skills – 45 Points
10+ years of experience with:
-
Design and development of Oracle (12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedures, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
-
Demonstrated ability to create normalized database schemas utilizing data modelling 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, data architecture, database design, and database modelling.
-
Data Warehouse design and development, database performance tuning, and 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, and RESTful web services.
-
Knowledge of the provincial immunization system.
3. Core Skills and Experience – 20 Points
10+ years of experience with:
-
Working with business analysts to translate business requirements and functional specifications into application designs appropriate to meet 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 the 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 configuration 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, troubleshooting, 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 frameworks 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.
4. General Skills – 30 Points
-
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 a 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 multitasking abilities, and a proven track record for meeting strict deadlines.
How to Apply
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to hrsmss@smsoftconsulting.com by Wednesday, November 18, 2026, at 2:30 AM EST.
Mandatory Documents:
-
Updated Resume in Word format (Mandatory)
-
References (Mandatory)
-
Expected Hourly Rate (Mandatory)
-
Visa Status (Mandatory)
-
LinkedIn ID (Mandatory)
Without the mandatory documents, we cannot submit a candidate.
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join our WhatsApp Group
Additional Information
This position is listed as Onsite. The resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00 AM and 5:00 PM, excluding lunch breaks, every Monday to Friday inclusive, at the identified Ontario Public Service (OPS) office location.
Extension/Amendment Attestation
Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value, including any extension options set out in the original Statement of Work (SOW).
Onsite Requirement: 5 days per week.
Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
