Database administrator - Architect

Project

On the lookout for new challenges on innovative and ambitious projects, especially projects that combine SQL, noSQL machine learning systems… (design, project management, setup) with a deep knowledege of IT ecosystem components and the acquired expertise on relational databases SGBD-R (Sybase SAP, Oracle, Microsoft SQL Server…) in the architecture, administration, performance, modeling and development areas.

Working experience

  1. AXA Investment Managers | 2003 today
    DBA - Data Architect

    Oracle (RAC, ASM, Dataguard).

    SAP Sybase Adaptive Server Enterprise, Replication Server and IQ Server.

    Architecture design and setup :

    • data replication flows from SAP Sybase ASE to datawarehouses SAP Sybase IQ (bulk loads, Real Time Loading for IQ with SAP Sybase Replication Server).
    • messaging flows in real time from Sybase ASE to IBM MQ (Sybase RTDS).
    • replications between heterogeneous databases (Sybase, Oracle, Microsoft SQL Server).

    Microsoft SQL Server servers. Mirroring, clusters and AlwaysOn functiunalities.

    PostgreSQL and MySQL servers. Replication and standby.

    Installations, normalizations, upgrades, backups, maintenance.

    Performance and tuning.

    Maintenance tasks scheduling with Control-M tool.

    Security (SSL, encryption, data level access…).

    Audits.

    Disaster Recovery strategies.

    Technical support for development teams (releases, queries, optimization).

    Development of an intranet tool with PHP, Korn Shell, Python and Apache : inventory and statistics counters (growths, performances, capacity planning…).

    Monitoring with ElasticSearch.

    Operations analyst - Oracle database administrator (2003-2005)

    Dedicated technical support for Sophis software (Front Office) Oracle instances. Sophis DRT Servers (Reuters real time) maintenance and industrialization on Solaris platforms.

    Application jobs scheduling with Control-M tool.

    Incident resolation and application industrialization.

  2. BNP PARIBAS - BPSS Securities Services | March 2002 February 2003
    Database Administrator

    Technical support for development teams (releases, Adaptive Server Enterprise 12.0 Transact SQL optimization and tuning).

    Chorus software migration (Back Office accounting) from IBM AIX environments to HP-UX 11i, migration including Sybase Open Servers 12.0 compilations and non-regression testing on HP-UX 11i platforms.

    Post migration HP-UX 11i/Sybase ASE 12.0 performance monitoring.

  3. SYBASE France | March 2000 February 2002
    Database Administrator & Tools Consultant (PowerBuilder, PowerAMC…)

    Technical support for Sybase customers : installations, Sybase Adaptive Server Enterprise 12.0 audit and tuning, PowerBuilder frameworks audits, PowerBuilder applications optimization.

    Teacher training : Transact-SQL, Adaptive Server Enterprise 12.0 administration level 1, Performance & Tuning, PowerBuilder (fast track, Datawindows, PFC PowerBuilder Foundation Classes, Advanced controls).

  4. NATEXIS BANQUES POPULAIRES | September 1998 February 2000
    Client/Server Powerbuilder Developer

    ISIS Project (payroll simulation tool) : PowerBuilder 6.5, Oracle 7.3 (PL/SQL).

    PERSE 2000 Project (payroll system management) : PowerBuilder 6.5, Sybase 11.9.2 (T-SQL).

Education

Profesional trainings

  1. 2017Apache Spark and Hadoop for developers (Xebia).
  2. 2015Oracle 11g R2 RAC Real Application Clusters - Administration (Oracle France).
  3. 2011Build Android applications for smartphones (IFB).
  4. 2010Sybase Replication Server - Mastering (Sybase France).
  5. 2009Oracle 10g R2 - Performance and tuning (Oracle France).
  6. 2008Sybase IQ 12.6 - Performance and tuning (Sybase France).
  7. 2007Sybase IQ 12.6 - Administration (Sybase France).
  8. 2006Sybase ASE 15.0 - New functionalities(Sybase France).

Foreign languages

  1. FrenchNative speaker.
  2. EnglishGood working knowledge (First Certificate in English of Cambridge, 1997).
  3. SpanishModerate.

Education

  1. 1997Degree in Chemical Engineering at Engineering School of Chemistry of Clermont-Fd (Inorganic materials option).

Skill matrices

    Expérience :
  • Good
  • Medium
  • Little practice
  • Theory
  • Self-educated
  • No practice, enterprise context
  • N/A
Administration
Maintenance, upgrade
Backups, restores
Performances & Tuning
Replication, standby
High availability
SAP Sybase Adaptive Server Enterprise (11.516)
SAP Sybase Replication Server (1215.7)
SAP Sybase IQ (12.716)
Oracle (712c)
Microsoft SQL Server (20002017)
MySQL (45.7)
PostgreSQL (910)
MariaDB Server MariaDB Column Store
IBM AIX
HP UX
Linux Red Hat
Linux Suse
Linux Ubuntu
Sun Solaris
Windows Server
Operating systems
Business Objects
Tableau
MS Reporting
Apache SuperSet
Control M
Apache AirFlow
Informatica
Genio
Apache
Nginx
ElasticSearch
Reporting, Schedulers, ETL, Web Server, Monitoring
Shell
PowerShell
SQL
T-SQL, PL/SQL
C, C++
HMTL, CSS, JS
PHP
Python
Go
R
NodeJS
Java - Android
Languages