Senior SQL Server Database Lead

16 hours ago

Vancouver, Metro Vancouver Regional District, Canada Astra-North Infoteck Inc. Full-time €120,000 - €180,000 Contract
Lead enterprise SQL Server operations in Vancouver with hands-on database administration, performance tuning, and high-availability expertise. Coordinate technical delivery across teams. This Technical Lead role requires 10–15 years of Microsoft SQL Server production support experience. You will guide DBAs, provide L2/L3 support, and manage enterprise database platforms. The work spans SQL Server 2016, 2019, 2022 or later, Windows Server, PowerShell, and SQL Agent.

Key Responsibilities
- Lead end-to-end SQL Server DBA operations and technical delivery
- Administer installations, upgrades, patching, migrations, cloning, and refreshes
- Manage Always On, clustering, replication, mirroring, and log shipping
- Plan backups, restore testing, point-in-time recovery, and DR exercises
- Coordinate application, infrastructure, security, vendor, and customer teams

Requirements:
- Minimum 10–15 years enterprise Microsoft SQL Server experience
- Expertise with SSMS, SQL Agent, HA, DR, and backup recovery
- Knowledge of Windows Server, services, permissions, and PowerShell
- Experience troubleshooting T-SQL, waits, deadlocks, blocking, and execution plans
- Ability to lead DBAs and deliver to SLA Apply your SQL Server leadership, availability management, and recovery expertise to mission-critical enterprise database operations in Vancouver.