at Michael Page Technology
£50,000 - £60,000 per annum (estimated)
London, EC1R 0WX, Greater London
Onsite | Full Time
This role offers the opportunity to lead the migration of analytical databases to ClickHouse, focusing on designing, optimising, and maintaining robust data infrastructure. You'll play a pivotal role in shaping best practices, ensuring high performance, and supporting cross-functional teams to scale the platform across the business.
Client Details
My client is a prestigious global financial services firm with a strong reputation for innovation in banking and investment solutions. They are committed to sustainability and ethical business practices, providing a wide range of services to clients across various industries, with a focus on cutting-edge technology and data-driven decision-making.
Description
Design and implement high-performance ClickHouse environments
Drive the migration of analytical databases to ClickHouse with minimal disruption
Manage database query optimisation for scalability and performance
Operate production-ready clusters with high availability and fault tolerance
Develop and maintain backup, disaster recovery, and data security strategies
Collaborate with teams to align database solutions with business goals
Monitor performance with Prometheus and Grafana, addressing issues proactively
Implement best practices for data modelling and processing
Guide and mentor junior developers in ClickHouse best practices
Stay up-to-date with ClickHouse advancements and implement innovative solutions
Deliver documentation for system architecture and troubleshooting
Profile
The successful candidate will have:?? Extensive experience with ClickHouse in a production environment?? Proficiency in Linux/Unix and database performance optimisation?? Strong knowledge of query optimisation, data modelling, and ETL?? Experience with DevOps tools (Jenkins, Ansible) and CI/CD pipelines?? Solid understanding of data security, backup, and disaster recovery?? Familiarity with Prometheus, Grafana, and C++ for customisation?? Strong problem-solving, analytical, and communication skills?? Ability to collaborate effectively with cross-functional teams
Job Offer
This role offers a competitive salary of up to £90k DOE, with a 12% non-contributory pension for long-term financial security. Flexible hybrid working (50% onsite) provides a great work-life balance, with the option to work 3 days one week and 2 days the next in the London office.