Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 10 hours ago
AI Cybersecurity Architect (GenAI Security, AI Risk Management, Cloud Security, Cyber Defense)
Astra North Infoteck Inc.
Toronto, ON
Partner with security, architecture, risk, compliance, and technology teams to establish:
Added 10 hours ago
AN
Security Architect (Cybersecurity, Cloud Security, Risk Management, NIST, CISSP)
Astra North Infoteck Inc.
Toronto, ON
- Contract
The Information Security team partners with departments to advance technology and third-party information/cyber risk management capabilities that enable the Fund to compete effectively and…
Added 10 hours ago
Java Full Stack Technical Lead – Java, Spring Boot, React, Kafka, DevSecOps
Astra North Infoteck Inc.
Mississauga, ON
Must Have Technical/Functional Skills
Added 10 hours ago
Java Cloud Architect – Azure, Spring Boot & Microservices
Astra North Infoteck Inc.
Toronto, ON
Lead application modernization and cloud transformation initiatives for enterprise Java applications on Microsoft Azure
Added 10 hours ago
Azure Solution Architect – Cloud, Integration & Enterprise Architecture
Astra North Infoteck Inc.
Toronto, ON
Lead application modernization, cloud migration, and enterprise platform transformation initiatives.
Added 10 hours ago
RSA Archer Solution Architect – GRC, Risk & Compliance
Astra North Infoteck Inc.
Toronto, ON
Lead architecture reviews, roadmap planning, and modernization initiatives.
Added 10 hours ago
AN
Senior Business Systems Analyst – Wealth Management & SQL
Astra North Infoteck Inc.
Toronto, ON
- Contract
…modernization of a portfolio management platform. The role will lead functional analysis, requirements, system/data analysis, integration design, and collaboration with business and…
Added 10 hours ago
Consulting Partner – IT/Digital Consulting, Construction Engineering & Digital Transformation
Astra North Infoteck Inc.
Montréal, QC
…consulting-led sales, solution shaping, and oversight of complex technology programs across areas such as cloud, data, AI, cybersecurity, enterprise platforms, and digital modernization.…
Added 10 hours ago
Senior Level 3 AI Engineer – Copilot, ChatGPT, Grok, Claude & Gemini
Astra North Infoteck Inc.
Montréal, QC
…complex queries that front-line support cannot resolve, work with lead Microsoft and vendor engineers on new features, and uplift the wider support team. Each engineer maintains broad…
Added 10 hours ago
Technical Lead – IBM TRIRIGA, Maximo Real Estate & Facilities
Astra North Infoteck Inc.
Vancouver, BC
Lead solution design, configuration, customization and enhancement activities across IBM TRIRIGA modules such as Real Estate, Lease, Space, Facilities, Operations, Maintenance and Capital…
Added 10 hours ago
Solution Architect – ServiceNow, ITSM, ITOM, CMDB & SecOps
Astra North Infoteck Inc.
Vancouver, BC
Own ServiceNow solution architecture across ITSM, ITOM, CMDB, SecOps and related ServiceNow platform capabilities for the Technology tower.
Added 10 hours ago
Technical Lead - Atlassian Guard, Atlassian Cloud & Identity Security
Astra North Infoteck Inc.
Vancouver, BC
…security operations, governance and technical support for the Technology tower. The role requires strong hands-on experience with Atlassian Cloud security, identity and access management,…
Added 10 hours ago
Technical Lead - SQL DBA, SQL Server & Database Administration
Astra North Infoteck Inc.
Vancouver, BC
Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support.
Added 10 hours ago
Dynamics 365 Lead Developer – Customer Service, Power Apps & Azure
Astra North Infoteck Inc.
Montréal, QC
Dynamics 365 Lead Developer – Power Platform, Azure & C#
Added 10 hours ago
AN
QE Automation Lead – Mobile, Appium, Selenium, Playwright & Rest Assured
Astra North Infoteck Inc.
Toronto, ON
- Contract
Added 10 hours ago
AN
RPA Platform Engineer.
Astra North Infoteck Inc.
Toronto, ON
- Contract
(including technology strategy & architecture) to the overall design of a
Added 10 hours ago
AN
Network Security Architect - Palo Alto Prisma SD-WAN (ION), AWS, PCNSA / PCNSE
Astra North Infoteck Inc.
Québec, QC
- Contract
Added 10 hours ago
AN
Cloud Solutions Architect - AWS & Azure
Astra North Infoteck Inc.
Toronto, ON
- Full-time
· Lead cloud migration transformation initiatives,
Added 10 hours ago
AN
Microsoft 365 & Exchange Administrator
Astra North Infoteck Inc.
Calgary, AB
- Contract
This role requires strong hands-on experience in enterprise-scale Microsoft cloud environments and the ability to lead complex migration, modernization, and operational initiatives.
Added 10 hours ago
Generative AI / Agentic AI Architect – Azure AI Foundry & Databricks
Astra North Infoteck Inc.
Toronto, ON
Lead AI solution deployment strategies, ensuring scalability, reliability, security, and maintainability.
Added 10 hours ago
Solution Architect – Salesforce Service Cloud Voice, Amazon Connect & Contact Center
Astra North Infoteck Inc.
Toronto, ON
Added 10 hours ago
Open Liberty Architect – WebSphere Liberty, Java & Spring Boot
Astra North Infoteck Inc.
Toronto, ON
Lead application modernization and migration programs from traditional WebSphere Application Server (WAS) to Open Liberty.
Added 10 hours ago
Technical Lead – Azure / Node.js / React
Astra North Infoteck Inc.
Toronto, ON
Lead the design, architecture, development, and delivery of cloud-native applications using Microsoft Azure, Node.js, React, AKS, and modern DevOps practices. Act as the primary technical…
Added 10 hours ago
Solution Architect – Enterprise Architecture | Cyber Security | Cloud | AWS | Azure | GCP
Astra North Infoteck Inc.
Toronto, ON
…compliance, governance, corporate security and policy library technology strategy, focusing on architecture blueprints, capabilities models, and proven enterprise…
Added 10 hours ago
Cloud Solutions Architect – Azure | AWS | Cloud Migration | Terraform | Kubernetes
Astra North Infoteck Inc.
Toronto, ON
Lead cloud migration transformation initiatives, including assessments, wave planning, modernization, and execution.

