Zensar Technologies · 19 hours ago
ESaaS - Oracle - DBA - JDE System Administration
West New York, NJ
Full-time
Onsite
Mid LevelZensar Technologies is a company committed to designing and managing digital solutions for leading enterprises. They are seeking an Application/Database Engineer specializing in PostgreSQL to design, build, optimize, and scale data-backed applications while collaborating with various teams to deliver reliable features.
ConsultingIT ManagementOutsourcingSoftware
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
Design new postgres db
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
Zensar Technologies
Zensar Technologies is a software company that provides information technology and business process outsourcing services.
Founded in 1991
10001+ employees
H1B Sponsorship
Zensar Technologies 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 (195)
2024 (147)
2023 (120)
2022 (195)
2021 (135)
2020 (139)
Funding
Current Stage
Public CompanyTotal Funding
$9MKey Investors
Epiris
2015-10-10Post Ipo Equity
2003-07-09IPO
1997-09-01Private Equity· $9M
Leadership Team
Manish Tandon
CEO & Managing Director
Nagesh Nagineni
Practice Leader and CTO for AES, Data and Analytics Services @Zensar Technologies
Recent News
Business Standard India
2025-10-29
Livemint.com
2025-09-26
Company data provided by crunchbase