Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration
- Montréal, QC, Canada
Applications open in a new tab.
Job details
- Experience
- 8–14 years of relevant database administration experience, with strong L3 MSSQL and Azure DBA expertise.
- Posting language
- English
- Posted
Original job description
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
More about this job
Responsibilities
The Senior Azure SQL DBA at Astra North Infoteck will keep SQL Server databases running fast, available and secure across on-premises and Azure. The role diagnoses and fixes performance problems, plans backups, migrations and disaster recovery, and leads incident response.
Requirements
Candidates need 8 to 14 years of database administration experience, with advanced hands-on skills in SQL Server and Azure SQL services. They must know performance tuning tools such as Query Store and execution plans, and be able to automate work with PowerShell, T-SQL and Azure CLI.
Skills
- Microsoft SQL Server
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines
- T-SQL
- Query Store
- Execution plans
- Dynamic Management Views
- Extended Events
- Wait statistics
- PerfMon
- SQL Profiler
- Azure Monitor
- Always On availability groups
- Failover groups
- Replication
- Log shipping
- Backup and restore
- Point-in-time recovery
- Elastic pools
- Geo-replication
- Microsoft Entra authentication
- Managed identities
- PowerShell
- Azure CLI
Categories
- Technology
- Software
- Data & Analytics
Keywords
- SQL Server
- Azure SQL Database
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines
- T-SQL
- Query Store
- execution plans
- Dynamic Management Views
- Extended Events
- performance tuning
- Always On availability groups
- failover groups
- disaster recovery
- high availability
- PowerShell
- Azure CLI
- Infrastructure as code
- database administrator
- DBA
- cloud database
Seniority
Senior
Tools
- SQL Server
- Azure SQL Database
- Azure SQL Managed Instance
- Query Store
- Extended Events
- SQL Profiler
- PerfMon
- Azure Monitor
- PowerShell
- Azure CLI