CV
Stéphane PAQUOT Blog : https://www.sqlpac.com
Databases expert : architecture, administration, performances, modeling, development.
Explore and analyze the data where it is stored. Duplicate it with or without transformation only if necessary.

Architect - Database administrator (DBA)

  • UKG | April 2022 today
    Database Administrator - DevOps

    PostgreSQL, DevOps :

    • production (PostgreSQL 12).
    • deployment using Ansible (packages, versions, extensions…). Unit tests : Jenkins.
    • migrations from PostgreSQL 12 to PostgreSQL 13.
    • pgBouncer.
    • pgBackRest.
  • AXA Investment Managers | January 2005 November 2021
    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, SQL optimizations.
    • Maintenance tasks scheduling with Control-M tool.
    • Security (SSL, encryption, data level access…).
    • Audits.
    • Disaster Recovery strategies.

    Technical Expertise :

    • Oracle (RAC, ASM, Dataguard).
    • SAP Sybase Adaptive Server Enterprise, Replication Server and IQ.
    • Microsoft SQL Server. Mirroring, clusters, AlwaysOn.
    • PostgreSQL.
    • MySQL, MariaDB Server & ColumnStore.
    • InfluxDB suite (time series database, telegraf), Grafana reporting.
  • SOCIÉTÉ GÉNÉRALE - SGCIB | Avril 2003 Décembre 2004
    Production Database Administrator - DBA Production
    • GLOSS application : Sybase Adaptive Server Enterprise, Sybase Replication Server.
    • Microsoft SQL Server 6.5/7.0 databases normalizing.
  • 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.
  • SYBASE France | March 2000 February 2002
    Consultant and Trainer (Databases and Tools)
    • Technical support for Sybase customers : installations, Sybase Adaptive Server Enterprise 12.0 audit and tuning, PowerBuilder frameworks audits, PowerBuilder applications optimization.
    • Trainer : Transact-SQL, Adaptive Server Enterprise 12.0 administration level 1, Performance & Tuning, PowerBuilder (fast track, Datawindows, PFC PowerBuilder Foundation Classes, Advanced controls).
  • 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).