ClickHouse Database Administrator

VMC Soft Technologies, Inc; Chennai District; On-site; INR 2,800,000 - 5,500,000; Full time

Job summary

VMC Soft Technologies, Inc. is seeking an experienced ClickHouse Database Administrator (DBA) to manage large-scale ClickHouse environments. The role focuses on performance, replication, backup, monitoring, and production support.

The ideal candidate will have strong hands-on expertise in database administration, high availability, and collaboration with DevOps and Cloud teams. This is a full-time opportunity based in Chennai, India.

Qualifications

• 8+ years of database administration experience.
• Strong ClickHouse DBA and production support experience.
• Experience with high availability, replication, and disaster recovery.

Responsibilities

• Install, configure, and maintain ClickHouse environments.
• Manage provisioning, upgrades, migrations, and version control.
• Monitor health, performance, capacity, and storage utilization.

Skills

ClickHouse DBA

Production support

Linux/Unix

Shell scripting

Cloud platforms

Monitoring tools

Replication/HA

Education

Bachelor's degree in CS/IT

Tools

Prometheus

Grafana

Docker

Kubernetes

Job description

ClickHouse Database Administrator (DBA) Job Summary

We are looking for an experienced ClickHouse Database Administrator (DBA) with 8 10 years of overall database administration experience to manage, maintain, optimize, and support large-scale ClickHouse database environments. The ideal candidate should have strong hands‑on expertise in database administration, performance tuning, high availability, replication, backup and recovery, monitoring, troubleshooting, and production support.

Key Responsibilities

• Install, configure, administer, and maintain ClickHouse database environments.
• Manage database provisioning, upgrades, patching, migrations, and version management.
• Monitor database health, availability, performance, capacity, and storage utilization.
• Perform performance tuning, query optimization, indexing, and resource optimization.
• Configure and manage ClickHouse replication, clustering, distributed tables, and high‑availability environments.
• Implement and manage backup, restore, disaster recovery, and business continuity solutions.
• Troubleshoot database incidents, outages, performance bottlenecks, and production issues.
• Monitor and optimize storage, CPU, memory, and overall database resource utilization.
• Implement database security, user management, access control, and compliance requirements.
• Support production, non‑production, and disaster recovery environments.
• Collaborate with Application, Infrastructure, Cloud, and DevOps teams to resolve database‑related issues.
• Develop and maintain operational documentation, SOPs, runbooks, and troubleshooting guides.
• Participate in incident management, root cause analysis, and on‑call production support.

Essential Skills

• Strong hands‑on experience in ClickHouse Database Administration.
• Expertise in ClickHouse installation, configuration, clustering, replication, and high availability.
• Strong knowledge of database performance tuning and query optimization.
• Experience with backup, restore, disaster recovery, and database migration.
• Knowledge of database monitoring, troubleshooting, and capacity planning.
• Experience managing large‑scale or high‑volume database environments.
• Strong understanding of database security and user access management.
• Good knowledge of Linux/Unix environments and shell scripting.
• Experience working with DevOps, Infrastructure, Cloud, and Application teams.
• Ability to handle production incidents and participate in on‑call support.

Preferred Skills

• Experience with distributed databases and large‑scale data platforms.
• Knowledge of monitoring tools such as Prometheus, Grafana, or similar platforms.
• Experience with cloud environments such as AWS, Azure, or GCP.
• Knowledge of automation and scripting using Bash, Python, or similar technologies.
• Experience with Docker and Kubernetes is an added advantage.

Required Experience

• 8 10 years of overall experience in Database Administration.
• Strong hands‑on experience specifically with ClickHouse DBA and production support.
• Experience managing mission‑critical, high‑volume, and highly available database environments.