Job Description
Join CERN's Database and Analytics group to operate and support the Database on Demand (DBOD) service, used by many IT services, and across CERN's experimental programme. The DBOD service provides more than one thousand MySQL, PostgreSQL, and InfluxDB instances, through multiple lifecycle environments, offering to its users administrative functionality and features such as configuration management, monitoring, backup and recovery, replication, and high availability.
Your responsibilities
As an early-career professional working in the Database Services (DB) team, you will contribute to the administration of the instances hosted in the DBOD service.
You will participate in the evolution of the user interface (based on Angular and Flask).
Participate in the service configuration and architecture design, database upgrades and patches campaigns.
Work with hardware migrations, monitoring of systems health and performance to ensure high levels of performance, availability and security.
You will also assist and advise users and play a role in the evolution of the DBOD service, discussing and working with the team on service enhancements including technical mentorship and cross-training to peers.
Your role will include both operations tasks and software development in Python, bash, and Angular.
You will be working with open-source software and gaining experience with the IT infrastructure stack used at CERN, such as AlmaLinux 9, OpenStack, Puppet, Prometheus, GitLab, etc.
Your profile
Experience working with MySQL, PostgreSQL, or TimescaleDB databases.
Experience with SQL, Unix shell script and Python.
Knowledge of Linux operating system.
Knowledge of service administration and configuration tools like Puppet.
Experience in the monitoring of system health and performance indicators.
Experience with Rundeck automation or orchestration tools.
Skill