Senior PostgreSQL Database Administrator
Posted 43ds ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior PostgreSQL Database Administrator owning lifecycle of PostgreSQL clusters at Take Profit Trader. Focused on optimizing performance, managing HA, and supporting data analytics.
Responsibilities:
- Own the end-to-end lifecycle of PostgreSQL clusters
- Design and manage high-availability (HA) PostgreSQL clusters across all environments
- Proactively monitor and resolve bottlenecks
- Implement advanced partitioning strategies and automated archival policies
- Own the backup/DR strategy and execute zero-downtime upgrades
- Optimize read-replicas and materialized views for BI reporting
- Utilize Infrastructure as Code (Terraform) and scripting to automate provisioning
- Design and orchestrate automated failover to maintain RTO of <15 minutes
- Enforce SOC2/GDPR standards and implement data retention policies
Requirements:
- 5–10 years as a production PostgreSQL DBA
- Deep mastery of MVCC, WAL, and Query Planner behavior
- Proficiency with pgBouncer, Patroni, and cloud-native database environments (AWS/Azure)
- Strong Linux skills and experience with Prometheus/Grafana monitoring
- BS in Computer Science or equivalent practical experience
Benefits:
- Comprehensive health insurance
- Remote-first culture
Report this job
Job expired or something wrong with this job?




















