Position Title - PostgreSQL Database Developer

Experience Required - 2 - 5 Years

Database Version -PostgreSQL 17

Department - Software Engineering

Employment Type- Full time
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 robust 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.
Key Responsibilities
Design and build PostgreSQL schemas, tables, views and indexes that hold up as data volume grows, not just at demo scale.
Write productive 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