Senior DB Administrator: PostgreSQL & MySQL in the Cloud

upscale; Kuala Lumpur; On-site; MYR 180,000 - 260,000; Full time

Job summary

upscale in Kuala Lumpur is seeking an experienced Database Administrator to design, deploy, and optimize PostgreSQL and MySQL databases across on-premises and AWS Aurora environments. You will ensure high availability, security, and performance for mission-critical workloads.

The role emphasizes disaster recovery, automation with shells and Python, and integration with CI/CD and DevOps practices, while managing security, backups, replication, and cost sizing.

Qualifications

• 7+ years of experience as a Database Administrator with hands-on PostgreSQL and MySQL expertise.
• Experience deploying and managing PostgreSQL and MySQL clusters on-premises and in AWS.
• Strong knowledge of high availability, backup, disaster recovery, and security best practices.
• Familiarity with CI/CD, DevOps practices, and automation scripting.

Responsibilities

• Deploy and configure PostgreSQL clusters in on-prem and AWS Aurora.
• Manage MySQL databases with optimal configuration and performance.
• Tune parameters for throughput and reliability (shared_buffers, work_mem, WAL, buffer pool).
• Implement WAL streaming, replication, failover, and DR drills.
• Design backup strategies and encrypt/secure credentials (AWS Secrets Manager).
• Monitor performance with CloudWatch, pg_stat_statements, and MySQL tools.

Skills

Database tuning

High availability

Security & compliance

Automation & scripting

DevOps integration

Performance optimization

Tools

PostgreSQL

MySQL

AWS Aurora

CloudWatch

pgAdmin

MySQL Workbench

Talend

ETL scripting

AWS CLI

Job description

upscale in Kuala Lumpur is seeking an experienced Database Administrator to design, deploy, and optimize PostgreSQL and MySQL databases across on-premises and AWS Aurora environments. You will ensure high availability, security, and performance for mission-critical workloads.

The role emphasizes disaster recovery, automation with shells and Python, and integration with CI/CD and DevOps practices, while managing security, backups, replication, and cost sizing.