Database Administrator (Oracle & SQL Server)
Astra North Infoteck Inc.
- Calgary, AB
- Permanent
- Full-time
Work Model: Onsite
Experience Required: 6–10 YearsRole OverviewWe 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 Responsibilities1. 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
- 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
- Manage PostgreSQL databases in production environments
- Handle replication, patching, and maintenance activities
- Optimize database performance and ensure reliability
- 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
- Work with cloud-based database platforms in:
- Azure
- AWS
- Oracle Cloud Infrastructure (OCI)
- Support PaaS database environments and migrations
- Develop automation scripts for database operations
- Use monitoring tools for performance and health tracking
- Improve operational efficiency through scripting and automation
- 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
- 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