Senior Database Administrator

B
BTSEFintech, Blockchain
Southeast Asia; Malaysia; Hong Kong; APACFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page

Job Details

Experience
4+ years
Required Skills
AWSPostgreSQLPythonSQLBashGoLinuxTerraformAnsible

Requirements

  • 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).

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.
View Full Description & ApplyYou'll be redirected to the employer's site
View details
Apply Now