Clickhouse C++ Developer

5 days ago

Singapore Ahrefs Full time

Ahrefs is looking for a C++ Software developer with the deep understanding of database systems.

Clickhouse DBMS is the backbone of our infrastructure, holding multiple petabytes crawler dataset updated in realtime and building advanced and flexible analytics reports for our customers. Ahrefs team is overcoming multiple challenges to adapt the opensource Clickhouse DBMS to operate with distributed clusters of massive scale on bleeding-edge hardware. And now we are looking for an experienced C++ developer to help contributing to the Clickhouse opensource project while solving those challenges.

**What you will be working on**:

- Collaborate with the software engineers teams in charge of data gathering and business logic to identify performance optimization opportunities for low latency massively parallel data processing, and work with other opensource contributors to improve Clickhouse performance and scalability. Implement optimizations specific to Ahrefs hardware and dataset to ensure data ingestion and queries perform efficiently on our infrastructure
- Improve the robustness and fault tolerance of the data infrastructure by improving edge cases and error handling inside the database code as reported by the devops team, and adapt features of the database to simplify operations
- Implement new features in the SQL interface and Clickhouse api to help business team develop new reports
- Work with opensource Clickhouse community to upstream changes and improve the Clickhouse database as a whole
- Help maintain Ahrefs specific fork of Clickhouse for features that cannot be upstreamed

**Basic requirements**:

- Strong experience in C++ (including C++20)
- Understanding of Unix/Linux systems inner working
- Strong production debugging skills
- Willingness to work on opensource and cooperate with the Clickhouse developers to upstream as many changes as possible
- Experience in database and/or Clickhouse codebase is a plus
- Independently deal with bugs, schedule tasks and investigate code
- Make well-reasoned technical choices and take responsibility for them
- Understand the whole technology stack at all levels: from network and user-space code to OS internals and hardware
- Handle full development cycle of a single component i.e. formalize task, write code and tests, setup and support production (basic DevOps), assure data correctness and quality
- Approach problems with a practical mindset and suppress perfectionism when time is a priority
- Write flexible, maintainable code and adapt to post-launch requirements/tweaks

These requirements stem naturally from our approach to development with fast feedback cycle, highly-focused personal areas of responsibility and strong tendency to vertical component splitting.

**What You Get**:

- Competitive compensation package
- Informal and thriving work atmosphere
- Above-average perks and fringe benefits
- [Office] First-class workplace (hardware, software, etc) in the modern office
- [Remote] Hardware allowance

  • Senior Cloud Performance Engineer

    1 week ago

    Singapore ClickHouse Full time

    Join to apply for the Senior Cloud Performance Engineer role at ClickHouse About ClickHouse Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries,...

  • Senior Cloud Performance Engineer

    7 days ago

    Singapore ClickHouse Full time

    Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes. Enterprises globally, including Lyft,...

  • Senior Cloud Performance EngineerNew

    7 days ago

    Singapore Clickhouse Full time

    *About ClickHouse * Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes. Enterprises globally,...

  • Senior Cloud Performance Engineer

    7 days ago

    Singapore clickhouse Full time

    About ClickHouse Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes. Enterprises globally,...

  • Senior Cloud Performance Engineer

    2 weeks ago

    Singapore ClickHouse Full time

    Join to apply for the Senior Cloud Performance Engineer role at ClickHouse About ClickHouse Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries,...

  • Senior Cloud Performance Engineer

    3 weeks ago

    Singapore ClickHouse Full time

    Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes. Enterprises globally, including Lyft,...

  • Senior Cloud Performance Engineer

    4 weeks ago

    Singapore ClickHouse Full time

    Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company empowers users to generate real-time analytical reports through SQL queries, emphasizing speed in managing escalating data volumes. Enterprises globally, including Lyft,...

  • Product Security Engineer

    1 week ago

    Singapore ClickHouse Full time

    Overview Product Security Engineer –ClickHouse . About ClickHouse Established in 2009, ClickHouse leads the industry with its open-source column-oriented database system, driven by the vision of becoming the fastest OLAP database globally. The company enables real-time analytical reports through SQL queries, emphasizing speed in managing escalating data...

  • Software Engineer

    1 week ago

    Singapore CLICKHOUSE PTE. LTD. Full time

    With over 40,000 stars on GitHub, ClickHouse is the fastest and most resource efficient open-source data warehouse in the world. Our Core Engineering teams own the heart of our ClickHouse Open Source project. We are looking for exceptional C++ engineers to join our remote-first, global team and continue to scale and grow both our open source and ClickHouse...

  • Senior Cloud Performance Engineer

    1 week ago

    Singapore CLICKHOUSE PTE. LTD. Full time

    **What will you do?** - Benchmark system performance, database performance analysis, capacity sizing and optimization. - Recommend configuration tuning/optimizations for performance bottlenecks - Work closely with ClickHouse core development team, cloud team, security team and partner with them to improve the performance of ClickHouse Cloud. - Plan, enable,...