MySQL Database Administrator(DBA)

CLOUD KINETICS CONSULTING PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

CLOUD KINETICS CONSULTING PTE. LTD. seeks an experienced MySQL Database Administrator to lead migration of on-premises VM-based MySQL to AWS, including architecture, assessment and execution across EC2 and managed DB services.

The role emphasizes deep MySQL performance tuning, AWS networking, hybrid replication, and use of AWS DMS/MGN tools to minimize downtime while ensuring data integrity and security.

Qualifications

• Experience migrating on-prem MySQL to AWS and leading end-to-end migration projects.
• Ability to architect target AWS environments and optimize performance.
• Knowledge of hybrid connectivity and data replication strategies.

Responsibilities

• On-Premises to AWS Migration Planning & Execution: architect and execute end-to-end migrations with minimal downtime.
• AWS Infrastructure Sizing & Storage Optimization: right-size compute and tune storage for performance.
• High Availability, Disaster Recovery & Security: design Multi-AZ topologies and enforce encryption and IAM controls.
• Performance Tuning & Post-Migration Validation: baseline benchmarks and monitor post-migration performance.

Skills

MySQL DBA

AWS migration

Cloud networking

Performance tuning

Hybrid cloud

Education

Bachelor's in Computer Science

Tools

AWS DMS

AWS MGN

VMware

Amazon EC2

AWS Direct Connect

Job description

We are seeking an experiencedMySQL 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 familiesbased 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