Microsoft SQL Server Database Administrator

Summer-Browning Associates Ltd; Nerston Village, Greater London; Híbrido; GBP 60.000 - 80.000; Jornada completa

Descripción de la vacante

Summer-Browning Associates Ltd is seeking a Microsoft SQL Server Database Administrator to support a central government client on a 12-month assignment with a potential extension.

Location options include East Kilbride (Glasgow) or London, with a hybrid model of roughly 60% onsite work. Applicants should hold an active security clearance and have a strong background in enterprise-scale SQL Server administration.

Formación

• Proven expertise in installing, configuring, and administering Microsoft SQL Server 2019.
• Experience developing and debugging T-SQL queries and scripts.
• Strong background in HA/DR, including Always-On and Log Shipping.
• Familiarity with Windows patching and TLS/SSL for secure SQL connections.

Conocimientos

SQL Server 2019

T-SQL development

PowerShell scripting

HA/DR design

Always-On Availability Groups

Log Shipping

Security best practices

TLS/SSL encryption

Descripción del empleo

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.