Solution Engineer (ClickHouse Team)

About the team

• At Semrush, we have many in-house uses for ClickHouse, some of which involve storing and processing petabytes of data, others relatively small.
• And so we faced lots of interesting issues that we needed to investigate. And by issues, we mean not only bugs but also approaches to storing data, some architecture design problems, scalability problems, performance bottlenecks, and so on.
• So we are happy to announce that we have decided to extend our in-house expertise in ClickHouse and open a new role.

In this position, you will be faced with:

• Scalability issues.
• Performance issues.
• Architecture analysis.
• Increasing expertise of other teams.
• Creating internal CI.
• Creating reproducible test cases for problems (docker if required).

Responsibility

• Participate in designing the architecture (either new or extending existing) and give suggestions about: indexes and other major bits, sharding and other scalability bits, required hardware (SSD / HDD / RAM / CPU/ Network IO).
• Find bottlenecks in existing architecture.
• Execute performance tests of existing services and give suggestions (if any).
• Write tests for problems (Python / SQL / Bash).
• Studying new features / patterns.

Expected skills

• Expert knowledge in SQL DBMS (OLAP / OLTP), 2-3+ years, preferably ClickHouse.
• Understanding today's hardware.
• Experience in building distributed systems.
• Local and distributed troubleshooting experience.
• Good Unix knowledge.
• A programming language, preferably Python.

Will be a plus:

• Kafka.
• Other DBMS.
• ZooKeeper.

What we offer

• It’s up to you what work format works best for you. You can work from the office, from home, or have a mix of both. Freedom is trending now, and so are we.
• Flexible working day start that would suit a night owl and an early bird alike. You can start between 9:00 am and 12:00 pm.
• Health insurance with dental coverage. Life insurance.
• Agile approach to work (we’ll gladly teach you).
• Online English classes.
• Various training/online courses/conferences/books to improve your hard and soft skills.
• Financial compensation for sports and hobbies (gym/dancing/climbing/horseback riding/painting/wakeboard — you name it. The choice is yours.).
• Corporate psychologist consultations. The mental health of our employees is as important to us as their physical well-being.
• Awesome parties, team building, and corporate events in different formats — both online and offline, depending on the current global situation. We can have fun in any case!

Semrush as an employer provides equal opportunities for all candidates. We do not restrict labor rights and freedoms based on gender, race, skin color, nationality, language, origin, property, family, social and work status, age, place of residence, attitude to religion, beliefs, affiliation, or non-affiliation with public associations or any social groups, as well as on other circumstances not related to the professional qualities of the candidate. All hiring decisions are made based on business needs, job requirements, merit, and individual qualification.