Job title: MS SQL Database Migration Consultant - AWS ProServe (Client Partner)
Location: 100% Remote
Job type: full time
Interview: Video
Job Description: Database Migration Consultant
Summary: Assist the Marketing team performing large-scale schema-level MySQL database migrations from on-premises (Tungsten HA clusters) to AWS Aurora MySQL, and develop supporting automation and tooling to enable repeatable execution across 5000+ schemas
Key Responsibilities:
Perform and assist with schema-level MySQL database migrations (dump, transfer, load, index rebuild) using MySQL Shell utilities at scale
Set up and manage binlog replication (CDC) from Tungsten clusters to Aurora including catch-up monitoring and cutover execution
Develop and enhance migration scripts using Python and Bash for repeatable, resilient operations
Build Ansible playbooks for end-to-end orchestration of parallel schema migrations (8+ concurrent streams)
Create monitoring and observability tooling
Coordinate with customer's DBA team on cutover sequencing, validation, and rollback procedures
Document runbooks and transfer knowledge to enable the customer team to execute migrations independently
Preferred:
Experience with Tungsten Replicator clusters
AWS Step Functions or similar workflow orchestration
Familiarity with Database schema-level migrations vs. full instance dumps
Multi-tenant SaaS database architecture experience
Never miss an opportunity! Create an alert based on the job you applied for.
