Software Developer - Full Stack

Job Title: Software Developer - Full Stack - Senior
Assignment: Sr APEX/ORDS Software Developer
Location: Anywhere in Ontario
Work Model: Remote
Duration: 8 Months
Extension: 1 Extension
Submission Deadline: 2026-07-14, 10:00 a.m. EST

Must Haves

• Application Development: Designing, developing, and implementing web applications using Oracle APEX. Proven experience with advanced APEX features including interactive reports, charts, and dynamic actions.
• Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating Oracle database data.
• Database Management: Strong Oracle database experience including SQL, PL/SQL, data modelling, and database development.
• Cloud Experience: Familiarity with Oracle Cloud Infrastructure (OCI).

Description / Responsibilities / Skills

Project Description

APEX/ORDS Evergreening

The goal of the APEX/ORDS Evergreening initiative is to upgrade the full technical stack for five Ministry of Environment, Conservation and Parks business-critical applications.

The current application suite is built on:

• Oracle Database
• Oracle APEX
• Oracle REST Data Services (ORDS)
• Red Hat Linux

These technologies are at end-of-life support and require modernization to remain secure and compliant with Ontario's Digital and Data Strategy.

Cloud hosting is targeted as part of the modernization effort.

Responsibilities

An Oracle APEX and ORDS Developer is required to:

• Design, develop, and maintain web applications using Oracle APEX.
• Utilize Oracle REST Data Services (ORDS) for backend integration and API development.
• Translate technical specifications into working, tested applications.
• Develop programming specifications.
• Write and maintain application code.
• Conduct unit testing.
• Troubleshoot software issues.
• Provide technical support for implementation, conversion, and migration activities.
• Participate in all phases of the software development lifecycle.

General Skills

• Knowledge of Information Management principles, concepts, policies, and practices.
• Experience with middleware and gateway technologies.
• Experience reviewing, analysing, modifying, encoding, testing, and debugging installation scripts.
• Ability to provide post-implementation support.
• Experience conducting design walkthrough sessions.
• Knowledge of Accessibility for Ontarians with Disabilities Act (AODA).
• Ability to produce user and system documentation.

Experience & Skill Set Requirements

Technical Knowledge & Skills 70%

10+ Years Experience In:

Application Development

• Designing, developing, and implementing Oracle APEX applications.
• Building web applications using Oracle APEX low-code platform.
• Advanced APEX features:
• Interactive Reports
• Interactive Grids
• Charts
• Dynamic Actions

Backend Integration

• Oracle REST Data Services (ORDS).
• RESTful API development.
• Data access and integration through ORDS.
• API security and integration patterns.

Database Management

• Oracle Database development.
• SQL.
• PL/SQL.
• Data modelling.
• Database architecture and design.

Full SDLC

• Requirements gathering.
• Design.
• Development.
• Testing.
• Deployment.
• Maintenance and support.

Web Development

• HTML.
• CSS.
• JavaScript.
• Web application architecture.

Security

• Web application security best practices.
• Oracle APEX security.
• Secure coding practices.

Solution Architecture

• Legacy application assessment.
• Current-state ("As-Is") analysis.
• Future-state ("To-Be") recommendations.
• Modernization planning.

Performance Tuning

• Application performance optimization.
• SQL and database performance tuning.
• Scalability improvements.

Cloud Experience

• Oracle Cloud Infrastructure (OCI).
• Cloud-hosted Oracle environments.

Analytical, Problem Solving, Communication & Collaboration 30%

• Work closely with developers, designers, architects, and stakeholders.
• Strong ability to communicate with technical and non-technical teams.
• Troubleshoot application and infrastructure issues.
• Self-starter with ability to manage work assignments independently.
• Experience updating work items in Kanban and DevOps boards.
• Strong verbal and written communication skills.
• Experience documenting technical procedures.
• Experience facilitating knowledge transfer sessions.
• Strong documentation and record-keeping skills.