PostgreSQL Application / Database Engineer

Overview

On Site
Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2

Skills

SQL
dba
postgre

Job Details

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 Java, .NET, Node.js, or Python.

  • Implement connection pooling (PgBouncer), transaction management, and retry logic.

Performance & Reliability

  • Diagnose and resolve performance issues using EXPLAIN/ANALYZE, pg_stat_statements, and auto_explain.

  • Tune PostgreSQL parameters such as work_mem, shared_buffers, effective_cache_size, 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 (Java, .NET, Node.js, or Python).

  • Familiarity with Docker, Kubernetes, and CI/CD workflows.

Nice to Have

  • Experience with PostgreSQL extensions such as pg_stat_statements, PostGIS, pg_partman, uuid-ossp, ltree.

  • Experience with Helm, ArgoCD, GitHub Actions, or Terraform.

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.

About Acunor Infotech