Database Infrastructure Engineer (IT-DA-DB-2026-174-LD)

CERN; Genf; Vor Ort; CHF 100.000 - 134.000; Vollzeit

Benefits dieser Stelle

Competitive salary

Leave entitlement

Health insurance

Pension plan

Relocation support

Contract tenure

Zusammenfassung

CERN in Geneva invites an experienced database engineer to shape and operate our mission-critical PostgreSQL and MySQL platforms, with emphasis on high availability, resilience and automation. You will build and maintain HA infrastructures (Patroni, Consul, HAProxy/PgBouncer), automate provisioning, and support application teams across LHC operations.

This 5-year limited duration contract offers hybrid working and generous benefits.

Qualifikationen

• Master's degree or equivalent in Computing Science or related field.
• Strong experience running production PostgreSQL and MySQL with backup, recovery, and continuity.
• Proficiency in high-availability concepts and disaster recovery.

Aufgaben

• Administration, operation, and evolution of MySQL and PostgreSQL platforms, including migrations and scaling.
• Design, deployment, and improvement of highly available PostgreSQL infrastructures.
• Automation for provisioning, configuration, failover, and operational workflows.
• Proactive monitoring to ensure performance, stability, and security.
• Define resilience, disaster recovery and service continuity strategies.
• Provide expertise and mentorship to development teams.
• Share knowledge and train peers.

Kenntnisse

PostgreSQL

MySQL

Patroni

Consul

HAProxy

PgBouncer

Python scripting

Linux

SQL

Ausbildung

Master's degree in Computing Science or related

Tools

Patroni

Consul

PgBouncer

HAProxy

Kubernetes

Puppet

Jobbeschreibung

Company Description

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.

Job Description

Introduction:

You will play an active role in the support and evolution of the database systems that underpin the LHC experiments, accelerator operations, and CERN’s support services. In addition to general database administration, you will focus on the engineering, operation, and modernisation of orchestrated High Availability (HA) infrastructures. A key responsibility will be the development and operation of a resilient, distributed PostgreSQL HA platform based on modern consensus, orchestration, and proxy routing technologies.

A hands‑on engineering role focused on the reliability, automation and evolution of CERN’s PostgreSQL and relational database platforms, with a particular focus on high availability, resilience and service continuity for mission‑critical scientific and organisational services.

Functions

• Administration, operation, and evolution of MySQL, and PostgreSQL database platforms, including troubleshooting, configuration, migrations, upgrades, scaling, and patching.
• Design, deployment, operation, and continuous improvement of highly available and resilient PostgreSQL infrastructures.
• Development and maintenance of automation for database provisioning, configuration, failover and operational workflows.
• Proactive monitoring of database environments to ensure optimum performance, throughput, stability, availability and security.
• Definition and evolution of database architecture, resilience, disaster recovery, and service continuity strategies.
• Provision of technical expertise and troubleshooting support to application development teams.
• Share domain and technical expertise, and provide technical mentorship and training to peers.

Qualifications

• Master's Degree or equivalent relevant experience in the field of Computing Science, or a science discipline (e.g., Physics) with significant computing content, or a related field.

Experience

• Demonstrated experience operating production relational database services, preferably PostgreSQL, in environments where reliability, availability, backup, recovery and service continuity are critical.
• Strong troubleshooting skills in database operations, including performance analysis, query optimisation, replication, clustering, partitioning, upgrades and incident resolution.
• Solid understanding of high-availability and disaster recovery concepts for relational databases; practical experience with PostgreSQL HA tooling such as Patroni, Consul, HAProxy or PgBouncer would be a strong asset.
• Technical and troubleshooting skills with open-source database clustering and automated failover tools, with experience in Patroni and Consul being a strong asset.
• Solid SQL knowledge with the ability to write and troubleshoot stored procedures, functions, tables, indexes, and constraints, and to support application teams in diagnosing database-related issues.
• Experience with infrastructure components including load balancers/proxies (e.g., HAProxy), connection managers (e.g., PgBouncer), Linux-based systems, and infrastructure tools like Puppet or Kubernetes is an asset.
• Ability to work collaboratively with infrastructure and application teams, document operational procedures, share knowledge and contribute to the continuous improvement of database services.

Technical competencies

• Administration of databases: experience with production relational database services, including PostgreSQL and MySQL administration. Experience designing, deploying and operating highly available architectures (familiarity with PostgreSQL clustering solutions such as Patroni and replica management is considered an advantage).
• Knowledge of operating systems: such as Linux, including familiarity with network port allocation, security configurations, and enterprise storage architectures.
• Knowledge of programming techniques and languages: ability to develop and maintain SQL, shell scripts or Python automation to support database operations, monitoring, deployment and troubleshooting.
• Architecture and design of ICT systems: ability to design resilient, distributed infrastructure components supporting high availability, failover, traffic routing and service continuity.

Behavioural competencies

• Solving Problems: identifying, defining and assessing problems, taking action to address them.
• Achieving Results: delivering high quality work on time and fulfilling expectations.
• Working in Teams: building and maintaining constructive and effective work relationships.
• Communicating Effectively: delivering presentations in a structured and clear way; adjusting style and content to the audience; responding calmly and confidently to questions.
• Learning and Sharing Knowledge: keeping up-to-date with developments in own field of expertise and readily absorbing new information.

Language skills

• Spoken and written English, with a commitment to learn French.

Additional Information

Eligibility and closing date:

Diversity has been an integral part of CERN’s mission since its foundation and is an established value of the Organization. Employing a diverse workforce is central to our success. We welcome applications from all Member States and Associate Member States.

This vacancy will be filled as soon as possible, and applications should normally reach us no later than 02.09.2026 at 23:59 CEST.

Employment Conditions

Contract type: Limited duration contract (5 years). Subject to certain conditions, holders of limited-duration contracts may apply for an indefinite position.

Working Hours: 40 hours per week

Job Flexibility: Hybrid

This position involves:

• Work during nights, Sundays and official holidays, when required by the needs of the Organization.
• Stand-by duty, when required by the needs of the Organization.

Job grade: 6-7

Job reference: IT-DA-DB-2026-174-LD

Field of work: Software Engineering and IT

Benchmark Job Title: Computing Engineer

Global Benefits

• A competitive salary (tax free), increasing in line with your years of relevant experience.
• 30 days of paid leave per year plus 2 weeks annual closure.
• Coverage by CERN’s comprehensive health insurance scheme (for yourself, your spouse and children), and membership of the CERN Pension Fund.
• Family, child and infant monthly allowances depending on your individual circumstances.
• A relocation package (installation grant, removal, travel expenses) depending on your individual circumstances.
• Possibility to extend your contract up to 8 years + eligibility for indefinite contract tenure.

Overview of CERN

Discover a world where the impossible is made possible!

At CERN, the European Organization for Nuclear Research, we are pushing the frontiers of science and technology. Our groundbreaking work brings together not only physicists but also a diverse range of professionals from engineering, technical, scientific, and administrative fields. Together, we foster an environment where innovation and collaboration thrive.

Every day, we face exciting new challenges and opportunities to contribute to cutting-edge research that shapes our understanding of the universe. We meet these challenges through the diverse perspectives within our teams, ensuring every contribution is valued and driving our shared sense of inclusion and purpose. Diversity is a core value of CERN since its foundation, and it remains central to our mission and continued success.

If you are ready to be part of a dynamic, inclusive community pushing the boundaries of knowledge, CERN is the place where your curiosity and skills can thrive. Be part of our mission to uncover what lies at the heart of the universe!

More information about us, here: careers.cern

• Compensation: from CHF 9236 - monthly