Role: SQL Server Architect Max Pay Rate: £640 pd inside IR35 Clearance Required: SC ClearanceUK Passport holders onlyDual nationality not supportedLocation: Hybrid - 60% onsite/40% remote (Central London)Overview: design and validate High Availability (HA) and Disaster Recovery (DR) solutions for SQL Server in AWS, supporting a mission-critical SharePoint environment.Key ActivitiesDefine PoV success criteria (RPO/RTO, failover, throughput, recovery) with Infra Architect.Build PoV topology: SQL Server Always On AGs on EC2 (multi-AZ); EBS (io1/io2/gp3), FSx (if required)Integrate CloudWatch, AWS Backup, Systems Manager, automation (CloudFormation/Terraform/PowerShell).Validate SharePoint DB compatibility (content/search/service).Produce resilience pattern catalogue incl. TCO, performance, complexity: Always On AG; FCI; SIOS DataKeeper; AWS Elastic DR; AWS DMSDeliverablesPoV plan andamp; metricsHA/DR pattern catalogue (pros/cons, prerequisites)DR testing with SharePoint teamPerformance findings (latency, throughput, failover)Final recommendation andamp; next-step designCore ResponsibilitiesArchitect SQL Server HA/DR in AWS.Design Always On patterns (listener, quorum, witness).Evaluate AWS services: EC2, EBS, FSx, Route 53, CloudWatch, Backup, SSM, CloudFormation.Ensure network/IAM/security alignment.Produce documentation and operational runbooks. Skills andamp; ExperienceEssential10+ years SQL Server (2016+) architecture andamp; ops.Always On AG, FCI, replication/log ..... full job details .....