Job Title PostGres Application/Database Engineer
Location: NYC (Hybrid need 2 days per week onsite)
Duration: Long term / Fulltime
Role Summary
We are seeking an Application/Database Engineer specializing in PostgreSQL to design, build, optimize, and scale data-backed applications. You will work across schema design, query optimization, application integration, data migrations, and production operations (replication, backups, observability). You will collaborate with backend engineers, SRE/DevOps, and product teams to ship reliable, performant features.
Who could help design new postgres db.
Responsibilities
Application & Data Engineering
Write performant SQL and PL/pgSQL functions; optimize ORM-generated queries; enforce data integrity with constraints and triggers.
Implement partitioning (range/list/hash) for large tables; handle archiving and lifecycle policies.
Build data access layers/APIs (Java/.NET/Node.js/Python) with connection pooling (PgBouncer), transactions, and retry logic.
Performance & Reliability
Diagnose slow queries via EXPLAIN/ANALYZE, pg_stat_statements, auto_explain.
Tune parameters (work_mem, shared_buffers, effective_cache_size, autovacuum) and plan maintenance (VACUUM/ANALYZE, REINDEX).
Implement streaming replication, failover, and pitR backups (WAL archiving); manage backup/restore strategy.
Operations & Security
Own DB migrations (Liquibase/Flyway), versioning, and rollback strategies.
Enforce security (roles/privileges), RLS, encryption at rest/in transit, secret management.
Cloud & DevOps
Containerize workloads (Docker/Kubernetes), maintain Helm charts/manifests, and CI/CD pipelines for DB/app changes.
Collaboration
Partner with product/engineering on requirements, estimations, and trade-offs.
Document designs, data contracts, runbooks; conduct code reviews; mentor junior engineers.
Nice-to-Have
Postgres extensions: pg_stat_statements, PostGIS, pg_partman, uuid-ossp, ltree.
Experience with Kubernetes, Helm, ArgoCD/GitHub Actions, Terraform.
Never miss an opportunity! Create an alert based on the job you applied for.
