(Sr.) Database Administrator

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.

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

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

We prioritize employee well-being through a comprehensive benefits package:
● Health & Wellness Benefits: Comprehensive health insurance, annual check-ups and onsite wellness initiatives.
● Flexible Work Arrangements (Role-Dependent): We support flexibility while ensuring effective team collaboration.
● Growth Opportunities: Career advancement opportunities in a rapidly expanding industry with international exposure.
● Comprehensive Leave Benefits: Enjoy paid volunteer time, Christmas Day and birthday leave, on top of annual leave, paid sick leave, enhanced maternity/paternity leave.
● Employee Engagement: Enjoy weekly lunches, team-building activities, and a dynamic and collaborative work environment.

我們通過全面的福利計劃優先考慮員工福祉：
● 健康福祉：完善的團體健康保險、年度健康檢查，並提供職場健康活動，保障您的身心健康。
● 彈性工作安排(視職務而定)：彈性上班，同時確保團隊高效合作。
● 成長機會：在快速成長的產業中拓展國際實務經驗，幫助職涯成長。
● 完善的休假福利：除了優於法規的年度休假、帶薪病假、產假/陪產假外，還享有帶薪志工假、聖誕假及生日假，讓您兼顧工作與生活。
● 員工參與：每週兩次免費午餐、定期團隊建設活動，打造多元合作的工作環境。