ZJFreelancer profile translated to English.
Back to original languageAbout Zakaria
With over 17 years of experience in banking and telecommunications, I specialize in the optimization, upgrade, and maintenance of highly secure databases.
I administer environments that comply with military programming law standards and PCI-DSS standards. I work on various operating systems: Windows, Linux, UNIX. I am proficient in a variety of technologies, including Oracle, MySQL, MariaDB, MS SQL Server, PostgreSQL, and Apache HTTP Server.
I also manage high availability environments (Oracle RAC, Galera cluster, MySQL InnoDB Cluster, SQL Server Always On) and have a strong ability to adapt to new technologies.
French
Native or bilingual
Arabic
Native or bilingual
English
Fluent
Can work on-site
Boulogne-Billancourt (up to 50km)
Experience
- Crédit Agricole Group Infrastructure Platform (CAGIP)Expert Database AdministratorJanuary 2022 - Today (4 years and 5 months)Paris, FranceITS Group for Crédit Agricole Group Infrastructure Platform (CAGIP) Paris, France• Management of a fleet of critical databases implementing the military programming law.• Oracle database patch management.• Development of automation scripts for patching and relinking Oracle binaries, as well as other recurring tasks.• Incident management (ITIL).• Administration and maintenance of Oracle databases (12c, 19c), MySQL (5.6, 5.7, 8.0), PostgreSQL, MySQL InnoDB Cluster.• Optimization of databases and SQL queries, performance tuning of Oracle databases using ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and Grid Control 12c.• Hardening of database environments.• Backup and restore: RMAN, DDBoost, TSM• Participation in IT disaster recovery plan exercises.• On-call support.
- Maroc Telecom |Senior Database AdministratorJanuary 2012 - January 2021 (9 years)Rabat, RZ, Morocco• Managed over 300 databases in various environments (development, testing, infocenter, and production), with databases reaching over 50 terabytes.• Provided Level 3 technical support for database incidents.• Administration and maintenance of Oracle databases (10g, 11g, 12c, 18c, 19c), MySQL (5.6, 5.7, 8.0), and SQL Server (2008, 2012, 2014, 2016).• Optimization of databases and queries, performance tuning of Oracle databases using ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and Grid Control 12c.• Conducted security audits of Oracle databases.• Integrated production databases into monitoring tools: Oracle Grid Control 12c and HP Sitescope.• Implemented backup and restore scripts for Oracle, MySQL, and SQL Server databases on Windows, Linux, and UNIX environments.• Optimized the configuration management database under PostgreSQL 9.3: achieved a 50% gain in processing speed.• Responsible for the sensitive data masking project.• Responsible for database patching operations for a team of six people.• Implemented a high availability environment for MySQL 8.0 and Oracle 18c databases using a cluster system on RedHat.• As part of the business continuity plan, drafted procedures for failover from the production site to the backup site.• Implemented a MariaDB high availability solution based on Galera Cluster, HAproxy, and Keepalived.• On-call support and resolution of production incidents.
- Maroc TelecomDatabase AdministratorJanuary 2008 - January 2012 (4 years)Rabat, RZ, Morocco• Configured ArcSight, a security information and event management tool.• Ensured cloning operations of production environments and anonymization of sensitive data.• Participated in disaster recovery plan tests.• Configured an active-passive MySQL and Oracle cluster on RedHat based on Pacemaker and Heartbeat.• Performed administration tasks on Sun Solaris and RedHat systems.• Supported project teams during development, acceptance, and go-live phases.• Provided monthly on-call support, 7 days a week.
Recommendations
Be the first to recommend Zakaria
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
- State Engineer's Diploma in Computer Science.National School of Applied Sciences2007Diplôme d'ingénieur d'Etat en informatique.
- Master of Science in Computer EngineeringNational School of Applied Sciences2007Diploma of Computer Science Engineer
Certifications
- Red Hat Enterprise Linux Automation with Ansible (RH294)Red Hat2024