Senior Oracle DBA & APEX/ORDS Architect

Stantec Consulting International Ltd.; Edmonton; On-site; CAD 89,000 - 137,000; Full time

Job summary

Stantec Consulting International Ltd. in Canada is seeking a Senior Oracle APEX and Database Administrator to design, implement, and optimize Oracle databases and APEX/ORDS environments across DEV, QA, and PROD.

You will collaborate with DBA, middleware, and application teams to ensure high availability, security, and performance for critical business applications. This role requires strong PL/SQL, 19c+ architecture, RMAN backups, and experience with WebLogic and OCI.

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 skills in complex environments.

Responsibilities

• Manage and maintain Oracle databases across multiple environments.
• Install, upgrade, patch, and migrate database software.
• Implement backup/recovery and disaster recovery strategies.
• Monitor and tune SQL, memory, and storage for performance.
• Manage database security, roles, and access controls.
• Support APEX/ORDS environments and deployments.
• Coordinate upgrades with cross-functional teams.
• Develop automation for deployments and monitoring.

Skills

Oracle Database Administration

Oracle APEX

ORDS

PL/SQL

Linux/Unix

Performance tuning

RMAN

Database upgrades

Troubleshooting

Tools

ORDS

WebLogic

OCI

SQL Server

CI/CD

Job description

Stantec Consulting International Ltd. in Canada is seeking a Senior Oracle APEX and Database Administrator to design, implement, and optimize Oracle databases and APEX/ORDS environments across DEV, QA, and PROD.

You will collaborate with DBA, middleware, and application teams to ensure high availability, security, and performance for critical business applications. This role requires strong PL/SQL, 19c+ architecture, RMAN backups, and experience with WebLogic and OCI.