PostgreSQL Application Database Engineer

New York City, NY - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

Job Title: PostgreSQL Application / Database Engineer

Location: NYC (Hybrid 2 days/week onsite)
Employment Type: Long-Term Contract / Full-Time

Job Description

We are seeking a PostgreSQL Application / Database Engineer to design build optimize and operate scalable high-performance data-backed applications. The ideal candidate will have strong hands-on experience with PostgreSQL database design query optimization application integration and production database operations. This role involves close collaboration with backend engineers DevOps/SRE teams and product stakeholders.

Key Responsibilities Application & Database Engineering

Design and implement new PostgreSQL database schemas and evolve existing data models.
Write and optimize complex SQL queries and PL/pgSQL functions.
Optimize ORM-generated queries and enforce data integrity using constraints indexes and triggers.
Implement table partitioning (range/list/hash) and data archival strategies.
Build and integrate data access layers/APIs using or Python.
Implement connection pooling (PgBouncer) transaction management and retry logic.

Performance & Reliability

Diagnose and resolve performance issues using EXPLAIN/ANALYZE pgstatstatements and autoexplain.
Tune PostgreSQL parameters such as workmem sharedbuffers effectivecachesize and autovacuum.
Perform routine maintenance activities including VACUUM ANALYZE and REINDEX.
Implement streaming replication failover strategies and point-in-time recovery (PITR) using WAL archiving.
Own backup restore and disaster recovery processes.

Operations & Security

Manage database migrations versioning and rollbacks using Liquibase or Flyway.
Implement database security controls including roles privileges and Row-Level Security (RLS).
Ensure encryption at rest and in transit; manage secrets securely.

Required Qualifications

Strong hands-on experience with PostgreSQL in production environments.
Expertise in SQL and PL/pgSQL.
Proven experience designing PostgreSQL databases from scratch.
Experience with query tuning indexing strategies and performance troubleshooting.
Hands-on experience with database migrations replication and backups.
Experience integrating PostgreSQL with application stacks ( or Python).
Familiarity with Docker Kubernetes and CI/CD workflows.

Nice to Have

Experience with PostgreSQL extensions such as pgstatstatements PostGIS pgpartman uuid-ossp ltree.
Experience with Helm ArgoCD GitHub Actions or Terraform.

Job Title: PostgreSQL Application / Database Engineer Location: NYC (Hybrid 2 days/week onsite) Employment Type: Long-Term Contract / Full-Time Job Description We are seeking a PostgreSQL Application / Database Engineer to design build optimize and operate scalable high-performance data-backed a...