Freelancer profile translated to English.

Description

Independent consultant with over 20 years of experience in database development, optimization, and migration.

Specializing in classic Oracle and Exadata technologies and Informatica PowerCenter, I am involved in all phases of a project.

My professional background has allowed me to work as a developer and DBA.

I perform code reviews, optimization (SQL & PL/SQL), and database optimization.

I am also an accredited SQL and PL/SQL trainer. My training courses are for beginners and experienced professionals alike.

Industry field of expertise

Languages

English
Conversational
French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Accor
Oracle DBA
HOSPITALITY
June 2015 - Today (11 years and 2 months)
Évry, France
Various assignments on the group's Oracle databases.
Audit:
• Oracle 11GR2 Exadata on supercluster:
- Of the financial data processing chain (shell, SQL, PL/SQL). Time savings of approximately 40%.
- Of data warehouse performance (11TB). Reduction of volume by 20% and performance increase of approximately 30%.
• Oracle Cloud:
- For an environment intended for an HR application. Security and application recommendations.
Administration:
• Oracle 11GR2 Exadata on supercluster:
- Creation of objects and schemas.
- Granting and revoking of rights.
- Maintenance of the data warehouse.
- Automation of recurring tasks via DBMS_SCHEDULER.
- Refreshing of non-production environments.
- Optimization of SQL code via Explain Plan and/or AWR.
• Oracle 19C Exadata on Nutanix:
- Creation of new Oracle environments integrated with ASM.
- Creation and rationalization of the project environment on Oracle Linux.
- Database migration (physical objects and code) to this environment.
- Granting and revoking of rights
- Maintenance of the data warehouse.
- Refreshing of non-production environments.
- Optimization of SQL code via Explain Plan and/or AWR.
- AMOE for the migration of the data warehouse to Snowflake on AWS.
Development:
- Automation of financial data processing via shell & Crontab.
- Rationalization and optimization of PL/SQL code.
- Design, star or snowflake, of data models.
- Implementation of GDPR law.
- Design and development of datamarts for the finance and human resources departments.
Miscellaneous:
- Development of a tool to automate object creation and rationalize names and formats.
- Technical supervision and implementation of development standards.
- Writing of technical documentation.
- Review of functional documentation.
- Deployment and testing of new developments.
- Version administration via SVN.
Oracle PL/SQL SQL Oracle Database Korn Shell Migration Projects
ESN
Trainer
TECH
June 2023 - June 2023
77000 Melun, France
Training several people in PL/SQL with the aim of placing them with clients and making them autonomous in their respective roles.
Oracle PL/SQL SQL
Carrefour
BI Developer Analyst
RETAIL (LARGE RETAILERS)
October 2013 - March 2015 (1 year and 5 months)
• Technical design for a pricing system
• Data model design.
• Data integration, datamart population
• SQL and PL/SQL optimization.
Oracle Database SQL Oracle PL/SQL Korn Shell

Check out Vincent's experience

Be the first to recommend Vincent

Help this freelancer shine by sharing your experience working together.

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

Bachelor's degree in Information Systems
CNAM
2002
Licence en système d'information
Higher National Diploma in Computer Management
BTS informatique de gestion

Data Base Administrator

Vincent Cinier

Oracle and Powercenter Consultant

About Vincent

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories