Freelancer profile translated to English.
Back to original languageAbout Mohammed El Habib
With 8 years of experience as a Database Consultant, I apply all my skills and knowledge to serve my clients. My credo: be proactive, propose solutions, and be rigorous regarding the quality of deliverables. My listening and adaptation skills are also important qualities that allow me to work within different teams and correctly qualify needs.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- RYDGE ConseilTeam Lead Database AdministratorCONSULTING AND AUDITSOctober 2024 - Today (1 year and 8 months)Paris, FranceStudy and implementation of Azure Cloud architecture.Definition and implementation of the database team's roadmap.Implementation of a disaster recovery plan.Definition of the company's database policy (backup strategy, delivery process, alerting standards, etc.).
- Groupe TF1Senior SQL Database AdministratorPRESS AND MEDIAJanuary 2022 - July 2025 (3 years and 6 months)Boulogne-Billancourt, FranceStudy and implementation of Azure Cloud architecture.Migration of databases to Azure Cloud.Database monitoring:
- Use of DATADOG/ DEMONDOG tool.
- Use of SCOM tool.
- Automation of monitoring tasks via PowerShell scripts and Task Scheduler, $U, and AZURE DEVOPS pipelines.
- Development of Power BI reports for SQL environment statistics.
Database migration:- From SQL SERVER 2008, 2008R2 and 2012 to 2019, 2022.
- From a SQL SERVER engine to AZURE SQL Database.
Implementation of High Availability infrastructure ONPREM and on Azure Cloud:- AlwaysOn Availability Groups.
- FailOver Cluster Instance.
- Log Shipping.
Deployment of a new infrastructure under MS SQL Server 2019 and 2022 ONPREM and on Azure Cloud:- Installation and Configuration of new servers in Standalone and High Availability.
Installation and configuration of SSAS, SSIS, and SSRS servers ONPREM and on Azure Cloud.Development and deployment of SSIS packages.Implementation and maintenance of the backup plan via SQL Agent jobs.Implementation of security standards and rights management processes based on the principle of Least Privileges.Implementation of SQL server maintenance and patching processes.Implementation of a disaster recovery plan.Participation in needs specification workshops and data model design with development teams.Performance Analysis and Optimization:- Execution plan analysis.
- Index implementation.
- Query optimization.
Level 2-3 Database incident resolution.Incident management via ticketing system: ServiceNow.Use of Azure DEVOPS versioning tools. - COLAS DIGITAL SOLUTIONSSenior SQL Database AdministratorCIVIL ENGINEERINGNovember 2021 - December 2021 (1 month)Vélizy-Villacoublay, FranceDatabase monitoring:
- Use of SCOM tool.
- Automation of monitoring tasks via PowerShell scripts and Task Scheduler.
- Development of Power BI reports for SQL environment statistics.
Use of TFS, GIT versioning tools.
Recommendations
Be the first to recommend Mohammed El Habib
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master in Computer EngineeringUFR Mathematics Informatics Mechanics University of Lorraine2018- Gestion & Administration des bases de données. - Optimisation des performances de bases de données. - Modélisation et conception de bases de données. - Modélisation de DataWareHouse. - Conception d’ETL : Talend. - Méthodologie de gestion de projet : SCRUM. - Scripting : PowerShell, Shell - Stratégie DevOps - Langages de Programmation : JAVA/JEE, C/C++, C# , PHP, Angular JS, Xamarin, ASP .NET.
Certifications
- Certificate of Consulting in Organization and Change Management26 ACADEMY2020