Yves Agbabou

• Advanced administration of SQL Server 2016/2019/2022 and Oracle 19c in 24/7 production environments.

• Configuration and maintenance of SQL Server Always On Availability Groups for critical environments.

• SQL Server performance tuning: T-SQL query optimization, execution plan analysis, index management.

• Implementation and management of Oracle Data Guard and RAC for high availability.

• Complete automation of DBA tasks via PowerShell, T-SQL, and Nolio Automation.

• Proactive monitoring with SQL Server DMVs, Extended Events, Grafana, and Oracle Enterprise Manager.

Major achievements:

• Migration of 15 SQL Server On-Prem instances to Azure SQL Managed Instance with zero downtime.

• Deployment of SQL Server Always On Availability Groups (3 replicas) for 25 critical databases.

• SQL Server optimization that reduced response times by 65% on critical queries.

• Automation of SQL Server and Oracle 19c instance installation via PowerShell scripts and Nolio.

• Migration of Oracle 19c (approx. 500 GB) to Oracle Cloud Infrastructure with a tested rollback plan.

• Configuration of automated SQL Server backup strategies (full, differential, logs).

• Implementation of Transparent Data Encryption (TDE) on 40+ SQL Server databases for security compliance.

DBA responsible for a fleet of over 300 multi-DBMS databases (SQL Server, Oracle, MySQL, PostgreSQL) for an international telecommunications group. Specialization in SQL Server and Oracle high availability, with responsibility for performance optimization and production incident management.

Key responsibilities:

• Daily administration of 80+ SQL Server instances and 50+ Oracle instances.

• Automated database monitoring via Ansible and PowerShell/T-SQL scripts.

• Design and maintenance of SQL Server and Oracle high availability architectures.

• Advanced performance tuning for SQL Server, Oracle, MySQL, and PostgreSQL.

• Proactive incident management and implementation of DR/BCP solutions.

• Administration and security of critical SQL Server and Oracle databases.

• Implementation of multi-DBMS high availability solutions.

• Consulting on architecture and technical communication to decision-makers.

Notable projects:

• Configuration of SQL Server Database Mirroring and Log Shipping for financial institutions.

• Implementation of Oracle Data Guard (Oracle 12c) for public organizations.

• Oracle 11g to 12c migration with performance tests.

• Installation and administration of Oracle WebLogic Server.

• Deployment of PostgreSQL HA solutions with Pgpool-II.

• Implementation of Oracle Audit Vault & Database Vault for regulatory compliance.