CV Stéphane PAQUOT - English Version

Skills

RELATIONAL DATABASE ENGINES

Sybase Adaptive Server Enterprise 11.9.2, 12.0, 12.5.x, 15.0.x & 15.5.
Sybase Real Time Data Services 3.1 & 4.0. Sybase Real Time Events 2.1.
Sybase Replication Server 12.0, 12.6, 15.2 & 15.5.
Sybase IQ 12.7, 15.1 & 15.2.
Sybase DirectConnect for Oracle and MS SQL Server 12.6.
Sybase Adaptive Server Anywhere versions 8 to 11.0.
Oracle 8i, 9i, 10g & 11g.
MS SQL Server 7, 2000, 2005 & 2008. MS SQL Server 2005 & 2008 R2 Cluster edition.
MySQL 4.1, 5.0 & 5.1.

SYSTEMS

Sun Solaris SPARC & x86. SunOS 6, 8, 9 & 10. ZFS.
HP-UX 11i.
Linux RedHat.
Windows Server NT, 2000 & 2003.

SCRIPTING LANGUAGES

Bourne Shell, Korn Shell, C-Shell.
C, C++.
PHP 4 & 5. TCPdf, JPGraph.
Database procedural programming languages : T-SQL, PL/SQL.

TOOLS

BMC ControlM 6.1 & 6.3 (scheduler).
Sybase PowerBuilder 5, 6.5, 7 & 8.
Borland C++.
Microsoft ADO.NET 2.0 (Factories), 3.0 & 3.5 (Entity Framework).

CAP (Computer Aided Design)

GIMP.
Scribus.

Professional Experience

AXA Investment Managers : Since March 2003 (7 years) - in position

DBA

(Financial sector)

Sybase Adaptive Server Enterprise (11.9 - 12.0 - 12.5 - 15.0 - 15.5) and Replication Server (12.0 - 12.5 - 15.1 - 15.5) on Solaris plaforms 6, 8, 9 & 10 : installation, industrialization, migration, tuning, configuration settings and maintenance.
Sybase Real Time Data Services for MQ setup (Sybase Adaptive Server Enterprise 12.5.3a). With this technology, messages are sent in real time from Sybase Adaptive Server Enterprise to IBM MQ Series messages bus.
Sybase IQ 12.7, 15.1 & 15.2 on Solaris 10 platforms : installation, configuration settings, industrialization and maintenance. Mass loadings from Sybase Adaptive Server Enterprise to Sybase IQ setup.
Real Time Loading for Sybase IQ with Sybase Replication Server 15.5 RTL Edition. Replication setup from Sybase ASE data sources to Sybase IQ datawarehouse.
ZFS benchmarks and configuration settings with Sybase Adaptive Server Enterprise, Sybase IQ and Oracle on Solaris 10 platforms.
Sybase heterogeneous replication setup to Oracle and MS SQL Server using Sybase Replication Server with Direct Connect for Oracle (DCO) and Direct Connect for MS SQL Server (DCM) components. .
Sybase Adaptive Server Enterprise migrations from version 12.0 to 12.5.3 and from version 12.5.3 to 15.0.x.
Oracle (8.1.7 - 9.2 - 10.2 - 11.2) on Solaris plaforms 8, 9 & 10 : installation, industrialization, migration, tuning, configuration settings and maintenance.
MS SQL Server (7 - 2000 - 2005 - 2008) : installation, industrialization, configuration settings and maintenance. Mirroring with witness and clusters setup with SQL Server 2008 R2.
Technical support for development teams (releases, queries, optimization). ADO.NET client access layers support : factories, entity framework.
Dedicated technical support for Sophis software (Front Office) Oracle instances. Solaris Sophis DRT Servers (Reuters real time) maintenance and industrialization.
Development of an intranet tool with PHP,Korn Shell and Apache : inventory and statistics counters (performances, CPU, I/O, caches usages...).

BNP PARIBAS (BPSS Securities Services) : March 2002 - February 2003 (1year)

DBA

(Financial sector)

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 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 (2 years)

DBA & Tools Consultant

Technical support for Sybase customers : installations, Sybase Adaptive Server Enterprise 12.0 audit et 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).

NATEXIS BANQUES POPULAIRES : September 1998 - February 2000 (2 years)

ARMÉE DE L'AIR (French Air Force, B.A. 102 de Dijon) : October 1997 - July 1998 (10 months)

SOLLAC Fos Sur Mer : March 1997 - September 1997 (7 months)

Education

Qualification

1997 : Degree in Chemical Engineering at ENSCCF (Engineering School of Chemistry of Clermont-Ferrand - France). Inorganic materials option.
1992-1994 : 2-year intensive program preparing for the national competitive exam for entry to French engineering schools, Dijon.
1992 : Baccalauréat série C, equivalent to an A level specialized in Sciences.

Foreign Languages

French : Native speaker.
English : Good working knowledge (First Certificate in English of Cambridge, 1997).
Spanish : Moderate.

Database administrator Sybase, Oracle, MySQL & MS SQL

Analysis, Modeling, Development, Administration, Performances and Tuning, Knowledge Transfer