Database Engineer

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.

Database Engineer 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