Job Description
Your responsibilities
You will be responsible for managing all programming and infrastructure support related to the CMS databases, particularly those involving online and offline conditions data handling and processing for alignment and calibration.
* Coordinate and manage databases: Oversee the databases at P5, where the conditions are written, as well as the copies hosted at CERN IT. You will also manage databases used by various computing projects for data and workflow management.
* Collaborate with the AlCa-DB team: Work closely with physicists in the Alignment, Calibration, and Database (AlCa-DB) team, which coordinates detector and physics object groups to prepare and deploy alignment and calibration conditions.
* Ensure service stability: In partnership with CERN IT DBAs, ensure the stability of services, coordinate scheduled updates, and oversee maintenance tasks.
* Optimize operations: Provide expertise to identify operational bottlenecks and suggest optimizations to users, ensuring smooth and efficient workflows.
* Manage data handling tools: Develop and maintain tools that enable users to efficiently manage conditions and calibration data in the database, and facilitate the distribution of this data to worldwide grid computing farms through the Frontier system.
* Support new use-cases: Offer guidance and expertise to handle new use cases that arise, providing tailored solutions as needed.
* Monitor and alert services: Implement monitoring systems for various services and establish infrastructure to alert experts when operational parameters are outside their acceptable limits.
* Operate CMS conditions database workflows: Manage the routine updates of the CMS conditions database, including Conditions and Global Tag management, for data processing and Monte Carlo productions.
* Maintain and develop tools: Contribute to the development and maintenance of web-based tools that manage and monitor alignment and calibration workflows, ensuring their continuous, unattended operation.
Your profile
Skills
* Excellent programming skills in Python and C++.
* Strong knowledge of databases, particularly ORACLE DB, and database handling tools like SQL and sqlalchemy.
* Expertise in software release management, testing procedures, SQL, and Object Relational Mapper (sqlalchemy).
* Familiarity with modern web frameworks such as CherryPy and Flask, and web technologies like jQuery and AJAX.
* Knowledge of High Energy Physics (considered an advantage).
* Demonstrated ability to achieve results.
* Results-oriented mindset.
* Excellent problem-solving skills.
* Strong autonomy and self-management.
Eligibility criteria:
* You are a national of a CERN Member State.
* By the application deadline, you have a maximum of two years of professional experience since graduation in Computer Science or Engineering, Physics (or a related field), and your highest educational qualification is either a Bachelor's or Master's degree.
* You have never had a CERN fellowship or graduate contract before.
* Applicants without University degree are not eligible.
* Applicants with a PhD are not eligible.
About us
CERN, the European Organization for Nuclear Research, is a truly unique organization. A genuinely collaborative environment, where everyone works together to pursue a single, mind-boggling ambition: to unlock the secrets of the Universe.
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.
The process gives physicists clues about how particles interact, and provides insights into the fundamental laws of nature. Find out more on our website.
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.