Teleforce- DBA / Database Engineer

Nexthire; Gurugram District; On-site; INR 1,400,000 - 2,200,000; Full time

Benefits offered by this job

Health insurance

Flexible working hours

Learning & development budget

Job summary

Nexthire is seeking an experienced Database Administrator/Database Engineer to own and manage our data infrastructure across PostgreSQL, MySQL, ClickHouse, and Elasticsearch. The role focuses on high availability, performance, and reliable operation under heavy data loads in a modern cloud/on‑prem environment.

You will design schemas, optimize queries, implement partitioning, and manage reader/writer architectures with monitoring and automation to support enterprise-grade products.

Qualifications

• 4–6 years of hands-on DBA/DBE experience in production environments.
• Strong expertise in PostgreSQL and MySQL installation, configuration, upgrades, and administration.
• Ability to write and optimize complex PostgreSQL/MySQL queries.
• Solid database design and schema optimization skills.
• Proficiency in indexing strategy and execution plan analysis.
• Proven performance tuning for queries, buffers, and connections.
• Experience with partitioning and archiving strategies.
• ETL/data migration experience with schema mapping.
• Experience with reader/writer (primary-replica) architectures at high throughput.
• Experience with ClickHouse and Elasticsearch cluster management.

Responsibilities

• Database Administration: Install, configure, monitor, and upgrade production databases across PostgreSQL, MySQL, ClickHouse, and Elasticsearch.
• Query Development & Optimization: Write complex PostgreSQL/MySQL queries and optimize 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 to resolve slow queries.
• Performance Tuning: Tune query performance, buffers, and connection pooling for high-QPS workloads.
• Partitioning & Archiving: Implement table partitioning and data archiving for large datasets.
• ETL & Data Migration: Plan and execute ETL/data migration with schema mapping.
• Replication & High Availability: Manage primary-replica replication; monitor lag; ensure HA and failover.
• Backup & Disaster Recovery: Implement and test backup/restore strategies and point-in-time recovery.
• ClickHouse & Elasticsearch: Manage clusters, ingestion, and tuning for performance under load.
• Monitoring & Capacity Planning: Monitor health with Prometheus/Grafana; plan capacity and storage.
• Connection Management: Manage pooling/ proxies (PgBouncer, ProxySQL, HAProxy).
• Cloud Administration: Administer PostgreSQL/MySQL on AWS/Azure with read replicas and monitoring.
• Security & Troubleshooting: Enforce security, diagnose production issues, on-call readiness.
• Data Handling: Efficiently manage hundreds of GBs to TBs of data; scripting for automation.

Skills

High availability design

Performance tuning

Troubleshooting

Shell scripting

Python scripting

Tools

PostgreSQL

MySQL

ClickHouse

Elasticsearch

PgBouncer

ProxySQL

HAProxy

Prometheus

Grafana

pgBackRest

Percona XtraBackup

AWS RDS/Aurora

Azure Database

Job description

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, fast‑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, mapping design, cluster health under heavy load).
• Monitoring & Capacity Planning: Monitor database health and replication using Prometheus, Grafana, pg_stat_statements, and Percona tools; handle capacity planning, storage forecasting, and scaling.
• Connection Management: Manage PostgreSQL/MySQL connection pooling and proxy layers (PgBouncer, ProxySQL, HAProxy).
• Cloud Administration: Administer PostgreSQL/MySQL on AWS (RDS/Aurora) and Azure (Database for PostgreSQL/MySQL Flexible Server) — provisioning, read replicas, HA, scaling, backups, and monitoring.
• Security: Enforce database security — access control, encryption, and audit logging.
• Troubleshooting: Diagnose and resolve production database issues quickly, including during on‑call rotations.
• Large‑Scale Data Handling: Efficiently manage and query large datasets (hundreds of GBs to TBs).
• Scripting & Automation: Use Python and/or Shell scripting to automate administration, monitoring, and operational tasks.
• Collaboration: Support schema migrations and collaborate with development teams on data modeling.

Required Skills & Experience

• 4–6 years of hands‑on experience as a DBA/Database Engineer in production environments.
• Strong expertise in PostgreSQL and MySQL installation, configuration, upgrades, and administration.
• Ability to write and optimize complex PostgreSQL/MySQL queries.
• Strong database design and schema optimization skills.
• Proficiency in indexing strategy and execution plan analysis.
• Proven performance tuning experience (query, buffer/cache, connection‑level).
• Hands‑on experience with partitioning and archiving strategies.
• Experience with ETL and data migration, including schema mapping between source and target systems.
• Proven experience managing reader/writer split (primary‑replica) architectures with high throughput.
• Working experience with ClickHouse (cluster setup, ingestion at scale, query optimization) and Elasticsearch (cluster management, indexing pipelines, search tuning).
• Hands‑on PostgreSQL/MySQL backup & restore experience (pg_dump, pgBackRest, Percona XtraBackup, snapshots).
• Hands‑on administration of PostgreSQL/MySQL on AWS and/or Azure managed database services.
• Experience monitoring database health and replication using Prometheus, Grafana, ELK/EFK.
• Strong understanding of connection management and pooling (PgBouncer, ProxySQL, HAProxy).
• Demonstrated production troubleshooting ability.
• Experience handling large datasets efficiently (hundreds of GBs to TBs, high‑QPS workloads).
• Proficiency in Linux administration and shell scripting; Python scripting required.

Good to Have

• Experience with GCP Cloud SQL or self‑managed databases on EC2/GCE/Azure VMs.
• Exposure to Kafka or other streaming pipelines feeding ClickHouse/Elasticsearch.
• Knowledge of Redis or other caching layers.
• Experience with Infrastructure as Code (Terraform, Ansible) and containerized databases (Docker, Kubernetes operators).
• Understanding of data warehousing and OLAP vs OLTP workload separation.

What We Offer

• Opportunity to work on large‑scale, high‑load data systems powering enterprise‑grade products.
• Health insurance, flexible working hours, and a dedicated learning & development budget.