Role Overview
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.
Must-Have Experience
- 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
Key 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
Nice to Have
- PostgreSQL / Aurora PostgreSQL
- Amazon Redshift
- Kinesis Firehose
- Amazon EKS
- Additional DB-to-application integration experience
Environment
SQL Server | EC2 | RDS SQL Server | Aurora PostgreSQL | AWS DMS | SCT | Terraform | Multi-AZ | Multi-Region
Recruiter Screening Checklist
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?
Do NOT prioritize generic Data Architects, BI Architects or Data Engineers unless they have the above hands-on SQL Server/AWS database architecture background.
This is a remote position.
Who We Are
High Bridge is a bottom-up consulting firm with more than two decades of experience creating innovative solutions for the technology industry.
- • We connect thoughtfully curated talent with reputable employers in our field.
- • We partner with like-minded companies to bolster mutual success and understanding.
- • We deliver results through strategic planning and meticulous project management.
At High Bridge, we believe that success is a measure of results and process, product and person. We are proud to bring integrity and humanity to the work that we do each day. Whether we’re interviewing prospective associates, brainstorming with partners, or troubleshooting with vendors, we pledge our commitment to honesty, transparency, and good humor at every junction.
Careers
Are you passionate about technology? Do you believe in no finish lines? Are people and process the heel in your stride? High Bridge Consulting may be the next journey for you.
Here at High Bridge, our island is technology, but our village is human. We value a culture of authenticity, integrity, and creativity. We work smart, not hard, we look forward, not backward, and we love coming to work on Monday.
If you aren’t afraid of heights, join us on our bridge.