Apply on Employer Site

Quantum World Technologies Inc. · 1 day ago

PostGres Application/Database Engineer

NYC Metro Area

Contract

Onsite

Mid Level

Quantum World Technologies Inc. is seeking an Application/Database Engineer specializing in PostgreSQL to design, build, optimize, and scale data-backed applications. The role involves working on schema design, query optimization, application integration, data migrations, and production operations while collaborating with various teams to deliver reliable features.

ConsultingHuman ResourcesInformation TechnologyStaffing Agency

Hiring Manager

Sachin Singh

Responsibilities

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, 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

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

Document designs, data contracts, runbooks; conduct code reviews; mentor junior engineers

Qualification

PostgreSQLSQLDatabase migrationsDockerKubernetesData integrityCollaborationMentoringDocumentation

Required

Specializing in PostgreSQL to design, build, optimize, and scale data-backed applications