Senior SQL Server DBA

Avanciers; Vancouver; On-site; CAD 90,000 - 120,000; Part time

Job summary

A leading company is seeking a Senior SQL Server DBA to provide database administration support, manage replication, and deploy BI solutions. The ideal candidate will have extensive experience with SQL Server, Azure SQL, and strong troubleshooting skills. This contract role is perfect for those looking to contribute to a dynamic IT environment.

Qualifications

• 8+ years of hands-on experience as a SQL Server DBA.
• Strong experience with SQL Server database engine and performance tuning.

Responsibilities

• Provide SQL Server database administration support and troubleshooting.
• Manage SQL Server replication and deploy BI solutions.

Skills

SQL Server Replication

Troubleshooting

Communication

Education

Relevant certifications

Tools

PowerShell

Azure SQL

SSIS

SSRS

SSAS

Job description

Senior SQL Server DBA

Direct message the job poster from Avanciers

Key Responsibilities :

1. Provide SQL Server database administration support, including monitoring, maintenance, and troubleshooting.
2. Manage SQL Server replication, primarily transactional replication.
3. Support and deploy SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) solutions.
4. Configure, deploy, and secure SSRS reports and SSAS tabular models.
5. Perform database backups, restores, and high-availability configurations (Always On, failover clustering, log shipping, etc.).
6. Work with Azure SQL, Managed SQL Instances, and Synapse Analytics.
7. Participate in on-call rotations for database support.
8. Perform day-to-day operational support tasks, including deployments and production change management.
9. Write and maintain PowerShell scripts for automation.
10. Ensure compliance with database security and best practices.

Required Qualifications & Experience :

• 8+ years of hands-on experience as a SQL Server DBA.
• Expertise in SQL Server Replication (Transactional Replication is a must).
• Strong experience with SQL Server database engine, backups, restores, and performance tuning.
• Hands-on experience with SSIS, SSRS, and SSAS (Tabular preferred).
• Experience with Azure SQL (Azure SQL DB, Managed SQL Instances, Synapse Analytics).
• Ability to deploy and secure SQL Server-based BI solutions.
• Basic scripting skills using PowerShell.
• Strong troubleshooting skills and the ability to work in a fast-paced support role.
• Excellent communication skills and ability to document processes concisely.
• Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: Data Engineer Associate, or equivalent) are preferred.

Seniority level: Mid-Senior level

Employment type: Contract

Job function: Information Technology, IT Services and IT Consulting