Summary
At Santiment, we’re looking for a Clickhouse DBA to manage and optimize our Clickhouse clusters. Your main focus will be maintaining, improving, and scaling our setup, including migrating to Clickhouse Cloud and integrating with data lakes. This role is about long-term impact - no rushing features, just making sure everything runs smoothly and efficiently.
Job Description / Tasks
- Perform regular updates of our Clickhouse clusters
- Develop and maintain monitoring and alerting infrastructure for the clusters
- Participate in migration of self-hosted Clickhouse to Clickhouse Cloud
- Collaborate on the design and maintenance of data lake solutions, ensuring efficient data ingestion and retrieval
- Implement best practices for managing data across self-managed, cloud, and data lake infrastructure
- Manage user access rights
- Understand and track usage patterns of our cluster
- Assist developers by developing and maintaining tools for table management automation
- Look for inefficient queries and work with developers to optimise them
- Help developers optimise inefficient table schemas
- Take charge in deciding on cluster and table topology to meet product demand
Key Qualifications
- At least 5 years of previous software engineering experience. This requirement can be reduced if you have a strong academic record
- At least 1 year experience with Clickhouse
- Solid knowledge of SQL
- You need to be able to communicate fluently in English
Preferred Qualifications