[Hiring] Senior SQL Server Database Administrator @Procom

Role Description

We are seeking an experienced Senior SQL Server Database Administrator (DBA) to join our Enterprise DBA team on a contract basis. This is a hands-on senior technical role responsible for supporting, maintaining, troubleshooting, and improving Microsoft SQL Server environments across a large enterprise portfolio.

• Operate with a high degree of independence.
• Take ownership of complex technical issues and assigned initiatives.
• Provide senior-level expertise across SQL Server operations, performance, high availability, disaster recovery, security, upgrades, migrations, and platform modernization.
• Become productive quickly and independently assess technical issues.
• Recommend appropriate solutions and drive work through to completion.
• Collaborate effectively with DBAs, infrastructure teams, application teams, vendors, and other stakeholders.
• Participate in the team's out-of-hours on-call rotation.
• Rapidly develop familiarity with the environment and operational procedures.
• Focus on operational discipline, documentation, knowledge transfer, and repeatable processes.

Qualifications

• 8+ years of hands-on SQL Server DBA experience, with significant experience operating at a senior level in complex enterprise environments.
• Demonstrated ability to independently administer and troubleshoot business-critical production SQL Server environments.
• Deep knowledge of Microsoft SQL Server administration, ideally across SQL Server 2016 through current supported versions.
• Strong understanding of SQL Server architecture, including the database engine, memory management, storage, transaction logging, tempdb, locking, concurrency, and query processing.
• Advanced experience troubleshooting SQL Server performance using DMVs, wait statistics, execution plans, Query Store, Extended Events, indexing analysis, and other diagnostic techniques.
• Strong experience designing and supporting backup, restore, and disaster recovery strategies, including point-in-time recovery and recovery validation.
• Significant hands-on experience with Always On Availability Groups and/or Windows Server Failover Clustering.
• Strong practical experience supporting and troubleshooting SQL Server replication.
• Experience performing SQL Server installations, cumulative updates, patching, version upgrades, migrations, and server/database consolidation activities.
• Strong knowledge of SQL Server security, including authentication, authorization, roles, permissions, service accounts, encryption, and least-privilege principles.
• Strong T-SQL scripting and troubleshooting skills.
• Experience automating DBA activities using PowerShell and/or other scripting technologies.
• Experience using enterprise database monitoring platforms such as SolarWinds, SentryOne, Redgate, or equivalent tools.
• Hands-on experience administering SQL Server backup and recovery through Commvault, including backup configuration, troubleshooting, point-in-time restores, and recovery validation.
• Experience operating within formal ITIL-aligned incident, problem, request, and change management processes, preferably using ServiceNow.
• Demonstrated experience producing clear, usable technical documentation and operational runbooks.
• Previous experience participating in an out-of-hours/on-call support rotation for business-critical database environments.

Requirements

• Experience administering Azure SQL Database and Azure SQL Managed Instance.
• Experience migrating workloads between on-premises SQL Server and Azure SQL platforms.
• Experience with SQL Server infrastructure running on VMware or other virtualized enterprise infrastructure.
• Experience with enterprise monitoring and observability platforms such as SolarWinds and SCOM.
• Experience working with vulnerability management and remediation processes and tools.
• Familiarity with DevOps and database deployment practices, including source control and CI/CD pipelines.
• Experience developing repeatable automation and standardized SQL Server deployment and configuration processes.
• Experience participating in SQL Server estate modernization, consolidation, lifecycle management, or large-scale migration programs.
• Microsoft SQL Server or Azure certifications are beneficial but are not a substitute for demonstrated senior-level hands-on experience.

Benefits

• 12 month assignment with possible extension/s.
• Fully remote role from BC, or occasional office visits if based in Calgary, AB.
• Working hours are MST timezone.