Freelancer profile translated to English.
Back to original languageAbout Yeo
Experienced DBA with over 3 years of experience in SQL Server, Oracle, PostgreSQL, MySQL, and MongoDB environments within major companies like L’Oréal, LCL, and SNCF. Specializing in migrations and version upgrades, high availability (Always On, Patroni, Slony), performance optimization, security, and automation via PowerShell, SSIS, and T-SQL, I guarantee business continuity, reliability, and performance of critical systems. My experience with Disaster Recovery Plans (PRA), monitoring with Nagios, Zabbix, and SQL Profiler, as well as incident management via Jira and ServiceNow, allows me to quickly resolve issues and sustainably improve database infrastructure. Proactive and methodical, I also design and model robust database architectures using the Merise method and Power AMC, while optimizing data flows and reports with SSRS, DataPump, and MongoDB. Versatile, I handle the entire database lifecycle, from installation and configuration to migration and maintenance on Azure cloud, ensuring security, performance, and compliance.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- TENEXA((l'OREAL)DBA SQL Server/Oracle/PostgresSQLJanuary 2025 - September 2025 (8 months)Paris, France• Installation and configuration of SQL Server [2012-2019] on Windows Server.• Installation and configuration of Oracle 19c via SQL Developer and SQL*Plus.• Administration of SQL Server databases with SSMS and T-SQL query development.• Installation and administration of PostgreSQL [10-16] on Linux and Windows Server via pgAdmin and psql.• Restoration of PostgreSQL databases with pg_dump, pg_restore, and WAL archiving.• Version upgrades of PostgreSQL databases with compatibility testing and application validation.• Import, export, and loading of PostgreSQL data (pg_dump, pg_restore, COPY, FDW).• Transfer of PostgreSQL data from different sources and destinations via COPY, FDW, and Python ETL.• High availability management: streaming and logical replication, automatic failover with Patroni and repmgr.• Access and security management: users, roles, permissions, and certificate renewal.• PowerShell scripts for task automation and environment cloning.• Performance optimization: execution plan analysis, index creation and rebuilding, statistics update.• Proactive maintenance: patches, incident management, and continuous monitoring.• Oracle support: restoration via Dump files and RMAN.• Incident management and technical support via ServiceNow and Jira, root cause analysis.• Database design and modeling using Merise method and Power AMC.• SQL Server data transfer via SSIS and report creation via SSRS.• Planning and automation of backups with SQL-Agent and Control-M.• Implementation of Disaster Recovery Plans (PRA) and business continuity.• Server and database monitoring with Nagios, Zabbix, and Windows/SQL Server monitors.• Configuration of SQL Server mirroring and availability groups on Azure.• Migration of on-premises SQL Server databases to Azure and Always On configuration.• Documentation and maintenance of operational files (Mex).
- LCLDBA SQL Server/Oracle/mongodbBANKING AND INSURANCEJanuary 2024 - December 2024 (11 months)Paris, France▪ Installation and configuration of SQL Server [2012-2019] on Windows Server.▪ Installation and configuration of Oracle 19c (SQL Developer/SQLPLUS).▪ Administration of SQL Server databases with SSMS.▪ Development of PowerShell scripts for administration task automation.▪ Restoration of Oracle databases via RMAN.▪ Migration of SQL Server 2012 to 2019 and Oracle 11g to 19c (Data Pump, OEM, DBUA).▪ Database design and modeling using Merise method and Power AMC.▪ SQL Server data transfer via SSIS and report creation via SSRS.▪ SQL execution plan analysis for performance optimization.▪ Configuration of SQL Server alerts and notifications via Control-M.▪ Development of T-SQL queries to interact with SQL Server databases.▪ Implementation of Disaster Recovery Plans (PRA) to ensure business continuity after a disaster.▪ Server and database monitoring with Nagios, Zabbix, and Windows/SQL Server monitors.▪ Use of Jira for incident tracking and priority assignment.▪ Database auditing via SQL Profiler and DDL.▪ Automation of cloning processes with PowerShell and T-SQL for test and development environments.▪ Query optimization, index creation, and statistics update (SSMS, Query Store).▪ Resolution of Oracle performance issues and analysis via pg_badger.▪ Import/export and loading of Oracle data (DataPump).▪ Planning and automation of regular backups (SQL-Agent).▪ Configuration of SQL Server mirroring and availability groups on Azure.▪ Creation and maintenance of SQL Server servers and databases on Azure.▪ Migration of on-premises SQL Server databases to Azure and Always On configuration.▪ Creation and tracking of operational files (Mex) to document and facilitate future incident resolution.
Recommendations
Be the first to recommend Yeo
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- BAC+5 Data Engineer2025BAC+5 data Engineer
- MasterEarth Science, Planets and Environment (STPE)2022Master