Freelancer profile translated to English.

Description

With my 19 years of professional experience, 27 years of programming and a great technical and theoretical culture, I have a strong desire to find creative solutions to complex problems in architecture and development.

PostgreSQL practitioner and consultant since 2005. Trainer of the "PostgreSQL, Advanced Administration in Nantes since 2019" course, two sessions per year.

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Can work on-site

Nantes (up to 50km), Nantes (up to 50km)

Ministère de l'Europe et des Affaires étrangères
PostgreSQL Performance Consultant –
March 2024 - Today (2 years and 3 months)
Technologies: **PostgreSQL**,

Context:
The France-Visas application is responsible for managing the issuance of entry visas to France throughout the world, with its connections to the Shengen area. The application is experiencing major performance problems

Mission:
Audit.
Advice on architecture.
Implementation of performance improvement strategies,
SQL optimization, structural
Freelance
SQL Trainer
DIGITAL AND IT
May 2011 - Today (15 years and 1 month)
Liège, Belgium
Since 2011, I have been training technicians and engineers in SQL on Postgresql, Sql Server or Oracle.
I mainly train professionals in mastering SQL and advanced SQL. I have also trained engineers to migrate from Oracle to PostgreSQL

o Installation, server configuration
o Performance improvement, indexes
o Access management
o Logging
o Rights management
o Advanced constraints
o Transaction
o Relational model, advanced SQL (with, window, lateral), Array Type
o Creation of advanced types
o Performance analysis of query execution
o Triggers, cursors, standard functions
o Database, TableSpace, Schema
o Vacuum, backup and maintenance, restoration
o Supervision, log analysis
o Replication
o Foreign Data Wrapper
o PL/PGSQL: specific syntax

- Development coaching: Work on specific and internal examples of Oracle source code to migrate to PostgreSQL in order to apply the course and identify a set of good practices and methods for migrating specificities.

Formation au langage de développement PL/SQL Oracle
o Initiation au PL/SQL
o Boucles, Curseurs
o Procédures, fonctions, triggers
o Planifications de tâche, types opaques

PostgreSQL administration training
o Installation, server configuration
o Performance improvement, indexes
o Access management
o Logging
o Rights management
o Advanced constraints
o Triggers, cursors, standard functions
o Database, TableSpace, Schema
o Vacuum, backup and maintenance, restoration
o Supervision, log analysis
o Replication
SQL Pedagogy Oracle
Alfa-Safety
PostgreSQL Consultant
February 2024 - October 2024 (8 months)
Technologies: PostgreSQL, OCaml
Context: As part of the technical definition of a DMS software with AI in the health field, I supported the client in its architectural choices. I also carried out various audit missions
Missions:
• Advice, monitoring of the software architecture design project
• Database audits for performance or structuring problems

Check out Pierre-Alexandre's experience

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Diplôme Universitaire d'Etudes Supérieur en Management des Organisations
IEMN-IAE - University of Nantes
2011
Le DUESMO est équivalent (même cours) au Master 1 de Management Double Compétence.
BTS Informatique de Gestion Option Développeur D'applications
CFA Laval (Alternance)
2005

Pierre-Alexandre Voye

PostgreSQL Database performance and HA expert

About Pierre-Alexandre

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories