SQL Server Architect – DV Clearance

Investigo; Greater London; Hybrid; GBP 96,000 - 130,000; Full time

Job summary

Investigo in London seeks a DV-cleared SQL Server Architect to supervise a major transformation of a large-scale SharePoint platform. You will ensure high availability and resilience as the project migrates from on-premises to SharePoint Subscription Edition hosted on AWS.

The role requires extensive SQL Server expertise, including Always On, FCI, log shipping, and performance tuning, with strong AWS workload design and stakeholder communication.

Qualifications

• 10+ years of SQL Server architecture and design expertise.
• Proven experience with Always On AGs, FCI, log shipping and enterprise HA/DR.
• Deep SharePoint on-prem to cloud migration experience.
• Experience designing SQL workloads in AWS (EC2, EBS, FSx).
• Strong stakeholder engagement and communication skills.

Responsibilities

• Provide architectural guidance and technical recommendations across SQL Server deployments.
• Lead performance tuning, capacity planning and disaster recovery design.
• Collaborate with SharePoint and cloud teams to migrate from on-prem to AWS.
• Document architecture decisions and present options to technical and business stakeholders.

Skills

SQL Server

Always On

Failover Clustering

Log Shipping

Replication

HA/DR

SharePoint

Performance Tuning

Indexing

AWS Workloads

Networking

Stakeholder Mgmt

Documentation

Tools

AWS

EC2

EBS

FSx

CloudWatch

Systems Manager

Route 53

Job description

SQL Server Architect – DV Clearance, Cloud Resilience & High Availability (AWS) £610 per day – Inside IR35 London (Hybrid, 3-4 days onsite per week) 3 months initially with strong likelihood of extension My client is seeking a DV Cleared SQL Server Architect to support a major transformation programme for a large-scale SharePoint platform. Having previously delivered an enterprise-grade on-premises SharePoint solution with full disaster recovery and resilience, the client is now migrating to SharePoint Subscription Edition hosted on AWS.

Key Requirements

• Proven experience as a SQL Server Architect with 10+ years of SQL Server architecture, design, and operational expertise across SQL Server 2016 and later versions.
• Extensive hands-on experience delivering SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), log shipping, replication, and enterprise HA/DR solutions.
• Strong background supporting large-scale SharePoint environments, including SharePoint database architecture, performance, and operational support.
• Deep understanding of SQL Server performance optimisation, including indexing strategies, storage performance, I/O optimisation, concurrency management, and wait-stat analysis.
• Experience designing and implementing SQL Server workloads within AWS, including EC2, EBS, FSx, CloudWatch, Systems Manager, AWS Backup, and Route 53.
• Strong networking knowledge relating to SQL Server clustering, Availability Groups, Listener configuration, DNS failover, and resilience design patterns.
• Ability to assess architecture options and provide technical recommendations based on performance, operational complexity, maintainability, and cost.
• Excellent stakeholder engagement, documentation, and communication skills with the ability to present findings and recommendations to both technical and business audiences.