Senior Oracle APEX & Database Specialist

Stantec; Edmonton; On-site; CAD 89,200 - 137,100; Full time

Benefits offered by this job

Health plan

Dental plan

Vision plan

Wellness program

RRSP / 401k equivalent

Employee stock purchase program

Life insurance

Disability coverage

Tuition reimbursement

Paid time off

Job summary

Stantec is seeking a Senior Oracle APEX and Database Administrator to support enterprise database platforms and Oracle APEX/ORDS environments. You will design, administer, and optimize databases, ensuring high availability, performance, and security across development, QA, and production settings.

The role requires collaboration with DBA, middleware, and application teams, with a focus on deployment, tuning, and automation of SQL and database processes.

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 environments (DEV/QA/PROD).
• 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 APEX/ORDS deployments and lifecycle management.
• Coordinate upgrades with cross-functional teams.
• Provide Tier 3 support for incidents.
• Develop automation scripts for deployments and monitoring.

Skills

Strong communication

Cross-team collaboration

Leadership

Ownership mindset

Detail-oriented

Prioritization

Tools

Oracle Database

Oracle APEX

ORDS

Linux/Unix

RMAN

Job description

Stantec is seeking a Senior Oracle APEX and Database Administrator to support enterprise database platforms and Oracle APEX/ORDS environments. You will design, administer, and optimize databases, ensuring high availability, performance, and security across development, QA, and production settings.

The role requires collaboration with DBA, middleware, and application teams, with a focus on deployment, tuning, and automation of SQL and database processes.