Postgresql Developer

SID Global Solutions

4 - 6 years

0 Lacs

mumbai maharashtra india

Posted:1 month ago| Platform: Foundit logo

Apply

Skills Required

checkpointing performance optimization questdb partitioning query performance tuning timeseries db indexing

Work Mode

On-site

Job Type

Full Time

Job Description

Job Title :

Job Location :

Job Typer :

Experience

Someone who can join within 15-20 Days.

Mandatory:

Postgres DB / Timeseries DB(QuestDB). Strong knowledge in Indexing, Portioning, Performance Optimization etc.

with deep expertise in PostgreSQL

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

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.