Database Administrator (Oracle & SQL Server)

Job Title: Database Administrator (Oracle & MS SQL Server)

Location: Calgary, AB, Canada

Work Model: Onsite

Experience Required: 6–10 Years

Role Overview

We are seeking a highly skilled Database Administrator / Subject Matter Expert (SME) with strong expertise in Oracle, Microsoft SQL Server, and PostgreSQL environments.

The role involves managing enterprise database systems, ensuring high availability, performance, security, and disaster recovery across critical production environments. The ideal candidate will have strong hands-on DBA experience along with exposure to cloud database platforms and automation practices.

Key Responsibilities

1. Oracle Database Administration

• Manage and support Oracle database environments
• Implement and maintain:
• Data Guard (Physical & Logical standby)
• Multitenant architecture (CDB/PDB)
• ASM (Automatic Storage Management)
• Perform switchover and failover operations
• Ensure high availability, performance tuning, and database stability

2. Microsoft SQL Server Administration

• Manage SQL Server environments and ensure optimal performance
• Configure and support:
• Always On Availability Groups
• Failover clustering
• Perform performance tuning and query optimization
• Handle backup, restore, and maintenance operations

3. PostgreSQL Administration

• Manage PostgreSQL databases in production environments
• Handle replication, patching, and maintenance activities
• Optimize database performance and ensure reliability

4. High Availability & Disaster Recovery

• Implement and maintain HA/DR strategies across database platforms
• Perform backup and recovery using:
• RMAN (Oracle)
• Native SQL Server tools
• Conduct DR drills and ensure business continuity readiness

5. Cloud & Platform Support (Preferred)

• Work with cloud-based database platforms in:
• Azure
• AWS
• Oracle Cloud Infrastructure (OCI)
• Support PaaS database environments and migrations

6. Automation & Monitoring

• Develop automation scripts for database operations
• Use monitoring tools for performance and health tracking
• Improve operational efficiency through scripting and automation

Required Skills

• Strong experience in Oracle Database Administration
• Expertise in MS SQL Server Administration
• Experience with PostgreSQL database management
• Hands-on experience with:
• High Availability (HA) and Disaster Recovery (DR)
• Performance tuning and optimization
• Backup and recovery strategies
• Strong troubleshooting and incident management skills

Preferred Skills

• Experience with cloud platforms (Azure / AWS / OCI)
• Knowledge of database automation and monitoring tools
• Scripting experience for operational tasks
• Exposure to enterprise-scale production environments