Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!

Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration

Montréal, QC
On-site
Posted Oct 28, 2026
1 position

Opens LinkedIn

Employment type: Full-time
Experience level: Lead · 10+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Administer SQL Server and Azure SQL environments, diagnose and tune performance, manage high availability and disaster recovery, and lead database migrations, upgrades, and cloud adoption. Secure and automate database operations, optimize Azure costs and capacity, resolve critical incidents, and maintain operational documentation while mentoring support teams.

Job details

Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration Your Responsibilities Administer and support SQL Server across on-premises, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Lead performance diagnostics and tuning using Query Store, execution plans, Dynamic Management Views, Extended Events, wait statistics, PerfMon, SQL Profiler, and Azure monitoring. Optimize complex T-SQL, stored procedures, indexing, statistics, partitioning, memory, TempDB, parallelism, locking, blocking, deadlocks, CPU, storage I/O, and transaction logs. Detect query-plan regressions and workload bottlenecks, establish performance baselines and capacity forecasts, and validate measurable improvements. Govern Azure SQL automatic tuning and Database Advisor recommendations, including production safeguards and rollback readiness. Design and support high availability and disaster recovery using Always On availability groups, failover groups, clustering, replication, log shipping, backup, restore, and point-in-time recovery. Plan and execute database migrations, upgrades, patching, consolidation, modernization, and cloud adoption with minimal disruption. Manage Azure SQL service tiers, elastic pools, scaling, geo-replication, private connectivity, firewall rules, and cost-performance optimization. Implement least-privilege access, Microsoft Entra authentication, managed identities, encryption, auditing, vulnerability remediation, secrets management, and compliance controls. Automate provisioning, configuration, health checks, maintenance, backup validation, and reporting with PowerShell, T-SQL, Azure CLI, and infrastructure-as-code practices. Own P1/P2 incidents, outages, root-cause analysis, corrective actions, vendor escalations, and stakeholder communications. Maintain standards, runbooks, recovery procedures, dashboards, and knowledge articles; mentor L1/L2 teams and support change and release readiness. Your Profile Essential Skills/Knowledge/Experience 8–14 years of relevant database administration experience, with strong L3 MSSQL and Azure DBA expertise. Advanced hands-on experience with Microsoft SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Deep knowledge of Query Store, performance monitoring, execution

What you’ll do

Requirements

Requires 8–14 years of relevant database administration experience, with strong L3 Microsoft SQL Server and Azure DBA expertise. Candidates need advanced hands-on experience with SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines, along with deep performance monitoring and tuning knowledge.