Job Description: PostgreSQL Developer

Experience: 5+ Years
Location: Pune, Maharashtra (Pune-based candidates only)
Role Type: Full time

Job Summary

We are looking for an experienced PostgreSQL Developer with 5+ years of hands-on experience in database development, SQL programming, query optimization, and database performance tuning. The ideal candidate should have robust expertise in PostgreSQL database design, stored procedures, and troubleshooting complex database issues.

Key Responsibilities
Design, develop, and maintain PostgreSQL databases, schemas, tables, views, and indexes.
Write complex SQL queries, functions, stored procedures, and triggers.
Optimize SQL queries and improve database performance.
Perform query execution plan analysis using EXPLAIN and EXPLAIN ANALYZE.
Manage database indexing, partitioning, transactions, and concurrency.
Troubleshoot database performance issues and resolve production incidents.
Support database migrations, upgrades, backup, and recovery activities.
Collaborate with developers, QA, and infrastructure teams to deliver reliable database solutions.
Follow database security,



data integrity, and coding best practices.

Mandatory Skills
5+ years of hands-on PostgreSQL development experience.
Robust SQL and PL/pgSQL programming skills.
Expertise in query optimization and performance tuning.
Experience with database design, indexing, joins, functions, and stored procedures.
Knowledge of execution plans, transactions, locking, and concurrency.
Strong analytical and problem-solving skills.

Preferred Skills
Experience with PostgreSQL replication, partitioning, and high availability.
Familiarity with database monitoring and troubleshooting tools.
Exposure to database migration and performance benchmarking.

Location Requirement

Only candidates currently based in Pune, Maharashtra, will be considered.

Interested candidates: Please share your updated resume along with current location, total experience, relevant PostgreSQL experience, current CTC, expected CTC, and notice period.

Pay: Up to ₹1,600,000.00 per year

Work Location: In person

📌 Postgresql Developer Pune
🏢 IRTISH Consulting Pte
📍 Pune