Senior Database Administrator
Location
bengaluru, karnataka
Job Type
Full-time
Category
automation,aws,data,databases,design,enterprise,grafana,infrastructure,lead,linux,monitoring,open-source,performance,postgresql,prometheus,red,sed,shell,sql,statistics,ux
Posted
June 04, 2026
Senior PostgreSQL Database Administrator
Duties and Responsibilities
- Lead 24x7 monitoring and proactive management of PostgreSQL production, staging, and development environments.
- Perform advanced performance tuning at query, schema, and system levels — identify slow queries, analyze execution plans, and implement effective optimization strategies.
- Manage PostgreSQL partitioning strategies (range, list, hash) for handling large data volumes and improving query performance.
- Implement and maintain robust backup and disaster recovery strategies including pg_basebackup, pgBackRest, barman, and Point-In-Time Recovery (PITR).
- Architect and administer streaming replication, logical replication, and failover mechanisms for high availability and business continuity.
- Plan and execute ...