Youness Agrich

Expert Database Oracle Cloud Specialist| EXADATA

Salaire / Taux journalier

Cergy, France

Freelance

Peut venir sur site

Expertises

Oracle CloudOracle DatabaseMySQLBase de données SQLPostgreSQLMicrosoft SQL Server

Langues

AnglaisArabeFrançais

À propos

Introduction

Avec plus de 12 ans d’expérience dans l’IT, dont un parcours chez deux grands éditeurs de logiciels (Oracle et Sopra HR), je suis spécialisé dans la gestion et l’optimisation des données, les migrations complexes, et la conception d’architectures innovantes et performantes. Mon expertise en Data Management et intégration Cloud me permet d’accompagner les projets dans leur transformation numérique avec efficacité et créativité.

Liens

Expérience de travail

Advanced Services Engineer - Customer Success Services (CSS)

Oracle

nov. 2021 - déc. 2024

3 ans 2 mois

92700 Colombes, France

📌 𝐄𝐱𝐩𝐞𝐫𝐭𝐢𝐬𝐞 𝐚𝐧𝐝 𝐭𝐞𝐜𝐡𝐧𝐢𝐜𝐚𝐥 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐟𝐨𝐫 𝐯𝐚𝐫𝐢𝐨𝐮𝐬 𝐜𝐥𝐢𝐞𝐧𝐭𝐬 𝒂𝒏𝒅 𝒑𝒓𝒐𝒋𝒆𝒄𝒕𝒔: GRDF, ENEDIS, Total, France TV, La Banque Postale,Minister de la Justice... ________________________________________ 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗗𝗲𝘀𝗶𝗴𝗻 𝗮𝗻𝗱 𝗔𝗿𝗰𝗵𝗶𝘁𝗲𝗰𝘁𝘂𝗿𝗲: • Design and architecture of databases and Exadata infrastructures. 𝗘𝘅𝗮𝗱𝗮𝘁𝗮 𝗮𝗻𝗱 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻: • Migration of databases to Exadata environments, including upgrades to 19c/23AI. • Migration from SuperCluster to Exadata. 𝗧𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹 𝗔𝘀𝘀𝗶𝘀𝘁𝗮𝗻𝗰𝗲 𝗮𝗻𝗱 𝗦𝘂𝗽𝗽𝗼𝗿𝘁: • Assistance and support for DBAs on Exadata/Database environments. • Incident reporting, root cause analysis, and crisis meeting support. 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗢𝗽𝘁𝗶𝗺𝗶𝘇𝗮𝘁𝗶𝗼𝗻: • Performance tuning and query optimization (Baselines, SQL Profiles/Patches). • Implementation of Exadata best practices (Resource Manager, IORM, Flash Cache). 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗮𝗻𝗱 𝗔𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: • Setup and management of multitenant databases. • Preparation for application upgrades. • Backup/restore with ZDLRA and OKV. 𝗜𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻: • Implementation and qualification of technical procedures. • Configuration of Oracle Enterprise Manager Cloud Control and setup of ASR Manager. 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆 𝗮𝗻𝗱 𝗖𝗼𝗺𝗽𝗹𝗶𝗮𝗻𝗰𝗲: • Performance, configuration, and security reviews (DBSAT) to ensure database compliance. 𝗪𝗼𝗿𝗸𝘀𝗵𝗼𝗽𝘀 𝗮𝗻𝗱 𝗣𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀: • Delivery of workshops and presentations on new Database/Exadata features and best practices. ________________________________________

Sopra HR Software

août 2014 - déc. 2021

7 ans 5 mois

Région de Paris, France

Tech Lead Database

nov. 2015 - déc. 2021

6 ans 2 mois

Région de Paris, France

