PostgreSQL Database Administrator (Production DBA)

About the Role Centric Software is seeking a PostgreSQL expert to join our R&D Customer Support team as a Production DBA. This role focuses on bringing deep Postgres expertise in-house to analyze, troubleshoot, and improve production database environments, perform root cause analysis on issues ranging from long-running queries to hosting environment problems and heavy traffic, and ensure our customers’ PostgreSQL deployments remain healthy, performant, and reliable. While the primary focus is production operations, the DBA will also work across development environments as needed to trace issues to their source and collaborate with engineering on fixes. What You'll Do

• Serve as the PostgreSQL expert and primary Production DBA within the R&D Customer Support team, driving the stability, performance, and reliability of customer-facing database environments.
• Perform root cause analysis (RCA) on production incidents spanning query performance, database configuration, infrastructure-level bottlenecks, and traffic/load conditions.
• Diagnose and resolve complex PostgreSQL performance, availability, and data-integrity issues, including query tuning, index strategy, vacuum/auto vacuum behavior, and lock contention.
• Troubleshoot and analyze production PostgreSQL systems across diverse hosting environments, ensuring performance, availability, and data integrity.
• Review execution plans, analyze slow queries, and recommend configuration, schema, or indexing changes to optimize production workloads.
• Support customers running PostgreSQL across on-premises, cloud (AWS RDS/Aurora, Azure, GCP), and self-managed deployments.
• Work across development and production environments to trace issues to their source and collaborate with engineering on fixes and product improvements.
• Advise on high-availability and disaster-recovery architectures including streaming replication, logical replication, failover, backup/restore (pg_basebackup, pgBackRest, WAL-G), and point-in-time recovery.
• Create and maintain internal knowledge-based articles, runbooks, and best-practice documentation for the support team.
• Mentor support engineers and developers on Postgres internals, SQL tuning, and operational best practices.
• Participate in on-call rotation for critical customer escalations as needed. What We're Looking For
• Minimum 5 years hands-on PostgreSQL DBA experience; deep knowledge of Postgres internals (MVCC, WAL, query planner, locking, buffer management) and operational best practices.
• Proven track record managing PostgreSQL in production; incident response, RCA, and performance optimization under heavy traffic.
• Strong SQL skills, including EXPLAIN/EXPLAIN ANALYZE.
• Experience with performance tuning: indexing strategies, autovacuum, connection pooling (PgBouncer), and config tuning (postgresql.conf).
• Experience with HA and replication: streaming replication, logical replication, Patroni, or equivalent.
• Experience with backup/recovery tooling such as pgBackRest, WAL-G, pg_basebackup, or Barman.
• Proficiency with Linux/Unix and shell scripting (Bash or similar).
• Strong written and verbal communication; ability to explain complex concepts to technical and non-technical audiences.
• Located in North America with ability to work core hours overlapping with team.
• Preferred: Experience with AWS RDS/Aurora, Azure Database for PostgreSQL, or Google Cloud SQL.
• Scripting/automation: Python, PowerShell, or similar.
• Familiarity with monitoring/observability tools (Datadog, New Relic, Prometheus, pganalyze, Sentry).
• Experience in customer-facing or customer-support-adjacent role.
• Exposure to additional database platforms (Oracle, SQL Server, MySQL, MongoDB) and migration experience to/from Postgres.
• Experience with infrastructure-as-code (Terraform, CloudFormation) and containerized workloads (Kubernetes). Nice to Have
• Experience with AWS RDS/Aurora, Azure Database for PostgreSQL, or Google Cloud SQL.
• Scripting/automation in Python or PowerShell.
• Monitoring/observability tooling experience (Datadog, New Relic, Prometheus, pganalyze, Sentry).
• Customer-facing or support-adjacent experience.
• Terraform/CloudFormation and Kubernetes experience. Compensation & Benefits
• Salary: 136,000 USD per year.
• Remote work arrangement with potential for cross-border collaboration.
• Equal employment opportunities and a chance to join a fast-growing, innovative team.