Database Infrastructure Engineer

CERN; Genf; Vor Ort; CHF 110.000 - 140.000; Vollzeit

Zusammenfassung

CERN in Geneva is seeking a Database Infrastructure Engineer to join the Databases and Analytics Group. You will operate and improve production PostgreSQL and MySQL databases, design and deploy highly available setups, and automate routine operations.

The role offers training and mentoring to grow your skills while contributing to LHC experiments and accelerator services with a modern, resilient database platform.

Qualifikationen

• Experience with PostgreSQL and MySQL administration in production environments.
• Ability to design and implement highly available database architectures.
• Strong scripting experience to automate provisioning and operations.

Aufgaben

• Operate and improve production PostgreSQL and MySQL databases (troubleshooting, upgrades, migrations, patching, scaling).
• Design, deploy and run highly available database setups with automated failover.
• Automate provisioning, configuration and routine operations using scripting.

Kenntnisse

PostgreSQL

MySQL

Scripting (Python/Bash)

Automation

High availability

Tools

Linux

Shell scripting

Jobbeschreibung

At CERN, the European Organization for Nuclear Research, physicists and engineers are probing the fundamental structure of the universe. Using the world's largest and most complex scientific instruments, they study the basic constituents of matter - fundamental particles that are made to collide together at close to the speed of light. The process gives physicists clues about how particles interact, and provides insights into the fundamental laws of nature.

Introduction

You will join a small team of experts managing the PostgreSQL and MySQL databases supporting the LHC experiments, accelerator operations and organisation-wide services. You will help build and automate a modern, highly available database platform, with training and mentoring to grow your skills.

Functions

As a Database Infrastructure Engineer in the Databases and Analytics Group, your main activities will consist of:

• Operate and improve production PostgreSQL (and MySQL) databases: troubleshooting, upgrades, migrations, patching and scaling.
• Help design, deploy and run highly available database setups with automated failover.
• Automate provisioning, configuration and routine operations using scripting…