Stantec

Senior Oracle APEX & Database Administrator

Canada full-time Senior Salary not listed
full-time Senior level Technology & IT Curated
Sign in to apply Free account — we bring you straight back to this role.

About the role

Position Summary
We are seeking a Senior Oracle APEX and Database Administrator to support and enhance enterprise database platforms and Oracle APEX application environments. This role will be responsible for the design, administration, performance optimization, and lifecycle management of Oracle databases and APEX/ORDS platforms supporting critical business applications.
The successful candidate will work closely with DBA, middleware, and application teams to ensure high availability, performance, and security of systems across development, QA, and production environments.
Key Responsibilities
Oracle Database Administration

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

Oracle APEX / ORDS Administration

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)

Environment & Infrastructure Management

Manage multi-environment setups (DEV, QA, PROD)

Support WebLogic or application server configurations for APEX/ORDS

Coordinate database and application upgrades with cross-functional teams

Maintain environment consistency and deployment standards

Support capacity planning and performance testing initiatives

Operational Support & Troubleshooting

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

Automation & Process Improvement

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

Working knowledge and experience with Microsoft SQL Server

Experience with PostgreSQL and MySQL is nice to have

Additional Responsibilities

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

Originally posted on Himalayas

Interview prep

Walk in with sharper answers.

Use this as a quick practice sheet before you speak with the employer.

Senior
Technology & IT Administration API integration MySQL Operations SQL Senior level

Likely questions

  1. Tell us about work you have done that is close to the Senior Oracle APEX & Database Administrator role.
  2. How would you approach your first 30 days at Stantec?
  3. Which of Administration, API integration and MySQL have you used recently, and what did it help you achieve?
  4. How have you led people, improved a process, or made a hard decision in a previous role?
  5. How do you handle busy days, changing priorities, or pressure at work?

Prepare before the call

  • A recent example that proves your experience with Administration, API integration and MySQL.
  • One short story with a problem, your action, and the result.
  • Two examples that show the strengths listed on your CV.
  • A clear reason why this role and company interest you.
  • Your availability, preferred work style, and salary expectations.

Ask them

  • What would success look like in the first 90 days?
  • What are the main problems this hire should help solve?
  • How does the team give feedback and measure good work?
  • What does a normal working week look like for this role?
Practice line

I am interested in the Senior Oracle APEX & Database Administrator role because I can bring practical experience in Administration, API integration and MySQL, learn the team quickly, and contribute to the outcomes Stantec needs from this hire.

Related jobs.

More roles from this company or category.