Marc Bitoun

Management and administration of Oracle databases, development, validation, and production. Rewriting and simplification of backup and restore procedures, consideration of CIFS disk storage instead of DDBOOST tape storage, implementation of RMAN Catalog and FRA. Definition and implementation of partial restore procedures for Enterprise Edition versions via auxiliary instance and Standard Edition via instance cloning. Reorganization of databases on servers to optimize Oracle license costs, grouping of instances on servers for paid options Multitenant and Partitioning. Upgrade of 12.x and 19.x databases to 19.22, classic and multitenant databases, and PDBs individually. Upgrades via Oracle Autougrade 19c and via PDB relocation. Implementation of replication via GOLDENGATE Microservices 21c for hot upgrades of databases not allowing prolonged service interruption. Implementation, management, reporting, and administration of GOLDENGATE 21c replication in Microservices mode.

- Management and administration of all Oracle, SQL Server, and MySQL databases for research (DISI), production, and integration.

- Upgrades from 10g to 11g then 11g to 12c.

- Upgrades from 12c to 19c on 2 different servers via Autoupgrade 19c. Performance stabilization by retrieving execution plans with SQL PLAN MANAGEMENT from the AWR repository. Automatic non-regression analysis of new execution plans compared to existing ones before acceptance.

- Administration, management, and supervision of production and integration environments, provisioning of new instances, version upgrades.

- Modification of the master-to-master replication system for Oracle databases: Migration from Oracle Multimaster replication to Oracle STREAMS (11G).

- Administration of ORACLE STREAMS, management of replication conflicts, error management, transaction frame analysis, STREAMS (11G) performance.

- Level 3 support, performance analysis, backup and restore management via RMAN.

- Implementation of RMAN, FRA, DATAGUARD (PRA).

- Implementation of Oracle proxy, OCM (Oracle Connection Manager).

- Instance caging via DRM to isolate server resources between instances.

- DRM implementation within instances to limit/prioritize batch/transactional processing.

- SQL_SERVER replication, transactional and by snapshot.

- SQL SERVER to Oracle replication.

- Installation and administration of SQL SERVER clusters, single-node and two-node active/passive mode.

- Implementation of replication via log shipping.

- Definition and implementation of the disaster recovery plan.

- Creation of dashboards for database monitoring and re-architecture of production servers.

- Administration of MySQL databases on Linux and Windows. Environment: Oracle 12c, 19c, Windows 2019, SQL SERVER 2012 to 2016, MySQL 5.7.

Management and administration of Oracle databases, development, validation, and production.

Rewriting and simplification of backup and restore procedures, consideration of CIFS disk storage instead of DDBOOST tape storage, implementation of RMAN Catalog and FRA.

Definition and implementation of partial restore procedures for Enterprise Edition versions via auxiliary instance and Standard Edition via instance cloning.

Reorganization of databases on servers to optimize Oracle license costs, grouping of instances on servers for paid options Multitenant and Partitioning.

Upgrade of 12.x and 19.x databases to 19.22, classic and multitenant databases, and PDBs individually.

Upgrades via Oracle Autougrade 19c and via PDB relocation.

Implementation of replication via GOLDENGATE Microservices 21c for hot upgrades of databases not allowing prolonged service interruption.

Implementation, management, reporting, and administration of GOLDENGATE 21c replication in Microservices mode.

Environment: Oracle 12.2c, Oracle 19c, Multitenant, Partitioning, RMAN, GOLDENGATE Microservices 21c, Windows Server 2016 and 2019.