Database Administrator - Level 3; Senior

Position: 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 Power
  
  BI models
• Install, configure, and maintain SQL Server instances
• Provide Level 2 technical support and collaborate with Level 1 support teams
• Automate database tasks using Power Shell 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 Power Shell 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.

CAB
7616
@@j