ClickHouse Database Administrator

International product IT company seeks ClickHouse Database Administrator to design data storage architecture, maintain ClickHouse clusters, optimize SQL queries, and handle replication/sharding.

Designing data storage architecture Maintaining existing ClickHouse clusters Reviewing and optimizing SQL queries and data schemas with developers Configuring and optimizing ClickHouse instances Setting up and optimizing replication and sharding, configuring Zookeeper Investigating and resolving complex incidents, including degradation and data loss

Experience with Linux Deep knowledge of ClickHouse architecture and principles (engines, indexes, replication, sharding, best practices) Confident with Bash and SQL Experience with monitoring systems Nice to have: Basic Python programming skills for routine tasks Experience with configuration management tools such as Ansible, Puppet, or SaltStack Advanced knowledge and experience with relational DBMS: MySQL and/or PostgreSQL

Official employment Medical insurance Work visa English compensation More details in DM