Postgresql Developer

Deloitte Shared Services India; Mumbai; Hybrid; INR 1,800,000 - 3,000,000; Full time

Job summary

Deloitte Shared Services India is seeking a Database Developer / Administrator with strong PostgreSQL DBA and development skills in Mumbai. You will manage PostgreSQL databases, optimize performance, design schemas, and lead migration and backup projects for real-time data processing.

Ideal candidates have hands-on PostgreSQL, SQL development, and experience with Time Series Databases such as QuestDB, enabling high-throughput environments.

Qualifications

• Hands-on PostgreSQL DBA and development experience.
• Strong skills in performance tuning, query optimization and indexing.
• Experience with backup/recovery strategies and migrations.
• Familiarity with time series databases, preferably QuestDB.

Responsibilities

• Manage and develop PostgreSQL databases across environments.
• Tune performance, optimize queries, and troubleshoot issues.
• Design and implement backup/recovery strategies.
• Develop complex SQL, functions, procedures and objects.
• Model schemas and PDMs; handle migrations and upgrades.
• Work with time series databases and real-time data processing.

Skills

PostgreSQL DBA

PostgreSQL Development

SQL

Query Optimization

Performance Tuning

Indexing

Backup & Recovery

Database Migration

Schema Design

Time Series DB

QuestDB

Real-Time DBs

High-Throughput Systems

Tools

QuestDB

Monitoring Tools

Data Migration Tools

Job description

Database Developer / Administrator PostgreSQL

Role Overview

We are looking for a Database Developer / Administrator with strong hands‑on experience in PostgreSQL DBA + Development. The ideal candidate should have expertise in database performance, SQL development, backup/recovery, schema design, migration, and Time Series Databases, preferably QuestDB. Experience in high-throughput, real‑time environments will be highly preferred.

Work Profile / Responsibilities

• Manage and develop PostgreSQL databases across development, testing, and production environments.
• Perform database performance tuning, query optimization, indexing, and troubleshooting.
• Design and implement backup and recovery strategies and execute database recovery procedures.
• Develop complex SQL queries, functions, stored procedures, and database objects.
• Design and maintain database schemas and Physical Data Models (PDM).
• Work on database migration, upgrades, and data movement projects.
• Manage and optimize Time Series Databases, preferably QuestDB.
• Support high-volume, high-throughput and real‑time data processing environments.
• Monitor database health, capacity, performance, availability, and reliability.
• Collaborate with application developers, architects, DevOps, and data teams to optimize database solutions.
• Identify database issues and implement proactive performance and reliability improvements.

Key Skills

PostgreSQL DBA, PostgreSQL Development, SQL, Query Optimization, Performance Tuning, Indexing, Backup & Recovery, Database Migration, Schema Design, PDM, Time Series Database, QuestDB, Real‑Time Databases, High‑Throughput Systems

Experience

• 510 years of overall database experience.
• Strong hands‑on experience in PostgreSQL DBA + Development.
• Proven experience in performance tuning and complex SQL development.
• Experience with backup/recovery and database migration projects.
• Exposure to QuestDB or other Time Series Databases.
• Experience working with high‑volume / real‑time applications is preferred.

Languages

SQL, PL/pgSQL

Technologies / Tools

PostgreSQL, QuestDB, Time Series Databases, SQL, PL/pgSQL, Database Migration Tools, Monitoring & Performance Tuning Tools