Astra North Infoteck Inc.
Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration
montreal, CAOn-siteContractFull-time
Posted Oct 28, 2026
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
Role snapshot
Job type
Full-time
Required skills
SQL Server Database AdministrationAzure SQL Database and Managed Instance AdministrationSQL Server on Azure Virtual Machines AdministrationSQL Performance Diagnostics and TuningT-SQL and Stored Procedure OptimizationDatabase Indexing, Statistics, and PartitioningPerformance Baselines and Capacity ForecastingAzure SQL Automatic Tuning GovernanceHigh Availability and Disaster RecoveryDatabase Backup, Restore, and Point-in-Time RecoveryDatabase Migrations, Upgrades, and Cloud AdoptionAzure SQL Scaling and Cost-Performance OptimizationDatabase Security and ComplianceDatabase Automation with PowerShell, T-SQL, Azure CLI, and Infrastructure as CodeIncident Management and Root-Cause Analysis
Similar jobs
Senior Identity and Reliability Engneering Specialist - Ping Forgerock
Astra North Infoteck Inc.
montreal, CAOn-siteContractFull-time
1 hour ago
ServiceDesk Engineer
Astra North Infoteck Inc.
montreal, CAOn-siteContractFull-time
1 hour ago
AI SUPPORT ANALYST – GENERATIVE AI, M365 & TECHNICAL SUPPORT
Astra North Infoteck Inc.
montreal, CAOn-siteContractFull-time
1 hour ago
Expert Imagerie Médicale TI (contrat 36+ mois)
DELAN
montreal, CAOn-siteContractFull-time
yesterday
Architecte Active Directory (contrat 18+ mois)
DELAN
montreal, CAOn-siteContractFull-time
yesterday
PCO (contrat 12+ mois)
DELAN
montreal, CAOn-siteContractFull-time
5 days ago