工作內容

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.

我們通過全面的福利計劃優先考慮員工福祉：

面議（經常性薪資達4萬元）