Postgress + Application/DB

Description

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.