CV/Mission ORACLE SYBASE freelance

Résumé des missions de Samir,
freelance ORACLE SYBASE résidant dans le Val-de-Marne (94)

• DBA ORACLE - SYBASE - MSSQL Project: SGBD Support Team

  BNP SECURITY SERVICES & CIB (Pantin/Montreuil - FR)
  Jan 2019 - Jan 2022

  • RISE Project for moving IRP Sybase DB to Exadata Oracle DB
  • Tuning Queries/Design and DB in Oracle technology
  • Implement new features Oracle 18c for DIMENSION project
  • Projects migration from Sybase HP-UX to Sybase Linux
  • Tuning DB in MSSQL 16
  • Migrate MSSQL 2014 to MSSQL 2016
  • Administration in Sybase ASE/RS/IQ
  • Administration in Oracle
  • Administration in MSSQL

  Technical environment : WinNT, Linux, Oracle 11g/12c/18c, MSSQL 2014/2016, Sybase ASE/RS/IQ 15/16, 2000 DB

• DBA production POSTGRESQL - SYBASE - ORACLE - MSSQL

  SOCIÉTÉ GÉNÉRALE BANK & TRUST (Luxembourg - LUX)
  Jan 2016 - Jan 2019

  Administration POSTGRESQL
  • Support for Oracle, Sybase & MSSQL
  • Deployment Sybase Rep Server between Luxembourg and Paris SG BANK by MSA routes for Forex/Trade application
  • Databases Migration Sybase ASE 15.7 SunOS to ASE 16 Linux
  • Databases migration Oracle 11g to 12c
  • Migrate MSSQL 2005 to MSSQL 2016
  • Administration in Sybase ASE
  • Administration in Oracle
  • Administration in MSSQL
  • Tuning queries in Oracle & Sybase ASE

  Technical environment : SunOs, Linux, PosgreSQL 10,11 Oracle 11g/12c, SqlServer 2008/2016, Sybase ASE/RS 15/16

• Dba production SYBASE ASE/RS - ORACLE

  SOCIÉTÉ GÉNÉRALE BANK & TRUST(Luxembourg - LUX)
  Jan 2013 - Jan 2016

  MSSQL Project: GTS SGBD Support Team
  Support level 1-2-3 for Oracle & Sybase DB
  •Support level 1-2 for MSSQL
  •Deployment Sybase Rep Server between Luxembourg and Paris SG BANK by MSA routes for Forex/Trade application
  •Databases Migration Sybase ASE 15.7 SunOS to ASE 16 Linux
  •Databases migration Oracle 11g to 12c
  •Migrate MSSQL 2005 to MSSQL 2016
  •Administration in Sybase ASE
  •Administration in Oracle
  •Administration in MSSQL
  •Tuning queries in Oracle & Sybase ASE

  Technical environment : WinNT, SunOs, Linux, Oracle 11g/12c, MSSQL 2008, Sybase ASE/IQ/RS 15/16, 800 DatabasesTechnical environment : WinNT, SunOs, Linux, Oracle 11g/12c, MSSQL 2008/2014/2016, Sybase ASE/RS 15/16, 1000 DB

• Dba production ORACLE - SYBASE

  NATIXIS CIB (Paris - FR)
  Jan 2011 - Jan 2013

  ASE/IQ/RS - MSSQL Project: Databases team CIB/EX-SISP
  Administration and installation of Oracle databases with ASM
  •Administration and installation Oracle Dataguard
  •Tuning Oracle OLTP query for financial project Ubix et Sophis Equities/Commodities
  •Work in collaboration with Sophis Equities applications for the reinitializing of the sequences in trading tables
  •Implementation of the Oracle FlashBackArchive on Storm (Total Recall)
  •Administration in Sybase ASE/Sybase RS
  •Administration in SQLSERVER (Level 1)
  •Administration in Sybase IQ
  •Tuning in Sybase ASE

  Technical environment: Win NT, Sun Solaris, Aix, Oracle 10g/11g, MSSQL 2008/2012, Sybase ASE IQ RS 15, 1500 Databases

