Engineering Consulting, Architecture, Design, Professional Services

Senior Oracle APEX & Database Administrator

RemoteRemoteFull TimeSeniorPosted 2 months agoHidden Gem · Himalayas

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Required skills

Oracle APEX
Oracle Database
19c
ORDS
PDB/CDB
backup/recovery
disaster recovery
performance tuning
SQL tuning
security

Nice to have

PostgreSQL
MySQL
WebLogic
EBS
middleware

Role summary

Seeking a Senior Oracle APEX and Database Administrator to manage and enhance enterprise database platforms and Oracle APEX application environments. Responsibilities include design, administration, performance optimization, and lifecycle management of Oracle databases and APEX/ORDS platforms. The role involves ensuring high availability, performance, and security across development, QA, and production environments, supporting critical business applications. Key tasks include database installations, upgrades, patching, migrations, backup/recovery, performance tuning, security management, APEX/ORDS administration, troubleshooting, and automation script development. Experience with Microsoft SQL Server is required, with PostgreSQL and MySQL being nice-to-haves.

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

Ready to apply?

You'll be redirected to Stantec's application page.