Description du poste

Rejoignez une entreprise innovante en tant que DBA Senior Microsoft SQL Server. Profitez d’un environnement dynamique et international.

Tâches

• Administre et optimise les bases de données Microsoft SQL Server en production.

• Gère des architectures de haute disponibilité comme Always-On et clustering.

• Dirige des projets techniques, migrations et automatisation des tâches DBA.

Compétences

• 10 ans d’expérience en SQL Server, Bac+5 en informatique requis.

• Maîtrise des outils SQL Server et de PowerShell.

• Leadership et gestion de projets en environnement grand compte.

Job description
Dans le cadre de la gestion et de la transformation des environnements de données de notre client, nous sommes à la recherche d’un(e) DBA Senior spécialisé(e) en Microsoft SQL Server. Vous serez impliqué(e) dans des architectures critiques et complexes, en support des activités RUN et BUILD, avec une forte composante de management technique et de pilotage de projets.

Vos responsabilités :
• Administration, exploitation et optimisation des bases de données Microsoft SQL Server (versions 2008 à 2022) dans des environnements de production, pré-production et développement.
• Gestion des architectures de haute disponibilité : Always-On (WSFC, Clusterless, Basic AO), Mirroring, Log Shipping, clustering, etc.
• Pilotage de projets techniques : migrations de versions, upgrades, consolidation/mutualisation d’environnements, automatisation des tâches DBA (PowerShell, scripts), industrialisation des processus.
• Management technique des équipes DBA : coordination, montée en compétences, transfert de connaissances, suivi des activités RUN/BUILD.
• Support de niveau 3 et expertise dans la résolution d’incidents majeurs, optimisation des performances (tuning, indexation, monitoring), audits, gestion des plans de continuité et de reprise d’activité (PCA/PRA).
• Participation à la définition et à la mise en œuvre de la stratégie Data : choix d’architectures, veille technologique, recommandations pour l’optimisation des licences et des coûts.
• Rédaction de documentation technique, procédures, normes et bonnes pratiques.
• Interface avec les équipes projets, infrastructure, développement et éditeurs.

Votre Profil :
• Vous justifiez d’au moins 10 ans d’expérience sur Microsoft SQL Server (2008 à 2022) et maîtrisez les outils associés (SSAS, SSIS, SSRS, PowerBI, PowerShell…).
• Vous avez une expérience confirmée en management technique et gestion de projets d’infrastructure SQL Server, idéalement en environnement grand compte ou ESN.
• Vous faites preuve de leadership, d’autonomie, de rigueur et d’un excellent sens du service.
• Vous êtes diplômé(e) Bac+5 en informatique, avec des certifications Microsoft appréciées.
• Vous parlez couramment anglais (l’allemand est un plus).

Notre culture d’entreprise :
• Agilité :Évoluez dans un environnement flexible, dynamique et stimulant.
• International :Bénéficiez de collaborations internationales et de nombreuses opportunités de mobilité.
• Intrapreneuriat :Impliquez-vous dans des initiatives parallèles ou développez votre propre Business Unit.
• Management à l’écoute :Recevez un accompagnement personnalisé tout au long de votre parcours professionnel.

Nous nous engageons en faveur de la diversité et de l’inclusion. Nous encourageons les candidatures de toutes les personnes qualifiées, indépendamment du genre, de l’orientation sexuelle, de la race, de l’origine ethnique, des croyances, de l’âge, de l’état matrimonial, du handicap ou de toute autre caractéristique. Lire la suite

Description du poste

Rejoignez le service Receptionnists & Attendants à Genève, offrant un environnement dynamique. Bénéficiez d’opportunités de carrière enrichissantes.

Tâches

• Accueillir les clients du restaurant avec professionnalisme.

• Gérer les réservations de salons et optimiser leur utilisation.

• Coordonner avec la cuisine et le service pour un déroulement fluide.

Compétences

• Formation hôtelière supérieure et expérience en restaurant haut de gamme.

• Excellente présentation et rigueur dans le travail.

• Maîtrise de l’anglais et du français, sens de l’accueil.

Votre équipe

