Database Administrator (PostgreSQL, ClickHouse)

Responsibilities:

• Work with databases: PostgreSQL, ClickHouse, 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
• Experience with ClickHouse: table design, cluster setup, query optimization
• Deep knowledge of SQL and experience administering large, high-load databases
• Understanding of database migration concepts
• Experience with backup maintenance, statistics, partitions, and indexes
• Experience setting up monitoring using Grafana
• Experience with cloud databases in AWS/GCP
• 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

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

We offer:

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