Staff PostgreSQL Performance Engineer – Scale

Capital Rx; Charlotte (NC); Hybrid; USD 167,200 - 209,000; Full time

Job summary

Judi Health is seeking a Staff Engineer in Architecture to lead the database performance agenda for a data‑intensive platform. You will set standards, patterns, and benchmarks for PostgreSQL and drive cross‑team improvements across claims and adjudication workloads.

You will own diagnostics, benchmarking, and optimization in a high‑throughput environment, participate in a 24/7 on‑call rotation, and mentor engineers on Postgres internals as the team scales toward greater efficiency from

Qualifications

• 10+ years of production engineering experience, with deep specialization in PostgreSQL performance and transactional systems at scale.
• Deep fluency in PostgreSQL internals: MVCC, autovacuum behavior, query planner statistics, locking semantics, and the interaction between transaction patterns and long-running queries.
• Ability to diagnose production database performance problems in regulated environments where performance must not compromise data integrity.
• Experience designing and building performance benchmarking and regression-detection systems – including CI-integrated performance gates and observability pipelines.
• Experience evaluating and implementing cluster topology changes: connection pooling, read replicas, partitioning/sharding, and parameter tuning.
• Track record of leading cross-team technical initiatives – producing documentation that holds up over time.
• Strong written and verbal communication – architectural guidance that the broader engineering organization depends on.
• Comfortable operating with ambiguity – own problems from first principles to production.
• Strong experience supporting 24/7 production on‑call rotations.

Responsibilities

• Apply PostgreSQL expertise to diagnose production performance problems by interpreting query plans, analyzing usage patterns, and evaluating how cluster configuration and architectural decisions shape system behavior at scale, then own the path from root cause to production remediation.
• Evaluate and implement cluster topology changes and drive the architectural transformations, including the migration from synchronous to asynchronous I/O patterns that take the platform's throughput to the next order of magnitude.
• Build the benchmarking and regression-detection infrastructure that gives engineering teams a database performance signal before changes reach production.
• Define and own performance contracts for the database layer: latency targets, throughput expectations, and the SLA boundaries that upstream services build against.
• Lead query and schema reviews for high-risk changes; own incident response for performance-related degradations and drive post-incident findings into engineering improvements.
• Mentor and develop senior engineers on Postgres internals, query analysis, execution plan interpretation, and the performance implications of schema decisions at scale.
• Participate in a 24/7 on-call rotation to provide continuous operational support and rapid incident response.

Skills

PostgreSQL performance

Database performance

MVCC internals

On-call rotations

Leadership

Tools

PostgreSQL

Aurora PostgreSQL

PgBouncer

CI performance gates

Observability pipelines

Job description

Judi Health is seeking a Staff Engineer in Architecture to lead the database performance agenda for a data‑intensive platform. You will set standards, patterns, and benchmarks for PostgreSQL and drive cross‑team improvements across claims and adjudication workloads.

You will own diagnostics, benchmarking, and optimization in a high‑throughput environment, participate in a 24/7 on‑call rotation, and mentor engineers on Postgres internals as the team scales toward greater efficiency from