Postgres Application/Database Engineer

Overview

Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - / Fulltime

Skills

Docker
Data Engineering
PostgreSQL
Cross-Functional Collaboration
data integrity
High Availability
Indexing Strategies
Query Optimization
Database Security
Advanced SQL
PostgreSQL extensions
Amazon Aurora PostgreSQL
Postgres Application Engineer
PostgreSQL Database Engineer
Database Application Development
Data-Backed Applications
Production Database Operations
PL/pgSQL
Schema Design
Partitioning (Range / List / Hash)
EXPLAIN / ANALYZE
pg_stat_statements
Query Performance Tuning
work_mem
shared_buffers
VACUUM / ANALYZE
Streaming Replication
Data Access Layer
ORM Optimization
Transaction Management
Connection Pooling
PgBouncer
Java / .NET / Node.js / Python
Database Migrations
Liquibase
Flyway
Schema Versioning
Encryption at Rest
Encryption in Transit
Database Observability
System Design Documentation
Data Contracts
Constraints & Triggers
Roles & Privileges
Table Archiving & Data Lifecycle Management

Job Details

Solution IT Inc. is looking for Postgres Application/Database Engineer for one of its clients NYC (Hybrid need 2 days per week onsite)

Job Title: Postgres Application/Database Engineer

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.

Required Skills:

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.

Work Site: NYC (Hybrid need 2 days per week onsite)

Duration: Long term / Fulltime

Expected Start Date: Immediate

Number of Positions: 01

Please send your responses back to

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.