Hervé - Administrateur Sql Server / Oracle / Postgress / Sybase

Dba for production and development environment. The Scope is oracle / slq server / Sybase . The goal is too maintain and to migrate the RDBMS in collaboraton with the system’s Team and developper’s Team. Involve in a process of migration sql server ( 2012  2016) with a log shipping system .

Participation in a migration sybase from 12 on AIX to Sybase 16 on linux. Development of a test and migration test with a 3 Tiers architecture ( Jaguar from Sybase)

Optimisation and migration of the BI environnement from BI suite 2012 to BI suite 2016 from Microosfot (SSRS / SSIS / SQL SERVER / SSAS). The project includes sql optimisation ; algorithmic optimisations (sql) but also query optimisation in sql server & oracle 12c.

Decathlon postgres / sql server / oracle DBA & Middleware administrator.

I am working in the operation team for the oneID/CRM (mydecathlon identification) scope. The used technologies are postgres / oracle / sql server andtomcat /apache on linux with database running around the world (europa / russia / china…) We are doing migration (from oracle , sql server , postgres), administation, performance and tuning on linux system. We are doing maintenance operation , call duty , surveillance (through nagios) , standby database to deliver a system up & running 24H/7days.
Postgres 9.2 – 9.6 ; SQL Server 2012 / 2014 ; Oracle 11gr2 & 12c
Linux Red Hat / CentOs , Tomcat 7 & 8 , java 8 , Apache 2.2 & 2.4
Tools: rundeck, Foreman , git ,Flyway , Docker , Rancher, AWS , F5 & ELB

DBA Sql server

Performance and tuning on an environment SQL SERVER 2014 with client cobol microfocus : profiler, trace plan , sql entry explorer....

Audit of an environment POSTGRESS , validation of performance and backup system

DBA MS Sql Server 2008&2012&2014

DBA production & development, we execute the DBA's tasks on environnment SQL SERVER 2012 & 2014 with reporting server, SSIS , Alwayson technologie , virtual machine , veeam backup and so on .....

BI TEACHER

Teacher on BI technologies (SSRS SSIS SSAS) The goal is also too demonstrate how to deploy a olap project ; to see difference between the tabular & maultidemntionnal model and so on

DBA oracle

DBA development production architecture on oracle platform (AIX 10Gr2 & 11Gr2) and Sql Server (2008&2012). I am principally involved in a migration project (oracle 10Gr2 11gR2 12c for 50 databases) and on grid control administration (detection of errors / resolution of errors / improvement of the system)

DBA sql server - DB2 – oracle 11Gr2

DBA production & development, responsible for administration, backup/Recovery Tasks , also involved with development Team to define standards and solution selection.
We are also involded in a Curam project with a target's platform DB2 & Websphere
We are using Microsoft SQL Server 2005 & 2008 & 2012, DB2 V10.5 and DB2
platform with SSIS and Reporting Services.

DBA Oracle&SQL Server & SYBASE &SYBASE IQ & mysql:

DBA production & architect , responsible for administration, backup/Recovery Tasks , tuning, installation, patching…
SQL Server 2005 & 2008, Oracle 11gR2 on Linux, SYBASE ASE 12.x&15.x and IQ 12.X on AIX , mysql 6.x on linux for JBOSS application .