Remote Senior SQL Server Architect: AWS Multi-AZ & Aurora

HIGH BRIDGE CONSULTING LLC; United States; Remote; USD 120,000 - 190,000; Full time

Job summary

HIGH BRIDGE CONSULTING LLC is seeking a Senior Database Architect to lead SQL Server modernization and AWS database architecture. The role focuses on untangling SQL Server replication, implementing Multi-AZ / multi-region HA, and preparing the database layer for a future SQL Server → Aurora PostgreSQL migration.

You will collaborate with infrastructure and development teams to design scalable, reliable data services on EC2/RDS, use AWS DMS/SCT for migrations, and ensure robust OLTP/OLAP

Qualifications

• Deep SQL Server architecture experience — SQL Server on EC2 and/or RDS SQL Server.
• SQL Server performance tuning, troubleshooting and database optimization.
• SQL Server → AWS Aurora PostgreSQL migration experience.
• Hands-on AWS DMS and Schema Conversion Tool (SCT).
• Strong T-SQL, stored procedure analysis and database object migration.
• Experience designing Multi-AZ Availability Groups and multi-region SQL Server architectures.
• Terraform / Infrastructure as Code.
• Strong understanding of OLTP/OLAP replication and database-to-application integration.

Responsibilities

• Own SQL Server modernization activities for Phase One.
• Analyze and resolve complex OLTP OLAP replication architecture.
• Design and implement Multi-AZ and multi-region SQL Server HA/DR.
• Perform T-SQL and database object assessment for migration.
• Develop migration strategy using AWS DMS/SCT.
• Prepare SQL Server databases for eventual Aurora PostgreSQL migration.
• Work closely with infrastructure, application and data teams on database architecture.

Skills

SQL Server architecture

Performance tuning

Migration to Aurora PostgreSQL

AWS DMS and SCT

T-SQL

Multi-AZ / multi-region HA

OLTP/OLAP replication

Terraform / IaC

Tools

AWS DMS

Schema Conversion Tool

Terraform

Job description

HIGH BRIDGE CONSULTING LLC is seeking a Senior Database Architect to lead SQL Server modernization and AWS database architecture. The role focuses on untangling SQL Server replication, implementing Multi-AZ / multi-region HA, and preparing the database layer for a future SQL Server → Aurora PostgreSQL migration.

You will collaborate with infrastructure and development teams to design scalable, reliable data services on EC2/RDS, use AWS DMS/SCT for migrations, and ensure robust OLTP/OLAP