Job Description Job Description: 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* 610+ years of enterprise DBA experience supporting Oracle, SQL Server, and PostgreSQL databases Robust 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 Requirements 60-70

📌 Oracle DBA (Calgary)
🏢 Astra North Infoteck
📍 Calgary