Вакансия в архиве
Компания больше не ищет сотрудника. Посмотрите похожие предложения
Semrush

Solution Engineer (ClickHouse Team)

в Semrush

3 000 —‍ 5 000 $/мес на руки

📍 Стамбул (Турция)Помощь с переездом
Специализация
DevOps
Уровень
Middle
Команда
1 - 5 человек

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.

Stack

PythonSQLClickHouseUNIX

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!

Ольга Пичугина Reseacher
Semrush

О компании Semrush

Сфера
Продуктовая компания
Инвестиции
$25-50М
Размер
1001+

Semrush — международная IT-компания, создают маркетинговую платформу. С помощью SEMrush можно отслеживать онлайн-стратегии конкурентов, оценивать свои успехи во многих маркетинговых сферах. Клиенты SEMrush-Booking.com, Twitter, Amazon, Hilton, Tripadvisor, Rentokil Initial и другие (более 5 миллионов пользователей).

Похожие вакансии

7 000 – 9 000 €/мес на руки
📍 Лимасол (Кипр), помощь с переездом
6 500 – 7 200 €/мес на руки
📍 Лимассол (Кипр), помощь с переездом
6 000 – 7 000 €/мес на руки
📍 Кипр, Малайзия, помощь с переездом
4 500 – 5 000 €/мес на руки
📍 Лимасол (Кипр), помощь с переездом
4 500 – 5 000 €/мес на руки
📍 Лимасол (Кипр), помощь с переездом