SQL Server DBA
Adecco
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Job summary
Adecco is seeking a Senior SQL Server DBA for a 12-month contract in Chester, onsite 3 days per week. You will manage enterprise SQL Server environments, focusing on performance, availability and security across a complex database estate.
The role requires strong troubleshooting skills and experience with HA/DR, upgrades, migrations and PowerShell automation. Collaboration with development and infrastructure teams is essential.
Qualifications
- Extensive experience as a SQL Server DBA in enterprise environments.
- Strong SQL Server Administration expertise.
- Experience supporting large-scale database estates.
- Advanced T-SQL development and optimisation skills.
- SQL Server Performance Tuning and Troubleshooting.
- SQL Server Integration Services (SSIS).
- SQL Server Reporting Services (SSRS).
- SQL Server Analysis Services (SSAS).
- SQL Server Backup and Recovery.
- Database Upgrades and Migrations.
- PowerShell scripting experience.
- Windows Server administration knowledge.
- Excellent communication and stakeholder management skills.
Responsibilities
- Administer and support enterprise SQL Server environments.
- Monitor database performance, health and availability.
- Diagnose and resolve production issues in real time.
- Implement and support High Availability and Disaster Recovery solutions.
- Perform SQL Server upgrades, migrations and patching activities.
- Design and maintain backup and recovery strategies.
- Conduct database performance tuning and optimisation.
- Analyse execution plans, indexes and query performance.
- Develop and optimise T-SQL code including stored procedures, functions, views and triggers.
- Support and administer SSIS, SSRS and SSAS environments.
- Automate routine administration tasks using PowerShell.
- Work within ITIL-driven change, release, incident and problem management processes.
- Collaborate with development and infrastructure teams on database design and optimisation initiatives.
Skills
Tools
Job description
£550 per day (Inside IR35 via Umbrella) | 12-Month Contract | Chester (3 days pw onsite)
A leading technology-driven organisation is seeking an experienced Senior SQL Server DBA to join its database infrastructure team on a long-term contract basis.
This is an excellent opportunity to work within a large-scale enterprise environment supporting business-critical SQL Server platforms, ensuring performance, availability, security and stability across a complex database estate.
You will be responsible for the administration, maintenance, optimisation and ongoing support of SQL Server environments, working closely with application, infrastructure and support teams to deliver highly available and high-performing database services.
The role requires strong troubleshooting capabilities and the ability to respond quickly to issues impacting critical business systems.
- Administer and support enterprise SQL Server environments
- Monitor database performance, health and availability
- Diagnose and resolve production issues in real time
- Implement and support High Availability and Disaster Recovery solutions
- Perform SQL Server upgrades, migrations and patching activities
- Design and maintain backup and recovery strategies
- Conduct database performance tuning and optimisation
- Analyse execution plans, indexes and query performance
- Develop and optimise T-SQL code including stored procedures, functions, views and triggers
- Support and administer SSIS, SSRS and SSAS environments
- Automate routine administration tasks using PowerShell
- Work within ITIL-driven change, release, incident and problem management processes
- Collaborate with development and infrastructure teams on database design and optimisation initiatives
- Extensive experience as a SQL Server DBA within enterprise environments
- Strong SQL Server Administration expertise
- Experience supporting large-scale database estates
- Advanced T-SQL development and optimisation skills
- SQL Server Performance Tuning and Troubleshooting
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- SQL Server Backup and Recovery
- Database Upgrades and Migrations
- PowerShell scripting experience
- Windows Server administration knowledge
- Excellent communication and stakeholder management skills
Candidates should have hands-on experience with:
- AlwaysOn Availability Groups
- SQL Clustering
- Database Mirroring
- Log Shipping
- Replication Technologies
- Experience working in highly regulated or secure environments
- Familiarity with BMC Remedy
- ITIL Foundation or equivalent experience
- Experience working with enterprise storage platforms
This role is based in Chester. Candidates should be located within approximately one hour's commute of the office.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
