Sr. Oracle APEX/ORDS Software Developer

This is a remote position.

Sr. APEX/ORDS Software Developer

Location: Remote (Ontario Government)

Closing Date: July 14, 2026 – 10:00 AM

Project: APEX/ORDS Evergreening

Project Overview

The APEX/ORDS Evergreening initiative aims to modernize five mission-critical applications for the Ministry of Environment, Conservation and Parks (MECP). The project involves upgrading Oracle Database, Oracle APEX, Oracle REST Data Services (ORDS), and Red Hat Linux infrastructure that has reached end-of-life, while preparing the applications for cloud hosting in alignment with Ontario's Digital and Data Strategy.

Key Responsibilities

• Design, develop, enhance, and maintain enterprise web applications using Oracle APEX.
  
• Develop RESTful APIs and backend services using Oracle REST Data Services (ORDS).
  
• Translate technical specifications into well-designed, tested, and maintainable applications.
  
• Develop SQL and PL/SQL code, stored procedures, packages, and database objects.
  
• Design and optimize Oracle database schemas and data models.
  
• Participate in all phases of the Software Development Life Cycle (SDLC), including:
  
• Requirements analysis
  
• Design
  
• Development
  
• Unit testing
  
• Deployment
  
• Maintenance
  
• Perform application performance tuning and optimization.
  
• Analyze legacy applications and provide modernization recommendations.
  
• Support implementation, migrations, and post-production issues.
  
• Review and modify installation and deployment scripts.
  
• Conduct design walkthroughs and technical knowledge transfer sessions.
  
• Produce technical documentation, system documentation, and operational procedures.
  
• Ensure applications comply with security best practices and AODA accessibility standards.
  
• Collaborate with developers, business teams, architects, and stakeholders.
  
• Track work using Kanban/Azure DevOps boards.
  

Mandatory Technical Skills

Oracle APEX Development (10+ Years)

• Enterprise application development using Oracle APEX
  
• Interactive Reports
  
• Interactive Grids
  
• Charts
  
• Dynamic Actions
  
• Forms
  
• Authentication & Authorization
  
• APEX security
  
• Responsive UI development
  

Oracle REST Data Services (ORDS)

• REST API development
  
• ORDS configuration
  
• Backend integration
  
• JSON services
  
• RESTful web services
  
• API security
  

Oracle Database

• Oracle Database administration concepts
  
• SQL
  
• PL/SQL
  
• Packages
  
• Procedures
  
• Functions
  
• Triggers
  
• Views
  
• Data Modeling
  
• Performance tuning
  
• Query optimization
  

Web Technologies

• HTML
  
• CSS
  
• JavaScript
  
• Web application architecture
  

Cloud Experience

Experience with:

• Oracle Cloud Infrastructure (OCI)
  

Preferred experience includes:

• Cloud migration
  
• Cloud-hosted Oracle environments
  
• Application modernization
  

Solution Architecture

• Legacy application assessment
  
• Current-state ("As-Is") analysis
  
• Future-state ("To-Be") architecture recommendations
  
• Application modernization strategies
  

Security

• Oracle APEX security
  
• Secure coding practices
  
• REST API security
  
• Authentication
  
• Authorization
  
• OWASP principles
  

Performance Tuning

Experience optimizing:

• Oracle SQL
  
• PL/SQL
  
• Oracle APEX applications
  
• ORDS services
  
• Database performance
  

General Skills

• Knowledge of Information Management principles
  
• Middleware and gateway experience
  
• Installation script review and modification
  
• Troubleshooting and production support
  
• Implementation and migration support
  
• Design walkthrough facilitation
  
• Technical documentation
  
• Operational knowledge transfer
  
• Post-implementation support
  
• Strong record keeping
  

Accessibility

Knowledge of:

• Accessibility for Ontarians with Disabilities Act (AODA)
  
• WCAG accessibility standards
  
• Accessible application development
  

Soft Skills

• Strong analytical and problem-solving skills
  
• Excellent verbal and written communication
  
• Ability to work with technical and business stakeholders
  
• Team collaboration
  
• Self-starter with minimal supervision
  
• Experience using Kanban/Azure DevOps boards
  
• Strong documentation skills
  
• Ability to troubleshoot complex production issues
  

Evaluation Criteria

Technical Skills (70%)

• 10+ years Oracle APEX development
  
• Oracle REST Data Services (ORDS)
  
• Oracle Database (SQL, PL/SQL, Data Modeling)
  
• Full SDLC experience
  
• HTML/CSS/JavaScript
  
• Application security
  
• Solution architecture analysis
  
• Performance tuning
  
• Oracle Cloud Infrastructure (OCI)
  

Communication & Collaboration (30%)

• Strong analytical skills
  
• Team collaboration
  
• Communication with technical and non-technical stakeholders
  
• Production support and troubleshooting
  
• Documentation and knowledge transfer
  
• Experience tracking work in Kanban/Azure DevOps
  

Must-Have Skills

• 10+ years Oracle APEX application development
  
• Oracle REST Data Services (ORDDS) development
  
• Oracle SQL and PL/SQL
  
• Oracle Database design and data modeling
  
• REST API development
  
• Performance tuning
  
• Full SDLC experience
  
• HTML, CSS, JavaScript
  
• Oracle Cloud Infrastructure (OCI)
  
• Legacy application modernization
  
• Strong troubleshooting and production support experience
  
• AODA accessibility knowledge
  
• Excellent communication and documentation skills