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
