Database Administrator Level 3 Senior

Adecco Canada; Ottawa; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

A leading recruitment firm is seeking a Senior Database Administrator for a 4-year hybrid contract in Ottawa. The role involves optimizing and securing SQL Server environments, supporting high-availability systems, and ensuring database performance. Candidates should have at least 10 years of database administration experience, extensive knowledge of SQL Server Always On configurations, and familiarity with ETL processes and PowerShell scripting. Strong communication skills and strong collaboration with development teams are essential.

Qualifications

• 10 years of Database Administration experience in the last 15 years.
• Recent experience with Microsoft SQL Server in a Canadian government environment.
• Experience supporting production databases in Always On environments.

Responsibilities

• Develop and implement procedures to ensure data accuracy and integrity.
• Monitor database performance and apply corrective measures.
• Design and maintain SQL Server High Availability solutions.

Skills

SQL Server Always On

Database performance tuning

ETL processes

PowerShell scripting

SSRS

SSIS

Education

University or College degree in a related field

Tools

Microsoft SQL Server 2016 or higher

Job description

Overview

Adecco is currently seeking a Senior Database Administrator for a 4-year contract opportunity in Ottawa, offering a hybrid work arrangement. In this role, you will be responsible for managing, optimizing, and securing enterprise-level SQL Server environments while supporting high-availability systems and mission-critical applications. The ideal candidate brings extensive hands-on database administration experience, strong expertise in SQL Server Always On environments, and a proven ability to support complex, large-scale systems in secure environments.

• Salary: $100,000 - $125,000/year
• Location: Ottawa, ON (Hybrid)
• Job type: 4-year Contract
• Security Clearance: Secret (mandatory)

Responsibilities

• Develop and implement procedures to ensure data accuracy, integrity, and timeliness
• Implement security measures including access controls, encryption, and compliance standards
• Monitor database performance, identify issues, and apply corrective measures
• Design, support, and maintain SQL Server Always On High Availability and Disaster Recovery solutions
• Create, modify, and optimize SQL scripts, stored procedures, views, triggers, and agent jobs
• Perform database migrations, including on-prem and Azure Cloud environments
• Support SAP, HRIS, and enterprise systems through performance tuning and optimization
• Build and maintain SSIS packages and ETL processes
• Develop SQL Server Reporting Services (SSRS) reports and support PowerBI models
• Install, configure, and maintain SQL Server instances
• Provide Level 2 technical support and collaborate with Level 1 support teams
• Automate database tasks using PowerShell scripting
• Maintain comprehensive documentation of database configurations, procedures, and standards
• Participate in patching cycles, testing, deployments, and production support
• Submit status reports, timesheets, and ensure proper knowledge transfer documentation

Requirements

• University or College degree in a related field
• Minimum 10 years of Database Administration experience within the last 15 years
• Minimum 36 months of recent experience working with Microsoft SQL Server 2016 or higher in a Canadian federal or provincial government environment
• Minimum 36 months supporting production databases in an Always On High Availability and clustered SQL environment
• Proven experience working closely with application development teams
• Hands-on experience designing and supporting SQL Server Always On Availability Groups
• Strong expertise in database performance tuning, optimization, and troubleshooting
• Experience with SSRS, SSIS, ETL processes, and PowerShell scripting
• Certifications related to database administration are considered an asset