SQL Developer

SQL Developer for high-load train scheduling system at Firebird, remote full-time. 5+ years MariaDB/MySQL experience required.

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

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

What We Offer: - Remote work - 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