Senior PostgreSQL DBA - Remote & Cloud HA

BTSE; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Benefits offered by this job

Competitive compensation package

Team-building programs

Company events

Job summary

BTSE Group is seeking an experienced Database Administrator with deep PostgreSQL expertise to join our core infrastructure team in Kuala Lumpur. You will design, deploy, and optimize highly available PostgreSQL clusters, automate deployments, and monitor performance across 24/7 production systems powering trading and analytics.

Responsibilities include query tuning, backups, DR planning, and collaborating with SRE/DevOps to integrate CI/CD for database operations.

Qualifications

• 4+ years of experience managing PostgreSQL databases in production.
• Strong knowledge of SQL query optimization, indexing strategies, and PostgreSQL performance tuning.
• Proven ability to design and maintain highly available, fault-tolerant systems with minimal downtime.
• Experience supporting 24/7 production systems with on-call or incident response.
• Hands-on experience with AWS services such as EC2, RDS, EBS, S3, and IAM.
• Understanding of PostgreSQL replication and HA solutions (Patroni, Repmgr, ProxySQL, or similar).
• Experience automating infrastructure using Terraform, Ansible, or similar tools.
• Proficiency in Linux systems administration and scripting (Bash, Python, or Go).

Responsibilities

• Design, deploy, and maintain PostgreSQL clusters in AWS environments using IaC tools.
• Develop automation for provisioning, configuration management, and monitoring of PostgreSQL databases.
• Perform regular maintenance including vacuuming, reindexing, and statistics analysis for peak performance.
• Identify, analyze, and optimize slow SQL queries and workloads.
• Build high-availability database architectures minimizing downtime during upgrades and failovers.
• Implement backup, recovery, and disaster recovery strategies to ensure data integrity and uptime.
• Support and monitor 24/7 production systems, participating in incident response.
• Collaborate with SRE, DevOps, and engineering teams to improve scalability and CI/CD integration for database operations.

Skills

PostgreSQL

SQL optimization

Linux administration

Scripting (Bash/Python/Go)

AWS basics

Tools

Terraform

Ansible

RDS/EBS/S3/IAM

Patroni

Repmgr

Job description

BTSE Group is seeking an experienced Database Administrator with deep PostgreSQL expertise to join our core infrastructure team in Kuala Lumpur. You will design, deploy, and optimize highly available PostgreSQL clusters, automate deployments, and monitor performance across 24/7 production systems powering trading and analytics.

Responsibilities include query tuning, backups, DR planning, and collaborating with SRE/DevOps to integrate CI/CD for database operations.