Senior MS SQL Server & Azure Database Administrator (L3) / Montreal, QC - (Hybrid)

AceStack; Montreal; Hybrid; CAD 120.000 - 180.000; Vollzeit

Zusammenfassung

AceStack in Montreal, QC is seeking an experienced Senior MS SQL Server & Azure DBA (L3) to manage, optimize, secure, and support enterprise database environments across on‑premises infrastructure and Microsoft Azure.

The ideal candidate will have strong hands‑on experience in SQL Server administration, Azure SQL services, advanced performance tuning, high availability, disaster recovery, migrations, and production incident management.

Qualifikationen

• 8–14 years of database administration experience with strong L3 SQL Server and Azure DBA expertise.
• Hands-on experience with SQL Server administration, Azure SQL services, tuning, HA, DR, migrations, and incident management.
• Proven ability to automate tasks using PowerShell and Azure CLI.

Aufgaben

• Administer SQL Server across on-premises and Azure environments including Azure SQL Database/Managed Instance and SQL Server on Azure VMs.
• Perform advanced performance tuning using Query Store, DMVs, Extended Events, and wait statistics.
• Implement and manage high availability (Always On) and disaster recovery (AG) solutions.
• Plan migrations, upgrades, patching, and cloud modernization with minimal disruption.
• Monitor health, forecast capacity, and establish baselines for performance improvements.
• Lead major incidents, perform root-cause analysis, and coordinate with stakeholders and vendors.

Kenntnisse

SQL Server Administration

Azure SQL

Performance Tuning

High Availability & DR

T-SQL

Automation (PowerShell)

Tools

SQL Server on Azure VM

Azure SQL Database

Azure SQL Managed Instance

Query Store & DMVs

Extended Events

PowerShell / Azure CLI

Jobbeschreibung

Location: Montreal, QC

Work Model: Hybrid

Experience: 8–14 Years

Employment Type: Full-Time

Primary Skills: Microsoft SQL Server, Azure SQL, Database Performance Tuning, High Availability & Disaster Recovery

Job Summary

We are seeking an experienced Senior MS SQL Server & Azure DBA (L3) to manage, optimize, secure, and support enterprise database environments across on-premises infrastructure and Microsoft Azure.

The ideal candidate will have strong hands-on experience in SQL Server administration, Azure SQL services, advanced performance tuning, high availability, disaster recovery, database migrations, and production incident management. The role requires expertise in troubleshooting complex database issues, automating administrative tasks, improving database performance, and ensuring high availability and operational stability.

Key Responsibilities

• Administer and support Microsoft SQL Server across on-premises environments, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
• Perform advanced database performance tuning and troubleshooting using Query Store, execution plans, Dynamic Management Views (DMVs), Extended Events, wait statistics, and Azure monitoring tools.
• Optimize complex T-SQL queries, stored procedures, indexing, statistics, partitioning, TempDB, memory, CPU, storage I/O, and transaction logs.
• Troubleshoot and resolve blocking, deadlocks, query-plan regressions, and database performance bottlenecks.
• Establish performance baselines, monitor database health, forecast capacity, and implement measurable performance improvements.
• Manage Azure SQL automatic tuning, Database Advisor recommendations, service tiers, elastic pools, scaling, geo-replication, and cost-performance optimization.
• Design, implement, and support high availability and disaster recovery solutions using Always On Availability Groups, failover groups, clustering, replication, and log shipping.
• Manage database backup, restore, point-in-time recovery, and disaster recovery testing to meet business continuity requirements.
• Plan and execute database migrations, upgrades, patching, consolidation, and cloud modernization with minimal business disruption.
• Implement database security best practices, including least-privilege access, Microsoft Entra authentication, managed identities, encryption, auditing, and vulnerability remediation.
• Automate database provisioning, configuration, health checks, maintenance, backup validation, and reporting using PowerShell, T-SQL, Azure CLI, and infrastructure-as-code practices.
• Lead P1/P2 production incidents, perform root-cause analysis, implement corrective and preventive actions, and coordinate stakeholder and vendor communications.
• Maintain database standards, operational runbooks, recovery procedures, monitoring dashboards, and technical documentation.
• Mentor L1/L2 support teams and contribute to change management, release readiness, and continuous service improvement.

Required Skills & Qualifications

• 8–14 years of relevant database administration experience, including strong L3-level Microsoft SQL Server and Azure DBA expertise.
• Advanced hands-on experience with:
• Microsoft SQL Server administration and troubleshooting.
• Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
• T-SQL development, query optimization, indexing, and execution-plan analysis.
• Query Store, DMVs, Extended Events, performance monitoring, and capacity management.
• Strong experience troubleshooting blocking, deadlocks, CPU and memory pressure, TempDB contention, and storage I/O issues.
• Proven expertise in high availability and disaster recovery, including Always On Availability Groups, replication, clustering, backup, and recovery.
• Experience with database migrations, upgrades, patching, and production change management.
• Hands-on scripting and automation experience using PowerShell, T-SQL, and Azure CLI.
• Strong production support experience, including major incidents, outages, root-cause analysis, and preventive actions.
• Understanding of database security, access controls, encryption, auditing, and compliance requirements.
• Excellent communication, troubleshooting, documentation, and stakeholder management skills.

Preferred / Nice-to-Have Skills

• Experience with Azure SQL automatic tuning, Database Advisor, elastic pools, geo-replication, and Azure cost optimization.
• Knowledge of Microsoft Entra ID authentication, managed identities, private connectivity, firewall configuration, and secrets management.
• Exposure to infrastructure-as-code practices and automated database deployments.
• Experience improving operational processes, maintaining runbooks, mentoring support teams, and reducing recurring incidents through automation.

Ideal Candidate Profile

The ideal candidate is a hands-on senior DBA with strong L3 production support capabilities, deep SQL Server performance-tuning expertise, and practical Azure database administration experience. They should be comfortable managing critical database environments, leading major incident investigations, implementing resilient HA/DR solutions, and driving automation and continuous improvement.