Senior PostgreSQL Database Administrator - Remote

Overview

As a Senior DBA at Take Profit Trader, you will own the end-to-end lifecycle of our PostgreSQL clusters. This is a hands-on leadership role focused on operating at scale—optimizing complex queries, managing multi-terabyte partitioned tables, and ensuring our reporting workloads thrive without impacting production stability.

In Short

• Design and manage high-availability (HA) PostgreSQL clusters.
• Proactively monitor and resolve performance bottlenecks.
• Implement advanced partitioning strategies and 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 and scripting for automation.
• Design automated failover to maintain RTO and RPO standards.
• Enforce SOC2/GDPR standards for compliance.
• Architect data retention policies for trade data.

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 environments.
• Strong Linux skills and experience with Prometheus/Grafana.
• BS in Computer Science or equivalent practical experience.

Benefits

• Starting salary of $145,000 + bonus.
• Performance bonus based on performance.
• Comprehensive health insurance.
• Remote-first culture.