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, quick-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 clusters (ILM, shard allocation,

📌 Teleforce- DBA (Gurugram)
🏢 NextHire
📍 Gurugram