Senior SQL Developer

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
• Online trip builder
• Service for booking hotels

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

We offer: