Technical Lead - SQL DBA
$120k - $130k per yearBeGlobal
Technical Lead - SQL DBA
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 for the BC Hydro PU13 Database tower. 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 in the BC Hydro database management scope.
• 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 customer 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 client-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 customer 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, permissions, PowerShell scripting and deployment support.
• Experience supporting mission-critical databases with high availability, disaster recovery, monitoring and 24x7 production support practices.
• Experience with T-SQL troubleshooting, execution plans, index tuning, statistics, wait events, deadlocks, blocking, query store and database resource management.
• Experience with database security, access controls, auditing, vulnerability remediation and compliance-driven operational controls is preferred.
• Experience with SQL Server backup tools and enterprise backup platforms such as CommVault is preferred.
• Experience in utility, regulated infrastructure, NERC CIP-adjacent systems, SaaS/cloud readiness or managed services environments is preferred.
• Ability to lead a technical DBA team, guide junior resources, review deliverables and deliver tasks as per agreed SLAs and timelines.
Technical Skills
• Microsoft SQL Server Database Administration: 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, database mirroring, high availability and disaster recovery support.
• SQL Server backup and recovery, transaction log management, restore/recovery testing, point-in-time recovery and DR exercise support.
• SQL Server Management Studio, SQL Server Agent, DMVs, Query Store, Extended Events, Profiler, performance counters and monitoring tools.
• T-SQL, stored procedures, functions, jobs, indexes, statistics, execution plan analysis, wait statistics, deadlock/blocking analysis and performance tuning.
• Windows Server administration for DBA support, PowerShell scripting, event log analysis, service account handling, storage checks and deployment support.
• Database security, auditing, access management, encryption awareness, vulnerability remediation and compliance support.
• Azure SQL, SQL Server on Azure VM, Azure Arc-enabled SQL Server, automation, or cloud readiness experience is preferred.
• Knowledge of ITIL processes, incident/problem/change/release management and service management tools such as ServiceNow/Jira/BMC Remedy.
• Managed services operations, SLA reporting, RCA documentation, runbooks, SOPs, audit evidence and knowledge management.
Key words to search in Resume:
SQL DBA Technical Lead, Microsoft SQL Server DBA, SQL Server Administrator, SQL Server 2019, SQL Server 2022, Always On Availability Groups, Failover Cluster, Log Shipping, Replication, Database Mirroring, SQL Server Agent, SSMS, T-SQL, Query Store, Extended Events, Performance Tuning, Backup and Recovery, Disaster Recovery, Database Security, PowerShell, CommVault, ServiceNow, ITIL, BC Hydro
$90k - $105k per year
...Technical Support Lead Location: Hybrid / Vancouver, WA (HQ): 3-4 days/week in-office Reports to: Chief Product Officer Job Type: Full-Time, Exempt About Digs Digs is an innovative startup building software that revolutionizes collaboration between builders...SuggestedLong term contractFull timeWork at officeWork visa3 days per week$55k - $75k per year
...Technical Support Lead Position Type: Full Time, Permanent About Portable Electric At Portable Electric, we believe in a future without GHG generators. We believe the future is electric. We are a Vancouver-based clean tech manufacturer, connecting teams to clean...SuggestedPermanent employmentFull timeWork at office$120k - $130k per year
...Technical Lead - IBM TRIRIGA Join BC's leading utility company at their Vancouver office. 10-15 Years Roles and Responsibilities: The... ...performance or production support issues. • Working knowledge of SQL and relational databases such as Oracle, DB2 or SQL Server. •...SuggestedFull timeWork at office$211k - $240k per year
...out there–no matter how big or small the team, and no matter which tools or workflows they use. We’re looking for a staff-level Technical Lead to drive execution and technical vision for our developer platform. Our API team has huge, cross-cutting scope: one day you’ll be...SuggestedLong term contractWork at officeLocal areaWork from homeWorldwideFlexible hours1 day per week$150k - $180k per year
...and 180+ supplier and ERP integrations. We are seeking a Team Lead, Software Engineering to guide a focused, high-performing agile pod... .... This role features a split between hands-on engineering and technical management. You will serve as a key technical contributor to our...SuggestedFor contractorsWork at officeRelocationRemarcable, Inc.
Vancouver, BC26 days ago$100k - $125k per year
...Job Description Overview AtkinsRéalis Project Delivery team is hiring a Project Technical Lead (PTL) based out of our Vancouver office. Our Project PTL's are responsible for the timely and efficient coordination and delivery of transmission and substation projects...Full timeInternshipWork at officeImmediate startFlexible hours- ...Data Cloud Platform Engineer (DBA) - AWS Infrastructure At INTRALOT... ...production systems. Technical Skills (AWS-Focused) AWS Databases... ...: MySQL, PostgreSQL, Oracle, SQL Server (one or more).... ...company established in 1992, is a leading gaming solutions supplier and operator...Full timeWorldwide
- ...Position Title: Technical Lead Team: Indigenous Led Assessment (ILA) Reports to: Business Lead Job Location: Western Canada Travel: Up to 4 days of travel per month required ORGANIZATIONAL STATUS Firelight is an Indigenous-owned consultancy that provides research...Long term contractFull timeTemporary workRemote work
- ...Qualified people may cover more than one role. Clients internal team leads product business project management UX/design and English/French content. Archive leads technical delivery and handover. All candidates should demonstrate relevant delivery...Long term contractFull timeContract workFor contractorsRemote work
$120k - $130k per year
...Technical Lead - Atlassian Guard 10-15 Years Roles and Responsibilities: The person will be responsible for leading Atlassian Guard administration, security operations, governance and technical support for the BC Hydro Technology tower. The role requires strong hands-...Full time- Job Description Responsible for the technical R&D and quality breakthroughs of the runtime animation system for the dual-perspective shooting... ...development plans and advance cross-team implementation. Lead and mentor the animation TA team through matrix management, with...Full timeLocal area
$55.02 per hour
...The Opportunity The Technical Product Development Lead is responsible for managing the development of systems and assigned features. They use their technical knowledge to bridge the gap between product and technical aspects of product development. They collaborate closely...Hourly payFull timeWork at office- ...MistyWest is seeking a Technical Lead to lead the development of innovative hardware products from concept through production. This role is ideal for an experienced engineering professional who thrives in multidisciplinary product development environments and enjoys solving...Full timeInternship
$141.4k - $204.4k per year
...is a diverse group of talented developers dedicated to solving unique technical challenges to create the most authentic on-ice experience for millions of players worldwide. The Senior Technical Lead – Core Technology is the strategic technical leader for the foundational...Long term contractFull timeLocal areaWorldwide3 days per week- ...Technical Recruiter — Remarcable, Inc. Remarcable, Inc. is growing fast, and our success depends on finding exceptional technical talent... ...About the Role We're seeking a seasoned Technical Recruiter to lead sourcing and hiring efforts across our engineering and product teams...Full timeInternshipWork at officeShift work
- ...intelligence. About The Role We are seeking a Lead Data Engineer to join our Measurement team... ...such as Airflow, Snowflake, MS SQL Server and .Net. Experience designing and... ...Management and stakeholders, as well as both technical and non-technical team members to deliver...Full timeWork at office
- ...ERP Technical Solutions Specialist VersaFile , an RKO Company is a Vancouver-based technology services and software company providing... ...to SuccessFactors, BTP, and SAP cloud apps Databases: SQL, Oracle, DB2 Storage: on-prem (NAS/SAN) and cloud object storage...Remote jobPermanent employmentFull timeWork from home
- ...software architecture to help organizations improve learning outcomes, engagement, and operational performance. We are looking for a Technical Lead who can help us scale our XR platform and lead the technical direction of our next generation of AI-powered immersive training...Permanent employment
$106.4k - $139.65k per year
...We are looking for a motivated and customer-oriented Security Technical Architect for our Security Practice with our Head Office team!... ...initiation through to successful implementation Implement industry leading security solutions by understanding client requirements through...Long term contractFull timeWork at office$70k - $90k per year
...Martin’s Lane Winery, and CheckMate Artisanal Winery. As a Technical Privacy Analyst at MAG, you will support the delivery of our global... ...Leave Paid time off An extensive offering of world leading learning and development programs to empower your career development...Full timeWork at office$21 - $26 per hour
...the continuous learning and growth of our teams. As a Culinary Leader, you will directly contribute to the overall success of a multi-... ...for your team’s delivery of a consistent and crafted product and leading through genuine warmth and care, providing our guests with memorable...Full timePart timeFlexible hours$187k - $220k per year
...wide effort and responsibility and we encourage all Asanas to adopt the motto “Always Be Recruiting.” As the Head of Technical Recruiting, you will lead a team of seasoned talent acquisition professionals to support R&D hiring at Asana. You will be responsible for driving...Long term contractFull timeWork at officeLocal areaWork from homeWorldwide$130k - $170k per year
...DataVisor DataVisor is the world’s leading AI-powered Fraud and Risk... ...is recognized as an industry leader and has been adopted by many... ...mentoring engineers, and driving technical execution in a high-impact... ...systems, relational databases, and SQL. Experience building and...Full time$100k - $120k per year
...like Glean and Vanta. Why This Role Exists We’re growing quickly, and hiring is accelerating across all functions, including our technical teams in APAC and Canada. This role exists because building great teams requires more than managing inbound applications. This is...Full timeContract workWork at office$84k - $119.7k per year
...LMI is seeking a results-driven experienced Technical Recruiter to provide recruitment services and work with the LMI HR team to support accelerated... ...as an in-house recruiter Strong sourcing, networking and lead generation skills that demonstrate tenacity, creativity and...Long term contractFull timeWork at officeLocal areaWorldwideRelocation package$52.86k - $60.79k per year
...way that companies bank. Being the market leader in ERP Banking, we work with the world’s Tier... ...effective troubleshooting of clients’ technical issues of a complex nature. ~ Work with... ...decision-making processes required to lead a global, mature technology company....Permanent employmentFull timeWork at officeImmediate startFlexible hours$132k - $150k per year
...We're hiring a Senior Technical Program Manager to lead Asana's push into agentic work management — building the programs that let AI teammates plan, execute, and orchestrate work alongside humans . You'll drive initiatives spanning the Asana Work Management Platform which...Long term contractFull timeWork at officeLocal areaWork from homeWorldwide$70k - $80k per year
...Technical Customer Success Manager Technical - Civil Engineering Location: Remote within Canada (Occasional Travel Required)... ...Track project progress and coordinate with internal technical leads to ensure timely, accurate delivery Support account managers...Full timeContract workInternshipRemote workFlexible hours$90k - $110k per year
...impact.com : impact.com is the world’s leading commerce partnership marketing platform,... ...Your Role at impact.com : The QA Lead is responsible for defining, implementing,... ...products for the group. This role bridges technical QA execution and leadership, guiding QA engineers...Long term contractFull timeTemporary workLocal areaHome officeFlexible hours$186k - $236k per year
...and contribute to global engineering standards. You will balance technical excellence with mentorship, acting as a role model and coaching others... ...languages and tools is essential. You possess the ability to lead major code design decisions and contribute to wider technical...Long term contractFull timeWork at officeWork from home
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Technical Lead - SQL DBA. Be the first to apply!
- tech lead Vancouver, BC
- sql database administrator Vancouver, BC
- technique Vancouver, BC
- electro technical officer Vancouver, BC
- technical writing Vancouver, BC
- ventes techniques Vancouver, BC
- technical customer success manager Vancouver, BC
- soutien technique Vancouver, BC
- spécialiste technique Vancouver, BC
- sql Vancouver, BC