Database Administrator

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
E-mail: i.maidanik@adtelligent.com
https://careers.adtelligent.com/#about