
Youness Agrich
Expert Database Oracle Cloud Specialist| EXADATA
Salaire / Taux journalier
Cergy, France
Freelance
Peut venir sur site
Expertises
Langues
À 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é.
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
Oracle Cloud Infrastructure 2024 Generative AI Certified Professional
Délivré le : juin 2024
Oracle Cloud Infrastructure 2023 Certified Architect Professional
Délivré le : avr. 2024
Oracle Cloud Infrastructure 2023 Certified Architect Associate
Délivré le : avr. 2024
Oracle Cloud Infrastructure 2023 AI Certified Foundations Associate
Délivré le : févr. 2024
Oracle Autonomous Database Cloud 2023 Certified Professional
Délivré le : nov. 2023