SQL Developer (Middle-Senior)

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

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
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.

DWH Developer jobs

Analytics Engineer [DWH]

Data Warehouse (DWH)

SQL Developer (Middle-Senior)

Analytics Engineer [DWH]

Data Warehouse (DWH)

SQL Developer (Middle-Senior)