REQUIREMENTS:

Experience and Knowledge

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

Administration Skills

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

Processes and Communication

• 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: 

Database Schema Change Management and Versioning

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

CI/CD Setup and Support for Databases

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

Security and Access Control

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

Monitoring, Problem Prevention, and Optimization

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

Risk Management and Rollback Strategy

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

Team Consultation and Training

• 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:

• Friendly atmosphere and goal-oriented colleagues
• Flexible schedule to work remotely and in our comfortable coworking space in Chișinău
• Corporative hardware for work
• Paid lunch
• Paid vacation (28 working days per year) and sick leave (5 days per year with 100% compensation )
• Education bonuses
• Corporate English language courses
• Medical insurance
• Participation in corporate parties, both online and offline
• Psychological and mental health support
• Pleasant corporate gifts
• Company support during significant life events