DBA
Limassol · HeySMS
Responsibilities
- Support, administer, and optimize high-load databases (PostgreSQL, MySQL, ClickHouse)
- Participate in the architectural migration from monolith to microservices: data modeling, separation, and consistency assurance
- Develop and implement data migration strategies
- Monitor performance, configure backups and high availability
- Optimize SQL queries and database schemas
- Promote and implement database best practices within the development team
Requirements
- Experience with both relational and non-relational databases (e.g., PostgreSQL, ClickHouse, MongoDB, etc.)
- Strong experience with data migrations and schema management tools (Liquibase, Flyway, or similar)
- Hands-on experience with high-load systems, understanding of scaling and optimization techniques including indexing, partitioning, and sharding
- Advanced knowledge of ClickHouse: cluster configuration, partitioning, merging, TTL, monitoring. Understanding of various engine types (MergeTree, ReplacingMergeTree, SummingMergeTree, AggregatingMergeTree, etc.) and their appropriate use cases
- In-depth knowledge of PostgreSQL: from configuration and performance tuning to complex queries and function development
- Understanding of microservice architecture and experience in adapting databases to such environments
Familiarity with monitoring and logging systems (Grafana, Zabbix, etc.)
Nice to Have
- Scripting skills (bash, Python)
- Experience with Kubernetes and Docker in the context of database management
- Knowledge of CI/CD principles and experience integrating databases into DevOps workflows
Conditions
- Official employment and support for a work visa
- Opportunities for professional growth
- Friendly work environment
- Flexible start to the workday
Share this job opening