PostGres​/Database Engineer

Post Gres Application/Database Engineer

Location:

New York City, NY

We are seeking an Application/Database Engineer specializing in Postgre

SQL 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/Dev Ops, and product teams to ship reliable, performant features.

• 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.
• Diagnose slow queries via EXPLAIN/ANALYZE, _statements, .
• Tune parameters (, , _size, autovacuum) and plan maintenance (VACUUM/ANALYZE, REINDEX).
• Implement streaming replication, failover, and PITR backups (WAL archiving); manage backup/restore strategy.
• Own DB migrations (Liquibase/Flyway), versioning, and rollback strategies.
• Enforce security (roles/privileges, RLS, encryption at rest/in transit, secret management).
• Containerize workloads (Docker/Kubernetes), maintain Helm charts/manifests, and CI/CD pipelines for DB/app changes.
• Partner with product/engineering on requirements, estimations, and trade‑offs.

• Postgres extensions: _statements, PostGIS, , uuid-ossp, ltree.
• Experience with Kubernetes, Helm, ArgoCD/Git Hub Actions, Terraform.

• Seniority level:
  Mid‑Senior level
• Employment type:
  
  Contract
• Job function:
  Information Technology
• Industry: IT Services and IT Consulting