Database Infrastructure Engineer - PostgreSQL & MySQL, Hybrid

CERN; Genf; Hybrid; CHF 94.000 - 112.000; Vollzeit

Benefits dieser Stelle

30 days leave per year

Health insurance

Relocation package

Pension fund

Zusammenfassung

CERN in Geneva seeks a Database Infrastructure Engineer to manage PostgreSQL/MySQL databases for LHC experiments and organization-wide services. You will build a modern, highly available platform with automation, training and mentoring to grow technical skills.

Join a small expert team, operate and optimize production databases, and contribute to disaster recovery, security and reliability. Hybrid work, 40 h/week, with a competitive salary and benefits.

Qualifikationen

• Hands-on experience (typically 2+ years) administering relational databases, ideal PostgreSQL, in a professional environment.
• Good troubleshooting: performance analysis, query tuning, replication, backup and recovery.
• Knowledge of SQL and scripting in Python or shell for automation.
• Good understanding of Linux systems and interest in database infrastructure, reliability and automation.
• Familiarity with high availability, replication, clustering, backup/recovery or infrastructure automation is advantageous.
• Experience with Patroni, Consul, HAProxy, PgBouncer, Kubernetes or config-management tools is welcome but not required.
• Ability to troubleshoot technical problems, learn new technologies and work collaboratively with teams.
• Administration of database architectures.
• Knowledge of operating systems such as Linux.
• Knowledge of programming techniques and languages SQL, Python, shell.
• Interest in designing resilient, distributed ICT infrastructure.
• Problem solving, delivering high quality work on time, teamwork and clear communication.

Aufgaben

• Operate and improve production PostgreSQL and MySQL databases: troubleshooting, upgrades, migrations, patching and scaling.
• Design, deploy and run highly available database setups with automated failover.
• Automate provisioning, configuration and routine operations using scripting and infrastructure tools.
• Monitor databases for performance, stability, availability and security.
• Contribute to backup, disaster recovery and service continuity strategies.
• Support application developers in diagnosing database and query issues.
• Document procedures and share knowledge within the team.

Kenntnisse

Database administration

Troubleshooting

SQL

Python

Shell scripting

Linux

HA/Replication

Infrastructure automation

Problem solving

Team collaboration

Communication

Learning and knowledge sharing

Distributed infrastructure design

Ausbildung

Master's Degree or equivalent in Computing Science/Physics with computing content

Tools

PostgreSQL

MySQL

Patroni

Consul

HAProxy

PgBouncer

Kubernetes

Jobbeschreibung

CERN in Geneva seeks a Database Infrastructure Engineer to manage PostgreSQL/MySQL databases for LHC experiments and organization-wide services. You will build a modern, highly available platform with automation, training and mentoring to grow technical skills.

Join a small expert team, operate and optimize production databases, and contribute to disaster recovery, security and reliability. Hybrid work, 40 h/week, with a competitive salary and benefits.