Senior Oracle DB & APEX Engineer

Stantec; Toronto; On-site; CAD 94,600 - 137,100; Full time

Benefits offered by this job

Health, dental & vision plans

Wellness program

RRSP/Stock purchase program

Paid time off

Job summary

Stantec seeks a Senior Oracle APEX and Database Administrator to design, administer, and optimize Oracle databases and APEX/ORDS environments. This role supports critical business applications across development, QA, and production with a focus on high availability and security.

You will collaborate with DBA, middleware, and application teams to ensure robust performance, scalable architecture, and proactive troubleshooting in a large enterprise setting.

Qualifications

• 5–10+ years of Oracle Database Administration experience
• Strong experience with Oracle APEX and ORDS administration
• Deep knowledge of: Oracle 19c+ database architecture
• PL/SQL, performance tuning, and troubleshooting
• Experience with Linux/Unix environments
• Backup/recovery strategies (RMAN)
• Database upgrades and migrations
• Strong troubleshooting and problem-solving skills in complex environments

Responsibilities

• Manage and maintain Oracle databases across environments
• Install, configure, and upgrade Oracle APEX and ORDS
• Support multi-environment setups (DEV, QA, PROD) and server configurations
• Provide Tier 3 support for database and APEX incidents
• Develop automation scripts for deployments, monitoring, and maintenance
• Improve DBA processes and CI/CD pipelines for database and APEX deployments

Skills

Oracle DBA

Oracle APEX

ORDS

Linux/Unix

RMAN backups

SQL performance tuning

Security & access control

DB upgrades & migrations

CI/CD for databases

Data Guard

Tools

WebLogic

OCI

Job description

Stantec seeks a Senior Oracle APEX and Database Administrator to design, administer, and optimize Oracle databases and APEX/ORDS environments. This role supports critical business applications across development, QA, and production with a focus on high availability and security.

You will collaborate with DBA, middleware, and application teams to ensure robust performance, scalable architecture, and proactive troubleshooting in a large enterprise setting.