Senior Oracle APEX, Database Administrator
Location
Canada
Posted
4 days ago
Salary
$89.2K - $129.3K / year
Seniority
Senior
Job Description
Senior Oracle APEX, Database Administrator
Stantec
• 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 • Manage multi-environment setups (DEV, QA, PROD) • Provide Tier 3 support for database and APEX incidents • Develop automation scripts for deployments, monitoring, and maintenance • Ensure compliance with security and audit requirements
Job Requirements
- 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
Benefits
- health, dental, and vision plans
- wellness program
- health care spending account
- wellness spending account
- group registered retirement savings plan
- employee stock purchase program
- group tax-free savings account
- life and accidental death & dismemberment (AD&D) insurance
- short-term/long-term disability plans
- emergency travel benefits
- tuition reimbursement
- professional membership fee coverage
- paid time off
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Owns the end-to-end health, reliability, and performance of database environments through proactive monitoring, maintenance, and observability. • Reviews database backups, maintenance activities, and health reports to ensure issues are identified and resolved within defined SLAs. • Responds to database alerts and escalations, serving as an L3 escalation point and driving root-cause analysis and long-term corrective actions. • Leads database performance tuning initiatives, including query optimization, index strategy, and workload-specific configuration improvements. • Partners with Database Engineering to assess database performance trends and identify systemic risks or improvement opportunities. • Collaborates with Cloud Engineering and Application Development teams to support scalable deployments and performance optimization. • Defines and enforces database security standards in partnership with engineering and security stakeholders. • Deploys and manages database objects (tables, indexes, views, stored procedures, packages) across multiple environments. • Participates in a 24/7 on-call rotation and provides L1–L3 support as required. • Contributes to planning and execution of initiatives that enhance database resiliency, availability, and operational transparency.
Database Administrator, DBA
The Voleon GroupApplying statistical machine learning to investment management.
• Administer, monitor, and maintain relational databases (PostgreSQL, MySQL, or Oracle) in production and development environments • Perform routine DB operations such as backup and recovery, schema changes, patching, upgrades, and security hardening • Support incident response, root cause analysis, and recovery for database-related issues • Automation, configuration management, modernization • Monitoring and analysis • Work collaboratively with systems and infrastructure teams to understand storage, OS, and networking components that influence database performance and reliability • Leverage basic Linux command-line and systems knowledge to troubleshoot and improve DB processes
Senior Database Administrator
MercolaA legacy natural-health brand rooted in sustainability and transparency
• Own production performance across PostgreSQL and Microsoft SQL Server. • Diagnose and resolve execution plan, indexing, locking, blocking, and query performance issues. • Design and operate high availability, replication, failover, and disaster recovery strategies. • Lead zero-downtime schema changes and production database migrations. • Execute large-scale data migrations and backfills using safe, verifiable processes. • Maintain secure database access, encryption, auditing, and governance practices. • Build monitoring, alerting, and capacity planning processes. • Support reporting, analytics, and warehouse performance. • Continuously improve database reliability, safety, and operational excellence.
• Monitor the availability, performance, capacity and overall health of customer SQL Server environments. • Review and respond to alerts generated through database monitoring and service-management platforms. • Assess and triage database tickets according to impact, urgency and technical complexity. • Investigate availability, performance, connectivity, configuration and capacity issues. • Identify root causes and develop clear, technically appropriate resolution plans. • Resolve incidents within agreed service levels and maintain ownership through to completion. • Identify recurring alerts and incidents and recommend preventative or permanent solutions. • Install, configure, maintain, patch and upgrade SQL Server environments as required. • Investigate slow queries, blocking, deadlocks, resource contention and other performance challenges. • Review database configurations, indexing and performance settings and recommend improvements. • Manage database users, roles, permissions and access controls. • Support database migrations, environment changes and SQL Server version upgrades. • Configure and support High Availability and Disaster Recovery solutions. • Support database mirroring, replication and data synchronisation. • Monitor and validate backup, restoration and recovery processes. • Communicate findings, risks, recommended actions and progress updates directly to customers. • Work closely with customers, application teams, infrastructure teams and internal delivery resources. • Escalate highly complex or critical issues when additional expertise or resources are required. • Maintain accurate records of incidents, investigations, configurations, changes and resolutions. • Develop and maintain technical documentation, operating procedures and knowledge-base articles. • Identify opportunities to improve operational processes, database reliability and customer outcomes.



