Senior Database Architect SQL Server / AWS

HIGH BRIDGE CONSULTING LLC

2d • $50 - $80 • Remote

About The Position

Seeking a Senior Database Architect to lead SQL Server modernization and AWS database architecture. The primary focus is untangling complex SQL Server replication, implementing Multi-AZ / multi-region HA, and preparing the database layer for a future SQL Server → Aurora PostgreSQL migration. This is a remote position.

Requirements

• 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
• Candidate should be able to answer YES to most/all of these: SQL Server Architect: Has the candidate architected/modernized SQL Server environments—not just administered them?
• AWS Database: Hands-on with SQL Server on EC2/RDS and AWS database architecture?
• Migration: Has the candidate used DMS/SCT and worked on SQL Server → Aurora/PostgreSQL migration?
• HA/DR: Experience with Multi-AZ Availability Groups, replication and/or multi-region SQL Server?
• Hands-on DB: Strong in T-SQL, stored procedures, performance tuning and DB object migration?

Nice To Haves

• PostgreSQL / Aurora PostgreSQL
• Amazon Redshift
• Kinesis Firehose
• Amazon EKS
• Additional DB-to-application integration experience

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed