Ilya Yatsishin is a Senior Technical Project Manager based in Amsterdam with six years of experience orchestrating complex data and infrastructure projects at ClickHouse and previously at Yandex. He blends hands-on backend and DevOps engineering—demonstrated by contributions to high-profile open-source projects like ClickBench, ByConity and sqlancer—with program management skills that drive reliable, high-performance analytical systems. Ilya has deep domain expertise in database benchmarking, query processing, and automated testing for ClickHouse and other analytical engines, plus a background designing HFT-ready trading platforms and resilient database infrastructures. He is comfortable moving between low-level optimization (C++/CUDA trading systems) and strategic planning for scalable production systems, often improving stability and failover behavior. With an MSc in Financial Economics, he uniquely combines quantitative rigor and systems engineering to turn complex requirements into practical, auditable solutions.
6 years of coding experience
7 years of employment as a software developer
MSc, Financial Economics, MSc, Financial Economics at Высшая Школа Экономики / Higher School of Economics
Contributions summary:Ilya primarily contributed to the backend logic, including modifications to the ActionsDAG and other core components, suggesting a focus on query processing and optimization within the ClickHouse environment. They made changes to the code related to the cache dictionary storage and other supporting files of the code. The commits also involved fixes and adjustments within the test integration.
Automated testing to find logic and performance bugs in database systems
Role in this project:
Back-end Developer / Database Engineer
Contributions:7 reviews, 28 commits, 40 PRs in 2 years 7 months
Contributions summary:Ilya's contributions primarily involve working on the ClickHouse database testing framework, as indicated by the code changes in the `sqlancer/sqlancer` repository, which aims to find bugs in database systems. The user implemented and debugged features related to the testing of ClickHouse, specifically focusing on implementing oracles (TLPGroupByOracle, TLPWhereOracle, TLPAggregateOracle) which are used to verify the correctness of query results. Their work includes creating and testing functionalities like aggregations, distinct clauses, and group by clauses, while also addressing errors and integrating enhancements for the testing framework.
dbms-testingdbmsmysqltidbtesting
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.
Request Free Trial
Ilya Yatsishin - Senior Technical Project Manager at ClickHouse