Senior Database Administrator

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

About BTSE

BTSE Group is a global leader in fintech and blockchain technology, anchored by three core business pillars: Exchange, Payments, and Infrastructure Development. Serving over 100 corporate clients worldwide, we provide white-label exchange and payment solutions. Our offerings encompass everything from exchange infrastructure hosting and development to custody, wallets, payments, blockchain integration, trading, and more. We are looking for talented professionals in marketing, operations, customer support, and other departments. The roles offered may be on-site, remote, or hybrid, in collaboration with our local partner.

About The Opportunity

We are looking for an experienced Database Administrator with deep PostgreSQL expertise and hands-on experience automating database deployment, monitoring, and performance tuning on Data Center and AWS. You will be part of the core infrastructure team responsible for scaling and maintaining BTSE’s mission-critical database systems that power our trading and analytics platforms. This role offers the opportunity to design, automate, and optimize high-availability PostgreSQL clusters while ensuring reliability, minimal downtime, and strong observability across production environments operating 24/7.

Responsibilities

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

Requirement

• 4+ years of experience managing PostgreSQL databases in production environments.
• 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 or zero downtime.
• Experience supporting mission-critical 24/7 systems in production, with on-call or incident response participation.
• Hands-on experience with AWS services such as EC2, RDS, EBS, S3, and IAM.
• Solid understanding of PostgreSQL replication, PITR (Point-in-Time Recovery), and HA solutions (Repmgr,Patroni, ProxySQL, or similar).
• Experience automating infrastructure using Terraform, Ansible, or similar tools.
• Proficiency in Linux systems administration and scripting (Bash, Python, or Go).

Nice to Haves

• Familiarity with observability and alerting stacks (Prometheus, Loki, Grafana, CloudWatch).
• Exposure to additional database systems such as ClickHouse or TimeScale Postgres.
• Experience building internal automation or self-healing tools for query analysis and database management.

Perks & Benefits

• Competitive total compensation package
• Various team-building programs and company events
• And many more! Apply and let us tell you more!

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.