Работа для программиста | IT вакансии

#вакансия #SQL #developer #DataEngineer

SQL Developer

location: world
format: full-time, remote
salary: up to 4500$ gross

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
- Online trip builder
- Service for booking hotels

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

📩 if interested, please send your CV to: olga.z@firebirdtours.com

Контакты: @olga_kozeko

331 views15:28