Pause
Lecture
Moteur de recherche d'offres d'emploi GEODIS

Database Administrator BI H/F


Détail de l'offre

Informations générales

Entité de rattachement

GEODIS est un opérateur de la chaîne logistique se classant parmi les plus grandes entreprises dans son domaine en Europe et dans le monde. Rattaché à SNCF Logistics, qui est elle-même une branche du Groupe SNCF, GEODIS est le leader du Transport et de la Logistique en France et se place au quatrième rang européen. Son rayonnement international s'appuie sur une présence directe dans 67 pays et un réseau mondial qui relie plus de 120 pays.

Pourquoi nous rejoindre ?

Le Transport et la Logistique sont aujourd'hui un secteur clé de l'économie mondiale. En tant qu'acteur international majeur du marché, GEODIS a pour objectif la satisfaction totale de l'ensemble de ses parties prenantes, à commencer par celle de ses collaborateurs. Ce sont plus de 39500 collaborateurs à travers le monde qui partagent les mêmes valeurs d'engagement, de passion, de solidarité, de confiance et d'innovation, piliers de la stratégie du Groupe.

Ce poste est également ouvert à toute personne reconnue travailleur handicapé  

Référence

2022-9386  

Line Of Business

CORPORATE

Description du poste

Type de contrat

CDI-Temps plein

Fonction

Fonctions Support - Informatique

Intitulé du poste

Database Administrator BI H/F

Description de la mission

The objective of BI department is to collect, transform and distribute vetted operational, financial and sales data in a controlled and secured environment. To present this data in a meaningful way in both existing and future developed solutions, combined with predictive analytics models.

Objective / Purpose of the Job

The role of DBA within the BI department is mainly of a development DBA with some knowledge of production DBA responsibilities. The DBA plays a crucial role and is involved in many aspects of the BI department back-end and front-end solutions. The DBA will develop, optimize and monitor ETL feed from source systems, adjust BI databases to changes in source systems. The DBA will also participate in new projects and be a sounding board for new requests for solutions the BI department has been asked to develop. Together with ISSC the DBA will also manage servers and databases used in our solutions, implement updates, and help troubleshoot connectivity issues for developers, testers, and users.
Dimensions and Quantities

Global scope for Geodis Freight Forwarding

Key Accountabilities (including activities)

 Design and maintenance of SSIS packages
 Ability to write complicated yet efficient SQL queries and stored procedures for SQL Server Database
 Deploy database changes during release cycles
 Perform scheduled maintenance and support release deployment activities including after-hours and weekends
 Analyse, solve, and correct issues in real time
 Provide suggestions for solutions
 Assist developers with query tuning and schema refinement
 Refine and automate regular processes, track issues, and document changes
 Create and maintain technical design documentation
 Configure and maintain database servers and processes
 Ensure high levels of performance, availability, sustainability, and security
 Day-to-day management of all SQL database servers (GBI and PAT)
 Monitor system's health and performance
 Identify need for hardware / software upgrades or replacements
Specific remarks

 Hybrid WFH Model
 Flexible working conditions and hours, with occasional evening work. Some travel may be required, including international travelling

Training within first 12 months
 Introduction to Geodis group
 Introduction to FF/IT/BI
 Introduction to Global Business Intelligence (GBI) DB and Profitability Analysis Tool PAT) DB

Profil du candidat

Experience & Knowledge

 Advanced knowledge about SQL Server query and index tuning
 Sense of ownership and pride in your performance and its impact on company's success
 Critical thinker and problem-solving skills
 Team player
 Good time-management skills
 Great interpersonal and communication skills
 At least 2 years of experience in Database Support as a DBA
 At least 2 years of experience interfacing and collaborating with business owners, developers and teammates
 High Availability, Always On, Mirroring, Replication technologies
 ETL process using SSIS, Change Data Capture, Change Tracking
 Good knowledge of the T-SQL query language

Adaptability: The ability to adapt to and work effectively within a variety of situations, and with various individuals or groups
Teamwork : Ability to partner with others, identify/anticipate needs and proactively provide support
Commitment to quality : Actively and constantly looking for ways to challenge, monitor and improve the quality of work and processes (by competing against a standard of excellence) taking initiatives and creating systems.
Business Acumen : The understanding of the business, industry principles and overall performance, in terms of the finance, operational and profitability measures. Ability to apply this understanding to achieve results and to increase the performance and profitability of the company.

Temps de travail en %

100

Lieu de prise de service

Lieu de prise de service

Europe, Allemagne

Ville(s)

ALLEMAGNE

Critères candidat

Niveau d'études min. requis

BAC+5 / MASTER

Niveau d'expérience dans la fonction

Confirmé (5 à 10 ans d'expérience)

Langues

Anglais (Maitrise Courante)