Database Administrator - Oracle, MS SQL Server, PostgreSQL
Astra North Infoteck Inc. · Calgary, Canada ·
- Category
- Devops
- Experience
- 10+ years
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*
• 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