Description de mission

Sales Solutions (SSo) is the IT department in charge of all IT systems providing transport tickets and related sales, validation and inspection tools for customers and employees of the STIB-MIVB. Applications/systems in scope of the department are:

• Mobib cards, transport tickets and validation machines used by the customers to pay for their transportation and get access to vehicles;
• Sales channels (GO sales automates, web sales applications, client sales applications, sales tools for commercial employees) enabling the acquisition of transport contracts by the customer through a variety of channels;
• Back-Office applications managing all customer data and sales processes including inter-operability with other transport operators in Belgium.

More specifically this person would work for the SSO Service Management team that target to improve services offered by the department to our clients by solving incidents, analysis and solving problems as well as giving guidelines to new projects and development.

We are looking for a technical analyst, specialist in database management, to contribute to:

Database Development

• Schema Design: Support the creating of the structure of the database, including tables, relationships, and constraints.
• Writing & Testing SQL Queries: Developing or supporting the development of queries to retrieve and manipulate data.
• Scripts: Creating and checking scripts to automate recurring tasks.

Technical Support

• DB Technical Support: Helping users resolve issues related to database usage.
• Maintenance: Updating and fixing incidents to ensure service continuity in the existing back-office platform (TBO).
• Release Management: Preparation and deployment of DB Installation package.
• Scheduling: Scheduling of redwood jobs for the entire department.
• Analysis: Analysis of data flows, transactions, incidents & problems linked to data or databases.
• Interface Management: With other databases or back offices.

Data Management

• Data Quality: Checking and improving the accuracy and consistency of data.
• Data Migration: Transferring data between different systems or DBMS versions.
• Data Correction: Correction of data in order for scripts/flows to perform adequately.

Project

• Analysis: Related to back office data synchronisation / cleaning via queries and scripts.
• Development, Test and Implementation: Of such synchronisation/cleaning scripts.

This work will be done in collaboration with the incident management teams as well as the Database Administrators and Data Architects.

Connaissance des langues

• Français ou Néerlandais : excellent
• Seconde langue Français ou Néerlandais : bon
• Anglais : bon

Informations additionnelles:
La mission peut être reconduite pour une durée maximale (durée initiale comprise) de : 880 jours ouvrables.