Database Administrator – Level 3 (Senior)

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

Apply now to this Senior Database Administrator role for immediate consideration. Our recruitment team will reach out to qualified candidates.

CAB7616
@@j