Senior Oracle DBA & APEX Expert

Stantec; Mississauga; On-site; CAD 89,000 - 137,000; Full time

Benefits offered by this job

Health benefits

Dental plan

Vision plan

Wellness program

Employee stock purchase program

Job summary

Stantec is seeking a Senior Oracle APEX and Database Administrator to design, administer, and optimize Oracle databases and APEX/ORDS platforms across DEV, QA, and PROD. You will collaborate with DBA, middleware, and application teams to ensure high availability, security, and performance of critical business applications.

The role requires 5–10+ years of Oracle DB experience, strong APEX/ORDS knowledge, and proficiency with Linux/Unix, RMAN, and DB upgrades.

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.

Responsibilities

• Manage and maintain Oracle databases across multiple environments.
• Install, upgrade, patch, and migrate databases.
• Implement backup/recovery strategies and DR solutions.
• Monitor performance, tune SQL, memory, and storage.
• Manage database security, roles, and access controls.
• Support PDB/CDB architecture and consolidation strategies.
• Install, configure, and upgrade Oracle APEX and ORDS environments.
• Manage APEX schemas, users, and workspaces.
• Support APEX deployments and lifecycle management.
• Troubleshoot APEX performance and connectivity.
• Coordinate between APEX and enterprise systems (APIs, EBS).
• Provide Tier 3 support for DB and APEX incidents.

Skills

Oracle DBA experience

PL/SQL

Performance tuning

Troubleshooting

Cross-team collaboration

Tools

Oracle APEX

ORDS

RMAN

WebLogic

Job description

Stantec is seeking a Senior Oracle APEX and Database Administrator to design, administer, and optimize Oracle databases and APEX/ORDS platforms across DEV, QA, and PROD. You will collaborate with DBA, middleware, and application teams to ensure high availability, security, and performance of critical business applications.

The role requires 5–10+ years of Oracle DB experience, strong APEX/ORDS knowledge, and proficiency with Linux/Unix, RMAN, and DB upgrades.