Senior Database Administrator (PostgreSQL)
At a glance
Senior Data Architecture & Governance role at BTSE. Remote, Singapore · full-time.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Build and maintain PostgreSQL clusters in AWS, using infrastructure-as-code tools to manage deployment
- Automate database setup, configuration and monitoring, and carry out routine maintenance such as vacuuming and reindexing
- Find slow SQL and tune queries, indexes and workloads to improve database performance
- Design high-availability setups and backup recovery plans that protect uptime and data
- Monitor round-the-clock production databases, handle incidents and investigate root causes with engineering and operations teams
What you bring
- At least four years managing PostgreSQL databases in production
- Strong SQL tuning skills, including query optimization, indexing and PostgreSQL performance work
- Experience supporting always-on production systems and taking part in on-call or incident response
- Hands-on AWS experience, plus knowledge of PostgreSQL replication, point-in-time recovery and high-availability approaches
- Experience automating infrastructure with Terraform, Ansible or similar tools, and administering Linux with scripting
Who this fits
This senior role suits someone who has run production PostgreSQL systems and can improve their availability and performance through automation. You’ll support systems operating around the clock and participate in incident response. The role is remote in Southeast Asia.
From the employer
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!
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & GovernanceRemote
Find me workBy the team behind dataroles.