About the Role

We are looking for an experienced Database Administrator / Database Engineer to own and

manage our data infrastructure across PostgreSQL, MySQL, ClickHouse, and Elasticsearch. The

ideal candidate has hands-on experience managing reader/writer (primary-replica) architectures

under high data loads, ensuring high availability, performance, and reliability of mission-critical

databases.

Key Responsibilities

• Database Administration: Install, configure, administer, monitor, and upgrade production

databases across PostgreSQL, MySQL, ClickHouse, and Elasticsearch.

• Query Development & Optimization: Write complex PostgreSQL/MySQL queries and

optimize existing ones for performance at scale.

• Database Design: Design and optimize PostgreSQL/MySQL schemas for scalability and

maintainability.

• Indexing & Query Analysis: Define indexing strategies and analyze execution plans

(EXPLAIN/ANALYZE) to resolve slow queries.

• Performance Tuning: Tune query performance, buffer/cache settings, and connection

pooling (PgBouncer/ProxySQL) for high-QPS workloads.





• Partitioning & Archiving: Implement table partitioning and data archiving strategies for

large, rapid-growing datasets.

• ETL & Data Migration: Plan and execute ETL and data migration for PostgreSQL/MySQL,

including source-to-target database/table schema mapping.

• Replication & High Availability: Design, configure, and manage reader/writer (primary-

replica) replication; monitor replication lag and troubleshoot failures; ensure HA and

failover using Patroni, Orchestrator, or managed cloud equivalents (AWS RDS/Aurora,

Azure Database for PostgreSQL/MySQL).

• Backup & Disaster Recovery: Implement and test PostgreSQL/MySQL backup and restore

(pg_dump, pgBackRest, Percona XtraBackup, snapshots), point-in-time recovery, and

cross-region DR strategies.

• ClickHouse & Elasticsearch: Manage ClickHouse clusters (MergeTree family, sharding,

replication, materialized views) and Elasticsearch clu

📌 Teleforce- DBA (Gurugram)
🏢 NextHire
📍 Gurugram