Freelancer profile translated to English.

Description

Expert in database management and data flow automation, the DataOps/DBA optimizes the performance, security, and availability of data systems. It combines the principles of DevOps with database administration to automate the deployment, monitoring, and management of data on a large scale.

Industry field of expertise

Languages

English
Native or bilingual
French
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

CRÉDIT MUTUEL
Database Administrator
BANKING AND INSURANCE
January 2022 - January 2025 (2 years and 11 months)
Paris, France
Installation and configuration of Oracle/Postgresql/Mysql versions

Management of Oracle databases using SQL Developer
Analysis of needs and recommendation of Oracle/Postgresql/Mysql solutions.
Design and implementation of solutions for Oracle/Postgresql/Mysql databases.
Evaluation and optimization of the performance of existing Oracle/Postgresql/Mysql databases.
Training teams on Oracle/Postgresql/Mysql database administration.
Automation of Oracle/Postgresql/Mysql database administration tasks.
Backup and restore management of Oracle databases using RMAN.
Configuration of Oracle database security using Oracle Label Security.
Implementation of data encryption solutions on Oracle/Postgresql/Mysql databases.
Integration of Oracle/Postgresql/Mysql databases with other enterprise applications and systems.
Participation in security and performance audits of Oracle/Postgresql/Mysql databases.
Design and development of Oracle databases with PL/SQL.
Automation of processes by creating stored procedures and PL/SQL triggers.
Optimization of SQL query performance using indexes and materialized views.
Proactive monitoring of Oracle databases with OEM
Improvement of SQL query performance on EXACC
Participation in the migration of databases between Oracle/Postgresql/Mysql versions
Management of Oracle database performance using ADDM and SQL Tuning Advisor
Creation of copies of Oracle 11gR2 and 19c databases using scripts and the RMAN tool
Creation of Ansible scripts to automate backup tasks
Management of level 2 and 3 technical tickets and incidents using JIRA
Writing and updating operating manuals (Mex)
ARTE
POSTGRESQL Database Administrator
August 2020 - January 2022 (1 year and 5 months)
France
Supervision and maintenance of PostgreSQL clusters for critical applications.

Implementation of logical replication for real-time failover.
Optimization of slow queries with a 30% reduction in response times.
Implementation of backup/restore procedures with pgBackRest for rapid recovery.
Securing databases (encryption, audits, fine-grained management of roles and permissions).
Install and configure PostgreSQL on various operating systems (Linux, Windows, etc.).
Performance and security optimization.
Configure PostgreSQL extensions.
Create and manage databases, users, roles, and privileges.
Manage backups and restores with tools like pg_dump, pg_basebackup, and automated solutions.
Manage tablespaces to optimize storage utilization.
Implement access policies and user rights control (GRANT, REVOKE).
Perform security audits to detect and prevent vulnerabilities.
Optimize joins, subqueries, and data structures for increased performance.
Implement incremental and full backup strategies
Configure monitoring tools like pgAdmin, Zabbix, Prometheus, and Nagios to monitor the status of databases.
Monitor critical metrics such as active connections, memory usage, and locks.
Develop automation scripts in Bash, Python, and other languages for repetitive tasks. Create stored procedures and triggers in PL/pgSQL to meet the specific needs of applications.
Manage database migrations between different versions of PostgreSQL and to/from other DBMS.
Provide technical support for the integration of databases into business applications.
Train users and teams on the optimal use of databases
ARTE FRANCE
Database Administrator
August 2020 - January 2022 (1 year and 5 months)
Function: Database Administrator
• Supervision and maintenance of PostgreSQL clusters for critical applications.
• Optimization of slow queries with a 30% reduction in response times.
• Implementation of backup/restore procedures with pgBackRest for rapid recovery.
• Securing databases (encryption, audits, fine-grained management of roles and permissions).
• Install and configure PostgreSQL on various operating systems (Linux, Windows, etc.).
• Configure parameter files to optimize performance and security.
• Configure PostgreSQL extensions.
• Create and manage databases, users, roles, and privileges.
• Manage backups and restores with tools like pg_dump, pg_basebackup, and automated solutions.
• Plan and execute regular maintenance tasks such as VACUUM, analysis, and reindexing.
• Manage tablespaces to optimize storage utilization.
• Implement access policies and user rights control (GRANT, REVOKE).
• Enable and configure SSL/TLS authentication to secure connections.
• Perform security audits to detect and prevent vulnerabilities.
• Monitor and adjust database performance via configuration parameters Analyze SQL execution plans to optimize queries (EXPLAIN, EXPLAIN ANALYZE).
• Manage indexing (creation of B-Tree, GIN, GiST indexes, etc.).
• Optimize joins, subqueries, and data structures for increased performance.
• Implement incremental and full backup strategies.
• Configure and manage data replication (logical and physical replication) to ensure high availability.
• Regularly test disaster recovery scenarios.