About the job
SummaryBy Outscal
We are looking for a Database Administrator with 1+ years of experience in ClickHouse and PostgreSQL, proficient in high availability architecture, backups, and optimization. You'll maintain databases, write procedures, and advise users on optimization.
Description
We are looking for a highly skilled and knowledgeable Database Administrator (DBA) to join our Infrastructure Team. In this role, you will be responsible for configuring and maintaining highly available PostgreSQL and Clickhouse databases. Your expertise will play a crucial role in ensuring the reliability, performance, and scalability of our database systems.
CloudLinux is a global remote-first company. We are driven by our principles: Do the right thing, employees first, we are remote first, and we deliver high volume, low-cost Linux infrastructure and security products that help companies to increase the efficiency of their operations. Every person on our team supports each other and does what we can to ensure everyone is successful. We are truly a great place to work.
You can find more details about the company on our branded website at cloudlinux.com
What you’ll do:
- Perform regular database maintenance, search for weak points (shortcomings) of the existing architecture, provide solutions or workarounds and help implement them
- Configure database backups and prepare recovery plans
- Describe database infrastructure as a code
- Document databases of existing services and applications
- Maintain user access rights and security of databases
- Define key database monitoring metrics and define action plans to avoid/fix possible problems
- Write standard operating procedures for recurring tasks, maintenance and recovery works
- Advise users on the subject of database optimization and writing DB queries
Requirements
To be successful you should have:
- 1+ years of ClickHouse DB administration experience
- 1+ years of PostgresSQL DB administration experience
- Experience in configuring a database in a high availability architecture
- Experience in database backup and recovery
- Experience in database optimization for different load profiles
- Intermediate level of English knowledge
Will be a plus:
- Experience in automating data loading from different sources.
- Experience with Ansible, Terraform
- Experience with k8s and clouds (AWS/GCP).
Benefits
What's in it for you?
- A focus on professional development;
- Interesting and challenging projects
- Flexible working hours
- Paid one month vacation per year and unlimited sick leave
- Medical insurance reimbursement
- Co-working and gym/sports reimbursement
- The opportunity to receive a reward for the most innovative idea that the company can patent
By applying for this position, you consent to the processing of your personal data as described in our Privacy Policy (https://cloudlinux.com/candidate-privacy-notice), which provides detailed information on how we maintain and handle your data.