CV Oracle Database Consultant : Recherchez le meilleur profil indépendant

Exemple de missions de Hicham,
Oracle Database Consultant habitant les Yvelines (78)

• Oracle Database Administrator (internship graduation)

  BNP Cardif Assurances
  Jan 2021 - Jan 2022

  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

  Technicalenvironment: Oracle 11g, VB.NET, VBA, SSIS, Oracle 10g

• Oracle Production engineer

  BNP PARIBAS - Geneva
  Jan 2021 - aujourd'hui

  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.

  Technical environment Oracle 12c, 19c, Oracle DataGuard, Linux RedHat, AIX, shell scripting

• Oracle consultant

  Orange - France Telecom
  Jan 2017 - Jan 2022

  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

  Technical environment: Oracle 12c, Oracle DataGuard, RedHat Linux, Netbackup, shell scripting

• Operating Engineer / Production Oracle Databases

  Agence de l’Eau Loire et Bretagne
  Jan 2015 - Jan 2017

  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.

• Atlantic M. Services
  Jan 2012 - Jan 2014

  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

  Technical environment Oracle 10g, SQL.

• Administrator backup

  TSM- Tivoli Storage Manager
  aujourd'hui

  Administration TSM Tivoli Storage Manager.
  Getting no place TSM backup strategies (TDP Vmware, TDPOraclebaclient and backup files)
  Set backup strategies TSM

  Technical environment Oracle 10g, 11g, SQL, Oracle Enterprise Manager, TOAD, ITIL V3, TDP for VM, TDPOracle TSM OC.