Location: Glasgow (hybrid working - 2-3 days onsite) Duration: 12 months + Vetting: SC security clearance will be required Essential Skills You must be able to demonstrate a strong track record as a Microsoft SQL Server Database Administrator, with experience supporting and maintaining enterprise-scale SQL Server environments Technical Skills Proven experience installing, configuring, and administering Microsoft SQL Server 2019. Strong T-SQL development and troubleshooting skills. Experience developing and maintaining PowerShell scripts for automation and administration. Good understanding of SQL Server High Availability (HA) and Disaster Recovery (DR) solutions. Hands-on experience with SQL Server Always-On Availability Groups and clustered environments. Experience implementing and managing Log Shipping solutions for disaster recovery. Experience applying SQL Server Service Packs (SPs), Cumulative Updates (CUs), and Windows security patches. Strong understanding of SQL Server security best practices, including Role-Based Access Control (RBAC), Active Directory integration, and security group management. Understanding of TLS/SSL certificates and encryption technologies used to secure SQL Server communications and endpoints. Experience managing and enhancing SQL Server maintenance processes, including backups, integrity checks, index maintenance, housekeeping routines, and automation through T-SQL and stored procedures. Experience implementing and managing SQL Server Auditing and compliance controls. Knowledge of database capacity planning, performance optimisation, and management of database files and virtualised storage platforms. Experience monitoring and maintaining SQL Server production environments to ensure high availability, performance, and reliability. Desirable Skills Enterprise policy-based management for SQL Server Disaster Recovery across DR sites Data warehouse / SSRS Understanding of Agile Methodologies and principals Experience of Atlassian Jira
SQL Database Administrator employer: Synapri
At Synapri, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. Our team enjoys flexible remote working arrangements with the opportunity for occasional office interactions in London, ensuring a healthy work-life balance while contributing to cutting-edge LegalTech solutions. We are committed to employee growth, providing access to training and development resources that empower our engineers to excel in their careers.
