Role : SQL DBA Senior Technical Lead

Location: Vancouver ,BC ,Canada

Experience : 10+

Role Overview

We are looking for an experienced SQL DBA Senior Technical Lead to lead Microsoft SQL Server database administration, production support, performance optimization, and HA/DR operations. The ideal candidate should have robust hands-on SQL Server expertise, technical leadership experience, and exposure to enterprise production environments.

Key Responsibilities

- Lead SQL Server DBA operations and L2/L3 production support.
- Manage SQL Server installation, configuration, upgrades, patching and migrations.
- Administer Always On Availability Groups, Failover Clustering, replication and log shipping.
- Manage database backup, recovery, disaster recovery and availability.
- Perform performance tuning, query optimization, index maintenance and troubleshooting.
- Monitor database health, capacity, blocking, deadlocks and SQL Agent jobs.
- Manage database security, access controls, auditing and compliance.
- Troubleshoot critical production incidents and perform Root Cause Analysis (RCA).
- Lead DBA teams,



coordinate with stakeholders and ensure SLA adherence.
- Maintain technical documentation, runbooks, SOPs and DR procedures.

Required Skills

- 10–15 years of Microsoft SQL Server DBA experience.
- Strong experience with SQL Server 2016/2019/2022.
- Expertise in Always On, Failover Clustering, HA/DR and backup/recovery.
- Strong T-SQL, stored procedures and performance tuning.
- Hands-on experience with SSMS, SQL Agent, Query Store and Extended Events.
- Windows Server administration and PowerShell scripting.
- Experience in database security, monitoring and production troubleshooting.
- Experience with enterprise backup tools such as CommVault.
- Knowledge of ITIL, ServiceNow/Jira and SLA-driven environments.
- Strong technical leadership and stakeholder management skills.

Preferred Skills

- Azure SQL, SQL Server on Azure VM and Azure Arc.
- Utility or regulated infrastructure environments.
- Managed services and 24x7 production support experience.

📌 SQL DBA Senior Technical Lead (Vancouver)
🏢 apptoza
📍 Vancouver