Talent.com
Astra North Infoteck Inc.
Technical Lead - SQL DBA, SQL Server & Database AdministrationAstra North Infoteck Inc. • Vancouver, BC, ca
Technical Lead - SQL DBA, SQL Server & Database Administration

Technical Lead - SQL DBA, SQL Server & Database Administration

Astra North Infoteck Inc. • Vancouver, BC, ca
1 day ago
Job type
  • Full-time
  • Quick Apply
Job description
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,




Requirements
Sailpoint
Create a job alert for this search

Technical Lead - SQL DBA, SQL Server & Database Administration • Vancouver, BC, ca

Similar jobs

Lead PostgreSQL DBA Role at Kraken

Electric CapitalVancouver, Metro Vancouver Regional District, CA
Full-time

Elevate your career as a Lead PostgreSQL DBA at Kraken, focusing on high-throughput environments.This remote role centers on operational excellence and automation.Join a team dedicated to scaling d... Show more

 • Promoted

Senior Sql Database Developer - C$65,000 - C$130,000 A Year

Global RelayNorth Vancouver, Canada
Full-time

Develop and maintain SQL databases, scripts, and reports for enterprise services, ensuring high performance. Show more

 • Promoted

Database Reliability Engineer (DBRE) - PostgreSQL

King River Capital GroupVancouver, British Columbia, Canada
Full-time

About the Company Cover Genius is a Series E Insurtech that protects the global customers of the world’s largest digital companies including Booking Holdings, owner of Priceline, Kayak and Booking.... Show more

 • Promoted

Senior Data Architect - Oracle EBS & Cloud Integration

Stantec Consulting International Ltd.Vancouver, Metro Vancouver Regional District, CA
Full-time

A leading engineering consulting firm is seeking a Senior Data Architect in Vancouver to drive the data architecture for a new project.The ideal candidate will have over 10 years of experience, par... Show more

 • Promoted

Database Administrator: Performance & Security, HA

Yeah! GlobalVancouver
Full-time

A data-driven technology firm in Vancouver is seeking an experienced Database Administrator (DBA) to manage, optimize, and oversee database systems ensuring high performance, availability, and secu... Show more

 • Promoted

Team Lead, Software Engineering

OSI Maritime SystemsBurnaby, Metro Vancouver Regional District, Canada
Full-time

At OSI Maritime Systems, we pride ourselves on delivering world‑class navigation and bridge systems.With decades of experience serving military customers, we remain at the forefront of innovation i... Show more

 • Promoted

Remote Cloud Data Platform Engineer: Hive & SQL at Scale

ClouderaVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A leading tech company in Toronto is looking for a Sr.Software Engineer to innovate within the Hive ecosystem.This remote role requires expertise in query optimization and programming, with a focus... Show more

 • Promoted

Technical Delivery Lead for Data Solutions

ITC InfotechVancouver
Full-time

Become a Technical Delivery Lead focused on driving exceptional performance in data engineering projects within a hybrid work framework.Engage in efficient and effective delivery management across ... Show more

 • Promoted

Senior Technical Lead for Virtualization

ICBC (Insurance Corporation of British Columbia)North Vancouver, Metro Vancouver Regional District, Canada
Full-time

Take on a leadership role as a Senior Technical Specialist with The Server Cloud Foundation, focusing on Virtualization and Storage in a hybrid environment.Shape technical delivery and operational ... Show more

 • Promoted

AXIOM SQL Consultant - Remote

Info-WaysVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

BGV will be done for the selected candidates.AXIOM controller view development experience.Good experience in either US or UK Regulatory reports.Good knowledge of Axiom batch setup and processing.St... Show more

 • Promoted

Senior Database Administrator

CIRO / OCRIVancouver, Metro Vancouver Regional District, Canada
Full-time

CIRO is seeking a highly capable Senior Database Administrator (DBA) to support the performance, reliability, and integrity of our Finance Systems and enterprise data ecosystem.This role strengthen... Show more

 • Promoted

Senior Databricks Architect — Lead Cloud Data Platform

Data ElephantVancouver, Metro Vancouver Regional District, CA
Full-time

A leading data consulting firm in Canada is seeking a Senior Databricks Architect to guide clients through their data modernization journeys.In this senior technical leadership role, you will be re... Show more

 • Promoted

Remote Data Team Lead & Architect: MongoDB to Redshift

Confidential CompanyVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A growing technology firm in Toronto, Ontario is seeking a Lead Data Engineer to spearhead the migration of its data infrastructure from a monolithic to a microservices-based architecture.This is a... Show more

 • Promoted

Database Administrator

Rivago Infotech IncVancouver, Metro Vancouver Regional District, CA
Full-time

Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Rivago Infotech Inc.Location : Remote, (Open for Canada only).The DBA position will be responsible f... Show more

 • Promoted

Remote Sql Server & Healthcare Interoperability Expert - $65,000 - $73,000 A Year - Remote

MediSolutionNorth Vancouver, Canada
Remote
Full-time

Seeking an expert SQL Server and healthcare interoperability analyst for a remote role in Canada, focusing on HL7 and FHIR standards.Requires 7+ years of experience. Show more

 • Promoted

Senior Data Architect — Oracle EBS & Cloud Integrations

StantecVancouver
Full-time

A leading design and consulting firm is looking for a Senior Data Architect to optimize collaboration between project managers and accountants.The ideal candidate will develop data architecture str... Show more

 • Promoted

Data Architecture Lead - Cloud, Governance & Analytics

PathlionVancouver, Metro Vancouver Regional District, CA
Full-time

A leading technology consulting firm is looking for a Data Architect in Edmonton, Canada, to lead the design and implementation of data architectures for a public trustee solution.The ideal candida... Show more

 • Promoted

Oracle DB Admin: Remote, Cloud, Performance & Security

Ateko, backed by Bell CanadaVancouver, Metro Vancouver Regional District, CA
Remote
Full-time

A tech solutions provider in Canada is seeking an Oracle Database Administrator to maximize value for clients through effective database management.The role entails optimizing internal and client d... Show more

 • Promoted

Oracle Cloud ERP/Database expert

Next VenturesVancouver, Metro Vancouver Regional District, CA
Full-time

Head of Oracle Technologies at Next Ventures.Our client is seeking a highly experienced.Oracle Cloud ERP and Database Expert.This role requires deep expertise across Oracle technologies, cloud plat... Show more

 • Promoted

Senior Data Architect & Enterprise Data Platform Lead

Fraser HealthSurrey, British Columbia, Canada
Full-time

A health organization is seeking a skilled Data Architect to lead a Data Engineering team in Surrey, Canada.The role involves overseeing the development and implementation of large-scale data solut... Show more