Microsoft SQL Server Database Administrator

Summer Browning; East Kilbride; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Hybrid work

Job summary

Summer-Browning Associates is seeking a Microsoft SQL Server Database Administrator for an initial 12-month contract supporting a central government client. Location options include East Kilbride (Glasgow) or London, with hybrid 60% onsite work.

The ideal candidate will have active security clearance and extensive experience in installing, configuring, and maintaining SQL Server environments, including HA/DR and Always-On configurations. Proficiency in PowerShell for automation is essential.

Qualifications

• Active security clearance is required.
• 12-month assignment with option to extend.

Responsibilities

• Install, configure, and administer SQL Server 2019 in enterprise environments.
• Develop and maintain PowerShell scripts for automation and administration.
• Implement HA/DR solutions including Always-On availability groups and log shipping.
• Apply and manage security patches and TLS/SSL encryption for SQL Server.
• Maintain security configurations with RBAC and AD integration.

Skills

SQL Server

T-SQL

PowerShell

HA/DR

Always-On

Log Shipping

Security best practices

TLS/SSL encryption

Tools

SQL Server 2019

Windows Server

PowerShell scripting

Job description

Microsoft SQL Server Database Administrator | SQL DBA
Summer-Browning Associates is currently supporting our central government client, who is seeking a Microsoft SQL Server Database Administrator for an initial 12-month assignment with the option to extend.
Location: East Kilbride (Glasgow) or London | Hybrid 60% onsite

The ideal candidate will have an active security clearance and a proven background in Microsoft SQL Server Database Administrator, with experience supporting and maintaining enterprise-scale SQL Server environments

Skills and Experience:

• Proven expertise in installing, configuring, and administering Microsoft SQL Server 2019, complemented by proficiencies in T-SQL development and troubleshooting.
• Experience in the development and maintenance of PowerShell scripts for purposes of automation and administration.
• Comprehensive understanding of SQL Server High Availability (HA) and Disaster Recovery (DR) solutions.
• Practical experience with SQL Server Always-On Availability Groups and clustered environments.
• Proficiency in implementing and managing Log Shipping solutions as a means of disaster recovery.
• Familiarity with the application of SQL Server Service Packs (SPs), Cumulative Updates (CUs), and Windows security patches.
• Strong knowledge of SQL Server security best practices, encompassing Role-Based Access Control (RBAC), Active Directory integration, and the management of security groups.
• Understanding of TLS/SSL certificates and encryption technologies used to secure SQL Server communications and endpoints.