Back to All Positions

SQL DBA - Senior Technical Lead

IT & InfrastructureOnsiteFull-timeID: REQ-43643
N2P Systems
Vancouver, BC, Canada10+ years$120K - $130K CADPosted 2 weeks ago
Apply for this Role

Role Overview

## Role Overview We are seeking a Senior SQL DBA Technical Lead to lead Microsoft SQL Server database administration, production support, operational governance, and database service delivery for the BC Hydro database management scope. The role requires strong hands-on SQL Server expertise combined with technical leadership, advanced troubleshooting, performance optimization, high availability, disaster recovery, and enterprise production support capabilities. The successful candidate will work closely with application, infrastructure, security, compliance, vendor, and customer teams while ensuring database services meet operational standards, SLAs, security requirements, and reliability expectations. ## Key Responsibilities - Lead end-to-end Microsoft SQL Server DBA operations, technical delivery, and L2/L3 production support. - Administer SQL Server environments including installation, configuration, patching, upgrades, migrations, cloning, database refreshes, SQL Agent jobs, storage planning, and capacity management. - Manage high availability and disaster recovery environments using Always On Availability Groups, Failover Cluster Instances, log shipping, replication, and database mirroring where applicable. - Plan, validate, and support backup and recovery operations including full, differential, and transaction log backups, restore testing, point-in-time recovery, and disaster recovery exercises. - Monitor database health, availability, performance, storage, jobs, alerts, wait statistics, blocking, deadlocks, and logs. - Perform SQL Server performance tuning using execution plans, index and statistics analysis, query optimization, wait analysis, and memory, CPU, and I/O trend analysis. - Troubleshoot production incidents including availability issues, backup failures, transaction log growth, storage capacity issues, SQL Agent failures, connectivity problems, and authentication issues. - Support database security, access management, auditing, encryption awareness, vulnerability remediation, and compliance controls. - Coordinate incident and change resolution with application, infrastructure, backup, Windows/Unix, security, vendor, and customer stakeholder teams. - Lead technical reviews, guide DBA team members, perform peer reviews, support task allocation, and ensure adherence to SOPs and SLA commitments. - Participate in incident, problem, service request, change, release, and knowledge management processes. - Create and maintain runbooks, SOPs, architecture notes, implementation plans, deployment procedures, DR evidence, RCA documents, release notes, and knowledge articles. ## Project Goals - Maintain reliable and highly available enterprise SQL Server database services supporting mission-critical operations. - Improve database performance, stability, capacity management, backup/recovery readiness, and disaster recovery capabilities. - Provide strong technical leadership across DBA operations while meeting service-level, governance, security, and compliance requirements. - Drive effective production incident resolution, root-cause analysis, operational standardization, and continuous improvement.

Key Responsibilities

  • Lead end-to-end Microsoft SQL Server DBA operations, technical delivery, and L2/L3 production support.
  • Administer SQL Server environments including installation, configuration, patching, upgrades, migrations, cloning, database refreshes, SQL Agent jobs, storage planning, and capacity management.
  • Manage high availability and disaster recovery environments using Always On Availability Groups, Failover Cluster Instances, log shipping, replication, and database mirroring where applicable.
  • Plan, validate, and support backup and recovery operations including full, differential, and transaction log backups, restore testing, point-in-time recovery, and disaster recovery exercises.
  • Monitor database health, availability, performance, storage, jobs, alerts, wait statistics, blocking, deadlocks, and logs.
  • Perform SQL Server performance tuning using execution plans, index and statistics analysis, query optimization, wait analysis, and memory, CPU, and I/O trend analysis.
  • Troubleshoot production incidents including availability issues, backup failures, transaction log growth, storage capacity issues, SQL Agent failures, connectivity problems, and authentication issues.
  • Support database security, access management, auditing, encryption awareness, vulnerability remediation, and compliance controls.
  • Coordinate incident and change resolution with application, infrastructure, backup, Windows/Unix, security, vendor, and customer stakeholder teams.
  • Lead technical reviews, guide DBA team members, perform peer reviews, support task allocation, and ensure adherence to SOPs and SLA commitments.
  • Participate in incident, problem, service request, change, release, and knowledge management processes.
  • Create and maintain runbooks, SOPs, architecture notes, implementation plans, deployment procedures, DR evidence, RCA documents, release notes, and knowledge articles.
  • ## Project Goals
  • Maintain reliable and highly available enterprise SQL Server database services supporting mission-critical operations.
  • Improve database performance, stability, capacity management, backup/recovery readiness, and disaster recovery capabilities.
  • Provide strong technical leadership across DBA operations while meeting service-level, governance, security, and compliance requirements.
  • Drive effective production incident resolution, root-cause analysis, operational standardization, and continuous improvement.