La division Real Estate & Logistics & Physical Security Group offre aux clients et aux collaborateurs du Groupe une gamme étendue de services; elle gère les bâtiments du siège du Groupe à Genève ainsi que ceux des filiales, succursales et bureaux de ce dernier en Suisse et à l’étranger, et en assure la sécurité physique.
Le service Receptionnists & Attendants de la division cherche, afin de renforcer ses équipes:

un/une Réceptionniste Restauration

Votre rôle

Vous aurez pour mission d’assurer l’accueil du restaurant destiné à la clientèle et à la direction, de gérer les demandes de réservation des salons et de coordonner avec les intervenants internes le bon déroulement du service (cuisine, service, visioconférence, etc.).

• Accueillir les clients du restaurant.

• Gérer les demandes de réservation de salons et en assurer une planification optimale.

• Rédiger et proposer les menus aux clients internes puis les confirmer aux équipes de cuisine et de service.

• Assurer la mise en place des salons selon les besoins, y compris le matériel technique.

• Effectuer divers travaux administratifs (courriers de confirmation, taux d’occupation, etc.).

• Participer ponctuellement à l’accueil lors d’événements exceptionnels.

Votre profil

• Formation hôtelière supérieure.

• Expérience significative en qualité de réceptionniste acquise dans un restaurant gastronomique ou un restaurant d’hôtel de luxe.

• Capacité à coordonner efficacement les activités liées à la réception du restaurant.

• Sens aigu de l’accueil d’une clientèle exigeante.

• Très bonne maîtrise des outils informatiques MS Office.

• Rigueur et aisance rédactionnelle.

• Français et anglais courants.

• Domicile en Suisse requis.

Votre capacité à travailler en équipe,  votre sens de l’organisation ainsi que votre aisance relationnelle constitueront de précieux atouts qui vous permettront d’accomplir avec succès les missions dont vous aurez la charge. D’excellente présentation et discret/e, vous êtes sensible à la notion de confidentialité et saurez accueillir une clientèle haut de gamme.

Ref: RFD/SBP/AD

Note

We will not accept any CVs via agencies

Diversity & Inclusion

Pictet is an equal opportunity employer and is committed to creating a diverse environment. We respect all individuals and seek their inclusion in the workplace. Lire la suite

Description du poste

CERN recherche un Ingénieur Logiciel passionné pour ses systèmes d’information.

Tâches

• Développer des solutions logicielles complexes en équipe.

• Optimiser les requêtes de bases de données et configurer des systèmes.

• Participer à l’amélioration continue des processus de l’équipe.

Compétences

• Diplôme en informatique et 2 ans d’expérience maximum exigés.

• Maîtrise de Java, Spring Boot, JavaScript et React.

• Compétences en systèmes de gestion de bases de données SQL.

Job Description

Your responsibilities
Are you a motivated Software Engineer with a passion for delivering complex and compelling information systems end-to-end? Are you at ease with server-side technologies, and also with writing frontends in JavaScript and not afraid to optimise database queries, to dive into data integration processes or configure and debug messaging/eventing systems? Do you enjoy working in an agile environment and a self-organized team? Then join our team of talented engineers and contribute to application software for CERN’s Corporate Information Systems. CERN, take part!
You will join the Business Computing (BC) group in the Finance and Administrative Processes (FAP) department, where 80+ talented international colleagues are responsible for delivering information systems for all of CERN’s business functions. The product management-driven Business Computing Group is working for clients across the whole organisation (HR, Finance, Planning, Safety, Security, Purchasing, Logistics, and Accelerator Operations).
The type of products under the group’s responsibility range from custom-made solutions for a few users to large and widely integrated systems with 15,000+ users. Hence, working for the BC group provides numerous perspectives for being in touch with different technologies and business areas.
As a Full-Stack Software Engineer in the Business Computing group, you will be part of a self-organised agile team responsible for the design, implementation, configuration and support of software solutions used across all of CERN.
Your day-to-day job will involve:
• Implementing and testing the solutions the team develops;
• Providing support for the final users;
• Participating in knowledge sharing activities;
• Supporting the continuous improvement of the team’s processes and dynamics in order to meet the objectives and service level agreements agreed upon together with the Product Manager.

