PostgreSQL Developer Mumbai Andheri East WFO 5 days

Intelli Search Services; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Intelli Search Services in Mumbai is seeking a skilled PostgreSQL Developer to design, develop, optimize, and maintain high-performance database systems. The role focuses on PostgreSQL architecture, query optimization, and ensuring reliability for scalable applications.

The candidate will design, develop, and optimize databases, write complex SQL, and ensure performance, security, and availability. Collaboration with DevOps and developers is essential, with responsibilities spanning migrations,

Qualifications

• Strong experience with PostgreSQL (version 10+ preferred).
• Proficiency in SQL and PL/pgSQL.
• Experience with performance tuning and query optimization.
• Solid understanding of database normalization and data modeling.
• Knowledge of indexing strategies, partitioning, and replication.
• Experience with backup and recovery tools (pg_dump, pg_restore, WAL, etc.).

Responsibilities

• Design, develop, and maintain PostgreSQL databases and schemas
• Write and optimize complex SQL queries, functions, triggers, and stored procedures
• Ensure database performance, availability, security, and scalability
• Plan and execute database migrations and upgrades
• Document database designs, processes, and standards
• Monitor database health and troubleshoot production issues
• Collaborate with application developers, DevOps, and system architects
• Manage backups, replication, and disaster recovery strategies

Skills

SQL

PL/pgSQL

PostgreSQL

Performance tuning

Query optimization

Data modeling

Database normalization

Indexing strategies

Partitioning

Replication

Tools

pg_dump

pg_restore

WAL

Job description

Job Title: PostgreSQL Developer

Job Summary

We are seeking a skilled PostgreSQL Developer to design, develop, optimize, and maintain high-performance database systems. The ideal candidate will have strong expertise in PostgreSQL architecture, query optimization, and database reliability, supporting scalable and secure applications.

Key Responsibilities

Design, develop, and maintain PostgreSQL databases and schemas

Write and optimize complex SQL queries, functions, triggers, and stored procedures

Ensure database performance, availability, security, and scalability

Perform database tuning, indexing, and query optimization

Manage backups, replication, and disaster recovery strategies

Monitor database health and troubleshoot production issues

Collaborate with application developers, DevOps, and system architects

Implement data integrity, consistency, and security best practices

Plan and execute database migrations and upgrades

Document database designs, processes, and standards

Required Skills & Qualifications

Strong experience with PostgreSQL (version 10+ preferred)

Proficiency in SQL and PL/pgSQL

Experience with performance tuning and query optimization

Solid understanding of database normalization and data modeling

Knowledge of indexing strategies, partitioning, and replication

Experience with backup and recovery tools (pg_dump, pg_restore, WAL, etc.)