ClickHouse Database Administrator (DBA)

VMC Soft Technologies, Inc; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

VMC Soft Technologies, Inc is seeking a ClickHouse Database Administrator to manage large-scale ClickHouse environments in production, non-production and DR setups. You will install, configure, monitor, and optimize databases, ensuring high availability and robust data protection.

You will work with application, infrastructure and DevOps teams, handling incident management, on-call rotations, and crafting runbooks and SOPs to sustain reliable operations in Chennai.

Qualifications

• Need extensive ClickHouse DBA experience in production environments.
• Hands-on installation, configuration and administration of ClickHouse.
• Experience with cluster, replication, sharding and HA.
• Ability to perform performance tuning and query optimization.
• Experience with backup, restore and disaster recovery.

Responsibilities

• Install, configure, administer, upgrade, patch, and migrate ClickHouse databases.
• Manage ClickHouse clusters, replication, sharding, and high availability.
• Perform database performance tuning and query optimization.
• Monitor database health, availability, capacity, storage, and resources.
• Implement backup, restore, and disaster recovery solutions.
• Troubleshoot performance issues, incidents, outages, and bottlenecks.
• Manage security, users, roles, access control, and compliance.
• Collaborate with App, Infra, and DevOps teams; participate in on-call.
• Create SOPs, runbooks, and operational documentation.

Skills

ClickHouse DBA

8-10 years experience

Cluster / Replication / Sharding

Performance tuning

Backup & DR

Monitoring & troubleshooting

Production support

On-call / incident mgmt

Tools

Linux

SQL

ClickHouse Keeper / ZooKeeper

Grafana / Prometheus

Cloud / Kubernetes

Job description

ClickHouse DBA

Location

Chennai

Experience

8 10 Years

Role

ClickHouse Database Administrator (DBA)

• contract role

Job Summary

We are looking for an experienced ClickHouse Database Administrator to manage, optimize, monitor, and support large-scale ClickHouse database environments across production, non-production, and DR platforms.

Key Responsibilities

• Install, configure, administer, upgrade, patch, and migrate ClickHouse databases.
• Manage ClickHouse clusters, replication, sharding, and high availability.
• Perform database performance tuning and query optimization.
• Monitor database health, availability, capacity, storage, and resource utilization.
• Implement and manage backup, restore, and disaster recovery solutions.
• Troubleshoot database performance issues, incidents, outages, and bottlenecks.
• Manage database security, users, roles, access control, and compliance.
• Support production, DR, and non-production environments.
• Collaborate with Application, Infrastructure, and DevOps teams.
• Create and maintain SOPs, operational documentation, and runbooks.
• Participate in production support, on-call, and incident management.

Non-Negotiable Skills

• ClickHouse Database Administration Mandatory
• 8 10 years overall DBA / Database Administration experience
• Hands-on ClickHouse installation, configuration and administration
• ClickHouse Cluster / Replication / Sharding / HA
• Performance tuning & query optimization
• Backup & Restore / Disaster Recovery
• Database monitoring, troubleshooting and capacity management
• Production database support experience

Strongly Preferred

• Linux administration
• SQL
• ClickHouse Keeper / ZooKeeper
• Distributed tables and ReplicatedMergeTree
• Database migration/upgrades
• Grafana / Prometheus or similar monitoring
• Cloud / Kubernetes exposure