📌 𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 𝒂𝒏𝒅 𝑨𝒄𝒉𝒊𝒆𝒗𝒆𝒎𝒆𝒏𝒕𝒔: • Leadership and coordination of a team of 5 DBAs to ensure the management, optimization, and maintenance of databases. • Study DBA, active participation in modeling and R&D tasks for Pléiades and HR Access solutions. • High Availability: RAC administration and Red Hat Linux cluster for high availability and performance. • SAN Migration: EMC SAN migration to SAN PureStorage. • Tender Process: Participation in the tendering process until the delivery, installation, and configuration of the new platform. • Database Migration: Established procedures to migrate more than 400 databases to Oracle 19C multitenant. • Documentation: Writing of detailed technical documentation. • R&D Collaboration: Worked with R&D teams to improve data model design. • Performance Optimization: Optimized Oracle and MySQL databases, SQL, and PL/SQL. • Security: Administered database security, ensuring compliance and robustness. • Installation, operation, and administration of SQL Server 2012 databases. • Backup Optimization: Enhanced backup efficiency in terms of space and duration. • Metrics Extensions: Designed on-demand metric extensions with Cloud Control 13c. • Monitoring: Supervised infrastructure subcontractors and ensured SLA adherence. • RMAN Expertise: Managed backups and restores via RMAN. • Training: Trained and managed junior DBAs, fostering team expertise. • Application Availability: Ensured 24/7 application availability for business-critical services. ________________________________________ ⚙️ 𝑻𝒆𝒄𝒉𝒏𝒊𝒄𝒂𝒍 𝑬𝒏𝒗𝒊𝒓𝒐𝒏𝒎𝒆𝒏𝒕: • Databases: o 550+ Oracle databases (10g, 11g, 12c EE/SE/RAC, 19C EE/SE/RAC). o 15 MySQL 5 SQLSERVER . o 70 Linux database servers, 4 AIX servers. o 60 Linux application servers, 15 Linux web servers. • Storage: SAN EMC VNX/VMAX with 300 TB of database storage. • Tools and Applications: o HR Access, Pléiades. o JIRA, Cloud Control 12c/13c.

DevOps-Ingenieurin

août 2014 - déc. 2015

1 an 5 mois

La défense

📌 𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 𝒂𝒏𝒅 𝑨𝒄𝒉𝒊𝒆𝒗𝒆𝒎𝒆𝒏𝒕𝒔: • Design and Implementation: Designed and implemented production architectures for new projects. • Automation: Implemented configuration and automation tools to simplify deployment and update processes across the platform. • Performance Analysis: Analyzed and resolved anomalies related to performance and scalability of systems. ________________________________________ ⚙️ 𝑻𝒆𝒄𝒉𝒏𝒊𝒄𝒂𝒍 𝑬𝒏𝒗𝒊𝒓𝒐𝒏𝒎𝒆𝒏𝒕: • Platforms: Linux/Unix. • Monitoring and Logs: ELK Stack (Elasticsearch, Logstash, Kibana). • Containerization: Docker. • Tools: Git, Ansible, Jenkins.

Software Development Engineer

Sopra Steria

mars 2013 - août 2014

1 an 6 mois

La défence

📌𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 𝒂𝒏𝒅 𝑨𝒄𝒉𝒊𝒆𝒗𝒆𝒎𝒆𝒏𝒕𝒔: 𝗗𝗲𝘀𝗶𝗴𝗻 𝗮𝗻𝗱 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: • Participation in the design, development, and deployment of the DSN (Nominative Social Declaration) module for Pléiades/HR Access. • Implementation of compatible shell scripts for multiple platforms (Unix, Linux, Sun Solaris, HP, AIX, Cygwin, etc.). 𝗖𝗼𝗻𝘁𝗶𝗻𝘂𝗼𝘂𝘀 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: • Implementation of a continuous integration plan through Jenkins, including jobs for installation, automatic deployment on QA environments, and execution of NR tests. 𝗧𝗲𝘀𝘁𝗶𝗻𝗴 𝗮𝗻𝗱 𝗩𝗮𝗹𝗶𝗱𝗮𝘁𝗶𝗼𝗻: • Management and control of the entire testing and validation process, including bug monitoring and testing. • Oversight of qualification environments (installation, updates, maintenance, and support). 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗮𝗻𝗱 𝗠𝗮𝗶𝗻𝘁𝗲𝗻𝗮𝗻𝗰𝗲: • Participation in the maintenance and development of various modules of the Pléiades software. • Development, integration, qualification, support, and customer intervention. 𝑷𝒓𝒐𝒈𝒓𝒂𝒎𝒎𝒊𝒏𝒈 𝒂𝒏𝒅 𝑺𝒄𝒓𝒊𝒑𝒕𝒊𝒏𝒈: • Shell, PL/SQL, and Python scripting for automation and custom solutions.

