What you'll do
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.
Your responsibilities
- 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 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.
Still here? Let's make a quick check about
Your profile
- Hands-on experience (typically 2+ years, including internships or substantial projects) administering relational databases, ideally PostgreSQL, in a professional environment.
- Good troubleshooting skills: 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 an interest in database infrastructure, reliability and automation.
- Familiarity with high availability, replication, clustering, backup/recovery or infrastructure automation would be an advantage..
- Experience with technologies such as Patroni, Consul, HAProxy, PgBouncer, Kubernetes or configuration-management tools is welcome, but not required..
- Ability to troubleshoot technical problems, learn new technologies and work collaboratively with infrastructure and application teams.
- 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: architectures
- Knowledge of operating systems: such as Linux
- Knowledge of programming techniques and languages: SQL, Python and Shell
- Architecture and design of ICT systems: interest in designing resilient, distributed infrastructure
- 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, Croatian and Turkish 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