Senior Oracle APEX & Database Performance Lead

Stantec Consulting International Ltd.; Winnipeg; On-site; CAD 94,000 - 137,100; Full time

Benefits offered by this job

Health, dental, and vision plans

Wellness program

Group retirement savings plan

Employee stock purchase program

Tuition reimbursement

Job summary

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

The role collaborates with DBA, middleware, and application teams to ensure high availability, security, and performance, while contributing to automation and CI/CD pipelines for database deployments.

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 (DEV, QA, PROD).
• Install, upgrade, patch, and migrate Oracle databases; implement backup/recovery and DR solutions.
• Monitor performance, tune SQL/memory/storage; manage security, roles, and access controls.
• Install, configure, and upgrade Oracle APEX/ORDS; manage schemas, users, and workspaces.
• Coordinate with WebLogic or application servers; support deployments and lifecycle management.
• Provide Tier 3 support for database and APEX incidents; troubleshoot complex issues.
• Develop automation scripts for deployments, monitoring, and maintenance; contribute to CI/CD pipelines.

Skills

Oracle DBA

Oracle APEX

ORDS

PL/SQL

Performance tuning

Linux/Unix

RMAN backup

Security & access controls

Multi-environment mgmt

Education

Bachelor's degree in CS or related

Tools

WebLogic

OCI

Oracle Data Guard

EBS integration

SQL Server

PostgreSQL

MySQL

Job description

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

The role collaborates with DBA, middleware, and application teams to ensure high availability, security, and performance, while contributing to automation and CI/CD pipelines for database deployments.