SQL Database Administrator

HCLTech; Calgary; On-site; CAD 100,000 - 130,000; Full time

Job summary

A global technology firm is seeking a Senior SQL Database Administrator to lead cloud-first strategies across SQL Server environments on Azure and AWS. The successful candidate will be responsible for architecting and optimizing SQL deployments, managing cloud migrations, and mentoring junior DBAs. With at least 10 years of experience, especially in cloud services, candidates will be expected to have advanced skills in PowerShell and T-SQL, complemented by leadership qualities. Excellent communication skills are essential for this role.

Qualifications

• Experience with cloud database platforms (Azure SQL, Managed Instances, AWS RDS).
• Strong experience with cloud-native backup and monitoring solutions.
• Proven track record in large-scale cloud migrations.

Responsibilities

• Architect and optimize cloud-based SQL Server deployments.
• Lead cloud migration projects: assessment, planning, execution.
• Mentor and train L1/L2 DBAs on cloud database best practices.

Skills

Cloud database architecture

SQL Server environments

Cloud migration projects

PowerShell scripting

Disaster recovery solutions

Leadership and mentoring

Education

10+ years of enterprise SQL DBA experience

Tools

Azure SQL Database

AWS RDS

PowerShell

T-SQL

Job description

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

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

• 10+ years of enterprise SQL DBA experience, with at least 3 years focused on cloud database platforms (Azure SQL, Managed Instances, AWS RDS).
• Deep expertise in cloud database architecture, migration, automation, and performance engineering.
• Strong experience with cloud-native backup, monitoring, and disaster recovery solutions.
• Advanced proficiency in PowerShell, T-SQL, and cloud automation frameworks.
• Proven track record in large-scale cloud migrations and optimization.
• Excellent communication, leadership, and mentoring skills.

Preferred Certifications

• Microsoft Certified: Azure Solutions Architect Expert
• AWS Certified Database – Specialty
• MCSA: SQL Server (2016 or later)