Technical Lead - SQL DBA, SQL Server & Database Administration

Astra North Infoteck Inc.

British Columbia

On-site

CAD 120,000 - 160,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Arrow Off Road Cambridge in Canada seeks a hands-on SQL Server DBA Lead to own and optimize the enterprise SQL platform. The role combines technical mastery with leadership, incident response, and cross-team coordination to ensure high availability and performance.

You will guide a team of DBAs, implement backup/recovery, manage Always On and clustering, perform tuning, security hardening, and DR exercises while partnering with application, infrastructure, and vendor teams to meet SLAs.

Qualifications

  • 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.
  • Windows Server, PowerShell, deployment support and 24x7 production readiness.

Responsibilities

  • Lead end-to-end SQL Server DBA operations and L2/L3 support.
  • Administer installation, configuration, upgrades, patching, migrations, cloning and refreshes.
  • Manage Always On Availability Groups, Failover Clustering, log shipping and mirroring.
  • Plan and validate full/differential/transaction log backups, PIT restore and DR tests.
  • Monitor health, availability, performance, space, jobs, waits, blocking and logs.
  • Tune execution plans, indexes, statistics, queries and resource management.
  • Support security, access, logins/users, auditing and vulnerability remediation.
  • Coordinate with application, infrastructure, backup, security and vendor teams.
  • Lead reviews, guide DBAs, allocate tasks and ensure SLA compliance.

Skills

Always On
Failover Clustering
Backup and Recovery
T-SQL Troubleshooting
Performance Tuning
Azure SQL
PowerShell

Tools

ServiceNow
JIRA
BMC Remedy
CommVault

Job description

SQL Server DBA Lead
Role Description

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

Technical Lead - SQL DBA, SQL Server & Database Administration
Technical Lead - SQL DBA, SQL Server & Database Administration

Astra-North Infoteck Inc. • Vancouver

On-site
CAD 120,000 - 180,000
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
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 Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration
Senior Azure SQL DBA – SQL Server, Performance Tuning & Cloud Database Administration

Astra-North Infoteck Inc. • Montreal

On-site
CAD 100,000 - 150,000
SQL Database Administrator
SQL Database Administrator

HCL Technologies Limited • Calgary

On-site
CAD 100,000 - 130,000
Database Administrator
Database Administrator

JPS Tech Solutions Pvt Ltd • New Brunswick

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

Rubicon Path • Toronto

On-site
CAD 90,000 - 120,000
SQL DBA
SQL DBA

Info-Ways • Brampton

On-site
CAD 80,000 - 100,000
Enterprise Technical Team Lead
Enterprise Technical Team Lead

Amtra Solutions • Canada

On-site
CAD 100,000 - 130,000