Quantum World Technologies Inc.
PostGres Application/Database Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a PostGres Application/Database Engineer in New York City, NY, offering a contract length of "unknown" and a pay rate of "unknown." Key skills include PostgreSQL, SQL, PL/pgSQL, and experience with Docker/Kubernetes.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
January 7, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York City Metropolitan Area
-
🧠 - Skills detailed
#Terraform #REST (Representational State Transfer) #Cloud #PostgreSQL #.Net #GitHub #Python #Data Access #Kubernetes #SQL (Structured Query Language) #Data Migration #Presto #Replication #Strategy #Docker #Triggers #Liquibase #DevOps #Data Integrity #Security #Data Engineering #Code Reviews #Migration #Observability #Java #Schema Design
Role description
Job Title – PostGres Application/Database Engineer
Location: New York City, NY
Role 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.
Who could help design new postgres db.
Responsibilities
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.
Job Title – PostGres Application/Database Engineer
Location: New York City, NY
Role 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.
Who could help design new postgres db.
Responsibilities
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.
