Job Description
Description
Role Summary
We are seeking an Application/Database Engineer specializing in Postgre SQL 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/Dev Ops, and product teams to ship reliable, performant features.
who could help design new postgres db.
---
Responsibilities
Application & Data Engineering
· · Write performant SQL and PL/pg SQL 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 (Pg Bouncer), 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 pit R 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 & Dev Ops
· 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, Post GIS, pg_partman, uuid-ossp, ltree.
· Experience with Kubernetes, Helm, Argo CD/Git Hub Actions, Terraform.
Role Summary
We are seeking an Application/Database Engineer specializing in Postgre SQL 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/Dev Ops, and product teams to ship reliable, performant features.
who could help design new postgres db.
---
Responsibilities
Application & Data Engineering
· · Write performant SQL and PL/pg SQL 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 (Pg Bouncer), 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 pit R 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 & Dev Ops
· 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, Post GIS, pg_partman, uuid-ossp, ltree.
· Experience with Kubernetes, Helm, Argo CD/Git Hub Actions, Terraform.
Apply for this Position
Ready to join ? Click the button below to submit your application.
Submit Application