At a Glance
- Tasks: Manage and optimise large-scale ClickHouse database systems for research and trading.
- Company: Leading technology-driven quantitative hedge fund in London.
- Benefits: Market-leading compensation and opportunities for professional growth.
- Other info: Onsite role with a focus on innovation and collaboration.
- Why this job: Join a dynamic team and make an impact in the finance tech space.
- Qualifications: 5+ years as a DBA with ClickHouse expertise and strong SQL skills.
The predicted salary is between 80000 - 100000 € per year.
A leading technology driven, quantitative hedge fund is seeking an experienced Database Engineer with ClickHouse expertise. You would be responsible for managing and optimising large-scale database systems supporting research and trading activities.
Responsibilities:
- Manage and maintain ClickHouse clusters across distributed environments
- Configure replication, sharding, and coordination services (Keeper/ZooKeeper)
- Handle data lifecycle: partitioning, TTL, and merge operations
- Monitor, troubleshoot, and optimise query performance
- Manage server resources: CPU, memory, and disk
- Design high availability and disaster recovery solutions
- Enforce access controls and security policies
- Support streaming and batch data ingestion pipelines
Requirements:
- 5+ years as a DBA in production environments
- Hands-on experience with distributed/clustered ClickHouse
- Confident tuning, monitoring, and troubleshooting at scale, with a solid understanding of HA and disaster recovery
- Strong SQL, Linux/UNIX, familiarity with streaming pipelines like Kafka, and exposure to PostgreSQL or SQL Server
ClickHouse Database Engineer in London employer: Stanford Black
Join a leading technology-driven quantitative hedge fund in London, where innovation meets excellence. As a ClickHouse Database Engineer, you'll thrive in a dynamic work culture that prioritises collaboration and professional growth, offering market-leading compensation and unique opportunities to work with cutting-edge technologies. Experience a supportive environment that values your expertise and encourages continuous learning, making it an ideal place for those seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land ClickHouse Database Engineer in London
✨Tip Number 1
Network like a pro! Reach out to industry professionals on LinkedIn or at tech meetups. We can’t stress enough how valuable personal connections can be in landing that ClickHouse Database Engineer role.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your ClickHouse projects or any relevant database work. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for technical interviews by brushing up on your SQL and ClickHouse knowledge. We recommend doing mock interviews with friends or using online platforms to get comfortable with the types of questions you might face.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace ClickHouse Database Engineer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with ClickHouse and any relevant database management skills. We want to see how your background aligns with the responsibilities listed in the job description.
Craft a Compelling Cover Letter:Use your cover letter to tell us why you're passionate about working with databases and how you can contribute to our team. Be specific about your achievements and experiences that relate to the role.
Showcase Your Technical Skills:Don’t forget to mention your hands-on experience with distributed systems, SQL, and any other relevant technologies. We love seeing candidates who can demonstrate their technical prowess clearly.
Apply Through Our Website:For the best chance of getting noticed, apply directly through our website. It helps us keep track of applications and ensures you’re considered for the role as soon as possible!
How to prepare for a job interview at Stanford Black
✨Know Your ClickHouse Inside Out
Make sure you brush up on your ClickHouse knowledge before the interview. Be ready to discuss your hands-on experience with managing and optimising ClickHouse clusters, as well as any specific challenges you've faced and how you overcame them.
✨Showcase Your Problem-Solving Skills
Prepare to share examples of how you've monitored, troubleshot, and optimised query performance in previous roles. Think of specific scenarios where you had to tune performance or manage server resources effectively.
✨Familiarise Yourself with Distributed Systems
Since you'll be working in distributed environments, it’s crucial to understand replication, sharding, and coordination services like Keeper or ZooKeeper. Be ready to explain how you've configured these in past projects.
✨Demonstrate Your SQL and Linux Expertise
Brush up on your SQL skills and be prepared to discuss your experience with Linux/UNIX systems. If you have experience with streaming pipelines like Kafka or databases like PostgreSQL, make sure to highlight that too!
