**SQL Developer**
#vacancy #SQL #developer #DataEngineer

**location: **world
**format: **full-time, remote

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