Serv Recruitment · 8 hours ago
Senior PostgreSQL Database Administrator
United States
Full-time
Remote
Senior Level
5+ years expServ is a global executive recruitment partner hiring for Take Profit Trader, a high-growth proprietary trading firm. The Senior PostgreSQL Database Administrator will oversee the lifecycle of PostgreSQL clusters, focusing on optimization, performance tuning, and ensuring stability in reporting workloads.
Staffing & Recruiting
Responsibilities
Cluster Orchestration: Design and manage high-availability (HA) PostgreSQL clusters (Single-node, Patroni, or managed cloud) across all environments
Performance & Tuning: Proactively monitor and resolve bottlenecks, including vacuum/autovacuum tuning, index bloat, and connection management
Data Lifecycle & Partitioning: Implement advanced partitioning strategies (Range, List, Hash) and automated archival policies to maintain performance as datasets grow
Resiliency & Security: Own the backup/DR strategy (PITR, pgBackRest), execute zero-downtime upgrades, and enforce RBAC and encryption standards
Analytics Support: Optimize read-replicas and materialized views to enable high-performance BI reporting (Tableau/Power BI) without compromising OLTP speed
Automation: Utilize Infrastructure as Code (Terraform) and scripting (Python/Shell) to automate provisioning and maintenance
High Availability & Disaster Recovery: Design and orchestrate automated failover (Patroni/Cloud HA) to maintain a Recovery Time Objective (RTO) of <15 minutes and near-zero data loss (RPO)
Financial Integrity & Compliance: Enforce SOC2/GDPR standards by implementing granular audit logging, encryption, and automated PII masking across all environments
Data Lifecycle & Archiving: Architect and execute data retention policies that move aged trade data to lower-cost storage tiers without sacrificing accessibility for BI or regulatory audits
Qualification
Required
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
Company
Serv Recruitment
Serv Recruitment Agency is an Executive Search Firm helping growth organizations find top talent in the market.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase