SQL Server Architect - SC Cleared

SQL Server Architect - SC Cleared

Posted Today by Whitehall Resources

Apply
Negotiable
Inside
Undetermined
London Area, United Kingdom
Apply
Amazon Elastic Block Stores Amazon Elastic Compute Cloud Amazon Web Services (AWS) Automation AWS Backup Business Continuity And Disaster Recovery Cloud Computing Cloud Technology Disaster Recovery DMS Software Reengineering Toolkits Domain Name System (DNS) Servers Failover File Servers Hardening Microsoft 365 Microsoft SharePoint Microsoft SQL Servers Microsoft Windows Performance Engineering Security Clearance SQL (Programming Language) Stakeholder Communications Stakeholder Management Windows PowerShell

Summary: The SQL Server Architect - SC Cleared role involves collaborating with the Infrastructure Architect to establish success criteria for a proof of value (PoV) in a cloud environment, specifically focusing on SQL Server architectures. The position requires expertise in high availability and disaster recovery solutions for SQL Server, particularly in AWS, and necessitates active SC clearance. The role is contract-based for an initial duration of one month, emphasizing the need for extensive experience in SQL Server and SharePoint database operations.

Key Responsibilities:

  • Architect HA/DR for SQL Server in AWS to support a mission-critical SharePoint farm.
  • Evaluate native AWS options (EC2, EBS, FSx, Route 53, CloudWatch, Backup, Systems Manager, CloudFormation).
  • Develop PoV Plan & Success Metrics.
  • Create a Resilience Pattern Catalogue (HA/DR topologies, pros/cons, prerequisites).
  • Test DR options with the SharePoint team.
  • Produce Performance Baseline & Findings Report (throughput/latency, failover timings).
  • Provide PoV Recommendation & Next Step Design Decisions.
  • Design and validate Always On patterns, listener routing, quorum/witness.
  • Collaborate with the Infrastructure Architect to ensure network/IAM/security fit.
  • Produce documentation, runbooks, and handover materials for operations.

Key Skills:

  • 10+ years with Microsoft SQL Server (2016+) architecture and operations.
  • Proven delivery of Always On Availability Groups, FCI, log shipping/replication.
  • Largescale SharePoint database design/operations experience.
  • Strong performance engineering (indexing, I/O, concurrency, wait stats, storage optimisation).
  • Deep understanding of networking for Always On, listener design, DNS failover.
  • Excellent documentation and stakeholder communication.
  • Azure SQL HA/DR exposure (SQL MI, zone redundancy) for comparative design decisions.
  • Hands-on AWS deployment for SQL workloads (EC2, EBS, FSx, Route 53, CloudWatch, Backup, SSM).
  • Automation tooling (CloudFormation/Terraform, PowerShell DSC).
  • Experience with regulated environments and security hardening.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

SQL Server Architect - SC Cleared

Whitehall Resources are currently looking for a SQL Server Architect - SC Cleared based in London for an initial 1 month contract.

*** INSIDE IR35 ***

*** MUST HOLD ACTIVE SC CLEARANCE ***

Job Spec:

You will be responsible for working with the Infrastructure Architect to define PoV success criteria (RPO/RTO, failover time, throughput, recovery steps). Stand up PoV topology: SQL Server Always On Availability Groups on Amazon EC2 across multiple AZs. Storage using EBS (io1/io2 / gp3) and, where required, FSx for Windows File Server for cluster dependencies. Integrate CloudWatch, AWS Backup, Systems Manager, and automation as appropriate (CloudFormation/Terraform/PowerShell). Confirm and test SharePoint compatibility (content/search/service DBs). Produce pattern catalogue and TCO/performance findings and assessment of complexity to introduce and in terms of operability and maintainability for each of the chosen patterns (Always On availability groups, Always On failover cluster instances (FCI), SIOS DataKeeper, AWS Elastic Disaster Recovery, and AWS Database Migration Service (AWS DMS)).

Main Responsibilities:

  • Architect HA/DR for SQL Server in AWS to support a mission critical SharePoint farm.
  • Evaluate native AWS options (EC2, EBS, FSx, Route 53, CloudWatch, Backup, Systems Manager, CloudFormation).
  • PoV Plan & Success Metrics
  • Resilience Pattern Catalogue (HA/DR topologies, pros/cons, prerequisites)
  • Testing of DR options with SharePoint team.
  • Performance Baseline & Findings Report (throughput/latency, failover timings)
  • PoV Recommendation & NextStep Design Decisions
  • Design and validate Always On patterns, listener routing, quorum/witness.
  • Collaborate with the Infrastructure Architect to ensure network/IAM/security fit.
  • Produce documentation, runbooks, and handover materials for operations.

Essential Experience:

  • 10+ years with Microsoft SQL Server (2016+) architecture and operations.
  • Proven delivery of Always On Availability Groups, FCI, log shipping/replication.
  • Largescale SharePoint database design/operations experience.
  • Strong performance engineering (indexing, I/O, concurrency, wait stats, storage optimisation).
  • Deep understanding of networking for Always On, listener design, DNS failover.
  • Excellent documentation and stakeholder communication.

Desirable Skills:

  • Azure SQL HA/DR exposure (SQL MI, zone redundancy) for comparative design decisions.
  • Handson AWS deployment for SQL workloads (EC2, EBS, FSx, Route 53, CloudWatch, Backup, SSM)
  • Automation tooling (CloudFormation/Terraform, PowerShell DSC).
  • Experience with regulated environments and security hardening.
Apply
Similar Jobs
Loading data...