PostgreSQL Database Consultant
Core
Diagnose, stabilize, and tune large self-managed PostgreSQL environments for enterprise clients to ensure reliable data platforms.
Role type
Senior IC PostgreSQL Database Consultant
Builds
Self-managed PostgreSQL clusters, high-availability setups, and performance-tuned data platforms
Domain
Database Administration / PostgreSQL / Enterprise Infrastructure
Required skills
PostgreSQL internals (MVCC, autovacuum, WAL, planner), indexing strategies (B-tree, GIN, GiST, BRIN), query performance analysis (EXPLAIN, pg_stat_statements), replication and high availability (Patroni, repmgr), backup and recovery (pgBackRest, Barman), connection pooling (PgBouncer), Linux administration, incident response and root cause analysis
Preferred skills
Configuration management (Ansible), runbook creation, capacity planning, major version upgrades, security hardening, Kubernetes (CloudNativePG), scripting (Python, Bash, Go), other relational databases
Technologies
PostgreSQL, Linux, Ansible, Prometheus, pgwatch, Datadog, Patroni, repmgr, pgBackRest, Barman, PgBouncer, CloudNativePG, Crunchy Postgres Operator
Responsibilities
Audit configuration and maintenance across enterprise PostgreSQL environments; optimize vacuum strategy, indexing, and queries; implement monitoring and alerting; consult with clients to build outcome-driven platforms; perform incident response and root cause analysis; travel 3-5 days per quarter for client engagements
Seniority
Senior, hands-on IC