Technical Lead - SQL DBA, SQL Server & Database Administration

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Vancouver; On-site; CAD 120,000 - 170,000; Full time

Job summary

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! seeks a Technical Lead - SQL DBA to guide Microsoft SQL Server database administration, production support and governance. You will lead end-to-end DBA operations and ensure high availability and performance across enterprise databases.

The role requires hands-on expertise, strong leadership, and collaboration with application, infrastructure, security and vendor teams to deliver reliable database services.

Qualifications

• Experience leading Microsoft SQL Server DBA operations.
• Strong hands-on SQL Server production support and governance.
• Ability to coordinate with cross-functional teams.
• Experience in enterprise database administration.

Responsibilities

• Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support for Microsoft SQL Server databases.
• Administer SQL Server environments including installation, configuration, upgrades, patching, migrations, cloning, database refresh, SQL Agent jobs, storage planning and capacity management.
• Manage high availability and disaster recovery technologies such as 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 DR exercise support.
• Monitor database health, availability, performance, space, jobs, alerts, wait statistics, blocking, deadlocks and logs using SQL Server Management Studio, SQL Server Agent, DMVs or monitoring platforms.
• Analyze and tune SQL Server performance using execution plans, index tuning, statistics maintenance, query optimization, wait analysis, memory/CPU/I/O trend analysis and workload reviews.
• Support security, access management, SQL logins/users/roles, auditing, encryption awareness, vulnerability remediation and compliance controls for SQL Server databases.
• Troubleshoot production incidents such as database availability issues, backup failures, transaction log growth, storage/disk capacity issues, SQL Agent job failures, application connectivity issues and authentication problems.
• Coordinate with application teams, infrastructure teams, backup teams, Windows/Unix teams, security teams, vendors and stakeholders for incident and change resolution.
• Lead technical reviews, guide DBA team members, perform peer reviews, support task allocation and ensure adherence to standards, SOPs and SLA commitments.
• Participate in incident, problem, service request, change, release and knowledge management processes using approved service management tools.
• Prepare and maintain runbooks, SOPs, architecture notes, implementation plans, deployment steps, DR test evidence, RCA documents, release notes and knowledge articles.

Skills

SQL Server DBA

Technical leadership

Troubleshooting

Performance tuning

Tools

SQL Server Management Studio

DMVs / Monitoring platforms

Always On Availability Groups

Failover Clustering

Job description

Technical Lead - SQL DBA, SQL Server & Database Administration

Experience Required: 10-15 Years

Roles and Responsibilities:

The person will be responsible for leading Microsoft SQL Server database administration, production support, operational governance and database service delivery. The role requires strong hands-on SQL DBA expertise, technical leadership, troubleshooting capability, database availability management, performance tuning, backup and recovery governance, and coordination with application, infrastructure, security, compliance and vendor teams.

Key Accountabilities:

• Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support for Microsoft SQL Server databases.


• Administer SQL Server environments including installation, configuration, upgrades, patching, migrations, cloning, database refresh, SQL Agent jobs, storage planning and capacity management.


• Manage high availability and disaster recovery technologies such as 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 DR exercise support.


• Monitor database health, availability, performance, space, jobs, alerts, wait statistics, blocking, deadlocks and logs using SQL Server Management Studio, SQL Server Agent, DMVs or monitoring platforms.


• Analyze and tune SQL Server performance using execution plans, index tuning, statistics maintenance, query optimization, wait analysis, memory/CPU/I/O trend analysis and workload reviews.


• Support security, access management, SQL logins/users/roles, auditing, encryption awareness, vulnerability remediation and compliance controls for SQL Server databases.


• Troubleshoot production incidents such as database availability issues, backup failures, transaction log growth, storage/disk capacity issues, SQL Agent job failures, application connectivity issues and authentication problems.


• Coordinate with application teams, infrastructure teams, backup teams, Windows/Unix teams, security teams, vendors and stakeholders for incident and change resolution.


• Lead technical reviews, guide DBA team members, perform peer reviews, support task allocation and ensure adherence to standards, SOPs and SLA commitments.


• Participate in incident, problem, service request, change, release and knowledge management processes using approved service management tools.


• Prepare and maintain runbooks, SOPs, architecture notes, implementation plans, deployment steps, DR test evidence, RCA documents, release notes and knowledge articles.

Experience required:

• Good communication skills with ability to work with stakeholders, application owners, infrastructure teams, security teams, DBAs and delivery leadership.


• Minimum 10-15 years of IT experience with strong hands-on Microsoft SQL Server DBA experience in production support and enterprise database administration.


• Strong experience with SQL Server 2016/2019/2022 or later, SQL Server Management Studio, SQL Server Agent, Always On Availability Groups, Failover Clustering and backup/recovery.


• Experience in SQL Server installation, configuration, patching, upgrades, migrations, database refresh, backup/recovery, performance tuning and operational monitoring.


• Experience in Windows Server environments including service management, event log review, filesystem checks,