Database Administrator (Oracle & SQL Server)

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

Job summary

Astra-North Infoteck Inc. in Calgary, AB, is seeking a highly skilled Database Administrator with expertise in Oracle, Microsoft SQL Server, and PostgreSQL. The role requires managing enterprise database systems, ensuring high availability, performance, security, and disaster recovery. Ideal candidates will possess 6-10 years of hands-on DBA experience and knowledge of cloud platforms like Azure and AWS. This onsite position offers an opportunity to work in critical production environments with strong operational responsibilities.

Qualifications

• 6-10 years of experience in database administration.
• Strong hands-on experience with Oracle, MS SQL Server, and PostgreSQL.
• Experience with cloud database platforms and automation practices.

Responsibilities

• Manage and support Oracle, MS SQL Server, and PostgreSQL database environments.
• Ensure high availability, performance tuning, and optimization.
• Implement and maintain disaster recovery strategies.

Skills

Oracle Database Administration

MS SQL Server Administration

PostgreSQL database management

High Availability and Disaster Recovery

Performance tuning and optimization

Backup and recovery strategies

Troubleshooting and incident management

Tools

Azure

AWS

Oracle Cloud Infrastructure (OCI)

Job description

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