Senior ClickHouse Database Engineer - Distributed Systems

United States Digital Space LLC; Greater London; On-site; GBP 90,000 - 120,000; Full time

Job summary

Qube Research & Technologies (QRT) is a global quantitative and systematic investment manager. You will join the Infrastructure Database team to administer ClickHouse clusters, manage replication and sharding, and optimize performance for high-throughput research and trading workloads.

The role requires 5+ years of production database experience, strong ClickHouse skills, and familiarity with data ingestion frameworks like Kafka. London-area applicants are welcome for on-site work.

Qualifications

• 5+ years of database administration experience in production environments.
• Strong experience with ClickHouse in distributed or clustered setups.
• Solid understanding of replication, sharding, and distributed database architectures.
• Experience with ClickHouse Keeper or ZooKeeper.
• Strong knowledge of performance tuning, monitoring, and troubleshooting.
• Experience supporting high-ingestion and large-scale analytical workloads.
• Proficiency in SQL and database design principles.
• Experience with UNIX/Linux systems and system-level performance tuning.
• Knowledge of high availability and disaster recovery strategies.
• Familiarity with data ingestion frameworks such as Kafka or streaming pipelines.
• Experience with PostgreSQL or SQL Server.
• Strong attention to detail with a focus on testing and documentation.
• Ability to work effectively in a collaborative environment.

Responsibilities

• Administer and maintain ClickHouse clusters in distributed environments.
• Configure and manage replication, sharding, and distributed table architectures.
• Operate and maintain ClickHouse Keeper or ZooKeeper.
• Manage data lifecycle processes including partitioning, TTL, and merge operations.
• Monitor database performance and troubleshoot issues in high-throughput environments.
• Optimise query performance through indexing strategies, partitioning, and projections.
• Manage system resources including CPU, memory, and disk I/O for database workloads.
• Design and implement high availability and disaster recovery solutions.
• Support database environments across production and non-production setups.
• Implement and maintain access control, roles, and security policies.
• Work with data ingestion pipelines including streaming and batch frameworks.
• Contribute to database reliability, observability, and scalability improvements.

Skills

ClickHouse experience

5+ years DBA experience

Replication & sharding

ClickHouse Keeper or ZooKeeper

Performance tuning

High-ingestion workloads

SQL & DB design

UNIX/Linux systems

HA & DR strategies

Kafka/streaming pipelines

PostgreSQL/SQL Server

Testing & documentation

Collaborative work

Tools

ClickHouse

Kafka

ZooKeeper

PostgreSQL

SQL Server

Job description

Qube Research & Technologies (QRT) is a global quantitative and systematic investment manager. You will join the Infrastructure Database team to administer ClickHouse clusters, manage replication and sharding, and optimize performance for high-throughput research and trading workloads.

The role requires 5+ years of production database experience, strong ClickHouse skills, and familiarity with data ingestion frameworks like Kafka. London-area applicants are welcome for on-site work.