Your profile
Skills
Required
• Experience in the design and development (incl. build/test/deployment tool chain) of full stack enterprise solutions built on top of industry standards (e.g. Java, Spring Boot, JavaScript, React and similar frameworks).
• Understanding of modern software design and architecture principles and patterns, and their application in the Java and JavaScript ecosystems.
• Knowledge of Git or equivalent VCS.
• Experience working with SQL , database systems, and their integration with Java applications.

Advantageous (please still consider applying if you don’t posses those yet):
• Knowledge of CI/CD tools like Gitlab or equivalent.
• Knowledge of containerized software solutions.
• Knowledge of GitOps software development workflows.
• Experience in maintaining and implementing features in legacy applications.
• Knowledge of PowerBI or a similar reporting solution.
• Knowledge of PL/SQL.

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

Eligibility criteria:
• You are a national of a CERN Member or Associate Member State.
• By the application deadline, you have a maximum of two years of professional experience since graduation in Computer Science / Computer Engineering (or a related field) and your highest educational qualification is either a Bachelor’s or Master’s degree.
• You have never had a CERN fellow or graduate contract before.
• Applicants without University degree are not eligible.
• Applicants with a PhD are not eligible.

Additional Information

Job closing date: 09.07.2025 at 23:59h CEST.
Contract duration: 24 months, with a possible extension up to 36 months maximum.
Target start date: 01-September-2025
This position involves:
• Work during nights, Sundays and official holidays, when required by the needs of the Organization.

Job reference: FAP-BC-ENG-2025-116-GRAE
Field of work: Software Engineering and IT

What we offer
• A monthly stipend ranging between 5196  and 5716  Swiss Francs (net of tax).
• Coverage by CERN’s comprehensive health scheme (for yourself, your spouse and children), and membership of the CERN Pension Fund.
• Depending on your individual circumstances: installation grant; family, child and infant allowances; payment of travel expenses at the beginning and end of contract.
• 30 days of paid leave per year.
• On-the-job and formal training at CERN as well as in-house language courses for English and/or French.

About us
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. Find out more on http://home.cern.

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. Lire la suite

Description du poste

CERN, l’Organisation Européenne pour la Recherche Nucléaire, explore l’univers.

Tâches

• Rejoindre un programme de bourses en physique expérimentale.

• Collaborer avec des chercheurs sur des projets innovants.

• Participer à des expériences utilisant des instruments complexes.

Compétences

• Doctorat en physique des particules ou discipline connexe requis.

• Compétences en recherche et analyse scientifique.

• Capacité à travailler en équipe internationale.

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. Find out more on home.cern/
Diversity has been an integral part of CERN’s mission since its foundation and is an established value of the Organization.

Job Description

Welcome to the Research Fellowship : Experimental Physics.
The Research Fellowship Programme is aimed at PhD holders in the fields of experimental physics which have up to 6 years’ experience after obtaining their PhD degree. Research Fellowships are intended for PhD graduates looking to work in a research group.

Please remember that you are applying for a programme and not for a specific job. If selected, you will have a free choice of research group. You may express your motivation for applying during the interactive online application process, and/or attach a separate motivation letter.  As our online application system only allows for alphanumeric values, an attachment may provide you with a greater freedom of expression.
Candidates holding a PhD (or about to hold one), whose specific field of interest is solely theoretical physics or in the fields of applied science and engineering, should consider to apply for the ‘Research Fellowship: Theoretical Physics’ or ‘Research Fellowship: Applied Physics and Engineering’, respectively.

Qualifications

In order to qualify for a place on the programme you will need to meet the following requirements:
• You are a national of a CERN Member or Associate Member State. A limited number of positions are also available to candidates from Non-Member States.
• You have or are about to obtain, a PhD in particle physics or in a closely related discipline aligned with the physics programme of CERN’s experimental facilities. If you have not obtained your PhD yet the defense date should be already scheduled, and your PhD completed within 6 months after the deadline of the publication of this position. In any event, you should have finished your PhD studies by the time you take up your appointment at CERN.
• You have no more than 6 years’ research experience after completion of your PhD degree at the deadline of the publication of this position.
• Please note that CERN Staff members are not eligible to apply for a Fellowship.

