CV/Mission ORACLE SYBASE freelance

Exemple des emplois de Samir,
freelance ORACLE SYBASE résidant dans le Val-de-Marne (94)

• DBA ORACLE - SYBASE - MSSQL

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

  Project: SGBD Support Team
  
  • 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

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

  DBA production POSTGRESQL - SYBASE - ORACLE - MSSQL
  Project: GTS SGBD Support Team
  
  • 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

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

  Dba production SYBASE ASE/RS - ORACLE - MSSQL Project: GTS SGBD Support Team
  Support level 1-2-3 for Oracle & Sybase DB
  •Support level 1-2 for MSSQL
  �ployment Sybase Rep Server between Luxembourg and Paris SG BANK by MSA routes for Forex/Trade application
  �tabases Migration Sybase ASE 15.7 SunOS to ASE 16 Linux
  �tabases migration Oracle 11g to 12c
  •Migrate MSSQL 2005 to MSSQL 2016
  �ministration in Sybase ASE
  �ministration in Oracle
  �ministration 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 Databases

• Dba production ORACLE - SYBASE ASE/IQ/RS - MSSQL Project

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

  Databases team CIB/EX-SISP
  Administration and installation of Oracle databases with ASM
  �ministration 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)
  �ministration in Sybase ASE/Sybase RS
  �ministration in SQLSERVER (Level 1)
  �ministration 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

• Sybase ASE/RS 15/16, 1000 DB

  BNP PARIBAS (Montreuil - FR) BNP PARIBAS (Montreuil - FR)
  2008 - 2016

  Dba production ORACLE - SYBASE ASE/IQ/RS
  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 Technical environment : WinNT, SunOs, Linux, Oracle 11g/12c, MSSQL 2008, Sybase ASE/IQ/RS 15/16, 800 Databases

• Dba production ORACLE - SYBASE ASE/IQ/RS

  BNP PARIBAS (Montreuil - FR) BNP PARIBAS (Montreuil - FR)
  2008 - 2016

  Sybase ASE/RS 15/16, 1000 DB
  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 Technical environment : WinNT, SunOs, Linux, Oracle 11g/12c, MSSQL 2008, Sybase ASE/IQ/RS 15/16, 800 Databases

• 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
  𠈪nalysis 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

• Dba development ORACLE

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

  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)
  𠈬reation 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 MANI

• 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