Azure SQL DBA

Enterprise Solutions Inc.; Canada; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading IT consulting firm is seeking an Account Manager specializing in Azure SQL solutions. This mid-senior level role involves architecting and deploying database solutions, mentoring junior staff, and collaborating with teams to optimize database performance and compliance. Ideal candidates will have extensive experience in SQL Server and Azure, along with a strong understanding of DevOps practices.

Qualifications

• 10+ years of experience as a SQL Server DBA, including 4+ years in Azure SQL.
• Proven hands-on experience with Azure SQL Database and SQL Server on Azure VMs.
• Experience with hybrid cloud/on-premises database environments is a plus.

Responsibilities

• Architect, build, and deploy Azure SQL solutions based on business requirements.
• Lead database build automation using tools like Terraform or Azure DevOps.
• Mentor junior DBAs and engineers.

Skills

T-SQL

Query tuning

Index strategies

Execution plans

Infrastructure-as-Code

Azure networking

Monitoring

Cost management

HA/DR designs

DevOps practices

Education

Microsoft Azure Certifications (DP-300, AZ-104, AZ-305)

Tools

Azure DevOps

Terraform

PowerShell

Job description

Job Title: Account Manager (Canada/US) - Client Relations & Delivery

Job Type: Contract

Key Responsibilities

1. Architect, build, and deploy Azure SQL (PaaS/IaaS) solutions based on business and application requirements.
2. Evaluate and recommend best-fit database services (Azure SQL DB, Managed Instance, Hyperscale, etc.).
3. Lead database build automation using tools like Terraform or Azure DevOps pipelines.
4. Own high-availability (HA), disaster recovery (DR), backup, and performance tuning strategies.
5. Proactively monitor database health, storage, and performance using Azure Monitor, Log Analytics, or custom dashboards.
6. Conduct root cause analysis for database issues and implement permanent fixes.
7. Collaborate with application and infrastructure teams during planning, development, and release cycles.
8. Participate in capacity planning, licensing optimization, and cost governance.
9. Define and enforce database security, compliance, and encryption policies.
10. Drive discussions with architects and senior stakeholders to shape long-term database strategies.
11. Develop and present technical recommendations, best practices, and improvement plans.
12. Mentor junior DBAs and engineers.

Required Skills & Experience

• 10+ years of experience as a SQL Server DBA, including at least 4+ years in Azure SQL.
• Proven hands-on experience with Azure SQL Database, Managed Instance, and SQL Server on Azure VMs.
• Strong knowledge of T-SQL, query tuning, index strategies, and execution plans.
• Experience with Infrastructure-as-Code (IaC) for database deployments.
• Deep understanding of Azure networking, identity (AAD), monitoring, and cost management related to databases.
• Expertise in HA/DR designs including geo-replication, failover groups, and AlwaysOn AGs.
• Familiarity with DevOps practices and automation tools like Azure DevOps, GitHub Actions, PowerShell, etc.

Preferred Qualifications

• Microsoft Azure Certifications (DP-300, AZ-104, or AZ-305).
• Experience with hybrid cloud/on-premises database environments.
• Familiarity with PostgreSQL, Cosmos DB, or other cloud-native data stores is a plus.
• Experience participating in architecture review boards and preparing engineering proposals.

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Contract
• Job function: Information Technology
• Industries: IT Services and IT Consulting