Junior Database Administrator

As a skilled Database Administrator with 23 years of hands-on experience, your primary focus will be on managing and optimizing relational database systems, particularly MariaDB and ClickHouse. Your responsibilities will include: - Installing, configuring, and maintaining ClickHouse in both development and production environments. - Supporting and managing at least one other RDBMS such as PostgreSQL, MySQL, or SQL Server. - Designing and implementing High Availability (HA) and Disaster Recovery (DR) solutions for ClickHouse. - Optimizing query performance through indexing, partitioning, and materialized views. - Automating database administration tasks using Python, Bash, or SQL scripting. - Setting up and maintaining monitoring using tools like Grafana, Zabbix, or Percona Monitoring. - Implementing robust backup and recovery processes to ensure data integrity. - Collaborating with engineering teams to develop scalable and performant data solutions. - Troubleshooting performance issues, slow queries, and conducting root cause analyses. - Documenting system configurations, standard operating procedures, and best practices. - Ensuring compliance with security and data governance policies. - Participating in disaster recovery testing and planning. Requirements for this role include: - 13 years of experience in managing ClickHouse and other RDBMS like PostgreSQL, MySQL, etc. - Proficiency in SQL scripting and performance tuning. - Experience with replication, sharding, or clustering in ClickHouse or similar systems. - Familiarity with monitoring tools such as Grafana, Zabbix, etc. - Proficiency in scripting with Python, Bash, or PL/SQL for automation. - Exposure to CI/CD pipelines and DevOps tools like Git, Jenkins, Docker. - Understanding of database security, networking, and compliance standards. - Strong analytical thinking, communication, and problem-solving skills. Please note that the above job description is for a Database Administrator role focusing on managing and optimizing relational database systems, primarily MariaDB and ClickHouse.,