Sr. Oracle APEXORDS Software Developer

This is a remote position.

Sr. APEX/ORDS Software Developer

Location: Remote (Ontario Government)
Closing Date: July: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 Ontarios 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
  

Required Skills:

Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing deploying and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms storage solutions networking and enterprise infrastructure services. Strong understanding of cloud architecture frameworks technology assessments and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication authorization and access governance controls. DevOps & CI/CD Automation Strong experience designing building and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies automation frameworks and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms enterprise systems and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security Monitoring & Compliance Strong understanding of infrastructure security cloud security and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting evidence gathering and log analysis. Experience supporting forensic investigations audit remediation and incident reviews. Familiarity with Government of Ontario I&IT Directives Policies and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes deployment approvals rollback planning and release governance. Experience with release readiness reviews deployment validation and post-release monitoring. Ability to maintain release documentation operational records and audit artifacts. Project Management & Communication Strong project planning coordination and resource management skills. Experience with roadmap planning modernization initiatives and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users leadership teams and non-technical stakeholders. Strong documentation reporting presentation and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance compliance frameworks and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience disaster recovery and enterprise monitoring strategies. Additional Information Strong hands-on DevOps cloud infrastructure automation CI/CD security and enterprise release management experience is mandatory for this role.

Employment Type : Full Time
Experience: years
Vacancy: 1
Monthly Salary Salary: 70 - 70