Role: Senior My SQL DBA - Remote

Employment Type: Full-Time

Role Overview

We are seeking a Senior My SQL 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 My SQL databases, low- or zero-downtime upgrade strategies, AWS-hosted production systems,and strong operational ownership.

The ideal candidate will have solid experience with My SQL upgrades, AWS RDS and

Aurora, database migration methods, high availability, disaster recovery, performance tuning, and production support. Exposure to Mongo DB, Amazon Aurora Postgre SQL, and regulated financial-services platforms is highly preferred.

Key Responsibilities

- Plan and execute major and minor My SQL upgrades, including My SQL 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, Dev Ops, 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.

AWS and Database Platform Administration

- Administer and support My SQL databases on AWS, including Amazon RDS for

My SQL, Amazon Aurora My SQL, Aurora Postgre SQL, EC2-hosted databases, and

AWS Database Migration Service.

- Manage Multi-AZ deployments, read replicas, snapshots, automated backups,





point-in-time recovery, parameter groups, option groups, cluster upgrades, and

Aurora Blue/Green deployments.

- Monitor performance, replication health, capacity, storage growth, availability,

security controls, audit logging, encryption, access policies, credential rotation, and

AWS database costs.

- Support Mongo DB environments, including replica sets, sharding, backups,

restores, indexing, performance, upgrades, migrations, monitoring, and security practices.

- Administer Aurora Postgre SQL clusters and support Postgre SQL upgrades, failover,

backups, monitoring, performance analysis, replication, autovacuum, indexing,

partitioning, and query optimization.

Performance, Availability, and Operations

- Monitor and tune My SQL performance in high-volume transaction environments using slow query analysis, execution plans, indexing, partitioning, configuration tuning, and workload analysis.
- Manage high availability, disaster recovery, replication, failover, recovery testing,

operational health checks, monitoring, alerting, and capacity planning.

- Support asynchronous, semi-synchronous, GTID-based, and read-replica architectures.
- Handle critical incidents, root-cause analysis, permanent corrective actions, and production escalations.
- Support databases for digital lending, loan origination, loan servicing, payments,

collections, credit decisioning, customer communications, and other financial-

services workloads.

- Ensure database changes follow change management, security, compliance, audit,

and release management processes.

Required Technical Skills

- Strong hands-on My SQL database administration experience, including My SQL internals, storage engines, transactions, replication, locking, indexing, query optimization, backup, restore, recovery, failover, and disaster recovery.
- Proven experience upgrading large production My SQL databases, including terabyte-scale environments and My SQL 5.7 to 8.x upgrades.




- Strong experience with Amazon RDS, Amazon Aurora, Aurora Blue/Green deployments, AWS DMS, Cloud Watch, Performance Insights, AWS Backup, KMS,

S3, and Secrets Manager.

Working experience with Mongo DB and Amazon Aurora Postgre SQL or Postgre SQL. Ability to write advanced SQL for monitoring, validation, troubleshooting, reconciliation, and performance analysis.

- Experience with Linux administration, shell scripting, database monitoring tools,

security controls, encryption, access management, audit logging, and compliance practices.

- Experience with ITIL, incident, problem, change, and release management processes.

Preferred Skills

- Experience with Percona Toolkit, My SQL Shell, My SQL Utilities, Orchestrator,

Proxy SQL, Grafana, Prometheus, Datadog, New Relic, or similar tools.

- Experience with Terraform, Cloud Formation, Ansible, CI/CD pipelines, database deployment automation, Python, Bash, or Power Shell.
- Knowledge of PCI-DSS, SOC 2, ISO 27001, data masking, tokenization, database activity monitoring, cross-region disaster recovery, and multi-region database architectures.
- AWS or database-related professional certification is an advantage.

Key Competencies

- Strong ownership, accountability, troubleshooting, analytical thinking, and production support discipline.
- Ability to explain complex database issues clearly to technical and non-technical stakeholders.
- Strong documentation, implementation planning, risk communication, and stakeholder management skills.
- Ability to remain composed during production releases, incidents, and business-

critical database operations.

- Willingness to support release activities and on-call requirements as needed.

Education and Experience

- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field; equivalent professional experience may be considered.
- 8+ years of database administration experience, including 5+ years of strong My SQL production support experience.

Demonstrated experience upgrading databases of 1 TB or more. Experience with fintech, lending, banking, payments, or regulated financial-services environments is preferred.

- Proven ability to independently lead database upgrade and migration initiatives.

Interested candidates can share their updated CV at:

vaishali.bhola@

📌 Mysql Dba (Madhya Pradesh)
🏢 Trantor
📍 Madhya Pradesh