Oracle DBA

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Calgary; On-site; CAD 110,000 - 150,000; Full time

Job summary

Astra-North Infoteck Inc. in Calgary is seeking a Database Admin/SME with deep expertise in Oracle, MS SQL Server and PostgreSQL. You will manage data guard, multitenant architecture, and high availability across on-prem and cloud environments.

The role requires 6–10+ years of enterprise DBA experience, strong patching and vulnerability remediation skills, and on-call availability. Onsite work in Calgary supports 24x7 production systems.

Qualifications

• 6–10+ years of enterprise DBA experience across Oracle, SQL Server, and PostgreSQL.
• Hands-on Oracle Data Guard, switchover and failover operations.
• Experience with Oracle Multitenant (CDB/PDB) and upgrades.
• Proficiency with MS SQL Server Always On and clustering.

Responsibilities

• Administer Oracle databases using Data Guard and Multitenant architecture.
• Manage MS SQL Server environments including Always On and clustering.
• Ensure high availability, disaster recovery readiness, and DR drills.
• Monitor databases and resolve availability, performance and capacity issues.
• Plan upgrades, patching cycles, and maintenance activities.
• Perform restores and recovery during incidents and outages.
• Support applications with deployments, schema changes and query tuning.
• Collaborate on on-prem to cloud migrations and modernization.
• Maintain SOPs and runbooks.
• Coordinate with infrastructure, cloud, security and app teams.

Skills

Oracle Database Administration

MS SQL Server Administration

PostgreSQL Administration

Oracle Data Guard

Multitenant Architecture (CDB/PDB)

Always On Availability Groups

Failover Clustering

Performance Tuning

Backup & Recovery

On-Prem to Cloud Migrations

Security & Auditing

On-Call / 24x7 Support

Job description

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

Onsite: Calgary

Primary Skill

• Oracle Database Administration – Data Guard (physical/logical), CDB/PDB (Multitenant), ASM, switchover/failover
• MS SQL Server Administration – Always On Availability Groups, failover clustering, performance tuning
• 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