MySQL Database Administrator

Cloud Kinetics; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Cloud Kinetics is seeking an experienced MySQL Database Administrator (DBA) to lead the migration of on-premises VMware/Hyper-V/KVM-based MySQL infrastructure to AWS, including EC2 and managed DB services. You will oversee architecture, assessment, and execution of multi-terabyte migrations with a focus on near-zero downtime.

The ideal candidate has deep MySQL performance tuning, AWS networking/storage expertise, and hands-on experience with hybrid cloud replication and migration tools such as

Qualifications

• Must have strong MySQL DBA experience and performance tuning skills.
• Experience migrating on-premises MySQL to AWS with near-zero downtime preferred.
• Familiarity with AWS DMS and AWS MGN for cutovers and validation.

Responsibilities

• Architect end-to-end migration strategies from on-prem to AWS EC2 and managed DB services.
• Assess workloads, compute, memory, and I/O to define target AWS architectures.
• Configure secure connectivity (direct connect or VPN) between on-prem and AWS VPCs.
• Execute cutovers using hybrid replication methods (DMS/MGN).
• Create and follow cutover playbooks with rollback procedures.
• Design and implement robust security and backup strategies for the migrated environment.
• Monitor post-migration performance and resolve any bottlenecks.

Skills

MySQL administration

AWS networking

Cloud migration

AWS DMS

AWS MGN

Hybrid cloud

VM ware/Hyper-V/KVM

Tools

VMware

Hyper-V

KVM

EC2

Job description

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.

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 t o 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