PostgreSQL Developer
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Overview:
We are seeking a highly skilled PostgreSQL Developer with deep expertise in designing, optimizing, and operating PostgreSQL databases at scale. This role is focused on performance, reliability, data integrity, and advanced PostgreSQL features rather than generic database administration. The ideal candidate is someone who truly knows PostgreSQL inside and out and can architect, tune, and support mission-critical data systems.
Key Responsibilities:
- Design, build, and maintain complex PostgreSQL database systems for high-availability and high-performance environments
- Lead schema design, table partitioning strategies, indexing, and query optimization
- Diagnose and resolve performance bottlenecks using EXPLAIN, ANALYZE, pg_stat views, and advanced profiling tools
- Implement and manage replication, backups, point-in-time recovery (PITR), and disaster recovery strategies
- Develop and optimize stored procedures, functions, triggers, and extensions using PL/pgSQL (or other supported languages)
- Ensure data integrity, security, and compliance through roles, permissions, encryption, and auditing practices
- Collaborate closely with backend engineers to design efficient data models and access patterns
- Handle database migrations, version upgrades, and zero/minimal-downtime deployments
- Establish best practices for database monitoring, alerting, and capacity planning
- Act as a PostgreSQL subject-matter expert and provide guidance to engineering teams
Required Skills & Experience:
- 5+ years of hands-on PostgreSQL experience in production environments
- Deep understanding of PostgreSQL internals (MVCC, WAL, vacuuming, locking, query planner)
- Strong experience with performance tuning, indexing strategies, and query optimization
- Expertise in replication technologies (streaming replication, logical replication)
- Experience with backup and recovery tools (pg_dump, pg_basebackup, PITR)
- Proficiency in PL/pgSQL and writing advanced database logic
- Strong SQL skills including complex joins, CTEs, window functions, and performance-aware query design
- Experience operating PostgreSQL on Linux-based systems
- Familiarity with database monitoring and observability tools
- Strong troubleshooting, analytical, and documentation skills
Nice to Have:
- Experience with very large databases (hundreds of GBs to TB+ scale)
- PostgreSQL extensions (PostGIS, pg_partman, pg_stat_statements, timescaledb, etc.)Cloud-managed PostgreSQL (AWS RDS/Aurora, GCP Cloud SQL, Azure PostgreSQL)
- Experience with sharding, partitioning, and multi-tenant database architectures
- Knowledge of HA solutions (Patroni, PgBouncer, Pgpool-II)
- Automation and Infrastructure-as-Code experience (Terraform, Ansible, CI/CD)
What Success Looks Like:
- Databases are fast, reliable, well-monitored, and resilient
- Query performance issues are proactively identified and resolved
- PostgreSQL upgrades and migrations are smooth and low-risk
- Engineering teams trust your guidance on data modeling and performance decisions
Compensation: Base salary starting at $80K$10K annual retention increase guarantee
Growth potential up to $170K