Freelancer profile translated to English.

Description

Expert Oracle PL/SQL – Optimization SQL, Performance & Development

Are your Oracle processes too slow? Do some SQL queries take minutes or hours to execute? Do you want to make your PL/SQL code more reliable and optimized?

I work as an Oracle PL/SQL expert to analyze, correct, and optimize your databases and critical processes.

With several years of experience in demanding environments, I help companies improve performance, reduce processing times, and implement robust, maintainable, and scalable solutions.

My services:

• Development of PL/SQL packages, procedures, functions, and triggers

• Optimization of complex SQL queries and performance improvement

• Analysis of execution plans and resolution of slowness issues

• Oracle SQL/PLSQL code audit and review

• Data model design and evolution

• Oracle APEX application development and maintenance

• Automation of business and regulatory processes

• Optimization of batch processes and Data Warehouse loading

• Diagnosis and correction of production anomalies

• Implementation of best practices for development and code quality

Skills:

Oracle Database, PL/SQL, SQL, Oracle APEX, Performance Tuning, Query Optimization, Data Warehouse, ETL, Python, Git, Linux.

My approach:

✔ Analysis of the existing situation and identification of blocking points

✔ Proposal of solutions adapted to business and technical constraints

✔ Development, optimization, and testing

✔ Documentation and support until production deployment

My goal is to provide reliable and high-performance solutions with a measurable impact on processing times, data quality, and operational efficiency.

Industry field of expertise

Languages

Arabic
Native or bilingual
English
Conversational
French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Bouygues Telecom
PL/SQL Expert
TELECOMMUNICATIONS
March 2025 - Today (1 year and 5 months)
Rabat, Morocco
Oracle PL/SQL Expert – Bouygues Telecom

Involved in development and optimization projects around Oracle databases in a high-volume data telecom environment.

Key achievements:

Development of stored procedures, functions, packages, and PL/SQL triggers.
Design and maintenance of critical Oracle components for business applications.
Optimization of complex SQL queries and performance improvement of processes.
Analysis of execution plans and resolution of performance issues.
Participation in the design and evolution of data models.
Development of batch processes and automation of data management processes.
Correction of anomalies and evolutionary maintenance of applications.
Execution of unit tests and validation of developments.
Writing technical documentation and support for project teams.
Collaboration with business and technical teams in an Agile context.

Technologies: Oracle Database, PL/SQL, SQL, SQL Developer
Oracle Database Oracle PL/SQL SQL/PLSQL
wafasalaf
PL/SQL Consultant
BANKING AND INSURANCE
March 2023 - March 2025 (2 years)
Casablanca, Morocco
Participation in strategic projects for the transformation and optimization of information systems at Wafasalaf.
Key achievements:
Development and maintenance of Oracle PL/SQL procedures, packages, and functions.
Design, population, and optimization of Data Warehouses.
Development of business applications with Oracle APEX.
Implementation of automation solutions for business and regulatory processes.
Automation of extractions and reports for business and audit teams.
Development and optimization of data integration flows.
Analysis and performance improvement of batch processes and SQL queries.
Quality control, data validation, and enrichment.
Development of Python automation services and tools.
Diagnosis and resolution of production incidents.
Close collaboration with business teams for the definition and implementation of functional requirements.
Writing technical documentation and user support.
Technologies: Oracle Database, PL/SQL, Oracle APEX, SQL, Python, ETL, Data Warehouse, REST API, Git.
Oracle PL/SQL Oracle Apex SQL Python Extract, Transform, Load (ETL)
Label'vie
Data Consultant
RETAIL (LARGE RETAILERS)
June 2021 - December 2022 (1 year and 6 months)
Skhirate, Morocco
Participation in Data projects for the Digital Department with the aim of improving the quality, reliability, and value of data for business purposes.

Key achievements:

Analysis, extraction, and transformation of data from multiple systems.
Implementation of data quality and integrity controls.
Development and optimization of data loading processes.
Participation in the design and evolution of data models.
Creation and automation of reporting and steering indicators.
Identification and correction of data anomalies.
Contribution to the improvement of data governance and reliability.
Collaboration with business teams to understand needs and propose adapted solutions.
Optimization of process and SQL query performance.
Documentation of processes and developments carried out.

Technologies: SQL, Oracle, PL/SQL, ETL, Data Warehouse, Reporting, Data Quality, Python.
Oracle Database SQL Server SQL/PLSQL Python Programming Reporting