REQUIREMENTS:

• Solid experience with relational databases (PostgreSQL, MySQL, or similar) and a strong understanding of internal mechanisms (transactions, locks, indexes)
• Hands-on experience with migration tools (Liquibase, Flyway, Sqitch, etc.) or built-in frameworks (Alembic, EF Migrations, Rails Migrations)
• Familiarity with CI/CD and DevOps practices: ability to integrate migrations into a GitLab Pipeline or similar setup
• Understanding of GitOps approaches and the principle of treating database schemas as code (Database-as-Code)
• Ability to configure and manage access (roles, privileges), monitor database activity, and track performance metrics
• Experience planning and implementing backups and restores, as well as building High Availability strategies (replication, sharding)
• Capable of handling the risks of large-scale changes (migrating big tables, batch operations, reducing downtime)
• Involvement in code reviews: preferably experience reviewing and collaborating on SQL scripts with development teams
• Skill in documentation and describing changes (logging migrations, maintaining version tables, creating Merge Requests)
• Willingness to work with developers, QA, and other stakeholders, explaining the nuances of schema modifications

WOULD BE A PLUS:

• Experience working with large datasets and optimizing complex queries
• Participation in developing or administering high-load (mission-critical) systems
• Experience with ClickHouse

RESPONSIBILITIES:

• Design and coordinate data structures in collaboration with developers and project team leads
• Keep the schema up-to-date in a version control system (Git), ensuring all changes are introduced exclusively via migrations
• Participate in reviewing SQL scripts and migrations, verifying correctness, query optimization, and the absence of conflicts between parallel changes
• Integrate migrations into GitLab pipelines (Liquibase, Flyway, or other tools)
• Automate the application of migrations for each release or application update
• Configure environments (dev/test/prod) so that their schemas remain synchronized
• Implement an RBAC model (Role-Based Access Control) so that only authorized roles can modify the production schema
• Enforce the policy of “no manual changes directly on production” — all alterations must come through migrations and pull/merge requests
• Monitor the database state (load, performance, locks) and promptly address bottlenecks.
• Plan and execute optimization changes (e.g., adding indexes, sharding, reorganizing large tables)
• Assess the risks of locks and deadlocks during DDL operations; propose “safe” table modification strategies (online migrations, batch updates)
• Develop backup and recovery plans to handle critical failures
• Define a rollback strategy for migrations and perform testing when necessary
• Apply an “expand-and-contract” schema approach to reduce downtime and data loss risks
• Collaborate with developers to design robust changes that account for performance, data integrity, and scalability
• Train the team in best practices for database migrations and schema management, fostering a Database-as-Code culture
• Participate in sprint/release planning, proactively highlighting potential data-related issues

WE OFFER:

• Competitive salary
• Flexible working conditions
• Work in a dynamic environment with interesting challenges
• Paid vacation (20+ working days per year) and sick leave
• Corporate English lessons
• Health insurance