Senior Oracle DBA & APEX/ORDS Specialist

Stantec Consulting International Ltd.; Halifax; On-site; CAD 89,200 - 137,100; Full time

Benefits offered by this job

Health, dental, vision plans

Wellness program

Health care spending account

Group retirement savings plan

Employee stock purchase program

Life and AD&D insurance

Short-term/long-term disability

Tuition reimbursement

Paid time off

Job summary

Stantec Consulting International Ltd. is seeking a Senior Oracle APEX and Database Administrator to support and optimize Oracle databases and APEX/ORDS environments.

You will design, administer, and monitor multi-environment deployments while coordinating with DBA, middleware, and application teams to ensure high availability and security across development, QA, and production. The role emphasizes upgrades, migrations, performance tuning, and automation of deployments, with on-call

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

Responsibilities

• Manage and maintain Oracle databases across DEV/QA/PROD environments.
• Install, configure, and upgrade Oracle APEX and ORDS environments.
• Monitor performance, tune SQL/memory/storage, and ensure security.
• Coordinate with cross-functional teams for upgrades and deployments.
• Provide Tier 3 support for Oracle DB and APEX incidents.
• Develop automation scripts for deployments, monitoring, and maintenance.

Skills

Oracle Database Administration

Oracle APEX administration

PL/SQL

Performance tuning

Troubleshooting

Linux/Unix environments

RMAN (Backup/Recovery)

Database upgrades/migrations

CI/CD pipelines (DB/APEX)

Tools

WebLogic

Oracle Data Guard

OCI (Cloud)

Job description

Stantec Consulting International Ltd. is seeking a Senior Oracle APEX and Database Administrator to support and optimize Oracle databases and APEX/ORDS environments.

You will design, administer, and monitor multi-environment deployments while coordinating with DBA, middleware, and application teams to ensure high availability and security across development, QA, and production. The role emphasizes upgrades, migrations, performance tuning, and automation of deployments, with on-call