SQL Developer

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