About Trantor:

Trantor is a technology services company focused on outsourced product development and digital re-engineering. Leveraging our CaptiveCoE™ engagement model, we operate as a seamless extension of our client’s teams to provide rapid scalability with predictable budgets. Founded in 2012, Trantor has worked with customers across Tech, FinTech, Media & Cybersecurity industries. We have centers in the US, India, Canada, and Costa Rica. We are consistently rated as the #1 employer in the region with the ability to attract and retain technical talent. Our commitment to excellence and impactful results has translated to long-term relationships and value for our clients and solution partners. 

Job Overview 

We are seeking a Senior MySQL Database Administrator with deep experience in planning, executing, and supporting complex database upgrades and migrations for large, business-critical environments. The role requires hands-on expertise with terabyte-scale MySQL databases, low- or zero-downtime upgrade strategies, AWS-hosted production systems, and strong operational ownership. The ideal candidate will have strong experience with MySQL upgrades, AWS RDS and Aurora, database migration methods, high availability, disaster recovery, performance tuning, and production support. Exposure to MongoDB, Amazon Aurora PostgreSQL, and regulated financial-services platforms is highly preferred.

Roles & Responsibilities 

Plan and execute major and minor MySQL upgrades, including MySQL 5.7 to 8.x migrations, for large production databases.
Design upgrade and migration strategies for databases ranging from hundreds of gigabytes to multiple terabytes.
Lead in-place upgrades, logical and physical migrations, replication-based migrations, Blue/Green deployments, and AWS DMS-based migrations.
Perform upgrade readiness assessments covering compatibility, deprecated features, SQL modes, drivers, plugins, stored procedures, triggers, events, and application dependencies.
Create upgrade runbooks, rollback plans, validation checklists, risk assessments, implementation plans, and stakeholder communication plans.
Conduct pre- and post-upgrade validation, including row counts, checksums, reconciliation queries, performance benchmarking, and application testing.
Coordinate production upgrade and migration activities with application, infrastructure, cloud, security, DevOps, QA, compliance, and business teams.
Troubleshoot upgrade failures, replication lag, data inconsistencies, performance issues, locking, deadlocks, and application connectivity problems.
Manage cutover planning, release windows, freeze periods, rollback decisions, post-migration monitoring, and production hypercare.