Microsoft SQL Server Database Administrator

Summer-Browning Associates Ltd; Glasgow; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

Summer-Browning Associates Ltd in East Kilbride (Glasgow) is seeking a Microsoft SQL Server Database Administrator for a 12-month assignment with hybrid work (60% onsite). The role focuses on maintaining enterprise SQL Server environments with emphasis on HA/DR, security, and automation.

The ideal candidate will have hands-on experience with SQL Server 2019, PowerShell scripting, Always-On, and Log Shipping in large-scale deployments.

Qualifications

• Experience in installing, configuring, and administering Microsoft SQL Server 2019.
• Experience developing PowerShell scripts for automation.
• Understanding of SQL Server HA/DR solutions.
• Experience with Always-On Availability Groups and clustering.
• Experience with Log Shipping for disaster recovery.
• Knowledge of SPs/CUs and Windows patches.
• Knowledge of SQL Server RBAC and AD integration.
• Familiarity with TLS/SSL certificates and encryption for SQL Server communications.

Responsibilities

• Install, configure, and administer SQL Server 2019.
• Develop and maintain PowerShell automation scripts.
• Design and implement HA/DR solutions for enterprise environments.
• Manage Always-On Availability Groups and clustering setups.
• Implement Log Shipping for disaster recovery.
• Apply SPs/CUs and Windows security patches.
• Enforce security best practices including RBAC and AD integration.

Skills

SQL Server 2019

T-SQL

PowerShell

HA/DR

Always-On

Log Shipping

SPs/CUs/patches

RBAC

Active Directory

TLS/SSL

Security

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) | 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.