SQL Developer (Middle-Senior)

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.