Job Description
Assignment: RQ11209 - Software Developer - Full Stack - Senior
Job Title: Sr APEX/ORDS Software Developer
Requisition (SS): RQ11209
Start Date: 2026-08-04
Client: Land & Resources Cluster
End Date: 2027-03-31
Office Location: Anywhere in Ontario
Organization: Land & Resources Cluster
Extension # of Days: 85.00
Ministry: Ministry of Public and Business Service Delivery and Procurement
# Business Days: 170.00
Remote
Must Have:
- 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.
- Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI).
Description
- Project Description - 'APEX/ORDS Evergreening' - The goal of the APEX/ORDS evergreening initiative is to upgrade the full technical stack for 5 Ministry of Environment, Conservation and Parks business critical applications. 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.
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
Job Tags
Work at office, Remote work