ClickHouse Solutions Engineer

Job Description

Job Description

ClickHouse is the hottest analytic database on the planet and Altinity is the home of ClickHouse experts who build real-time data solutions that run anywhere. ClickHouse now has more contributors than ElasticSearch, previously the biggest Open Source analytic project on GitHub. 

Altinity is looking for elite database support engineers who can guide users around the globe in building ClickHouse applications. Have you delivered analytic applications in production environments? Have you operated ClickHouse clusters at a petabyte scale? Are you intensely curious about database technology and tricks to use ClickHouse effectively? Let’s talk about how you can share your knowledge with our rapidly expanding customer base as well as the broader ClickHouse open-source community.

Your responsibilities will be divided as follows:

• Support (75% of the 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 100s of nodes, including Altinity.Cloud, our managed ClickHouse service
  - Working with the community - GitHub, Stack Overflow, Telegram
• Research and development (25% of the time)
  - Studying new usage patterns, ClickHouse functions, & integration with other products
  - Writing tech articles - for Altinity 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
• Technical English writing and speaking skills
• Docker/Kubernetes self-defense skills
• Basic knowledge of distributed system concepts and big data technology stacks
• Knowledge of at least one programming language (Python, C++, Java, Go)
• University degree (IT/math) or equivalent experience

The following additional qualifications are a significant plus:

• Kubernetes knowledge and operating experience
• 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

A day in your life as a ClickHouse Solutions Engineer may include any or all of the following:

• Handling support calls from customers using ClickHouse. This includes diagnosing problems connecting to ClickHouse, designing applications, deploying/upgrading ClickHouse, and operations
• Support engineers need to be ace puzzle-solvers who can figure out what problem the user is encountering, diagnose root cause(s), and propose solutions
• Researching new technology, working on ClickHouse-related side projects, and fixing Clickhouse itself

Our Benefits:

• Work from Anywhere, Anytime: We are not your typical nine-to-five shop! Enjoy the flexibility of working from literally wherever and whenever. Create a schedule that works for you and your family or lifestyle. Recharge your batteries with our open vacation policies.
• Cultural Diversity: We love that we get to work with passionate people from around the world. Currently, our team is made of professionals from 25 different countries!
• Career Development: We provide opportunities to learn new technologies as well as try out new roles. We also offer access to training on leading-edge technologies, plus flexible work schedules for external education.
• USA Employees Benefits: We offer comprehensive PPO health care plans for our US-based employees that are incredibly flexible to meet the needs of individuals or families. 401K with company match also available.
• Company Travel: We come together in person two to three times per year in locations across the globe.
  We also fund travel to conferences and encourage presentations as well as contributions to open source communities.

Please make sure you describe your experience with Clickhouse in your resume

This is a full-time position and includes equity in the company.
Altinity is venture-funded and financially stable.
We are 100% remote. You may work anywhere you have work permits.

We are eager to meet you!