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
5 hours ago
Job type
  • Full-time
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,



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 Azure Cloud Architect - Migration Lead

Huntel GlobalVancouver, Metro Vancouver Regional District, CA
Full-time

A leading IT staffing firm in Ontario is seeking a Senior Azure Cloud Specialist to lead cloud migration projects and engage stakeholders.Candidates should be proficient in enterprise cloud strateg... Show more

 • Promoted

PBCS Migration Lead - Oracle Hyperion Planning

SA TECHNOLOGIESVancouver, Metro Vancouver Regional District, CA
Full-time

A leading IT consulting firm in Canada is seeking an Oracle Hyperion Planning Lead for a migration project to Cloud-based PBCS.The ideal candidate must have prior PBCS migration experience.This con... 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

Lead Azure Data Architect(15+ Years Required)

QData IncVancouver, Metro Vancouver Regional District, CA
Full-time

Senior Azure Databricks Architect.Python skills and a passion for building scalable data solutions in the cloud? Join our team to lead architecture, optimize pipelines, and drive innovation across ... 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

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 Lead, Data & Storage Platforms (Remote)

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

A technology company in Prince Edward Island is seeking a Senior Manager, Software Engineering to lead engineering teams in developing frameworks and tools for data and storage services.The role re... Show more

 • Promoted

Senior Dev Engineer RDS Oracle - AWS

AmazonVancouver, Metro Vancouver Regional District, CA
Full-time

Become a key player at Amazon Web Services as a Senior Software Development Engineer III within the RDS for Oracle team in Vancouver, BC.Own the design and development of database capabilities for ... 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

Remote Head of Data Infrastructure & Analytics

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

A leading e-commerce company is hiring a Head of Data Infrastructure and Analytics to architect systems ensuring data reliability for strategic decisions.This fully remote position emphasizes build... Show more

 • Promoted

AI Workflow Adoption Lead

EviSmartVancouver, Metro Vancouver Regional District, CA
Full-time

Most AI rollouts fail not because the tools are wrong — but because nobody owns the behavior change.EviSmart's business teams — sales, customer success, finance, product, marketing — have access to... 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

SAP SD/LE/TM Strategic Lead in Canada

NTT DATA North AmericaBurnaby, Metro Vancouver Regional District, Canada
Full-time

Drive innovation at NTT DATA as a Strategic Lead for SAP SD/LE/TM based in Burnaby, British Columbia.Utilize your extensive knowledge in sales, transportation management, and logistics execution to... 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

Data Platform Lead for Scalable Solutions (Remote)

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

A healthcare technology company is looking for a seasoned Data Engineering Manager to shape their Data Platform while leading a team of data engineers.This remote role requires significant expertis... Show more