Kirill Shirokov is a Python developer with a background in engineering and eight years of professional experience, currently based in California. He builds high-performance backends using Django, FastAPI, PostgreSQL and Docker, and has delivered production services for product matching, analytics and employee development tracking. Kirill also contributed to the well-known Apache Ignite project, optimizing SQL COUNT(*) and PK index lookups to improve query performance—demonstrating practical database internals experience beyond typical web development. His training at Yandex Practicum and formal engineering education in aerospace inform a disciplined, systems-oriented approach to design and debugging. As a freelancer and student-developer he pairs hands-on coding and deployment skills with a knack for performance tuning and pragmatic architecture choices.
8 years of coding experience
инженер, Самолето- и вертолетостроение, 4,5, инженер, Самолето- и вертолетостроение, 4,5 at Таганрогский Государственный Радиотехнический Университет
Python developer, Python developer at Yandex Practicum
Contributions summary:Kirill primarily contributed to the Apache Ignite project by optimizing database operations and enhancing query performance. Their work included improving the `COUNT(*)` functionality within SQL queries by leveraging the `BPlusTree.size` method, reducing the need for cursor iterations. Additionally, they optimized PK index lookups using `findOne` instead of `find` to improve efficiency. Furthermore, the user fixed an assertion error in the BPlusTree printing code and addressed index naming issues related to the Optimized Marshaller.
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.