About Position:

We are looking for an experienced Lead ClickHouse Database Administrator to own and operate our ClickHouse analytics database platform that powers large-scale, real-time network analytics solutions. This role is responsible for ensuring the availability, scalability, performance, and security of distributed ClickHouse environments deployed across Kubernetes-based infrastructure. he ideal candidate will have deep expertise in ClickHouse administration, Kubernetes operations, Kafka integrations, database observability, backup and recovery, infrastructure automation, and large-scale analytics platform management. You will work closely with Engineering, Product Management, DevOps, and Support teams to deliver highly reliable, geo-redundant analytics platforms that support mission-critical business operations.

• Role: Lead ClickHouse Database Administrator
• Location: All Persistent Locations
• Experience: 10 to 15 Years
• Job Type: Full time Employment

What You'll Do:

• Own and execute ClickHouse version upgrades, including compatibility validation,



rolling deployments, rollback planning, and post-upgrade verification.
• Administer and optimize ClickHouse cluster topology, shard and replica configurations, distributed DDL operations, and node management.
• Lead migration initiatives from ZooKeeper to ClickHouse Keeper, including planning, execution, validation, and risk mitigation.
• Manage ClickHouse maintenance activities such as merges, mutations, storage optimization, partition management, and TTL administration.
• Design, implement, and validate backup and disaster recovery strategies using ClickHouse backup tools and S3-compatible storage solutions.
• Administer database security controls including RBAC, authentication, TLS configuration, certificate management, user provisioning, and audit logging.
• Modernize aggregation architectures and optimize analytical workloads using advanced ClickHouse engine capabilities.
• Manage WAN replication bet

📌 Lead ClickHouse Database Administrator (Pune)
🏢 Persistent Systems
📍 Pune