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: