Samir - Architecte ORACLE

Work EXPERIENCE

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

DBA ORACLE - SYBASE - MSSQL
Project: SGBD Support Team


06/2019 to 10/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


SOCIÉTÉ GÉNÉRALE BANK & TRUST (Luxembourg - LUX) 12/2016 to 05/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


BNP PARIBAS (Montreuil - FR)

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

04/2013 to10/2016


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


SOCIÉTÉ GÉNÉRALE BANK & TRUST (Luxembourg - LUX) 12/2016 to 03/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
•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/2014/2016, Sybase ASE/RS 15/16, 1000 DB
BNP PARIBAS (Montreuil - FR) BNP PARIBAS (Montreuil - FR)
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 2008, Sybase ASE/IQ/RS 15/16, 800 Databases

NATIXIS CIB (Paris - FR) 04/2011 to 04/2013
Dba production ORACLE - SYBASE 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

SOCIETE GENERALE (Paris - FR)09/2008 to 02/2011
Dba exploitation ORACLE
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) 02/2006 to 09/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) 01/2004 to 12/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 ********
CEGETEL (Défense - Paris FR)
06/2002 to 12/2003 DBA production SYBASE/ORACLE
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

SIT A (Paris) 07/2001 to 05/2002
Development Engineer
Project: Design of datamart decisional systems «tax invoice»
•Update of technical specifications detail
•Development of Shell scripts launched in ControlM
•Monitoring and analysis of log files in UNIX
•Use of the SQL*Loader tool to upload data
•Development and maintenance of program C
•Organization of tests before delivery in production
Technical environment: UNIX, Windows NT, Sun Solaris, oracle 9i, 200 Databases, C, PL SQL, SQLLoader