You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Pierre-Jean CatezPC

Pierre-Jean Catez

Expertise SQL Server - Consultant DBA

€800/day
10 projects
Paris, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Pierre-Jean

SQL Server DBA for about twenty years, I have solid experience as a production DBA - particularly in the banking sector (Natixis, Amundi, Banque de développement du conseil de l'europe) and IT outsourcing (Prosodie, Altair) - but also numerous audit missions for institutional clients such as RATP, La Poste Internationale, GRDF, compte nickel, le Conservateur, Kepler Cheuvreux, OTO technology, Safebrands, CNFPT, Constructis, Avanci, Pacifica, OpCommerce, RCI, Auxia...
I have had the opportunity to work on large sites (> 100 instances) with applications that are highly volumetric or highly transactional, but also on smaller but very demanding IT systems.
I work on all types of architecture: MS Cluster, Veritas Cluster, Always On, Mirroring...

I have some knowledge of other DBMS such as Oracle, Sybase, MySQL and I have also contributed to the development of a universal DBMS exploitation tool named dbSQWare, a leader in its field.

I have a pragmatic approach to SQL Server issues: analysis, diagnosis, recommendations, implementation of solutions, monitoring of improvements achieved.

I have excellent interpersonal skills, as well as good communication and service orientation.
During my interventions, I provide an Audit Report detailing the points checked, the anomalies found, best practices, and resolution actions.
I also provide commands and SQL scripts.
Indeed, it is important for me to exchange and transfer skills to the client during my interventions.
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • Natixis
    DBA SQL Server
    BANKING AND INSURANCE
    October 2017 - Today (8 years and 8 months)
    Charenton-le-Pont, France
    Handling requests, daily job review, incident management, installation, writing architecture and exploitation documents.
    Environment of 240 instances: Always On and Mirroring
    SQL 2008, 2012, 2014 migration projects to 2016
    compliance control
    SQL Server Database administration IT Architecture migration alwayson
  • Council of Europe Development Bank
    Consultant SQL Server
    BANKING AND INSURANCE
    June 2018 - July 2018 (1 month)
    Paris, France
    Architecture choices
    Deployment of SQL Server Cluster Always On environments
    Implementation and monitoring of exploitation
    Security recommendations
    sql server always on cluster IT Architecture
  • Kepler Cheuvreux
    Audit and architecture
    BANKING AND INSURANCE
    September 2017 - October 2017 (1 month)
    Paris, France
    Consulting and writing exploitation documents: mirroring and replication environment
    Recommendations to improve database exploitation (configuration, upgrade, etc.), DRP, code review, proposal for availability solution migration
    Database administration mirroring Replication SQL Server database exploitation

Reviews

5.0

Out of 6 ratings

H

Hedi

Pacifica

Reviewed on 5/16/2023

S

Stéphane

ContactMe

Reviewed on 1/4/2023

Recommendations

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • University Diploma in Technology in Computer Science Software Engineering - specialization in Software Design and Development
    IUT de Paris
    1999
  • Oracle Administrator Training
    Greta
    2005

Certifications

  • Cyber security
    FormationSSI
    2019
    LPM

Skill set

Categories