Technical Lead - SQL DBA, SQL Server & Database Administration

Astra-North Infoteck Inc.

Vancouver

On-site

CAD 120,000 - 180,000

Full time

12 days ago

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Astra-North Infoteck Inc. in Vancouver, Canada is seeking a Technical Lead - SQL DBA to own the SQL Server lifecycle, drive performance tuning, and ensure high availability across enterprise systems.

You will lead cross-functional teams, troubleshoot outages, and mentor DBAs to deliver reliable data services. This role requires hands-on expertise in Always On, backups, security, and recovery governance, with close collaboration across application, infrastructure and security teams to meet SLA

Qualifications

  • Excellent communication with stakeholders, application teams and leadership.
  • 10–15 years of enterprise SQL Server production support experience.
  • SQL Server 2016/2019/2022 or later, SSMS, Always On, clustering and backup/recovery.
  • Installation, configuration, patching, upgrades, migrations, monitoring.
  • Windows Server, PowerShell, deployment support.
  • Mission-critical HA/DR, 24x7 production support.
  • T-SQL troubleshooting, indexing, statistics tuning and Query Store.
  • Security, access controls, auditing, vulnerability remediation and compliance.
  • Commvault or enterprise backup platform experience preferred.
  • Ability to lead DBAs and deliver to SLA.

Responsibilities

  • Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support.
  • Administer installation, configuration, upgrades, patching, migrations, cloning, refreshes, SQL Agent jobs, storage and capacity.
  • Manage Always On Availability Groups, Failover Cluster Instances, log shipping, replication and mirroring as applicable.
  • Plan and validate backups, restore testing, point-in-time recovery and DR exercises.
  • Monitor health, availability, performance, space, jobs, alerts, waits and blocking issues.
  • Tune execution plans, indexes, statistics, queries, waits, memory, CPU and I/O.
  • Support database security, access, logins/users/roles, auditing, encryption awareness and compliance.
  • Coordinate with application, infrastructure, backup, Windows/Unix, security, vendor and customer teams.
  • Lead technical reviews, guide DBAs, perform peer reviews and ensure SLA adherence.
  • Participate in incident, problem, change, release and knowledge management.
  • Maintain runbooks, SOPs, architecture notes and RCA/knowledge articles.

Skills

Communication
Leadership
SQL Server DBA
T-SQL troubleshooting
Performance tuning

Tools

SSMS
Always On
Failover Clustering
Log Shipping
Query Store
PowerShell
DMVs / Extended Events

Job description

Technical Lead - SQL DBA, SQL Server & Database Administration

Vancouver, Canada | Posted on 11/05/2026

The role requires hands-on SQL DBA expertise, leadership, troubleshooting, availability management, performance tuning, backup/recovery governance and cross-team coordination.

Key Accountabilities

  • Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support.
  • Administer installation, configuration, upgrades, patching, migrations, cloning, refreshes, SQL Agent jobs, storage and capacity.
  • Manage Always On Availability Groups, Failover Cluster Instances, log shipping, replication and mirroring as applicable.
  • Plan and validate full, differential and transaction log backups, restore testing, point-in-time recovery and DR exercises.
  • Monitor health, availability, performance, space, jobs, alerts, wait statistics, blocking, deadlocks and logs.
  • Tune execution plans, indexes, statistics, queries, waits, memory, CPU, I/O and workloads.
  • Support database security, access, logins/users/roles, auditing, encryption awareness, vulnerability remediation and compliance.
  • Troubleshoot availability, backup, transaction log, disk capacity, Agent job, connectivity and authentication incidents.
  • Coordinate with application, infrastructure, backup, Windows/Unix, security, vendor and customer teams.
  • Lead technical reviews, guide DBAs, perform peer reviews, allocate tasks and ensure SLA/standards adherence.
  • Participate in incident, problem, request, change, release and knowledge management.
  • Maintain runbooks, SOPs, architecture notes, implementation plans, DR evidence, RCA, release notes and knowledge articles.

Experience Required

  • Good communication with customer stakeholders, application owners, infrastructure, security, DBAs and delivery leadership.
  • Minimum 10–15 years of enterprise Microsoft SQL Server DBA production support experience.
  • SQL Server 2016/2019/2022 or later, SSMS, SQL Agent, Always On, clustering and backup/recovery.
  • Installation, configuration, patching, upgrades, migrations, refresh, tuning and monitoring.
  • Windows Server, services, event logs, filesystem, permissions, PowerShell and deployment support.
  • Mission-critical HA/DR, monitoring and 24x7 production support.
  • T-SQL troubleshooting, execution plans, index/statistics tuning, waits, deadlocks, blocking, Query Store and resource management.
  • Security, access controls, auditing, vulnerability remediation and compliance preferred.
  • CommVault or enterprise backup platform experience preferred.
  • Utility, regulated infrastructure, NERC CIP-adjacent, cloud readiness or managed services preferred.
  • Ability to lead DBAs and deliver to SLA.

Technical Skills

  • SQL Server 2016/2019/2022 or later: installation, configuration, upgrade, patching, migration, cloning and refresh.
  • Always On Availability Groups, Failover Cluster Instances, log shipping, replication, mirroring, HA and DR.
  • Backup/recovery, transaction log management, restore testing, point-in-time recovery and DR exercises.
  • SSMS, SQL Agent, DMVs, Query Store, Extended Events, Profiler, counters and monitoring tools.
  • T-SQL, stored procedures, functions, jobs, indexes, statistics, plans, waits, deadlocks/blocking and tuning.
  • Windows Server DBA support, PowerShell, event logs, service accounts, storage and deployment.
  • Database security, auditing, access management, encryption awareness and vulnerability remediation.
  • Azure SQL, SQL Server on Azure VM, Azure Arc-enabled SQL Server, automation or cloud readiness preferred.
  • ITIL and ServiceNow/Jira/BMC Remedy.
  • Managed services, SLA reporting, RCA, runbooks, SOPs, audit evidence and knowledge management.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Database Administrator
Senior Database Administrator

Alberta Pensions Services Corporation (APS) • Edmonton

On-site
CAD 110,000 - 140,000
SQL Server DBA
SQL Server DBA

Astra-North Infoteck Inc. • Brampton

Hybrid
CAD 90,000 - 120,000
Database Administrator – Oracle, SQL Server, AWS RDS
Database Administrator – Oracle, SQL Server, AWS RDS

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 95,000 - 130,000
SQL DBA
SQL DBA

Info-Ways • Brampton

On-site
CAD 80,000 - 100,000
Senior SQL Server DBA - High Availability & Security Expert
Senior SQL Server DBA - High Availability & Security Expert

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000
Senior Database Administrator (DBA) – SQL Server
Senior Database Administrator (DBA) – SQL Server

Strategize it Inc. • Toronto, Winnipeg

Hybrid
CAD 90,000 - 120,000
Senior Database Administrator
Senior Database Administrator

BuzzClan • Toronto

On-site
CAD 83,000 - 165,000
Database Administrator and Back-up Consultant
Database Administrator and Back-up Consultant

TEEMA Group • Edmonton

On-site
CAD 110,000 - 150,000
Database Administrator (DBA) - Vancouver
Database Administrator (DBA) - Vancouver

Yeah! Global • Vancouver

On-site
CAD 70,000 - 90,000
RQ08345 - Sr. Database Administrator
RQ08345 - Sr. Database Administrator

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000