SQL Database Administrator

CloudVital; Calgary; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

CloudVital is seeking an experienced SQL Server DBA to manage the core database platform. The role involves maintenance, upgrades, performance tuning, uptime, and collaboration with development teams to optimize queries and schema.

You will ensure backups, recovery models, and high availability strategies are in place, while handling migrations and production support in a hybrid Calgary environment.

Qualifications

• Minimum 5 years of experience as a SQL Server DBA.
• Proven experience with SQL Server Administration.
• Experience in Performance Tuning and Optimization (PTO).
• Hands-on backups, restores and recovery models.
• Knowledge of High Availability and Disaster Recovery options for SQL Server.
• Strong problem-solving and teamwork skills.

Responsibilities

• Perform Core SQL DBA tasks and manage database servers.
• Configure and maintain database processes and upgrades/migrations.
• Plan capacity and monitor health and performance of databases.
• Handle alerts and operate in production environments.
• Install and patch SQL Server 2016 through 2019.
• Tune queries and applications for optimal performance.
• Collaborate with developers on query tuning and schema refinement.
• Perform scheduled maintenance and support release deployments outside business hours.

Skills

SQL Server DBA

SQL Server Administration

Performance Tuning

Backups & Recovery

HA/DR planning

PowerShell

Azure

Team player

Tools

PowerShell

Azure

Job description

Job Location: Calgary (Hybrid – 3 days Onsite, 2 days Remote)

Responsibilities:

• Perform Core SQL DBA tasks.
• Configure and maintain database servers and processes
• Handle Database upgrades and migrations.
• Capacity planning for databases.
• Working in Operations and handling Database alerts.
• Install, patch SQL 2016 through 2019.
• Performance tuning of Queries/applications
• Monitor system's health and performance
• Ensure high levels of performance, availability, sustainability and security
• Analyze, solve, and correct issues in real time
• Provide suggestions for solutions
• Refine and automate regular processes, track issues, and document changes
• Assist developers with query tuning and schema refinement
• Perform scheduled maintenance and support release deployment activities after hours

Requirements and Qualifications:

• At least 5 years of experience as a SQL Server DBA.
• Experience with SQL Server Administration experience required
• Experience with Performance Tuning and Optimization (PTO)
• Hands on experience with backups, restores and recovery models
• Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Critical thinker and problem-solving skills
• Team player

Preferred Skills:

Strong experience with PowerShell and Azure