Senior Oracle APEX & DB Admin — Multi-Env, High Availability

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

Benefits offered by this job

Health benefits

Stock purchase program

Tuition reimbursement

Job summary

Stantec is seeking a Senior Oracle DBA to support enterprise Oracle databases and APEX/ORDS environments. The role focuses on design, administration, performance, and lifecycle management across DEV, QA, and PROD.

The candidate will collaborate with DBA, middleware, and application teams to ensure high availability, security, and performance. Strong experience in Oracle 19c+, PL/SQL, and Linux/Unix is essential.

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 multiple environments.
• Install, upgrade, patch, and migrate Oracle databases.
• Implement backup/recovery strategies and disaster recovery solutions.
• Monitor database performance, tune SQL, memory, and storage.
• Manage database security, roles, and access controls.
• Support PDB/CDB architecture and database consolidation strategies.
• Install, configure, and upgrade Oracle APEX and ORDS environments.
• Manage APEX schemas, users, and workspace configurations.
• Support APEX deployments and lifecycle management.
• Troubleshoot APEX performance, session management, and runtime issues.

Skills

Oracle Database Admin

Oracle APEX/ORDS

PL/SQL

Linux/Unix

Performance tuning

RMAN backup

Migrations

Team collaboration

Tools

Oracle APEX

ORDS

WebLogic

OCI

SQL Server

PostgreSQL/MySQL

Job description

Stantec is seeking a Senior Oracle DBA to support enterprise Oracle databases and APEX/ORDS environments. The role focuses on design, administration, performance, and lifecycle management across DEV, QA, and PROD.

The candidate will collaborate with DBA, middleware, and application teams to ensure high availability, security, and performance. Strong experience in Oracle 19c+, PL/SQL, and Linux/Unix is essential.