Additional Information

CERN would very much like to benefit from your expertise, commitment and passion. In return, CERN will provide you with:
• An employment contract for typically 24 months. A small number of outstanding candidates will be offered a 36 month fellowship.
• A stipend ranging from 6,808 to 7,218 Swiss francs per month (net of tax).
• Coverage by CERN’s comprehensive health scheme (for yourself, your spouse and children), and membership of the CERN Pension Fund.
• Depending on your individual circumstances: an installation grant, family, child and infant allowances as well as travel expenses to and from Geneva.
• 2.5 days of paid leave per month.

Your future Life @CERN
Get a glimpse of what it’s like to work at CERN: https://careers.cern/benefits and https://careers.cern/our-people
This is how you can apply:
You will need the following documents (in PDF format, as separate files) to complete your application:
• A CV.
• Your most recent relevant qualification.
• A statement of research interests focusing on your plans for the research fellowship (maximum one page and a maximum of 4000 characters).
• Three recent letters of recommendation (not older than a year at the time of the deadline for applications) giving an overview of your academic and/or professional achievements, indicating the professional relationship to the candidate. • You will be provided with a link as soon as you have submitted your application to forward to your referees to upload their letters confidentially. Please note this must be done before the closing date. You can also upload these letters at the time of the application if you have them to hand, but this is discouraged.

When filling in the online application form, you will also be asked to specify:
• Up to five most important publications to which you have made a significant contribution;
• Up to five international conferences or workshops at which you have given presentations;
• Up to five public or internal notes to which you have contributed personally;
• Up to three experiments in which you have participated.

All applications should reach us no later than 25 August 2025 at 23:59 CET.
The results will be approved at the selection committee meeting at the end of November 2025 , and candidates will be notified shortly after. It is expected that selected candidates start their contract within six months following the notification.
Please note that all the documents you upload will remain attached to your Smartrecruiters profile. You do not need to upload them again for other applications you might submit. Lire la suite

Description du poste

Rejoignez notre équipe de trésorerie au sein de Pictet, un leader en finance. Profitez d’une ambiance collaborative et d’un environnement dynamique.

Tâches

• Analysez les risques de trésorerie pour des rapports réguliers et ad hoc.

• Développez des modèles de simulation des risques pour optimiser la gestion.

• Collaborez avec le service informatique pour améliorer les outils de gestion.

Compétences

• Diplôme en finance, économie ou domaine technique avec 2-3 ans d’expérience.

• Compétences analytiques avancées et pensée conceptuelle.

• Excellente maîtrise de l’anglais et du français.

Your team

Corporate Functions includes the Group’s non-banking activities and employs more than 600 people. These functions are carried out by specialists with expertise across all business units, and include Communications, Compliance, Finance, Human Resources, Information Security, Internal Audit, Legal, Corporate Office, Risk and Tax departments.

As a member of the Group Treasury team within Group Finance, you will create in-depth analysis and presentations for senior management discussions related to interest rate and liquidity risk management. In addition, you will focus on regular maintenance and enhancement of key liquidity and IRRBB models. You will operate in an environment of increasing complexity (regulations, regionalisation, trapping of liquidity/capital, etc.) where the ability to think in a multidimensional way and to collaborate well across functions and jurisdictions is absolutely key.

Your role

•    Analyse all relevant treasury risks from a quantitative and qualitative point of view and provide comprehensive regular and ad-hoc analysis and reporting on these risks. Work actively to conceptualise, develop and optimise quantitative risk analysis models.
•    Focus on liquidity risk, interest rate risk, risk in the treasury investment portfolio and collateral management at the Group level as well as for all banks of the Group.
•    Develop and optimise models for risk simulation. Conceptualise new ways of analysing treasury risks and develop prototype models for that purpose.
•    Monitor the department’s needs in terms of IT systems; collaborate actively with the IT department in the development of new IT tools or the optimisation of existing ones.
•    Monitor the treasury investment portfolio; provide reporting on compliance with the limits imposed. Monitor the collateral quality of securities to determine their eligibility as liquid assets or for pledging purposes.
•    Monitor and manage collateral positions and requirements for securities pledging, repurchase agreements and central bank access.
•    Keep abreast of regulatory developments relating to treasury management (liquidity regulation, interest rate risk in the banking book). Identify needs to adjust aspects of treasury risk management (concepts, tools, models) arising from regulatory developments.

