Senior Database Administrator (PostgreSQL)
- Salary not listed
- Posted last month · via Lever
Design and maintain high-availability PostgreSQL clusters in AWS
Design, deploy, and maintain high-availability 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 thr...
Why This Role?
Directly contribute to BTSE's mission-critical database systems
Key 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
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
Required Skills
Indonesia Context
- Working Hours Overlap:
- Flexible — work your own hours
View Original Description from Lever PostingsShow more
Original description from Lever Postings
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! #LI-PP1
Not quite right? Similar roles hiring now
See all 5 similar →Openness not stated by employer — check the listing
Explore related
Market data & reports
Salary & skill-demand research built from our own listings data.
- Skills Remote Employers Ask For in the AI EraMost-named skills in active listings by kind, AI-named skills and the fastest risers. Weekly data.
- Indonesia IT Jobs vs Global Remote (2026)Primary analysis of 2,049 listings: methodology, classification rules, downloadable datasets.
- AI-Skill Demand: Indonesia vs Global Remote (2026)10,000+ postings, taxonomy-first classifier, Wilson CIs, pre-registered before analysis.
- Remote ≠ Remote: The Skills That Open Global Work to Indonesians (2026)12,891 remote listings: the highest-paid coding skills are the most geo-locked for Indonesia-based applicants. CC BY 4.0 aggregate dataset.
- The Compliance Layer of the AI Hiring Stack (2026)6,349 remote listings: 77.2% never state who may apply. Methodology and a CC BY 4.0 aggregate dataset.
- AI in Job Ads: Indonesia vs Global (2026)Global engineering ads naming AI rose from 3.4% to 23% after ChatGPT; Indonesian ads went from 2.2% to 2.8%. 2027 scenarios and a CC BY 4.0 dataset.
- Future of Jobs Index: every quarterly editionOne index per quarter from global remote and Indonesian job ads. Q4 2026 is the baseline (= 100); later editions are measured against it on the same sources.
- Future of Jobs Index, Q3 2026 (pre-baseline)Global remote and Indonesian job ads by job family: AI-skill demand, remote reach, pay transparency and seniority. Every figure with its sample size. CC BY 4.0 dataset.
- Pandora's Box Ep. 1: AI and Southeast Asian Job Ads (2026)118,545 archived job ads, 2019–2026: web and software developer ads shrank on every board, a phone app became the entry ticket, and a Job X-ray for 17 jobs. CC BY 4.0 datasets.
- Cron vs LLM vs LangGraph vs Agent for Social Posts (2026)A pre-registered test of four ways to turn a blog post into social posts, on two models. Automated checks picked a cron template; the model mattered more than the framework.
- Indonesia Hiring Report: Tech vs Non-TechJob demand by field from aggregate open-job counts — never individual listings.
- Indonesia Salary BenchmarkAggregate salary ranges across roles, with open methodology and dataset.
- Indonesian Remote Work Salary & Demand IndexHow much of the global remote job corpus is open to Indonesia, and what it pays (USD) by role.
- Indonesia Quarterly Labor Market ReportLayoffs, funding, salaries & skills per quarter — open aggregates.
- Remote Market Reports by RoleAuto-generated per role family — skills, seniority, companies, salary.
- Global Remote Salary BenchmarkAnnual salary by role & currency, plus the share of listings open worldwide.