Senior Database Administrator (DBA)

Alphatech Software; Kuala Lumpur; On-site; MYR 120,000 - 150,000; Full time

Job summary

A software company in Kuala Lumpur is seeking a Senior MySQL DBA to manage and optimize mission-critical database systems. The ideal candidate should have over 5 years of experience with MySQL, specializing in performance tuning and AWS databases like Aurora and RDS. Key responsibilities include database administration, ensuring high availability, and implementing strong security measures. The position offers a collaborative environment working alongside developers to enforce best practices.

Qualifications

• 5+ years hands-on experience as a MySQL DBA.
• Strong knowledge of MySQL internals and indexing strategies.
• Experienced with monitoring tools for Aurora MySQL.

Responsibilities

• Administer and optimize MySQL databases.
• Troubleshoot performance issues using metrics.
• Manage backups, snapshots, and replication.

Skills

MySQL internals

Indexing strategies

Database security

CloudWatch

Performance Insights

SQL

Python

Bash

Tools

AWS RDS

Aurora MySQL

Terraform

Grafana

Job description

Alphatech Software – Kuala Lumpur, Kuala Lumpur

Job Description

We are looking for a Senior MySQL DBA to manage and optimize our mission-critical database systems. The ideal candidate will have deep expertise in MySQL and experience operating databases in AWS (Aurora MySQL / RDS MySQL). Knowledge of other DB engines is a strong advantage.

Key Responsibilities

• Administer, maintain, and optimize MySQL databases across production and non-production environments.
• Tune queries, indexes, InnoDB parameters, and troubleshoot performance issues using MySQL metrics and performance schema.
• Manage AWS Aurora MySQL and RDS MySQL, including backups, snapshots, PITR, replication, failover, and upgrades.
• Monitor database health (CPU, memory, IOPS, buffer pool, slow queries, locks, replication lag) and perform proactive tuning.
• Implement strong database security (user permissions, encryption, auditing, SSL).
• Ensure high availability, disaster recovery readiness, and capacity planning.
• Automate routine DBA tasks using scripts (SQL, Bash, Python preferred).
• Work with developers to guide schema design, write efficient SQL, and enforce DB best practices.

Requirements

• 5+ years hands-on experience as a MySQL DBA.
• Strong knowledge of MySQL internals, indexing strategies, locking, transactions, and InnoDB engine.
• Experienced with Aurora MySQL / RDS MySQL operations and monitoring tools (CloudWatch, Performance Insights, etc.).
• Proven ability to diagnose and resolve performance issues, replication problems, and query bottlenecks.
• Strong understanding of database security, backups, PITR, HA/DR.

Bonus / Good to Have

• PostgreSQL, MariaDB, MongoDB, or other database systems.
• Experience with Terraform/CloudFormation or DevOps pipelines.
• Knowledge of Percona Toolkit or Grafana/Prometheus.