We are 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
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.
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
Selection Process
- HR interview
- Technical interview including practical problem-solving
- Final interview with the team
We are looking for a specialist ready to work with high-load systems and complex business logic, who is also open to adopting modern technologies and AI-driven tools. Experience with transportation systems is a strong plus but not a strict requirement.
