Desired Skills and Experience
- Plan, setup, optimize, monitor, and maintain our SQL and NoSQL database clusters;
- Work with the application teams to ensure that our data models are making the best usage of our database cluster resources;
- Closely work with other departments, such as Engineering, Business Intelligence, Data Science, and Cyber Security to ensure correct and secure database access patterns;
- Act as a bridge between application teams and the underlying database infrastructure;
- Make sure our database backup and restore procedures are state of the art;
- Be responsible for troubleshooting issues and analysing incidents in our database servers together with your department colleagues and application teams;
- Be empowered to design and implement solutions to ensure our databases are properly reliable, scalable, monitored, and maintainable.
- Expertise in PostgreSQL and MongoDB administration and tuning;
- Expertise with Linux-based systems;
- Experience in troubleshooting complex database issues (query optimization, performance problems, etc);
- Experience with database backup, restore, and disaster recovery procedures;
- Experience in designing and monitoring highly scalable database clusters;
- Experience with at least 2 scripting languages;
- Knowledge in ZFS and other Linux storage filesystems would be a big plus;
- Knowledge in any provisioning tools (SaltStack, Chef, Puppet, Ansible) would also be a big plus.