As part of outsourced management of business processes related to life insurance retirement with BNP (Cardiff insurance)
Mission
As part of outsourced management of business processes related to life insurance retirement:
Optimization of a 3 tier architecture information system and tuning the performance of the Oracle database:
Creating a capture trigger traces between the connection and disconnection of a user
Recovery and formatting of the trace with the utility TKPROF
execution plan analysis generated by the trace and operation of the implementation plan data in optimization manipulation
Improved PL / SQL code packages.
Creation and / or improvement of SQL queries.
Test and acceptance of SQL and PL / SQL
Automatedgeneration of financial reports
Creating VBA macros
Injection reporting data in the database with the Microsoft SSIS ETL
Oracle Production engineer
I worked as a production engineer specialized in Oracle databases within database expert team.
I am in charge of the production environment.
Mission:
Administration and Tuning Oracle Databases.
Providing automated processes for installing, configuring, upgrading, backup/restoring and managing databases.
Applying security patches + automating the process of patching
I am in charge of maintaining operational the IT environments ( production, development, test environments )
Resolving of incidents level 2 and 3
Giving support for project teams in the realization of defining the best databases solutions.
I worked as a service provider for Orange-France Telecom. I was the Oracle expert in charge of the implementation of a solution for Orange Group dedicated to the provisioning of Oracle DBMS environments. This solution aims to guarantee high availability in shared storage
Mission:
Define the database architectures
Define best practices to ensure the availability of Oracle environments
Provide automated processes for installing, configuring and managing environments
Automation of the current management processes
Operating Engineer / Production Oracle Databases
I worked as a consultant specialized in Oracle databases within database expert team.
I participate in studies dedicated to the evolution of architecture Oracle databases as well as ongoing projects.
I was also in charge of the production environment.s
Mission:
Defining Oracle database server backup policies and implementation of RMAN backup with NetBackup.
Setting up a backup specification for the SI
Automation of database administration tasks for Oracle via shell script
maintenance of production environments
Resolving incident level 2 and 3
DataGuard switchover / failover between Oracle Primary / Standby bodies
Administrator backup TSM- Tivoli Storage Manager
As part of an outsourcing project-type package with guaranteed results, I was in charge of Oracle databaseenvironment and also a TSM backup expert.
Mission:
Operating Engineer / Production Oracle Databases
Analyze the needs of functional changes and their impacts on existing infrastructure.
Administration and Tuning for Oracle Databases.
Setting up databases backup policies.
Restorations databases according to customer needs.
Duplication of databasesbetween production environments and non-production.
Into production of new applications.
Oracle DatabaseAdministrator
Mission
Administration and tuning the performance of an Oracle database in a production environment:
Implementation of database backup strategies by Oracle RMAN and cold off bases
Placing duplications of databases between production environments.
Backup and database restore hot / cold.
Installing and configuring the database
SQL development
Administration TSM Tivoli Storage Manager.
Getting no place TSM backup strategies (TDP Vmware, TDPOraclebaclient and backup files)
Set backup strategies TSM