Required Skills & Qualifications

  • Strong proficiency and experience with Microsoft SQL Server Database Administration
  • Strong proficiency and experience with SQL Server 2016/2019/2022
  • Strong proficiency and experience with Always On Availability Groups
  • Strong proficiency and experience with Failover Clustering
  • Strong proficiency and experience with Backup and Recovery
  • Strong proficiency and experience with SQL Server Performance Tuning
  • Strong proficiency and experience with T-SQL
  • Strong proficiency and experience with SQL Server Installation and Configuration
  • Strong proficiency and experience with Windows Server
  • Strong proficiency and experience with PowerShell
  • Strong proficiency and experience with Production Support
  • Strong proficiency and experience with Technical DBA Leadership
  • Strong proficiency and experience with SQL Server Management Studio (SSMS)
  • Strong proficiency and experience with SQL Server Agent
  • Strong proficiency and experience with High Availability and Disaster Recovery
  • Strong proficiency and experience with SQL Server Installation, Configuration, Patching and Upgrades
  • Strong proficiency and experience with SQL Server Migration
  • Strong proficiency and experience with Performance Tuning
  • Strong proficiency and experience with Execution Plan Analysis
  • Strong proficiency and experience with Index and Statistics Tuning
  • Strong proficiency and experience with Wait Statistics
  • Strong proficiency and experience with Blocking and Deadlock Troubleshooting
  • Strong proficiency and experience with Technical Leadership
  • Strong proficiency and experience with Enterprise Database Administration

Target Tech Stack

Microsoft SQL Server Database AdministrationSQL Server 2016/2019/2022Always On Availability GroupsFailover ClusteringBackup and RecoverySQL Server Performance TuningT-SQLSQL Server Installation and ConfigurationWindows ServerPowerShellProduction SupportTechnical DBA LeadershipMicrosoft SQL ServerSQL Server Database AdministrationSQL Server Management Studio (SSMS)SQL Server AgentFailover Cluster InstancesLog ShippingReplicationDatabase MirroringHigh AvailabilityDisaster RecoveryPoint-in-Time RecoverySQL Server Patching and UpgradesSQL Server MigrationDatabase Cloning and RefreshPerformance TuningExecution PlansIndex TuningStatistics ManagementWait StatisticsBlocking and Deadlock AnalysisQuery StoreExtended EventsDMVsDatabase MonitoringDatabase SecurityAuditingAccess ManagementVulnerability RemediationCapacity ManagementStorage ManagementITILIncident ManagementProblem ManagementChange ManagementRelease ManagementServiceNowJiraBMC RemedyManaged ServicesSLA ManagementRCA DocumentationRunbooksSOPsHigh Availability and Disaster RecoverySQL Server Installation, Configuration, Patching and UpgradesExecution Plan AnalysisIndex and Statistics TuningBlocking and Deadlock TroubleshootingTechnical LeadershipEnterprise Database AdministrationDatabase Security and AuditingCommVaultAzure SQLSQL Server on Azure VMAzure Arc-enabled SQL ServerUtility or regulated infrastructure experienceNERC CIP-adjacent environmentsSaaS/Cloud Readiness

Quick Details

Location
Vancouver, BC, Canada
Employment Type
Full-time
Work Arrangement
Onsite
Experience Level
10+ years
Compensation
$120K - $130K CAD
Domain Focus
IT & Infrastructure
Requisition Ref
REQ-43643

Ready to Apply?

Submit your resume and contact information. Our recruitment lead for this role will review your dossier and connect with you.

Apply for this Role