Job Title : PostgreSQL Developer
Job Location : Mumbai
Job Typer : Permanent
Experience
: 4-6 Years
Someone who can join within 15-20 Days.
Mandatory :
Postgres DB / Timeseries DB(QuestDB). Strong knowledge in Indexing, Portioning, Performance Optimization etc.
We are seeking a skilled PostgreSQL DBA
with deep expertise in PostgreSQL
to design, optimize, and manage complex database systems, particularly with large-scale and time-series data workloads. The ideal candidate will have experience in performance tuning, high availability configurations, query optimization, and cloud database operations.
Key Responsibilities :
Design and manage PostgreSQL clusters (single and replica setups)
Work with
partitioning and indexing strategies
for large datasets
Write and optimize complex
time-based queries
and work with
time-series databases
Configure and manage
WAL buffers, checkpoint settings , and
WAL retention
for durability and recovery
Implement database
failover handling and recovery
mechanisms during data transfers
Conduct
query tuning and performance analysis
using real-world metrics
Manage
database partitioning
without relying on enterprise versions
Work with
cloud-based DB deployments
(AWS RDS, GCP, Azure, etc.)
Maintain and scale database indexing as data size grows beyond predefined thresholds
Required Skills :
Strong hands-on experience with
PostgreSQL
(including WAL, replication, clustering)
Proficiency in
Docker
and containerized database environments
Experience with
time-series databases
(e.g., TimescaleDB or native Postgres)
Deep understanding of
query performance tuning techniques
Familiarity with
WAL (Write Ahead Log) ,
checkpointing , and
buffer management
Knowledge of
cloud-native DB services
and backup / restore strategies
Ability to handle
high availability and failover scenarios
Database Developer • Delhi, India