Senior Oracle APEX & DB Admin: HA, Automation & CI/CD

Stantec; Vancouver; Vor Ort; CAD 95.000 - 137.000; Vollzeit

Benefits dieser Stelle

Health benefits

Wellness program

RRSP/retirement plan

Employee stock purchase program

Zusammenfassung

Stantec is seeking a Senior Oracle APEX and Database Administrator to support and optimize enterprise Oracle databases and APEX/ORDS environments. You will ensure high availability, security, and performance across development, QA, and production landscapes.

You will collaborate with DBA, middleware, and application teams, lead deployment activities, and contribute to automation and CI/CD pipelines while adhering to security and audit requirements.

Qualifikationen

• 5–10+ years of Oracle Database Administration experience.
• Strong experience with Oracle APEX and ORDS administration.
• Deep knowledge of Oracle 19c+ database architecture and SQL tuning.
• Proficient in PL/SQL, performance tuning and troubleshooting.
• Experience with Linux/Unix environments and RMAN backups.
• Database upgrades and migrations across DEV/QA/PROD.

Aufgaben

• Manage and maintain Oracle databases across multiple environments.
• Install, upgrade, patch, and migrate databases; performance tuning.
• Design and implement backup/recovery and DR strategies.
• Administer Oracle APEX/ORDS environments and security.
• Support multi-environment setups and CI/CD for deployments.
• Provide Tier 3 support and troubleshoot complex incidents.

Kenntnisse

Oracle DBA

Oracle APEX/ORDS

Oracle 19c+

PL/SQL

Linux/Unix

RMAN backups

Upgrades & Migrations

Troubleshooting

Tools

WebLogic

OCI

Jobbeschreibung

Stantec is seeking a Senior Oracle APEX and Database Administrator to support and optimize enterprise Oracle databases and APEX/ORDS environments. You will ensure high availability, security, and performance across development, QA, and production landscapes.

You will collaborate with DBA, middleware, and application teams, lead deployment activities, and contribute to automation and CI/CD pipelines while adhering to security and audit requirements.