Equipment Management Database Specialist

Arbeidsplassen; Schweiz; Vor Ort; CHF 110.000 - 170.000; Vollzeit

Zusammenfassung

Arbeidsplassen is seeking an Equipment Management Database Specialist to ensure that all CMS equipment installed or decommissioned during LS3 is accurately recorded in the EMdb. You will bridge field inventory with the database, maintain and enhance apps, and develop tools for data visualisation and accessibility.

You will combine IT expertise with CMS assets knowledge, prepare documentation for installations, and support teams to keep the inventory coherent throughout its lifecycle,

Qualifikationen

• Experience with relational databases and SQL.
• Experience with web application development using Oracle APEX, PHP, JavaScript, client-oriented APIs.
• Experience monitoring data quality and ensuring data consistency between physical assets and the digital inventory system.
• Experience with engineering equipment, scientific infrastructure, or large-scale technical installations.
• Ability to develop dashboards and application features.
• Proactive in improving processes and application functionality.
• Familiarity with the CMS Experimental and upgrade program is an advantage.
• Ability to bridge operational activities in the field with IT systems and interface CERN asset management procedures.

Aufgaben

• Ensure the consistency, accuracy and integrity of the CMS Equipment Management Database by synchronising it with the physical installation and decommissioning of equipment.
• Act as the interface between field inventory activities of CMS teams and the Equipment Management Database, ensuring that all equipment installations, removals and modifications are accurately reflected in the system.
• Maintain, support and enhance the Equipment Management Database and its applications, ensuring their reliability and long-term sustainability while developing new features, dashboards and visualisation tools for equipment traceability, data quality monitoring and reporting.
• Drive continuous improvements to the usability, functionality and efficiency of the Equipment Management Database by streamlining the registration and management of equipment, cables and other assets, and enhancing data management and asset traceability across the CMS experiment.
• Supporting work on the field, to ensure that the operational aspects of asset installation run smoothly for the CMS experiment and that there is coherence between installed equipment and services and the database inventory.
• Collaborate with the CERN Enterprise Asset Management service and ensure the inter-operationality of processes within the CERN-wide infrastructure and applications.

Kenntnisse

Relational databases

SQL

Dashboard development

Data quality monitoring

Ausbildung

Master's degree or PhD in Computer Science or Applied Physics or related field

Tools

Oracle APEX

PHP

JavaScript

APIs

Jobbeschreibung

Equipment Management Database Specialist

What you'll do

• The role is responsible for ensuring that all equipment installed or removed during CMS Long Shutdown 3 (LS3) is accurately recorded in the CMS Equipment Management Database (EMdb). Acting as the interface between the physical inventory and the database, the post-holder ensures data consistency, maintains and enhances the database and its associated applications, and develops tools to improve data visualisation and accessibility.
• The role combines strong IT expertise with an understanding of the CMS experiment's equipment and asset management processes. It also provides support to colleagues across the CMS experiment in keeping the database up to date by preparing dedicated documentation and labelling for the services installation campaign, ensuring that equipment can be accurately identified, tracked and managed throughout its lifecycle.

Your responsibilities

• Ensure the consistency, accuracy and integrity of the CMS Equipment Management Database by synchronising it with the physical installation and decommissioning of equipment.
• Act as the interface between field inventory activities of CMS teams and the Equipment Management Database, ensuring that all equipment installations, removals and modifications are accurately reflected in the system.
• Maintain, support and enhance the Equipment Management Database and its applications, ensuring their reliability and long-term sustainability while developing new features, dashboards and visualisation tools for equipment traceability, data quality monitoring and reporting.
• Drive continuous improvements to the usability, functionality and efficiency of the Equipment Management Database by streamlining the registration and management of equipment, cables and other assets, and enhancing data management and asset traceability across the CMS experiment.
• Supporting work on the field, to ensure that the operational aspects of asset installation run smoothly for the CMS experiment and that there is coherence between installed equipment and services and the database inventory.
• Collaborate with the CERN Enterprise Asset Management service and ensure the inter-operationality of processes within the CERN-wide infrastructure and applications.

Your profile

• Experience with relational databases and SQL.
• Experience with web application development, using for example Oracle APEX, PHP, JavaScript, client-oriented APIs.
• Experience monitoring data quality and ensuring data consistency between physical assets and the digital inventory system.
• Experience with engineering equipment, scientific infrastructure, or large-scale technical installations.
• Ability to develop dashboards and application features.
• Proactive in improving processes and application functionality.
• Familiarity with the CMS Experimental and upgrade program is an advantage.
• Ability to bridge operational activities in the field with IT systems and interface CERN asset management procedures.
• Master's degree or PhD or equivalent relevant experience in the field of Computer Science or Applied Physics or a related field.

Your skills

• Knowledge of database and/or data mining architectures and technologies.
• Conceptualising, designing and developing user experiences and interfaces.
• Decommissioning and disposal of detector components and systems.
• Development of application software.
• Defines clear objectives, milestones and deliverables before initiating work/ project.
• Builds and maintains constructive and effective work relationships.
• Ensures that information, procedures and decisions are appropriately documented.
• Addresses complex problems by breaking them down into manageable components.
• Proposes ways to improve or streamline existing procedures, processes and methodologies.
• Spoken and written English or French, with a commitment to learn the other language.

Medical hazard

• Exposure to electromagnetic fields under certain exposure conditions.
• Given the occupational health risks associated with this position, the selected candidate must obtain medical clearance before a contract offer is confirmed.

Employment conditions

• A valid driving licence.
• Interventions in underground installations.
• Work in Radiation Areas.
• Work during nights, Sundays and official holidays, when required by the needs of the Organization.

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.