Remote SQL Server DBA - Replication & SSRS Expert

Idea Theorem; Toronto; Remote; CAD 80,000 - 100,000; Full time

Job summary

A technology solutions company is seeking an experienced SQL Server Database Administrator to oversee the integrity and performance of enterprise database environments. The role includes optimizing SQL Server 2016 databases, maintaining replication, and collaborating with IT teams. Candidates must have over 7 years of DBA experience, strong T-SQL skills, and familiarity with SQL Server Reporting Services. Remote work available with occasional client collaboration.

Qualifications

• 7+ years of experience as a SQL Server DBA, including SQL Server 2016.
• Experience configuring and troubleshooting SQL Server Replication and SQL Agent jobs.
• Understanding of .NET data access and integration with web applications.

Responsibilities

• Administer and optimize Microsoft SQL Server 2016 databases.
• Maintain SQL Server Replication ensuring synchronized data flow between systems.
• Monitor database health and performance; resolve locking, blocking, and bottlenecks.
• Collaborate with system administrators and developers on deployments and schema updates.

Skills

T-SQL development and optimization

SQL Server Replication configuration

SSRS and Report Builder expertise

Database backup and recovery

Documentation and analytical skills

Education

Microsoft Certified: SQL Server Database Administrator or Data Analyst Associate

Tools

Microsoft SQL Server 2016

Windows Server 2016

Job description

A technology solutions company is seeking an experienced SQL Server Database Administrator to oversee the integrity and performance of enterprise database environments. The role includes optimizing SQL Server 2016 databases, maintaining replication, and collaborating with IT teams. Candidates must have over 7 years of DBA experience, strong T-SQL skills, and familiarity with SQL Server Reporting Services. Remote work available with occasional client collaboration.