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 strong experience with My SQL upgrades, AWS RDS and Aurora, database migration methods, high availability, disaster recovery, performancetuning, and production support.

Exposure to Mongo DB, Amazon Aurora Postgre SQL, andregulated financial-services platforms is highly preferred. Key Responsibilities• Plan and execute major and minor My SQL upgrades, including My SQL 5.7 to 8.xmigrations, for large production databases.

- Design upgrade and migration strategies for databases ranging from hundreds ofgigabytes to multiple terabytes.
- Lead in-place upgrades, logical and physical migrations, replication-basedmigrations, Blue/Green deployments, and AWS DMS-based migrations.
- Perform upgrade readiness assessments covering compatibility, deprecatedfeatures, SQL modes, drivers, plugins, stored procedures, triggers, events, andapplication 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, performanceissues, 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 securitypractices.
- 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 environmentsusing slow query analysis, execution plans, indexing, partitioning, configurationtuning, 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-replicaarchitectures.
- Handle critical incidents, root-cause analysis, permanent corrective actions, andproduction 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 SQLinternals, storage engines, transactions, replication, locking, indexing, queryoptimization, backup, restore, recovery, failover, and disaster recovery.

- Proven experience upgrading large production My SQL databases, includingterabyte-scale environments and My SQL 5.7 to 8.x upgrades.
- Strong experience with Amazon RDS,



Amazon Aurora, Aurora Blue/Greendeployments, 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 compliancepractices.
- Experience with ITIL, incident, problem, change, and release managementprocesses.

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, databasedeployment automation, Python, Bash, or Power Shell.
- Knowledge of PCI-DSS, SOC 2, ISO 27001, data masking, tokenization, databaseactivity monitoring, cross-region disaster recovery, and multi-region databasearchitectures.
- AWS or database-related professional certification is an advantage. Key Competencies• Strong ownership, accountability, troubleshooting, analytical thinking, andproduction support discipline.
- Ability to explain complex database issues clearly to technical and non-technicalstakeholders.
- Strong documentation, implementation planning, risk communication, andstakeholder 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 arelated field; equivalent professional experience may be considered.

- 8+ years of database administration experience, including 5+ years of robust My SQLproduction support experience.
- Demonstrated experience upgrading databases of 1 TB or more.
- Experience with fintech, lending, banking, payments, or regulated financial-servicesenvironments is preferred.
- Proven ability to independently lead database upgrade and migration initiatives. Interested candidates can share their updated CV at:vaishali.bhola@

📌 Mysql Dba (Chhattisgarh)
🏢 Trantor
📍 Chhattisgarh