Hi there!
We are Semrush, a global IT company developing our own product – a platform for digital marketers.
And this is our ClickHouse Solution Engineer role for those who want to turn ideas into reality using code, algorithms, and maybe a bit of magic.
A bit about the team you’d work with
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
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
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!
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