SQL Database Administrator

Job Description : SQL Database Administrator (L3 – Cloud Focus)

Location : - Calgary, AB

Experience Level : Senior / Expert (L3)

Position Summary

We are seeking an L3-level SQL Database Administrator with advanced expertise in cloud database platforms. This role will architect, optimize, and lead SQL Server environments across Azure and AWS, driving cloud-first strategies, automation, and innovation. The ideal candidate will serve as the technical authority for cloud database solutions, guiding migrations, performance engineering, and advanced troubleshooting, while mentoring junior DBAs and collaborating with cross-functional teams.

Key Responsibilities

• Architect and optimize cloud-based SQL Server deployments (Azure SQL Database, Managed Instances, AWS RDS) for scalability, reliability, and security.
• Lead cloud migration projects : assessment, planning, execution, and post-migration optimization.
• Design and implement advanced high-availability and disaster recovery solutions using cloud-native features (e.g., Azure Geo-Replication, AWS Multi-AZ).
• Drive automation for provisioning, patching, monitoring, and backup in cloud environments using PowerShell, T-SQL, and cloud-native tools.
• Evaluate and implement new cloud database technologies, services, and cost optimization strategies.
• Act as the highest-level escalation for complex cloud database incidents, root cause analysis, and performance challenges.
• Collaborate with architects, application owners, and infrastructure teams to align cloud database solutions with business goals.
• Mentor and train L1 / L2 DBAs on cloud database best practices and troubleshooting.
• Ensure compliance with cloud security, audit, and regulatory requirements.
• Set and maintain database standards
• Performance tuning of database systems
• Diagnose and troubleshoot database errors
• Recommend and implement emerging database technologies
• Create automation for repeating database tasks
• Familiarity with SSAS, SSIS, SSRS
• Be available for on-call support as needed.
• Excellent written and verbal communication skills
• Own documentation of cloud architectures, standards, and advanced troubleshooting guides.
• Install, upgrade, and manage database, Instance ( SQL Server 2008,2012,2014,2016,2017)
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards
• Good hand on Experience in establishing High Availability configurations including SQL Mirroring, SQL
• Clustering, Always-On Failover Clustering, Always-On Availability Groups, and log-shipping
• Advantage if having experience in PowerShell scripting
• Hands on experience on Azure / AWS related database service
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end

Required Skills & Qualifications

Preferred Certifications