Senior Database Administrator, PostgreSQL

BTSE

. Design, deploy, and maintain PostgreSQL clusters in AWS environments using Infrastructure as Code (IaC) tools .

Posted 10/12/2026full-timeRemote • TaiwanSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in managing PostgreSQL databases in production environments, with a strong focus on performance tuning, high availability, and disaster recovery strategies. Proficient in automating infrastructure and collaborating with cross-functional teams to enhance database operations.

Highest-signal resume keywords

PostgreSQL Database ManagementSQL Query OptimizationAWS Services (EC2, RDS, EBS, S3, IAM)Infrastructure Automation (Terraform, Ansible)Linux Systems Administration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

PostgreSQLSQLDatabase Performance TuningHigh Availability SolutionsBackup and Recovery StrategiesAutomation Scripting (Bash, Python, Go)Database MaintenanceIncident ResponseMonitoring and ObservabilityReplication and PITR

Tools & Technologies

TerraformAnsiblePrometheusGrafanaCloudWatch

Industry Keywords

Infrastructure as Code (IaC)24/7 Production SystemsFault-Tolerant SystemsTrading PlatformsAnalytics Platforms

Tech Stack

Tools & technologies

AnsibleAWSEC2GrafanaLinuxPostgresPrometheusPythonSQLTerraformGo

About the role

Key responsibilities & impact

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
Maintain and optimize BTSE’s mission-critical database systems powering trading and analytics platforms

Requirements

What you’ll need

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 have: Familiarity with observability and alerting stacks (Prometheus, Loki, Grafana, CloudWatch)
Nice to have: Exposure to additional database systems such as ClickHouse or TimeScale Postgres
Nice to have: Experience building internal automation or self-healing tools for query analysis and database management

Benefits

Comp & perks

Competitive total compensation package
Various team-building programs and company events