Senior SQL Server DBA – HA/DR & Data Migration

TAG HR; Ottawa; On-site; CAD 80,000 - 100,000; Full time

Job summary

A recruitment agency in Ontario is seeking a Database Administrator with at least 10 years of experience in database management. The successful candidate will perform tasks related to SQL Server 2016, implement security measures, and migrate databases to Azure Cloud. Responsibilities include data accuracy, performance monitoring, and providing technical support for enterprise systems. Candidates with proven experience in SSRS and PowerShell scripting will be highly regarded.

Qualifications

• Minimum 10 years of experience in database administration.
• At least 36 months working in a Canadian federal or provincial department.
• Experience with Microsoft SQL Server 2016 or higher required.

Responsibilities

• Develop and implement database procedures to ensure data accuracy.
• Monitor database performance and maintain security measures.
• Provide Level 2 technical support for enterprise databases.

Skills

SQL performance tuning

Security procedures

Data migration

PowerShell scripting

SSRS reporting

ETL processes

Tools

Microsoft SQL Server 2016

Azure Cloud

Power BI

SQL Server Integration Services (SSIS)

Job description

A recruitment agency in Ontario is seeking a Database Administrator with at least 10 years of experience in database management. The successful candidate will perform tasks related to SQL Server 2016, implement security measures, and migrate databases to Azure Cloud. Responsibilities include data accuracy, performance monitoring, and providing technical support for enterprise systems. Candidates with proven experience in SSRS and PowerShell scripting will be highly regarded.