Raoul Marie Rm

- Manage TTM projects - Description and modeling of Run & Build processes - Involved in the Root cause analysis team and insurance for the implementation of corrective / continuous improvement actions - collaborated with the configuration manager to establish and follow the changes management process in order to assess - Directed the daily meeting on the progress of the project with operational teams of the process, test managers, infrastructure managers, risk capture and discussion of mitigation plans. - Worked with operational teams to ensure that the product meets functional requirements - Involved in IT urbanization for the production of IP solution, Transmission, Signaling, Voice, MDB, CDN, Cloud - Process modeled with UML/BPMN diagrams - Assisted the RAC team and insured the implementation of corrective actions / continuous improvement - Technical referent for Oracle 18c databases, MariaDB, PostgreSQL, MongoDB - Deployed the Stack Grafana / Prometheus for database application monitoring - Monitoring and analyze datacenter with Vrealize and Grafana stack dashboads Env: UML, Jira, Kanban, Confluence, Lucidchart, ITIL v3, COBIT, TOGAF, ELK, AWS, ELK, MySQL, MongoDB, Oracle 18C, Jenkins, Jenkins, OpenShift, VSphere vCenter, ESXi, vRealize, Grafana Prometheus

- Make architecture evolve if in relation to cloud projects - Create the automation frame based on Terraform and Linux Bash Script - Implemented from start to finish A Hosting Web solution on the AWS Cloud with integration into S3 Buckets  Make the supervision and the update on AWS Autoscaling and Cloud Watch - Management of authorizations with AWS IAM - Lambda implemented to configure Dynamo DB Autoscaling and the data access layer in order to access AWS Dynamodb - Worked on AWS SNS to send emails and automated messages using Boto3 - AWS Lambda creation, EC2 provisioning instances on an AWS environment and implemented safety groups, administered Amazon VPC - Used Jenkins pipelines to pilot all micro-service creations in the Docker register, and deployed on Kubernete, created pods managed using Kubernetete - Effective monitoring containers in AWS EC2 machines using the Datadog API and ingested, enriched data in the internal cache system - Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases - Implementation of High Availability solutions with Oracle 12c, 11g RAC, Standby Database (Active Data Guard) - Replication, extracting data and applying on production database using Golden Gate. - Implemented unidirectional and Bi-directional replication using Golden Gate 11.1 for High Availability and reporting projects. - Checking Databases Backup/Restore validity periodically, and Data refreshes from Production to Non- Production environment - Created Duplicate Databases using RMAN Backups. - Worked with database export & import scripts to backup database structures and automation procedures. - Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning - Worked with storage team to diagnose IO latency occurring with VMs latency configured in HADR (log shipping and Always-On

- Disign, architecture and deployment of solutions in the AWS platform - Design of well -structured relational database patterns. Creation of automated pipelines for a variety of data sources (S3, Postgresql, Oracle, SQL Server) to load Cloud Snowflake Datawarehouse - Develop new data storage architectures for data growth growth with Amazon EMR, S3, Redshift - Implementation of FGA access using AWS Lambda, Dynamodb - Make imports and exports in SQL Server Integration Service data, Oracle and PostgreSql requests with SQL Developer - 24x7 Oracle Production Database Administration including Oracle 11g/18c RAC - Installation, Configuration and Upgrading of Oracle 10g/11g/18c - Assist developer team with data modelling improvement - Refresh/Cloning of Database for development and testing purpose. - Standby Database (Data Guard) setup and configuration - Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements. - Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements. - Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

- Configured Backup and Recovery setting for Oracle database 10g, 11g, 12c, & 18c for single instance on File system & ASM storage using RMAN - Monitoring database performance and database operation to prevent downtime and slowness of the services. - Managed multi node (3 nodes) RAC with ASM, and adding instance to existing RAC. - Created and monitored all database objects, including tables, clusters, indexes, sequences, packages and procedures - Created table spaces and managed table spaces adding/deleting/ resizing data files - Managed Undo Segment in order to avoid "Snapshot too old" error - Performed logical backup & recovery using export/import utilities and Datapump. Involved in Configuration. - Design and implement database backup and recovery procedures using RMAN - Install, configure, modify, test & deploy applications on Apache Webserver, Nginx & Tomcat, JBoss App Servers - Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements. • Developed & maintained scripts, utility jobs or implement needed software for database maintenance. - Implemented & managed database clustering, failover and load balance technologies as per client requirement. - Involved in the design, implementation and maintenance of current consolidated physical and virtual infrastructure on a large scale, as well as the design, testing and implementation of technologies in the virtual environment . - Made VMware support, in particular ESX vSphere 5 to monitor clusters' performance, optimized the server environment, and diagnose and solve production problems around 2 data centers. - Developed, tested & implemented a robust database backup and recovery strategy with client assistance. - Monitored data activities such as Database status, logs, space utilization, extents, Checkpoints, locks and long transactions. - SAP FI, CO, MM, SD involved on business blueprint design

• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs • Design/Setup & support HADR environments using Clustering, mirroring and AlwaysOn Availability Groups, creating scripts for DR Drills and performing POC for SQL Server 2016/2014/2012/2008 R2 environments. • Consolidated 3 major business environments into one consolidated environment and implemented AlwaysOn Availability groups for HADR using SQL Server 2016/201/2012 Enterprise Edition. • Implemented and designed compression/continuing compression strategy. • Work with storage/virtualization teams involving technologies Vcenter / Vsphere, Hyper V • Work with the programming team, for optimal SQL Server behavior using query tuning and lock checking. • Performance tuning of long running queries and stored procedures, using SQL Profiler, server-side traces, Database Tuning Advisor, and query execution plans. • Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore and performance tuning. • Configured and Maintained Replications, Log Shipping • Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor. • Designed migration procedure for Postgres DB on premise to Azure • Designed and implemented incremental and full backup policies and procedures

• Worked with system administration team to have Windows 2012 R2 VM servers created with standard configuration of specified number of CPUs and amount of Memory for Development, QA, and Prod • Enabled and created AlwaysOn Availability Groups, AlwaysOn Availability with Transactional Replication and Distributed Always on Availability Groups on the SQL Server instances (2016) • Configured and setup snapshot replication from production environment • Monitored and modified Performance using execution plans and Index tuning. • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer. • Determined and implemented best practices for Oracle Setup, Installation, Configuration, Monitoring, Sizing, Capacity Planning, Backup and Recovery strategies • Setup jobs and events using Enterprise Manager (OEM) console • Migration of databases and schemas across multiple platforms of Windows to Linux, Oracle 10g to 11g, Oracle 11g to 12c, Oracle 12c to 18c . using DataPump within the same server & different servers. • Installed and configured the latest Linux Redhat 6.2 software. • Monitored the servers and Linux Redhat 6.2 scripts regularly, performed troubleshooting steps, & tested the software to make sure there were no software issues, on a server for end-users. • Establishing recovery strategies and implementation of Oracle Dataguard standby failover systems in disaster scenarios. • Configuration and management of ASM - Grid Control instances. Configured Oracle Restart Used Import/Export and SQL * Loader utilities to move data and objects • Performance monitoring, Database Monitoring using OEM, TOAD and Spotlight, and Database/Instance/RAC tuning using Dictionary views, AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters • Tuning of Oracle Databases for performance improvement, sizing database objects for effective space management and for optimal performance, using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN,

• Oracle Production Database Administration including Oracle 11g/10g RAC • Developing and delivering a details data migration plan • Identifying the data migration impact of all proposed changes • Manage end-to-end complex data migration, conversion and data modeling • Installation, Configuration and Upgrading of Oracle 11g/10g • Refresh/Cloning of Database for development and testing purpose. • Standby Database (Data Guard) setup and configuration. • Creating databases for Testing and Development servers. • Support for test and development environments. • Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF • Writing Shell Scripts for managing day-to-day activities and automation of backup. • Implementing logical backup and recovery using export/ import utility. • Defining and Setting backup and recovery procedures. • Backup and Recovery using RMAN • Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption) Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS. • Configuring Replication from Production to Reporting server and adding articles as and when new tables are created. • Configured Always-on as a Disaster Recovery Planning for Critical databases. • Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs • Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults. • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. • MySQL administration on Prod environment, installation, tuning, backups, resource optimization and distribution, Innodb and MyISAM storage engines, replication in large-scale env

• Installing and Configuring PostgreSQL from source or packages on Linux machines. • Managed Microsoft Active/Active and Active/Passive Clustered SQL Server 2000, 2005 environments. • Provided MSSQL Server 2000 and SSRS production support. • Design reports as per the client’s requirements. • Work on troubleshooting day to day production support and development SQL Server issues. • Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS. • Migrated SQL Server 2000 to SQL Server 2005