Tell us about yourself, the employer will receive this information
Firebird is an international online travel company that organizes trips to Europe for customers from around the world. We have a dedicated software development department that focuses on our internal products that allow everyone else to deliver some of the top-notch, worldwide services. Currently, there are a number of commercially available projects in production that are being actively worked on:
Service for booking rail tickets https://rail.ninja
Online trip builder https://triptile.com
Service for booking hotels https://travel.ninja
Technical Skills:
– 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
Work Experience:
– 5+ years of commercial SQL development
– Experience with high-load systems (processing millions of records)
– Knowledge of database design principles and normalization
– Experience working in a team using version control systems (Git)
Personal Qualities:
– Adaptability and willingness to embrace new technologies
– Openness to innovation and modern development practices
– Commitment to continuous learning and professional growth
– Flexible thinking and the ability to quickly master new tools
Nice-to-have Technologies:
– Experience using AI agents for SQL development and optimization
– Knowledge of modern automation tools in development workflows
– Experience with Jenkins or other CI/CD systems
– Knowledge of Docker for database containerization
– Experience monitoring database performance (Percona Toolkit, pt-query-digest)
– Knowledge of NoSQL solutions (Redis, MongoDB) for caching
– Experience with cloud databases (AWS RDS, Google Cloud SQL)
Domain Knowledge:
– Experience with transportation or logistics systems
– Understanding of railway systems and scheduling
– Experience with real-time systems and data stream processing
Responsibilities:
– Developing and optimizing complex SQL queries and stored procedures
– Designing database schemas for high-load systems
– Creating and maintaining migrations using Flyway
– Optimizing performance of existing queries and indexes
– Developing bash scripts for process automation
– Leveraging modern tools and AI agents to enhance efficiency
– Analyzing query performance and identifying bottlenecks
– Monitoring database health and planning for scalability
– Profiling queries and creating optimization plans
– Working with logs and diagnosing issues
– Participating in SQL code reviews and database design reviews
– Consulting team members on database-related topics
– Documenting architectural decisions and procedures
– Mentoring junior developers in SQL and performance optimization
– Introducing new technologies and best practices to the team
What We Offer:
– Flexible working hours and the option to work remotely
– Modern technology stack and engaging challenges
– Opportunities for professional growth within an expert team
– Access to cutting-edge tools and technologies
– Participation in technical conferences and professional training
– Hands-on experience with modern technologies and approaches
– Ability to influence architectural decisions in the project
– Mentorship and knowledge sharing with colleagues
– Exploration and implementation of AI tools in daily workflows
About the Project:
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.
Tell us about yourself, the employer will receive this information
Main
For candidates
For employers
Tell us about yourself, the employer will receive this information
The employer will receive your resume shortly!
