Join our team as a Senior Oracle APEX/ORDS Developer to modernize Ontario’s mission-critical Air Quality systems as part of a major evergreening initiative. You'll lead the development of secure, cloud-ready web applications using Oracle APEX and Oracle REST Data Services (ORDS), supporting backend integration, performance tuning, and migration to Oracle Cloud Infrastructure. In this hybrid role, you’ll engage in full SDLC activities, apply security best practices, and ensure compliance with accessibility standards. Ideal for experienced developers with strong problem-solving skills, cloud familiarity, and a collaborative approach to delivering scalable and resilient public sector solutions.

 

To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.

 

Project Description - 'Air Quality Suite Evergreening' - The goal of the Air Quality suite evergreening initiative is to upgrade the full technical stack for Ontario's Mission Critical Air Quality I&IT solutions. The current suite is built with Oracle database, APEX/ORDS, and Red Hat Linux OS software which are all at end-of-life support with the manufacturer. To stay secure and compliant with Ontario's Digital and Data Strategy, the systems software and hardware technical components must be upgraded - A process known as Evergreening . Cloud hosting is targeted as part of this evergreening.

 

This Statement of Work (SOW) shall expire on 31st March 2026. Clients may exercise its option(s) to extend the SOW beyond 31st March 2026. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 1 2026 and be upon the same terms, conditions and covenants contained in the SOW

Skills

Experience and Skill Set Requirements

Responsibilities

• An Oracle APEX and ORDS Developer is needed to design, develop, and maintain web applications using the Oracle APEX platform, with a focus on utilizing Oracle REST Data Services (ORDS) for backend integration and API development. The role requires experience with the full software development lifecycle, including data architecture, development, maintenance, and support. 

• Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.

• Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.

 

General Skills

 

• Knowledge and understanding of Information Management principles, concepts, policies and practices

• Experience with middleware and gateways

• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging

• Ability to provide post-implementation support and resolve any post-implementation technical issues

• Experience conducting design walkthrough sessions with project team

• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA)

and related regulations and standards

• Ability to provide user and system documentation as required

 

Evaluation Criteria

 

Technical Knowledge and Skill - 70%

10+ years experience with/related to the following:

• Application Development: Designing, developing, and implementing web applications using Oracle APEX, a low-code development platform. Proven experience in developing applications using Oracle APEX.  Experience with advanced APEX features like interactive reports, charts, and dynamic actions. 
• Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database.  Solid understanding of Oracle REST Data Services (ORDS) and its capabilities. 
• Database Management: Working with the Oracle database, including data modeling, SQL, and PL/SQL development. Strong knowledge of Oracle databases, including SQL, PL/SQL, and data modeling. 
• Full SDLC: Participating in all phases of the software development lifecycle, from requirements gathering and design to testing, deployment, and ongoing maintenance.  Experience with HTML, CSS, JavaScript, and other web technologies. 
• Security: Ensuring the security of the Oracle APEX platform and the applications built upon it.  Knowledge of security best practices for web applications. 
• Solution Architecture Analysis and recommendations: Ability to assess 'as is' state of legacy applications and assist in providing recommendations to a supported 'to be' state.
• Performance tuning: Experience with optimizing application performance. 
• Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI). 

 

 

Analytical, Problem Solving, Communication and Collaboration: 30%

• Working closely with other developers, designers, and stakeholders to build high-quality applications. 
• Strong ability to work with technical and non-technical team mates.
• Troubleshooting and Support: Identifying and resolving issues within the application and its underlying infrastructure.
• Self starter with ability to track activities and update work/deliverables on team boards Kanban/DevOps
• Strong verbal, written and interpersonal skills
• Strong ability to document technical procedures and facilitate transition to operations knowledge transfer sessions.
• Strong record keeping and documentation skills

Supplier Comments

Assigning Type - Remote (Candidate must be in Ontario)

Max no of submission- 1( one)

 

Must Haves:

• Application Development: Designing, developing, and implementing web applications using Oracle APEX, a low-code development platform. Proven experience in developing applications using Oracle APEX. Experience with advanced APEX features like interactive reports, charts, and dynamic actions. 
• Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database.  Solid understanding of Oracle REST Data Services (ORDS) and its capabilities. 
• Security: Ensuring the security of the Oracle APEX platform and the applications built upon it.  Knowledge of security best practices for web applications. 
• Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI)
• Strong ability to work with technical and non-technical team mates.
• Troubleshooting and Support: Identifying and resolving issues within the application and its underlying infrastructure.