Click House Database Administrator

• 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,

• 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

Expertia AI Technologies