Stéphane PAQUOT
years old

Architect - Database administrator (DBA)

Working experience

  1. AXA Investment Managers | 2005 today
    Database Architect - DBA

    Architecture design and setup :

    • data replication flows (reporting SAP Sybase IQ…).
    • high availability solutions.
    • replications between heterogeneous databases (SAP Sybase ASE / IQ, Oracle, Microsoft SQL Server…).
    • messaging flows in real time (SAP Sybase ASE RTDS to IBM MQ…).

    Global Skills :

    • Installations, normalizations, upgrades, backups/restores, maintenance, monitoring, capacity planning…
    • Performance & 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).

    Technical Expertise :

    • Oracle (RAC, ASM, Dataguard).
    • SAP Sybase Adaptive Server Enterprise, Replication Server and IQ.
    • Microsoft SQL Server. Mirroring, clusters et AlwaysOn.
    • PostgreSQL, MySQL, MariaDB.
    • InfluxDB Time Series.
  2. SGCIB - Société Générale Corporate Investment Banking | Avril 2003 Décembre 2004
    Production Database Administrator - DBA Production
    • GLOSS application : DBA production Sybase Adaptive Server Enterprise, Sybase Replication Server.
    • Microsoft SQL Server 6.5/7.0 databases normalizing.
  3. 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.
  4. 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).
  5. 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).

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).

Education

  1. 1997Degree in Chemical Engineering - Engineering School of Chemistry of Clermont-Fd.

Foreign languages

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

Skill matrices

    Experience :
  • Good
  • Medium
  • Little practice
  • Theory
  • Self-educated
  • Context
  • N/A
Administration
Maintenance, upgrade
Backups, restores
Performances & Tuning
Replication, standby
High availability
SAP Sybase - Adaptive Server
SAP Sybase - Replication Server
SAP Sybase IQ
Oracle
Microsoft SQL Server
MySQL
PostgreSQL
MariaDB Server - Column Store
TimeSeries - InfluxDB
IBM AIX
HP UX
Linux Red Hat
Linux Suse
Linux Ubuntu
Sun Solaris
Windows Server
Operating systems
Business Objects
Tableau
MS Reporting
Control M
Apache AirFlow
Informatica
Genio
Apache
ElasticSearch
Reporting, Schedulers, ETL, Web Server, Monitoring
Shell
PowerShell
SQL
T-SQL, PL/SQL
C, C++
HMTL, CSS, JS
PHP
Python
Go
Languages