VLink Inc · 1 day ago
Postgres Database Engineer
NYC Metro Area
Contract
Hybrid
Mid, Senior LevelVLink Inc is seeking a Postgres Database Engineer specializing in PostgreSQL to design, build, optimize, and scale data-backed applications. The role involves collaborating with backend engineers, SRE/DevOps, and product teams to ensure reliable and performant features while handling various database operations and optimizations.
Information ServicesInformation Technology
Hiring Manager
Dipansh Gaur
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
Required
Specializing in PostgreSQL to design, build, optimize, and scale data-backed applications
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
Preferred
Postgres extensions: pg_stat_statements, PostGIS, pg_partman, uuid-ossp, ltree
Experience with Kubernetes, Helm, ArgoCD/GitHub Actions, Terraform
Company
VLink Inc
VLink Inc.
Founded in 2006
501-1000 employees
H1B Sponsorship
VLink Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (21)
2024 (42)
2023 (37)
2022 (36)
2021 (27)
2020 (44)
Funding
Current Stage
Late StageLeadership Team
Sharad Patney
President and CEO
Recent News
EIN Presswire
2025-09-17
Company data provided by crunchbase