What you'll be doing
- Administer, maintain and support Microsoft SQL Server environments, including installations, configuration, upgrades, patching and migrations
- Manage databases, instances, security settings, users, roles and permissions
- Monitor and optimise performance-investigating bottlenecks, locking issues and query-related problems
- Analyse execution plans and apply indexing strategies to improve query efficiency
- Design and maintain backup and recovery strategies, including restores and disaster recovery testing
- Support High Availability and Disaster Recovery solutions such as Always On Availability Groups, Log Shipping, Replication, and Database Mirroring (where applicable)
- Troubleshoot database incidents within agreed service levels, performing root cause analysis for recurring issues
- Maintain accurate technical documentation, operational runbooks, and improve processes through automation scripts
- Support security and compliance through audits, vulnerability assessments and access reviews, aligning with organisational standards
What you'll bring
- Hands-on experience supporting production SQL Server databases
- Strong T-SQL troubleshooting and an analytical approach to performance tuning and query optimisation
- Proven background with backup/recovery, upgrades, migrations and operational stability
- A proactive, problem-solving mindset with the ability to collaborate effectively with application, infrastructure and support teams
- Confidence working with SQL Server Management Studio (SSMS) and supporting database security and access management
- Comfort with Windows Server fundamentals and Scripting/automation (PowerShell or similar)