Freelancer profile translated to English.

Description

I am an expert in Oracle database management and administration with over 12 years of experience in production environments and project work. I have assisted various clients in the design and implementation of Oracle database structures, the establishment of database backup strategies, administration and performance tuning tasks, as well as security and database encryption issues.

Languages

French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

TOTSA (Total Oil Trading SA) - Geneva
Oracle and SQL Server Database Engineer
ENERGY AND UTILITIES
March 2023 - Today (3 years and 5 months)
Genève, Switzerland
Operational maintenance of Oracle and SQL Production environments. Implementation and maintenance of a Dataguard architecture for Oracle databases. Implementation and maintenance of an AlwaysOn architecture for MSSQL databases. Resolution of Level 2 and 3 incidents. Automation of Oracle operational processes using bash scripting. Application of security patches: PSU patching for Oracle and SQL Server KB according to releases. Participation in the implementation of a Data Protect backup strategy with DDBOOST. Participation in the study of migrating Oracle standalone to RAC. Migration of Mongo On-Prem database to Cloud Atlas. Production deployment, application releases. On-call interventions.
Oracle 19c, DataGuard, RAC, AlwaysOn
bnpparibas
Oracle Database Expert Production Engineer
BANKING AND INSURANCE
January 2022 - February 2023 (1 year and 2 months)
Genève, Switzerland
I work as a production engineer specializing in Oracle databases within a database expertise team.

Mission:

Operational maintenance of the Oracle production environment and preventive maintenance of Oracle databases.

Automation of Oracle operational processes using bash scripting.

Application of security patches; PSU patching.

Resolution of Level 2 and 3 incidents.

Implementation of TDE encryption.

Implementation of SSL encryption via Oracle Wallet.

Assisting project teams in defining the best database solutions with budget estimation.

Production deployment.

On-call interventions.

Oracle Database Dataguard RAC Always on
ORANGE
Senior Oracle Consultant – Oracle Database Integrator
TELECOMMUNICATIONS
June 2018 - January 2022 (3 years and 7 months)
Saint-Quentin-en-Yvelines, France
Senior Oracle Consultant – Oracle Database Integrator.

I act as an Oracle expert in the implementation of an Orange group solution dedicated to provisioning DBMS environments under Oracle.

Mission:

Automation of Oracle operational processes using bash scripting:

• Automation of Oracle database instance creation for versions 11g, 12c, 18c, and 19c.

• Automation of Oracle engine cloning for projects on shared environments for versions 11g, 12c, 18c, and 19c, including binary relinking.

• Implementation of Oracle Rman backup on disk and tape for Netbackup and DDBoost backup tiers.

• Automation of DataGuard replication between the primary node of a VCS cluster and the DataGuard node with automated creation of physical and/or logical standby databases.

• Defining Oracle database architectures according to project needs.

• Automation of Oracle duplication via Rman for standby database creation.

• Database performance optimization.

• Application optimization of schemas, PL/SQL packages, SQL queries.

• Level 3 support to projects on Oracle incidents.

• High availability: Automation of Oracle machine switches between primary and standby nodes with Veritas VCS.

• Implementation of Oracle monitoring with Nagios, Patrol….

Technical environment:

Oracle 11g, 12c, 18c, 19c; Oracle RMAN, DataGuard, OEM, Veritas VCS, Linux RedHat, Netbackup, DataDomainBoost, shell scripting, Nagios/Patrol monitoring
Oracle 11g, 12c, 18c, 19c ; Oracle RMAN, Shell scripting Dataguard