Oracle DBA

Role: Database Admin/SME (Oracle & MS SQL)

Onsite: Calgary

Primary Skill

1.Oracle Database Administration – Data Guard (physical/logical), CDB/PDB (Multitenant), ASM, switchover/failover

2.MS SQL Server Administration – Always On Availability Groups, failover clustering, performance tuning

3.PostgreSQL Administration – Replication, maintenance, and performance management

Job Requirements*

• 6–10+ years of enterprise DBA experience supporting Oracle, SQL Server, and PostgreSQL databases
• Strong hands-on experience with Oracle Data Guard (physical/logical), switchover, and failover operations
• Expertise in Oracle Multitenant architecture (CDB/PDB), upgrades, and PDB lifecycle management
• Solid experience with MS SQL Server Always On Availability Groups and failover clustering
• Advanced database performance tuning, query optimization, indexing, and capacity planning
• Experience performing database patching, minor/major upgrades, and vulnerability remediation
• Proven knowledge of backup and recovery tools (RMAN, SQL Server native, third-party solutions)
• Exposure to on-prem to cloud database migrations and modernization initiatives
• Working knowledge of database security, encryption, auditing, and access management
• Ability to support 24x7 production environments and participate in on-call rotations

Key Responsibilities*

• Administer and support Oracle databases using Data Guard and Multitenant (CDB/PDB) architecture
• Manage MS SQL Server environments including Always On, clustering, and performance baselines
• Ensure high availability, disaster recovery readiness, and conduct regular DR drills
• Proactively monitor databases and resolve availability, performance, and capacity issues
• Plan and execute database upgrades, patching cycles, and maintenance activities
• Perform database restores and recovery during incidents and unplanned outages
• Support application teams with deployments, schema changes, and query optimization
• Participate in database migration projects across on-prem and cloud platforms
• Maintain operational documentation, SOPs, and runbooks
• Collaborate with infrastructure, cloud, security, and application stakeholders