System Administrator

TRACE

juin 2010 - déc. 2010

7 mois

Clichy, France

📌 𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 𝒂𝒏𝒅 𝑨𝒄𝒉𝒊𝒆𝒗𝒆𝒎𝒆𝒏𝒕𝒔: 𝗩𝗶𝗿𝘁𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻: • Design, installation, implementation, and administration of VMware (vSphere 5), including ESXi and vCenter Server. 𝗦𝗲𝗿𝘃𝗲𝗿 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: • Administration of Windows and Linux servers (OpenSUSE / Ubuntu). • Management of Oracle, Apache, MySQL, PHP, and POP3/IMAP services. • SNMP monitoring setup and management with Nagios. 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗼𝗳 𝗜𝗻𝘁𝗲𝗿𝗻𝗮𝗹 𝗧𝗼𝗼𝗹𝘀: • Developed internal tools using PHP, MySQL, CSS, Jquery, and XML to streamline operations and improve efficiency.

Technicien GTB

Btib

mai 2008 - oct. 2008

6 mois

91300 Massy, France

📌 𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 𝒂𝒏𝒅 𝑨𝒄𝒉𝒊𝒆𝒗𝒆𝒎𝒆𝒏𝒕𝒔: 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝗮𝗻𝗱 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻: • Creation and development of Niagara for GTB systems. 𝗖𝗼𝗺𝗺𝗶𝘀𝘀𝗶𝗼𝗻𝗶𝗻𝗴: • Field commissioning at Institut Gustave Goussy, ensuring smooth integration and operation. 𝗧𝗿𝗮𝗶𝗻𝗶𝗻𝗴 𝗮𝗻𝗱 𝗦𝘂𝗽𝗽𝗼𝗿𝘁: • Assisted in training integrators by creating detailed tutorials to facilitate onboarding and usage.

MOBILE APPLICATIONS DEVELOPER

SCORE MB

mai 2006 - oct. 2006

6 mois

91300 Massy, France

📌 𝑲𝒆𝒚 𝑹𝒆𝒔𝒑𝒐𝒏𝒔𝒊𝒃𝒊𝒍𝒊𝒕𝒊𝒆𝒔 𝒂𝒏𝒅 𝑨𝒄𝒉𝒊𝒆𝒗𝒆𝒎𝒆𝒏𝒕𝒔: 𝗔𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: • Developed a lone worker application using WindevMobile. 𝗪𝗲𝗯𝘀𝗶𝘁𝗲 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁: • Created and maintained a website using WEBDEV with MySQL as the database backend. 𝗠𝗮𝗶𝗻𝘁𝗲𝗻𝗮𝗻𝗰𝗲 𝗮𝗻𝗱 𝗦𝘂𝗽𝗽𝗼𝗿𝘁: • Provided maintenance and technical support for the tools developed, ensuring reliability and user satisfaction.


Formation

EFREI - Grande école du numérique

Diplôme d'ingénieur

2013 - 1900

Université Paris-Est Marne-la-Vallée

Bachelor’s degree

2009 - 1900

Université Paris-Est Créteil (UPEC)

Diploma for Electrical Engineering and Industrial Computing

2008 - 1900


Licences et certifications

Oracle Cloud Infrastructure 2024 Generative AI Certified Professional

Délivré le : juin 2024

Certifié par Oracle

Oracle Cloud Infrastructure 2024 Generative AI Certified Professional

Délivré le : juin 2024

Certifié par Oracle

Oracle Cloud Infrastructure 2023 Certified Architect Professional

Délivré le : avr. 2024

Certifié par Oracle

Oracle Cloud Infrastructure 2023 Certified Architect Associate

Délivré le : avr. 2024

Certifié par Oracle

Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate

Délivré le : févr. 2024

Certifié par Oracle

Oracle Autonomous Database Cloud 2023 Certified Professional

Délivré le : nov. 2023

Certifié par Oracle

Le meilleur endroit pour trouver votre prochaine opportunité

© 2026. Tous droits réservés.