ClickHouse Engineer- L2 CONSULTBAE INDIA PRIVATE LIMITED

About CONSULTBAE INDIA PRIVATE LIMITED

Job Description

Education: Any graduate but preferably B.E./B.Tech/MCA in Computer Science

Experience: 4+ Years experience specially in ClickHouse Technology

Mandatory Skills/Knowledge :

• Helping build production-grade systems based on ClickHouse: advise how to design schemas, plan clusters etc. Environments range from single node setups to clusters with 100s of nodes, Cloud, managed ClickHouse service.
• Working on infrastructure projects related to ClickHouse
• Improving ClickHouse itself fixing bugs, improving docs, creating test-cases, etc.
• Studying new usage patterns, ClickHouse functions, & integration with other products. Working with the community GitHub, Stack Overflow, Telegram.
• Installation multiple node cluster , configure, backup and recovery and maintain ClickHouse database.
• Monitor and optimize database performance, ensuring high availability and responsiveness.
• Troubleshoot database issues, identify and resolve performance bottlenecks.
• Design and implement database backup and recovery strategies.
• Develop and implement database security policies and procedures.
• Collaborate with development teams to optimize database schema design and queries.
• Provide technical guidance and support to development and operations teams.
• Experience with big data stack components like Hadoop, Spark, Kafka, Nifi,
• Experience with data science/data analysis
• Knowledge of SRE / DevOP stacks monitoring/system management tools (Prometheus, Ansible, ELK, )
• Version control using git
• Handling support calls from customers using ClickHouse. This includes diagnosing problems connecting to ClickHouse, designing applications, deploying/upgrading ClickHouse, and operations