Astra North Infoteck Inc.

Technical Lead - SQL DBA, SQL Server & Database Administration

Vancouver, BC, Canada

Apply on astra-north.zohorecruit.ca About employer

Applications open in a new tab.

Job details

Experience: Minimum 10–15 years of enterprise Microsoft SQL Server DBA production support experience.
Posting language: English
Posted: Nov 5, 2026

Original 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.

Apply on astra-north.zohorecruit.ca About employer

More about this job

Responsibilities

The SQL Server DBA Lead at Astra North Infoteck will manage SQL Server installs, upgrades, patching, backups and restores, and high availability setups. The role also tunes performance, handles incidents and leads a team of DBAs.

Requirements

Candidates need 10-15 years of enterprise Microsoft SQL Server DBA production support experience. They must know SQL Server 2016/2019/2022, Always On, clustering, backup and recovery, and T-SQL performance tuning.

Skills

SQL Server 2016/2019/2022
SQL Server Management Studio (SSMS)
SQL Agent
Always On Availability Groups
Failover Cluster Instances
Log shipping
Replication
Database mirroring
Backup and recovery
Transaction log management
Restore testing
Point-in-time recovery
Disaster recovery
T-SQL
Execution plan analysis
Index and statistics tuning
Query Store
Extended Events
SQL Profiler
DMVs
Windows Server
PowerShell
Database security
Azure SQL
CommVault

Keywords

SQL Server
SQL DBA
Database Administrator
Always On Availability Groups
Failover Cluster Instance
log shipping
replication
mirroring
backup and recovery
disaster recovery
high availability
performance tuning
T-SQL
SQL Agent
Query Store
PowerShell
Windows Server
Azure SQL
CommVault
ITIL

Seniority

Lead

Tools

SQL Server
SSMS
SQL Agent
PowerShell
CommVault
ServiceNow
Jira
BMC Remedy

Report this job

Work requirements

Jobs in Canada