Senior Oracle DBA & APEX/ORDS Expert

Stantec

Fredericton

On-site

CAD 89,000 - 137,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, dental & vision plans
Wellness program
Group RRSP
Employee stock purchase program
Tuition reimbursement

Job summary

Stantec is seeking a Senior Oracle APEX and Database Administrator to support enterprise database platforms and Oracle APEX environments. The role will design, administer, optimize performance, and manage lifecycle across development, QA, and production environments.

The successful candidate will work with DBA, middleware, and application teams to ensure high availability, security, and efficient operations, including automation and CI/CD integration for Oracle solutions.

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 (19c and newer) across multiple environments.
  • Perform database installations, upgrades, patching, and migrations.
  • Implement backup/recovery strategies and disaster recovery solutions.
  • Monitor database performance and tune SQL, memory, and storage.
  • Manage database security, roles, and access controls.
  • Support PDB/CDB architecture, and database consolidation strategies.
  • Install, configure, and upgrade Oracle APEX and ORDS environments.
  • Manage APEX schemas, users, and workspace configurations.
  • Support APEX application deployments and lifecycle management.
  • Troubleshoot APEX performance, session management, and runtime issues.
  • Configure ORDS connections, pools, and security integration.
  • Support integration between APEX and enterprise systems (e.g., APIs, EBS, middleware).
  • Coordinate database and application upgrades with cross-functional teams.
  • Maintain environment consistency and deployment standards.
  • Support capacity planning and performance testing initiatives.
  • Provide Tier 3 support for database and APEX incidents.
  • Troubleshoot complex issues including: Database performance degradation, APEX application errors, ORDS connectivity and configuration issues.
  • Monitor system health and proactively resolve issues.
  • Participate in on-call rotations and incident response.
  • Develop automation scripts for deployments, monitoring, and maintenance.
  • Improve DBA operational processes and documentation.
  • Contribute to CI/CD pipelines for database and APEX deployments.
  • Ensure compliance with security and audit requirements.

Skills

Oracle Database Administration
Oracle APEX
ORDS
PL/SQL
Linux/Unix
RMAN
Upgrades & Migrations
Performance Tuning
Troubleshooting
WebLogic Middleware

Tools

WebLogic
Oracle SQL Tools
ORDS

Job description

Stantec is seeking a Senior Oracle APEX and Database Administrator to support enterprise database platforms and Oracle APEX environments. The role will design, administer, optimize performance, and manage lifecycle across development, QA, and production environments.

The successful candidate will work with DBA, middleware, and application teams to ensure high availability, security, and efficient operations, including automation and CI/CD integration for Oracle solutions.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle DBA & APEX Expert
Senior Oracle DBA & APEX Expert

Stantec • Mississauga

On-site
CAD 89,000 - 137,000
Health benefits
Dental plan
Vision plan
+2
Senior Oracle APEX & DB Admin: HA, Automation & CI/CD
Senior Oracle APEX & DB Admin: HA, Automation & CI/CD

Stantec • Vancouver

On-site
CAD 95,000 - 137,000
Health benefits
Wellness program
RRSP/retirement plan
+1
Senior Oracle DBA & APEX Administrator
Senior Oracle DBA & APEX Administrator

Stantec • Markham

On-site
CAD 95,000 - 137,000
Health, dental, and vision plans
Wellness program
RRSP employer match
Senior Oracle APEX & Database Engineer
Senior Oracle APEX & Database Engineer

Stantec • Regina

On-site
CAD 89,000 - 137,000
Health and dental plans
RRSP/401K-like retirement plan
Employee stock purchase program
+2
Senior Oracle APEX & DB Admin — Multi-Env, High Availability
Senior Oracle APEX & DB Admin — Multi-Env, High Availability

Stantec • Burnaby

On-site
CAD 89,000 - 137,000
Health benefits
Stock purchase program
Tuition reimbursement
Senior Oracle APEX & Database Administrator
Senior Oracle APEX & Database Administrator

Stantec • Montreal

On-site
CAD 89,000 - 137,000
Health, dental & vision plans
Wellness program
Retirement savings plan
+3
Senior Oracle APEX & Database Administrator
Senior Oracle APEX & Database Administrator

Stantec • Calgary

On-site
CAD 89,000 - 129,000
Health, dental & vision plans
Wellness program
Group RRSP
+1
Senior Oracle APEX & Database Administrator
Senior Oracle APEX & Database Administrator

Stantec • Halifax

On-site
CAD 95,000 - 137,000
Health benefits
Dental benefits
Vision benefits
+8
Senior Oracle APEX & Database Administrator
Senior Oracle APEX & Database Administrator

Stantec • Burnaby

On-site
CAD 89,000 - 137,000
Health benefits
Stock purchase program
Tuition reimbursement
Senior Oracle APEX & Database Administrator
Senior Oracle APEX & Database Administrator

Stantec • Regina

On-site
CAD 89,000 - 137,000
Health and dental plans
RRSP/401K-like retirement plan
Employee stock purchase program
+2