Your profile

•    Education/background in a technical field (mathematics, physics, engineering, IT, etc.) or in economics, finance or banking with in-depth technical, analytical and IT knowledge.
•    2-3 years of experience in a treasury-related role a plus.
•    Knowledge of banking and asset/liability management concepts and money/fixed-income markets would be a plus.
•    A strong interest in finance and financial markets is a must.
•    Knowledge of OneSumX by WKFS would be a strong plus.
•    Very good analytical skills and conceptual thinking, as well as programming skills in state-of-the-art programming languages.
•    Good command of standard office applications (Excel, Access and PowerPoint).
•    Results-oriented with strong attention to detail.
•    Pragmatic and strategic thinking.
•    Excellent command of French and English.
•    Must be resident in Switzerland or willing to relocate.

Note

We will not accept any CVs via agencies.

Ref.: TA/CC/OD

Diversity & Inclusion

Pictet is an equal opportunity employer and is committed to creating a diverse environment. We respect all individuals and seek their inclusion in the workplace. Lire la suite

Description du poste

Rejoignez le groupe Pictet, leader en gestion d’actifs. Opportunité d’évoluer au sein d’une équipe dynamique et innovante.

Tâches

• Gérer les impôts indirects (TVA/GST) du groupe Pictet.

• Conseiller sur la TVA en lien avec le secteur bancaire et la gestion de fonds.

• Superviser la conformité et effectuer des audits TVA.

Compétences

• Diplôme en droit, sciences économiques ou fiscalité requis.

• Expérience de 10 ans en TVA, de préférence dans le secteur financier.

• Maîtrise du français et de l’anglais, l’allemand est un plus.

Votre équipe

La division Corporate Functions regroupe les activités non bancaires du groupe Pictet et compte plus de 600 collaborateurs. Assurées par des spécialistes connaissant parfaitement l’ensemble des lignes de métier, les fonctions centrales se répartissent en divers départements: Audit interne, Communication, Compliance, Corporate Office, Finances, Fiscalité, Juridique, Ressources humaines, Risques et Sécurité de l’information.

La mission du département Fiscalité Groupe, basé à Genève, consiste à gérer la fonction fiscale du Groupe conformément aux lois et réglementations existantes et futures, en mettant en œuvre un cadre de contrôle des risques approprié et une gestion fiscale proactive pour protéger la réputation du Groupe, en offrant à nos clients une expérience fiscalement avantageuse et en maintenant des relations équitables avec les autorités fiscales.

Au sein de ce département, vous serez la personne en charge des impôts indirects du groupe Pictet et conseillerez les collaborateurs du Groupe et de diverses sociétés affiliées sur des questions se rapportant aux impôts indirects, en lien avec les opérations bancaires et la gestion d’actifs (clients institutionnels et fonds de placement).

Votre rôle

• Être responsable des impôts indirects (TVA/GST) du groupe Pictet.

• Fournir des conseils et une assistance sur divers aspects de la TVA suisse et internationale (notamment EU), y compris:

• TVA dans le secteur bancaire et financier,

• TVA applicable à la gestion et à l’administration de fonds de placement,

• réglementations et obligations en matière de TVA au niveau national et international.

• Superviser la conformité avec les réglementations en matière de TVA et les déclarations TVA du Groupe.

• Effectuer des audits TVA et formuler des recommandations basées sur les conclusions.

• Evaluer les risques liés à la TVA et concevoir des stratégies de réduction des risques.

• Collaborer avec d’autres départements pour intégrer les aspects TVA dans les processus internes.

• Participer à l’élaboration et à la mise à jour des politiques et procédures TVA du Groupe.

• Suivre l’évolution des lois et réglementations en matière de TVA et informer les différents acteurs des changements pertinents.

Votre profil

