Senior Database Administrator, PostgreSQL

This is a fully remote position, open to applicants in Taiwan.

📋 Description

• Design, implement, and oversee PostgreSQL clusters within AWS environments utilizing Infrastructure as Code (IaC) tools.

• Create automation solutions for the provisioning, configuration management, and monitoring of PostgreSQL databases.

• Conduct routine database maintenance tasks such as vacuuming, reindexing, and analyzing statistics to maintain optimal performance.

• Identify, evaluate, and enhance slow SQL queries and workloads to boost efficiency and throughput.

• Develop resilient, high-availability database architectures that reduce downtime during upgrades, maintenance, and failovers.

• Establish strong backup, recovery, and disaster recovery plans to ensure data integrity and continuous uptime.

• Provide support and monitoring for 24/7 production systems, engaging in incident response and root cause analysis as necessary.

• Collaborate with SRE, DevOps, and engineering teams to enhance scalability, performance, and CI/CD integration for database operations.

• Sustain and optimize BTSE’s essential database systems that drive trading and analytics platforms.

⛳️ Requirements

• Over 4 years of experience managing PostgreSQL databases in production settings.

• In-depth knowledge of SQL query optimization, indexing techniques, and PostgreSQL performance tuning.

• Demonstrated capability in designing and maintaining highly available, fault-tolerant systems with minimal or no downtime.

• Experience in supporting mission-critical 24/7 systems in production, including participation in on-call or incident response activities.

• Practical experience with AWS services such as EC2, RDS, EBS, S3, and IAM.

• Comprehensive understanding of PostgreSQL replication, PITR (Point-in-Time Recovery), and high availability solutions (Repmgr, Patroni, ProxySQL, or similar).

• Experience in automating infrastructure using tools like Terraform, Ansible, or similar technologies.

• Proficient in Linux systems administration and scripting languages (Bash, Python, or Go).

• Nice to have: Familiarity with observability and alerting tools (Prometheus, Loki, Grafana, CloudWatch).

• Nice to have: Exposure to other database systems such as ClickHouse or TimeScale Postgres.

• Nice to have: Experience in developing internal automation or self-healing tools for query analysis and database management.

🏝️ Benefits

• Competitive total compensation package.

• Various team-building programs and company events.