Senior ClickHouse Solution Engineer

This is a fully remote position, open to applicants in Cyprus.

📋 Description

• Oversee cross-team projects focused on ClickHouse architecture, scalability, and reliability.

• Assist other product teams in designing and advancing ClickHouse-based systems.

• Identify bottlenecks and implement enhancements in performance, cost efficiency, and maintainability.

• Establish and advocate for best practices and standards for utilizing ClickHouse at Semrush.

• Collaborate with engineering leaders and teams to ensure technical decisions align with product and business objectives.

• Remain actively involved by contributing to internal systems, key company initiatives, and resolving complex challenges.

• Foster the growth of other teams through knowledge sharing and collaborative efforts.

⛳️ Requirements

• In-depth knowledge of SQL DBMS (OLAP/OLTP), including database internals, performance tuning, storage design, and troubleshooting systems at scale, with over 5 years of production experience, preferably with ClickHouse.

• Strong understanding of distributed systems, performance metrics, and troubleshooting techniques.

• Expertise in designing and maintaining resilient, data-intensive systems.

• Familiarity with modern hardware and its capabilities.

• Comprehensive knowledge of UNIX environments.

• Proficient in at least one programming language, such as Rust or C/C++.

• Capability to collaborate across teams, drive consensus on intricate technical decisions, and articulate technical trade-offs effectively.

• Not mandatory, but advantageous:

• Experience with other DBMS.

• Proficiency in additional programming languages (such as Python / Go).

• Understanding of Kubernetes and its ecosystem.

• Cloud computing experience, ideally with Google Cloud Platform (GCP).

🏝️ Benefits

• Unlimited PTO.

• Hobby and team-building budget allowance.

• Employee Support Program.

• Financial assistance for loss of a family member.

• Employee Resource Groups.