Provide senior-level administration and operational support for enterprise Microsoft SQL Server environments, taking ownership of complex technical issues through diagnosis, resolution, and documentation.

Rapidly become familiar with the SQL Server estate, critical applications, operational procedures, and escalation paths in order to join and supplement the DBA out-of-hours on-call rotation as quickly as practical.

Proactively monitor, troubleshoot, and optimize SQL Server health, performance, availability, capacity, and reliability, including complex performance and production issues.

Administer and support HA/DR, backup and recovery, and replication technologies, including Always On Availability Groups, clustering, replication, log shipping, and Commvault.

Lead and execute SQL Server installations, patching, upgrades, migrations, configuration changes, and modernization activities across production and non-production environments.

Maintain appropriate SQL Server security and compliance controls, and support vulnerability remediation, access management, and audit requirements.

Partner with application, infrastructure, and other technical teams on database deployments, incidents, changes, troubleshooting, and production readiness.

Develop and improve T-SQL, Power

Shell, automation, monitoring, standards, and repeatable DBA processes to improve operational efficiency and consistency.

Produce and maintain high-quality technical documentation, operational procedures, troubleshooting guides, and runbooks.

Provide knowledge transfer and technical mentoring to permanent DBA team members and proactively identify opportunities to improve the reliability, supportability, and management of the SQL Server estate.

What you must have: 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.

Solid 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 Power

Shell and/or other scripting technologies.

Experience using enterprise database monitoring platforms such as Solar

Winds, Sentry

One,



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 Service

Now.

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.

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 Solar

Winds and SCOM.

Experience working with vulnerability management and remediation processes and tools.

Familiarity with Dev

Ops 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.

Thank you for your interest in this opportunity.

If you are selected to move forward in the process, we will contact you directly.

If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.

📌 Senior SQL Server Database Administrator (Calgary)
🏢 TEEMA
📍 Calgary