Job Description
Alphatech Software – Kuala Lumpur, Kuala Lumpur
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.
Benefits
- Group Insurance (Hospitalization)
- Annual Leave / Medical Leave
- Say "NO" to office politics, a young company with more opportunity