MySQL Database Administrator(DBA)

We are seeking an experienced MySQL Database Administrator (DBA) with specialized expertise in migrating on-premises Virtual Machines to Amazon Web Services (AWS). In this role, you will lead the architecture, assessment, and execution of migrating our on-premises virtualized MySQL infrastructure (VMware/Hyper-V/KVM) to high-performance AWS cloud environments (Amazon EC2 IaaS and AWS Managed DB ecosystems).

The ideal candidate possesses deep expertise in MySQL AWS networking and storage, hybrid cloud replication, and modern cloud migration tools like AWS Application Migration Service (AWS MGN) and AWS Database Migration Service (AWS DMS).

Key Responsibilities

On-Premises to AWS Migration Planning & Execution

• Architect and execute end-to-end migration strategies to move multi-terabyte on-premises MySQL databases to AWS with near-zero downtime.

• Assess existing on-premises virtual server workloads, compute demands, memory footprints, and disk I/O to define optimal AWS target architectures.

• Configure hybrid connectivity workflows over AWS Direct Connect or IPsec VPNs for secure, low-latency data replication between on-premises data centers and AWS VPCs.

• Execute cutovers using hybrid replication techniques (e.g., AWS Database Migration Service (DMS), or AWS Application Migration Service / AWS MGN).

• Establish comprehensive cutover playbooks, contingency plans, and rollback procedures to eliminate risk during production maintenance windows.

AWS Infrastructure Sizing & Storage Optimization

• Right-size AWS compute instances (e.g., Amazon EC2 memory-optimized instance families based on on-premises NUMA and CPU baseline data.

• Provision and tune AWS storage options specifically Amazon Elastic Block Store (EBS) volume types to achieve target IOPS and throughput requirements.

• Design and implement secure Network Topologies within AWS VPCs, including public/private subnet routing, Security Groups, Network ACLs, and AWS IAM policies.

High Availability, Disaster Recovery & Security

• Design high-availability topologies in AWS utilizing Multi-AZ deployments, MySQL Cluster, Group Replication

• Implement robust cloud backup and disaster recovery strategies using AWS Backup, EBS Snapshot integration

• Enforce security best practices, including transit encryption (TLS/SSL), storage encryption at rest (AWS KMS / TDE), and least-privilege IAM control.

Performance Tuning & Post-Migration Validation

• Establish baseline benchmarking, workload validation, and performance tests before and after cutover to ensure target AWS performance meets or exceeds on-premises levels.

• Monitor resource utilization, latency, buffer pool efficiency, and query execution using Amazon CloudWatch, Performance Schema, and Slow Query Logs.

• Resolve post-migration bottlenecks, query regressions