SQL Developer

SQL Developer (Middle-Senior)
#vacancy #fulltime #job #sql #developer #remote

Firebird is an international online travel company that organizes trips to Europe for customers from around the world. Commercially available projects 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

📩 If interested, please send your CV to: Показать контакты