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.
Skills
- Familiarity with large-scale and high-availability database environments.
- Proficiency with Angular and Flask.
- Knowledge and understanding of containerisation/container orchestration.
- Knowledge of the ELK stack.
- Spoken and written English, with a commitment to learn French.
Eligibility criteria:
- You are a national of a CERN Member or Associate Member State.
- By the application deadline, you have a maximum of two years of professional experience since graduation in Computer Science (or a related field) and your highest educational qualification is either a Bachelor's or Master's degree.
- You have never had a CERN fellow or graduate contract before.
- Applicants without University degree are not eligible.
- Applicants with a PhD are not eligible.