Firebird
SQL Developer
1 нед. назад
Страна неизвестнаSeniorRemote
mariadbmysqlsqlstored proceduresperformance optimizationindexingflywaybash
Firebird is an international online travel company developing a high-load train scheduling system with real-time railway data.
About the company
- Firebird is an international online travel company that organizes trips to Europe for customers from around the world.
About the product
- Service for booking rail tickets https://rail.ninja (https://rail.ninja/)
- Online trip builder https://triptile.com (https://triptile.com/)
- Service for booking hotels https://hotel.ninja (https://hotel.ninja/)
- We are developing a high-load train scheduling system that processes large volumes of real-time railway route data. The system is built on MariaDB and includes complex logic for caching, task queue processing, and query optimization.
Requirements
- 5+ years of experience with MariaDB/MySQL and a deep understanding of database architecture and optimization
- Expert-level SQL knowledge (complex queries, window functions, CTEs, subqueries)
- Experience developing stored procedures and functions in MySQL/MariaDB
- Proficiency in performance optimization of queries and database schemas
- Strong understanding of indexing and optimization strategies for large datasets
- Experience with Flyway or similar database migration tools
- Knowledge of Linux/Unix and bash scripting for automation