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).

Example of an everyday job

• Participate in designing 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.

Optionally

It would be great, if you were familiar with or have a strong desire to understand one or all of the following:

• Kafka.
• Other DBMS.
• ZooKeeper.

We will try to create all the right conditions for you to work and rest comfortably

• Work format Choice: It’s up to you to decide what work format works best for you. You can #wfo, #wfh, or mix both.
• Flexible working day start.
• Annual leave as per the employment legislation of the country of stay (employment).
• Training, courses, conferences.
• English courses.
• Gifts for employees.

Finally, a little more about our company:

Semrush is a leading online visibility management SaaS platform that enables businesses globally to run search engine optimization, pay-per-click, content, social media and competitive research campaigns and get measurable results from online marketing.

We've been developing our product for 13 years and have been awarded G2's Top 100 Software Products, Global and US Search Awards 2021, Great Place to Work Certification, Deloitte Technology Fast 500 and many more. In March 2021 Semrush went public and started trading on the NYSE with the SEMR ticker.

10,000,000+ users in America, Europe, Asia, and Australia have already tried Semrush, and over 1,000 people around the world are working on its development. The Semrush team is constantly growing.

Our new colleague, we are waiting for you!