SQL Developer

SQL Developer #вакансия #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 https://rail.ninja - Online trip builder https://triptile.com - Service for booking hotels https://hotel.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 d