Position Title - PostgreSQL Database Developer

Experience Required - 2 - 5 Years

Database Version -PostgreSQL 17

Department - Software Engineering

Employment Type- Full time

1. Position Summary

We are looking for a skilled PostgreSQL Database Developer with 25 years of hands-on experience in designing, developing, and optimizing PostgreSQL databases for enterprise applications. The ideal candidate should possess strong expertise in relational database design, SQL, PL/pgSQL programming, query optimization, and database performance tuning. The role requires working closely with application developers, architects, and infrastructure teams to build scalable, secure, and high-performing database solutions.

2. Key Responsibilities
- Design and build PostgreSQL schemas, tables, views and indexes that hold up as data volume grows, not just at demo scale.
- Write efficient SQL and PL/pgSQL stored procedures, functions, triggers and know when not to use them.
- Turn data model specs and LLDs into clean, production-ready DDL without back-and-forth.




- Get into EXPLAIN/EXPLAIN ANALYZE regularly to find and fix slow queries before they become a problem in production.
- Keep an eye on overall database health bloat, autovacuum behavior, connection usage and act on it proactively rather than after an incident.
- Work with the infra/DBA team on backup, recovery and replication strategy you don't have to own the infra, but you should know enough to spot a bad setup.
- Apply sensible access control and constraints so data integrity isn't left to chance.
- Make calls on partitioning, sharding or extensions (pg_partman, pgcrypto, PostGIS, etc.) when the use case genuinely needs it.
- Keep documentation current ER diagrams, data dictionaries, scripts so the next person isn't reverse-engineering your work.
- Review database-related code from the rest of the team and flag issues before they ship.
- Support application teams with database integration and query optimization as feature

📌 Postgresql Developer (Noida)
🏢 Inventia Technology Consultants
📍 Noida