You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Arbi Y.AY

Arbi Y.

Senior Oracle DBA Certified ☆OCA,OCP,OCE TUNING☆

On-demand
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Arbi

Oracle DBA with over 15 years of experience, having worked on several versions of Oracle 8i.....19c (NON CDB, CDB)
Intense experience in administering large production databases (Banks and Insurance, Telephone Operators...)
- Implementation of Oracle new technologies solutions for clients: RAC, DATA-GUARD, STREAMS, Database Vault, Audit Vault Oracle Advanced Security, ...
- In-depth methodology for analyzing and diagnosing performance issues (SQL TUNING, AWR, ASH, DATABASE TUNING)
- Expertise in choosing the right backup and restore strategy as well as various database high availability techniques
- Database version migration
- Security audit operations and controlling access to Oracle databases by integrating Oracle techniques such as (Audit Vault, Database Vault, Database Firewall, Encryption, Oracle Data Masking, ...)
- Installation and heavy maintenance (reorganizations, patches, upgrades, ...)
- Monitoring of ORACLE databases (CLOUD CONTROL, TOAD,..)
  • French

    Native or bilingual

Can work on-site
Paris (up to 50km)

Experience

  • BPCE International
    Oracle Database Administrator
    BANKING AND INSURANCE
    January 2022 - Today (4 years and 5 months)
    Paris, France
     Administration of production/bench/dev Oracle databases
     Oracle database migration
     Level 3 analysis of production database issues
     Oracle Performance Tuning (Tuning performance issues (AWR, ASH, TKPROF, EXACHECK..........)
     Oracle SQL TUNING (Tuning SQL queries and helping developers optimize their processing time ....)
     Optimization of slowness issues at the SQL query level
     Oracle Maintaining HA DATABASE (Service creation, Dataguard, Flashback DB...)
     Oracle Dataguard (Troubleshooting issues at the dataguard level, DG broker, snapshot standby, physical standby, MRP, RFS .....)
     Oracle RMAN Recovery and backup (Restore, Recover rman backup, ZDLRA...... )
     Oracle Restore environment (Bench, Dev, Test, RMAN, CONVERT....)
     Patch installation: installation of RU patches as well as security patches and/or due to a bug
    Exadata SQL TUNING TUNING DATABASE Migration
  • Groupe Crédit Agricole
    Oracle Database Administrator
    BANKING AND INSURANCE
    June 2017 - December 2021 (4 years and 6 months)
    Île-de-France, France
    RAC 12c implementation Clusterware management Filesystem management ASM Migration Oracle databases Active Dataguard single instance from RAC primary Performance Monitoring (AWR report, Statspack, TAF, ORACHEK, RACCHEK, SQLT...) Security audit of databases (TDE Encryption, Role creation, privilege management ...) Duplication of databases for Pre-prod and acceptance environment RMAN backup restoration (Disks, TSM) Creation of snapshot standby for R/W needs on the standby database Oracle Golden Gate implementation Resolving operational issues (Corruption....) Installing patches at RAC and single instance level Data Export/Import Installation of Cloud Control 12c and agents (approx. 300 databases) Creation of operational scripts (Backup, Alert management, ASM disk space management Grid infra and clusterware management ASM storage migration to filesystem storage
  • ORADIST
    Oracle Database Administrator
    February 2014 - June 2017 (3 years and 4 months)
    Install and configure Oracle Database on various platforms (Unix, Windows, Aix..) Install and configure Oracle Cloud Control 13c Install and configure Oracle Cloud Control 12c Install and configure Oracle Grid Control 10g, 11g Install and configure Oracle Linux, Solaris, Redhat (Kernel parameters, Packages, users...) Install and configure Windows Server Perform Backup/Restore (RMAN) Generate backup scripts for clients (Full Database, Partial Backup, Incremental Backup) Perform restore tasks in case of client incidents Database duplication Preventive visit and generation of a report evaluating the database situation Implement Real Application Cluster (RAC) 10g, 11g, 12c. Implement Dataguard (Physical standby, Logical Standby) System performance management (Storage, Memory, Partitioning) Database performance management (SGA, PGA, Memory_Target, ASMM, AMM..) Generate reports and snapshots for performance studies (, AWR, Statspack) Configure standby site with Oracle Data Guard (Implementation and testing) Data Import/export Manage database storage structures (File System, ASM..) Manage database files (Alert, control, dbfiles..) Manage alerts (Alert files/trace files) Data migration on different platforms Client-side consulting and problem management Diagnose client databases and provide solutions for issues and meet their needs Manage server security (Database Vault, Audit Vault, Oracle Data Masking) OCE Trainer (ORACLE CERTIFIED SQL EXPERT) OCA Trainer (ORACLE CERTIFIED ASSOCIATE (DBA ADMINISTRATION)) (10g, 11g, 12c) OCP Trainer (ORACLE CERTIFIED PROFESSIONAL (DBA ADMINISTRATION)) (10g, 11g, 12c)

Recommendations

Be the first to recommend Arbi

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Certifications

  • ORACLE CERTIFIED TUNING
    ORACLE
    Performance Tuning
  • ORACLE CERTIFIED PROFESSIONAL OCP
    ORACLE

Skill set (10)

Categories

  • Other