Database Engineer (ClickHouse)

<p>Qube Research &amp; Technologies (QRT) is a global quantitative and systematic investment manager, operating in all liquid asset classes across the world. We are a technology- and data-driven group implementing a scientific approach to investing. Combining data, research, technology, and trading expertise has shaped our collaborative mindset, which enables us to solve the most complex challenges. QRT’s culture of innovation continuously drives our ambition to deliver high-quality returns for our investors.</p>

<p>You will join the Infrastructure Database team responsible for managing and optimising large-scale database systems supporting research and trading activities. The team works closely with Quantitative Researchers, Developers, and Data Engineers to ensure reliability, scalability, and performance of critical data infrastructure.</p>

<p><strong>Your Future Role within QRT</strong><br>You will:</p>

<ul>

<li>Administer and maintain ClickHouse clusters in distributed environments</li>

<li>Configure and manage replication, sharding, and distributed table architectures</li>

<li>Operate and maintain ClickHouse Keeper or ZooKeeper</li>

<li>Manage data lifecycle processes including partitioning, TTL, and merge operations</li>

<li>Monitor database performance and troubleshoot issues in high-throughput environments</li>

<li>Optimise query performance through indexing strategies, partitioning, and projections</li>

<li>Manage system resources including CPU, memory, and disk I/O for database workloads</li>

<li>Design and implement high availability and disaster recovery solutions</li>

<li>Support database environments across production and non-production setups</li>

<li>Implement and maintain access control, roles, and security policies</li>

<li>Work with data ingestion pipelines including streaming and batch frameworks</li>

<li>Contribute to database reliability, observability, and scalability improvements</li>

</ul>

<p><strong>Your Present Skillset</strong></p>

<ul>

<li>5+ years of experience in database administration in production environments</li>

<li>Strong experience with ClickHouse in distributed or clustered setups</li>

<li>Solid understanding of replication, sharding, and distributed database architectures</li>

<li>Experience with ClickHouse Keeper or ZooKeeper</li>

<li>Strong knowledge of performance tuning, monitoring, and troubleshooting</li>

<li>Experience supporting high-ingestion and large-scale analytical workloads</li>

<li>Proficiency in SQL and database design principles</li>

<li>Experience with UNIX/Linux systems and system-level performance tuning</li>

<li>Knowledge of high availability and disaster recovery strategies</li>

<li>Familiarity with data ingestion frameworks such as Kafka or streaming pipelines</li>

<li>Experience with PostgreSQL or SQL Server</li>

<li>Strong attention to detail with a focus on testing and documentation</li>

<li>Ability to work effectively in a collaborative environment</li>

</ul>

<p>QRT is an equal opportunity employer. We welcome diversity as essential to our success. QRT empowers employees to work openly and respectfully to achieve collective success. In addition to professional achievement, we are offering initiatives and programs to enable employees achieve a healthy work-life balance.</p>

<p>&nbsp;</p>