What you'll do
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.
Your responsibilities
- 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.
Still here? Let's make a quick check about
Your profile
- 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.
- 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.
Your skills
- 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.
- Identifies, defines and assesses problems, takes action to address them.
- Delivers high quality work on time and fulfils expectations.
- Builds and maintains constructive and effective work relationships.
- Delivers presentations in a structured and clear way; adjusts style and content to the audience; responds calmly and confidently to questions.
- Keeps up-to-date with developments in own field of expertise and readily absorbs new information.
- Spoken and written English, with a commitment to learn French.
Employment conditions
- 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.
Global Benefits at CERN
Let's get you ready
Be sure to meet the eligibility criteria
- You are a national of a CERN Member State or Associate Member State. Currently, we cannot consider applications from Pakistani, Lithuanian, Latvian, Cypriot and Croatian nationals, as the ceiling defined under Article II.5 of the Associate Membership Agreement has been reached.
- You have relevant qualifications and professional experience.
- If you have previously held a Staff contract at CERN, you will not be eligible for these positions.
- Please pay attention to the additional criteria and requirements for this specific position and mentioned above.
You will need these documents to complete your application
- Your CV (English or French)
- Any document you consider relevant to your application