Senior Sql Database Administrator

Senior SQL Server Database Administrator

12-month contract | Calgary, AB - Primarily Remote with occasional onsite meetings |
Hourly Rate
: $70-80/hour | Must hold a valid Canadian Work Visa

Our client, a large Canadian organization operating in the natural resources and industrial sector, is seeking an experienced Senior SQL Server Database Administrator for a 12-month contract
. The role is based in Calgary and will be primarily remote
, with occasional onsite attendance required for meetings and other business needs.

This opportunity is being created to support an upcoming retirement within the Enterprise DBA team.

This is a hands-on senior technical role supporting a large enterprise Microsoft SQL Server environment with some Azure
. The Senior DBA will be responsible for production database administration, troubleshooting, performance optimization, high availability and disaster recovery, security, upgrades, migrations, automation, and ongoing platform improvements.

The successful candidate should be a seasoned SQL Server professional who can step into an established environment, independently diagnose complex issues, take ownership through resolution, and provide senior-level guidance to the broader team. The position also includes participation in the team's after-hours on-call rotation once sufficiently familiar with the environment.

• Provide senior-level administration and operational support for enterprise Microsoft SQL Server environments
• Quickly develop a strong understanding of the existing SQL Server estate, critical applications, operational procedures, monitoring, backup and recovery processes, and escalation paths
• Work closely with the existing DBA team to facilitate effective knowledge transfer ahead of an upcoming team transition
• Monitor and optimize database health, performance, availability, capacity, and reliability
• Diagnose complex SQL Server performance and production issues using appropriate diagnostic tools and techniques
• Administer and support high availability and disaster recovery technologies, including Always On Availability Groups, Windows Server Failover Clustering, replication, log shipping, and backup/recovery solutions
• Administer SQL Server backup and recovery using Commvault
  , including backup configuration, troubleshooting, restores, and recovery validation
• Lead SQL Server installations, patching, cumulative updates, upgrades, migrations, configuration changes, and modernization initiatives
• Support SQL Server security, access management, vulnerability remediation, audit requirements, and least-privilege practices
• Partner with application, infrastructure, security, and other technical teams on deployments, incidents, changes, troubleshooting, and production readiness
• Develop and enhance T-SQL and Power Shell automation to improve the efficiency and consistency of database operations
• Support enterprise database monitoring and proactively identify potential performance or availability issues
• Participate in formal incident, problem, request, and change management processes
• Produce and maintain technical documentation, troubleshooting guides, operational procedures, and runbooks
• Identify opportunities to improve the reliability, security, performance, supportability, and maintainability of the SQL Server environment
• Provide technical guidance, mentoring, and knowledge transfer to other DBA team members
• Participate in the team's after-hours/on-call support rotation for business-critical database environments

• 8+ years of hands-on SQL Server DBA experience
  , including significant senior-level experience within complex enterprise environments
• Deep knowledge of Microsoft SQL Server administration
  , ideally across SQL Server 2016 through current supported versions
• Advanced SQL Server performance troubleshooting skills, including experience with DMVs, wait statistics, execution plans, Query Store, Extended Events, and indexing analysis
• Strong experience with Always On Availability Groups and/or Windows Server Failover Clustering
• Hands-on experience supporting SQL Server replication
• Strong backup, restore, disaster recovery, and point-in-time recovery experience
• Hands-o…