About the Company
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.
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
Requirements
•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
•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)
•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
•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)
•Experience with transportation or logistics systems
•Understanding of railway systems and scheduling
•Experience with real-time systems and data stream processing
Conditions
•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
