Microsoft SQL Server Database Administrator

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% onsiteThe 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 environmentsSkills 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 ..... full job details .....