Clickhouse Support Engineer
About the Job
BusinessNext is looking for database geeks able to guide customers around the globe in building applications running over ClickHouse. We serve several customers in the BFSI domain using Clickhouse for applications like Data Warehousing Analytics & AI.
Role and responsibilities will be divided as follows:
Support (70% of time)
- 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 multiples of nodes running on On-Premises Private Cloud AWS GCP Azure etc.
- Actively monitoring the community to keep the build upgraded to latest stable version and do security vulnerability patching from time to time
- Performance and load testing of the clusters
Research and Development (30% of time)
- Studying new usage patterns ClickHouse functions & integration with other products.
- Writing tech Whitepapers for BusinessNext blog and internal KB.
- Working on infrastructure projects related to ClickHouse
- Improving ClickHouse itself fixing bugs improving docs creating test-cases etc
Candidates need to meet the following qualifications:
- Experience with ClickHouse is a MUST
- Expert SQL knowledge for one of: MySQL PostgreSQL Oracle SQL Server.
- Strong Linux shell skills / bash scripting skills
- Experience with running production-grade systems
- Docker self-defense skills
- Basic knowledge of distributed system concepts and big data technology stacks
- Bachelors degree or above
The following additional qualifications are a significant plus:
- Kubernetes knowledge and operating experience
- Experience with big data stack components like Spark Kafka
- Any Vector database experience like Milvus pgVector etc.
- Experience with data modelling/data analysis
- Knowledge of SRE / DevOP stacks monitoring/system management tools (Prometheus Ansible EFK )
- Version control using git
- Knowledge of at least one programming language (Python C Java Go)