Freelancer profile translated to English.

Description

Hello,

I am currently looking for new opportunities that will allow me to explore other technologies. After gaining significant long-term experience with SQL Server, Oracle, PostgreSQL, and MySQL, I am eager to take on new professional challenges.

If you are aware of any interesting opportunities in this field, I would be delighted to discuss them further.

Thank you in advance.

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Lille (up to 50km), Bordeaux (up to 50km), Lyon (up to 50km), Paris (up to 50km), Strasbourg (up to 50km)

CULTURA
DBA
RETAIL (LARGE RETAILERS)
June 2023 - January 2024 (7 months)
Bordeaux, France
• Inventory and consistency monitoring between database environments (MongoDB, SQL server, Oracle, MySQL)
• Creation of PYTHON, BASH, and SQL Scripts
• Creation of Ansible Playbooks for task automation on Ubuntu
• Comparison of database schemas with LIQUIBASE
• Table comparison
• Data set creation
• Creation of SELECT and UPDATE variables, STORED PROCEDURES, and functions
• Optimize, tune SQL queries as needed: Views, Indexes, SP_Table, Triggers, CTE in SQL server and Oracle
• Analysis of Changelog files generated by Liquibase
• Versioning of Python and SQL Scripts under Gitlab with necessary commands (git add, push, commit…)
• Data anonymization
script Python Ansible Liquibase AWX Gitlab Gitlab CI/CD Talend Ubuntu Bash scripting
CONSEIL DE L'EUROPE
Expert DBA
February 2024 - December 2024 (10 months)
Context: Company in the Public sector
Achievements:
• SQL Server database migration
• SQL Server database upgrade
• Creation of scripts in Python, Bash, and SQL
• Database analysis and optimization
• Incident resolution
• Creation of performance reports for each database
• Creation of indexes, stored procedures, and functions
• Configuration of events (deadlock, maintenance plan, etc.)
• Creation of jobs and linked servers
• SQL query optimization and tuning
• Installation and application of SQL patches
• Database backup and restore
ELECTRO-CONTACT
DATABASE ADMINISTRATOR
August 2014 - April 2023 (8 years and 8 months)
• Installation and configuration of SQL Server, PostgreSQL, Oracle, MySQL databases
• Performance monitoring and optimization
• Database high availability
• Working with Oracle GoldenGate, Data Pump, pgAdmin (pg_dump and pg_restore, pg_basebackup…)
• Optimize, tune SQL queries as needed: Views, Indexes, SP_Table, Triggers, CTE in SQL
• Develop data models and database designs to plan projects
• Specified user access levels for each database segment to protect database integrity and company information
• Evaluate needs and objectives through communication and system assessments to modify existing databases
• Implementation of database backup and restore systems
• Performing security audits of database management systems and writing recommendations
• Development with Node.js, Node-Red, PL/SQL
• Creation of virtualized servers with VMware vSphere
• Analyze and respond to user needs
• Create production-related utilities (Dashboard web application with ASP .NET)