SQL DBA (DV
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+31 more
Job description
Our client is a global systems integrator who requires an experienced Senior SQL Server Database Administrator for a customer based near to Reading.
Requirements
- Proven second- or third-line SQL Server DBA experience in business-critical production environments, typically 5+ years, including at least 3 in a dedicated DBA role.
- Supporting a mixed estate of legacy and current SQL Server versions (e.g. 2012 to 2022) on Windows Server, including installation, patching, upgrades and migrations.
- Strong hands-on SQL Server high-availability clustering, including Failover Cluster Instances (FCIs) on Windows Server Failover Clustering (WSFC), quorum and witness configuration, shared storage, cluster-aware patching, failover and troubleshooting.
- Always On Availability Groups and legacy HA/DR technologies such as log shipping, database mirroring and replication.
- Backup and recovery, including full, differential and log backups, point-in-time recovery and DR testing.
- Performance tuning using legacy and current tools, including execution plans, indexing, wait statistics, DMVs, Profiler/Trace, Extended Events and Query Store.
- Strong T-SQL skills, including queries, stored procedures and functions.
- Database maintenance using maintenance plans and scripted solutions (e.g. Ola Hallengren), including DBCC CHECKDB, index and statistics maintenance, Agent jobs, capacity planning and TempDB.
- Database security, including least-privilege access, Active Directory integration, TDE, SQL Server Audit and privileged access management (e.g. CyberArk).
- Scripting and monitoring using PowerShell (including dbatools), T-SQL and tools such as SCOM, Redgate SQL Monitor or SolarWinds DPA.
- Working knowledge of Windows Server, Active Directory and SQL connectivity (DNS, Kerberos/SPNs and firewall rules).
- ITIL-based incident, problem and change management in a controlled environment.
- Strong communication and customer-service skills, and the organisation to manage multiple priorities in a highly visible support role.
-
Eligibility to obtain a high level of UK Security Clearance. DESIRABLE SKILLS AND QUALIFICATIONS
- SSIS, SSRS and SSAS, including migrating legacy packages and reports to current versions.
- Managing risk on out-of-support SQL Server versions, including ESU and upgrade planning.
- Supporting databases for SCCM/MECM, SCOM and SharePoint.
- Azure SQL, Managed Instance or Azure Arc, to support future modernisation.
- Other database platforms (e.g. Oracle, PostgreSQL, MySQL) and SQL Server on Linux.
- VMware and EMC SAN storage, including SQL Server performance on virtual and shared- storage platforms.
- Database DevOps and automation tools, such as Git, Azure DevOps, SSDT, Redgate, Ansibleor DSC.
- Mentoring colleagues in diagnosing complex database issues.
- Security hardening (e.g. CIS Benchmarks) and awareness of UK GDPR obligations.
- Experience in defence, government or other secure, restricted-network environments.
- Degree in Computer Science or a related discipline, or equivalent experience.
- Certifications such as DP-300, legacy MCSA/MCSE (SQL Server) and ITIL Foundation.
About the company
Due to the nature and urgency of this post, candidates holding or who have held high level security clearance in the past are most welcome to apply. Please note successful applicants will be required to be security cleared prior to appointment which can take a minimum 18 weeks. LA International is an award-winning partner of choice for many of the world’s most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…