• Dba exploitation ORACLE

  SOCIETE GENERALE (Paris - FR)
  Jan 2008 - Jan 2011

  Project: Databases team Oracle-BDDF
  •Support, administration and assistance in the implementation of Oracle data bases in various applications.
  •Production assistance for level 2 and 3 support Migration Oracle 11gR2
  •New feature to Oracle 11g for development
  •Use Oracle Tuning Advisor for bottleneck issue in SQLqueries.
  •SQL development for setup to Oracle Advanced Queuing
  •Script for reloading all environments except production with DATAPUMP/External Table
  •Implementation of compression tools for Oracle 11g

  Technical environment: Unix, Win NT, Sun OS, Aix, HP, Oracle 10g, 300 SGBD, 5 To, PL/SQL, MEGA

• SOCIETE GENERALE (Paris - FR)
  Jan 2006 - Jan 2008

  Dba development/production ORACLE
  Project: Datamarts allowing to target customers for private and professional market
  •Work in collaboration with the project on technical architecture
  •Packaging and deployment in production
  •Migration Oracle 10g
  •Tuning SGBD/SQL query
  •Installation of Oracle Spatial for geo-localization(Géomarketing)
  •Use of Parallelism method for Query, DML et DDL
  •Scheduling of job for execution of SQL program
  •Implementation of composite partitioning for OLTP program
  •Sending of DBA alert reports from DB with UTL_MAIL
  •Analysis of AWR reports
  •Writing a document to advice for the development SQL

  Technical environment: Unix, Win NT, Sun OS, Oracle 10g, 22 Databases, 1 To, PL SQL, AMC Designer

• GROUPE CARREFOUR (Massy Palaiseau - FR)
  Jan 2004 - Jan 2005

  Dba development ORACLE
  Project: Implementation of a loyalty program for the Carrefou
  Design and concept of data model for a decisional system.
  •Tests, integration and production delivery
  •Implementation of partitioning for tables/index
  •Using STATPACK analysis tools
  •Tuning PL/SQL program (9i features)
  •Creation of a document on technical architecture
  •Macro Excel (VB) for loading a databases
  •Memory space management for databases

  Technical environment: Unix, Windows NT, HP-UX/Sun OS, Oracle 9i, 50 Databases, 600 Go, PL SQL, AMC Designer CV Samir ********

• DBA production SYBASE/ORACLE

  CEGETEL (Défense - Paris FR)
  Jan 2002 - Jan 2003

  Project: Customization of “SFR” billing system, “the 7” and “Universal Mobile”
  •Administration of Sybase ASE databases
  •Tuning of PL/SQL - Transac SQL
  •Writing of document of norms SQL-PL/SQL
  •Configuration and administration of Oracle Databases
  •Migration of data base to Oracle 9i
  •Work on execution plan for tuning of sql query
  •Tuning Oracle databases

  Technical environment: Unix, Windows NT, HP UX, Sun Solaris, oracle V8i/9i, sybase 12.5, PL SQL, SQL, Shell

• Dba production ORACLE - SYBASE ASE/IQ/RS

  BNP PARIBAS (Montreuil - FR)
  aujourd'hui

  Project: ITPS SGBD Support Team for the BP2S area
  
  • Administration in Oracle 11g
  • Databases migration project Oracle 11g _HPUX to 12c_Linux
  • Tuning queries in Oracle
  • Administration in Sybase ASE/RS/IQ
  • Installation Sybase IQ multiplex 15
  • Implementation of the HVAR option in Sybase RS
  • Deployment Sybase ASE16/IQ16 in Linux farm (40 VM)
  • Tuning in Sybase ASE/IQ
  • Installation of Sybase RS
  • Implementation of partitioning in Sybase ASE

• Dba production ORACLE - SYBASE ASE/IQ/RS

  BNP PARIBAS (Montreuil - FR) BNP PARIBAS (Montreuil - FR)
  aujourd'hui

  Project: ITPS SGBD Support Team for the BP2S area
  • Administration in Oracle 11g
  • Databases migration project Oracle 11g _HPUX to 12c_Linux
  • Tuning queries in Oracle
  • Administration in Sybase ASE/RS/IQ
  • Installation Sybase IQ multiplex 15
  • Implementation of the HVAR option in Sybase RS
  • Deployment Sybase ASE16/IQ16 in Linux farm (40 VM)
  • Tuning in Sybase ASE/IQ
  • Installation of Sybase RS
  • Implementation of partitioning in Sybase ASE

  Technical environment : WinNT, SunOs, Linux, Oracle 11g/12c, MSSQL 2008, Sybase ASE/IQ/RS 15/16, 800 Databases