• Diplôme universitaire en droit, en sciences économiques ou en fiscalité.

• Au moins 10 ans d’expérience dans le domaine de la TVA, avec une spécialisation dans la TVA financière.

• Expérience acquise au sein d’un cabinet d’avocats ou de l’une des quatre grandes sociétés de conseil: un atout.

• Maîtrise des applications MS Office courantes.

• Maîtrise du français et de l’anglais indispensable; connaissance de l’allemand: un plus.

Note

We will not accept any CVs via agencies

Diversity & Inclusion

Pictet is an equal opportunity employer and is committed to creating a diverse environment. We respect all individuals and seek their inclusion in the workplace. Lire la suite

Description du poste

Rejoignez Pictet Tech, un leader en solutions financières innovantes. Participez à un environnement dynamique et stimulant.

Tâches

• Développer la stratégie technologique du Groupe Pictet pour 2030.

• Gérer les initiatives liées aux crypto-actifs et leur mise en œuvre.

• Collaborer avec les parties prenantes pour répondre aux besoins des clients.

Compétences

• Diplôme de Master et expérience significative en technologie digitale.

• Compétences analytiques et en leadership éprouvées.

• Excellentes compétences en communication et gestion du temps.

Your team

Pictet Tech division specializes in designing and integrating cutting-edge software applications, including advanced portfolio management systems, sophisticated trading platforms, and comprehensive banking and corporate solutions.
As a key contributor to the Group’s strategic advancements, Pictet Tech division plays a vital role in driving transformative innovations that enhance our services and deliver exceptional value to our clients.

In your new position, you will play a pivotal part in shaping Pictet’s technology ambitions. You will have a dual role; first, as a key contributor to define and drive Pictet Group’s Technology Strategy and second, as the product manager overseeing crypto-asset initiatives for the Group. You will be free to chart your own course toward achieving these goals, and will work closely with business stakeholders as well as senior Pictet Tech executives.

Your role

Technology Strategy

• Shaping a holistic technology strategy for the Pictet Group and defining key objectives for 2030, working closely with the Pictet Tech executive committee, their teams and business stakeholders.

• Ensuring progress towards these objectives is monitored and reporting up to senior executives.

• Driving the preparation, agenda and content for the annual Tech Deep-Dive, the purpose of which is to  ensure the Group’s top executives are aware of the latest technology trends and their implications for Pictet.

Product Management for Crypto-Asset Initiatives

• Defining and driving Pictet’s strategy on crypto-assets, covering crypto-asset custody, trading and asset tokenisation.

• Continuously monitoring market trends, emerging solutions and the competitive landscape.

• Driving key initiatives underpinning the overarching strategy, starting with the successful implementation of a crypto-asset custody and trading solution.

• Working with internal stakeholders from Compliance, Legal, Risk and Infrastructure to the Business to ensure that the solution meets our clients’ needs, as well as all of Pictet’s internal requirements.

• Defining a product roadmap with the business that captures early feedback from clients and the evolving nature of the space.

• Working closely with Pictet Asset Management (PAM) to define and implement the next tokenisation initiatives that could be differentiators for Pictet.

Your profile

• Master’s degree, or qualification deemed equivalent.

• Solid professional experience, including at least three years’ experience with a major consulting firm and/or corporate strategy group.

• Experience working in the field of digital technology.

• Excellent knowledge of the financial and tech industries.

• Best-in-class analytical capabilities: top-notch quantitative, problem-solving and conceptual skills.

• Solid people leadership skills: Ability to build and leverage the capabilities of a high-performing team, as well as business partners across the company.

• Strong interpersonal and communication skills, both spoken and written.

• High motivation and self-direction, taking personal ownership for results and professional development.

• Ability to manage multiple tasks simultaneously and to prioritise, thriving in a fast-paced, collaborative environment.

• Strong sense of professional ethics and integrity, with proven ability to maintain the utmost confidentiality.

Note

TS&IM/NVT/SB

We will not accept any CVs via agencies

Diversity & Inclusion

Pictet is an equal opportunity employer and is committed to creating a diverse environment. We respect all individuals and seek their inclusion in the workplace. Lire la suite