Senior Database Administrator

uspio • Cyprus
Visa Sponsorship
Apply
AI Summary

The Senior Database Administrator will be responsible for designing, optimizing, and maintaining databases. The ideal candidate will have experience with PostgreSQL, ClickHouse, and other databases. Key requirements include database performance tuning, replication, and security.

Key Highlights
Design and optimize databases
Collaborate with developers to improve query performance
Ensure database security and enforce data access policies
Key Responsibilities
Work with databases: PostgreSQL, ClickHouse, MySQL, ScyllaDB, Redis
Collaborate with developers to design and optimize queries
Configure and maintain data backup and recovery processes
Set up database monitoring
Ensure security and enforce data access policies
Maintain data integrity and consistency in distributed systems
Optimize performance: configure database parameters, indexes, partitioning; manage replication and sharding in distributed systems
Identify and optimize slow queries
Automate routine administration tasks via scripts and CI/CD
Troubleshoot incidents and diagnose database issues
Plan capacity and scale database clusters
Technical Skills Required
PostgreSQL ClickHouse MySQL ScyllaDB Redis SQL Grafana AWS
Benefits & Perks
Official employment
Support for a work visa
Opportunities for professional growth
Friendly work environment
Flexible start to the workday
Nice to Have
Experience with ScyllaDB
Experience with Redis
Experience with Docker/Kubernetes
Experience with object storage systems
Understanding of CI/CD principles and experience with automation systems
Understanding of DWH architecture patterns

Job Description


Responsibilities

  • Work with databases: PostgreSQL, ClickHouse, MySQL, ScyllaDB (Cassandra), Redis
  • Collaborate with developers to design and optimize queries
  • Configure and maintain data backup and recovery processes
  • Set up database monitoring
  • Ensure security and enforce data access policies
  • Maintain data integrity and consistency in distributed systems
  • Optimize performance: configure database parameters, indexes, partitioning; manage replication and sharding in distributed systems
  • Identify and optimize slow queries
  • Automate routine administration tasks via scripts and CI/CD
  • Troubleshoot incidents and diagnose database issues
  • Plan capacity and scale database clusters

Requirements

  • Experience with PostgreSQL: performance tuning, replication, partitioning, sharding, cluster architecture
  • Experience with ClickHouse: table design, cluster setup, query optimization
  • Understanding of HA architecture patterns: quorum, leader election, split-brain prevention, fencing; hands-on experience with relevant tooling (e.g. Patroni, HAProxy, Keepalived)
  • Deep knowledge of SQL and experience administering large, high-load databases
  • Understanding of database migration concepts
  • Experience with backup and recovery strategies, statistics management, partitioning, and indexing
  • Experience setting up monitoring using Grafana
  • Experience with cloud databases in AWS
  • Experience with version control systems
  • Practical experience in analyzing and improving SQL query performance and database structures
  • Practical experience in building fault-tolerant configurations and disaster recovery plans
  • Fluent Russian

Nice To Have

  • Experience with ScyllaDB (strong advantage)
  • Experience with Redis
  • Experience with Docker/Kubernetes
  • Experience with object storage systems
  • Understanding of CI/CD principles and experience with automation systems
  • Understanding of DWH architecture patterns

We offer

  • Official employment and support for a work visa
  • Opportunities for professional growth
  • Friendly work environment
  • Flexible start to the workday

Similar Jobs

Explore other opportunities that match your interests

Infrastructure Engineer

Devops
•
16h ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

wheely

Cyprus

DevSecOps Specialist

Devops
•
1w ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Mid-Senior level

Mayflower

Cyprus

SOC L2 Analyst

Devops
•
2w ago
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Not Applicable

FP Markets (First Prudential M...

Cyprus

Subscribe our newsletter

New Things Will Always Update Regularly