Database Administrator

Job Title :

ClickHouse Database Administrator

Location : Hyderabad

Employment type : Full-time

Experience level : 8+ Yrs

Key Responsibilities :

Database Management :

Creating, configuring, monitoring, and maintaining ClickHouse databases across various environments, including single-node setups and large-scale clusters with replication and sharding.

Performance Optimization :

Ensuring optimal performance, availability, and security of ClickHouse databases. This includes performance tuning, query optimization, and schema design improvements.

High Availability and Disaster Recovery :

Implementing and maintaining data backup, recovery, and disaster recovery strategies to ensure data integrity and business continuity.

Automation :

Automating routine database administration tasks, monitoring, and alerting activities using scripting languages like Shell, Python, or Perl.

Security and Compliance :

Developing and implementing database security policies and procedures, ensuring compliance with security and governance standards.

Collaboration and Support :

Collaborating with development, infrastructure, and operations teams to ensure seamless database integration, provide technical guidance, and support application testing and deployments.

Troubleshooting and Incident Management :

Participating in incident management, root cause analysis, and problem resolution related to ClickHouse databases.

Documentation :

Documenting database standards, operational procedures, and technical configurations.

Required Skills and Qualifications :

ClickHouse Expertise :

In-depth knowledge and hands-on experience with ClickHouse administration, including cluster design, replication, sharding, and performance tuning.

Database Administration :

Strong understanding of database administration principles and best practices.

Scripting Languages :

Proficiency in scripting languages like Shell, Python, or Perl for automation and task management.

SQL Knowledge :

Solid understanding of SQL and experience with query optimization.

Linux Administration :

Experience with Linux operating systems, as ClickHouse is typically deployed on Linux.

Problem-Solving :

Excellent analytical and problem-solving skills to diagnose and resolve database issues.

Communication :

Strong communication skills to collaborate effectively with various teams and provide technical support.