Oracle DBA

• Nov 2022 - Present

Oracle DBA

• Jun 2020 - Aug 2022

Owner

• Apr 2019 - Jan 2022

DB Chemistry provides highly specialized IT consulting services in Oracle : - Oracle Database and Weblogic technologies and architecture - Oracle Database Tuning Performance - Oracle Database Analysis - Oracle Database migration - Disaster recovery plan - Oracle Forms and Report migration DB Chemistry provides highly specialized IT consulting services in Oracle : - Oracle Database and Weblogic technologies and architecture - Oracle Database Tuning Performance - Oracle Database Analysis - Oracle Database migration - Disaster recovery plan - Oracle Forms and Report migration

Oracle DBA

• Jul 2019 - Jun 2020

TD Insurance is part of the TD Bank Group, one of Canada's largest financial services organizations. • Maintain, administrate, troubleshooting databases • Apply corrective actions (patches), as required • Monitor and optimize Database performance • Perform testing, reporting, capacity planning, performance tuning, backup and restore • Flashback databases • Manage database functionalities, such as DB configuration, Materialized Views, Partitioning, etc • Script deployment • Implement and use management tools such as OEM, cloning and migration process • Development and update the technical documentation • Analyze production issues and take corrective actions, as needed • Technical meetings • Technical environment: Oracle 11g, 12c, OGG, DataGuard, RAC, Linux and AIX

Oracle DBA & Weblogic

• May 2018 - Jun 2019

Responsibilities : • Install Oracle 11g and 12c software • Create and plan RMAN scripts using Crontab and Windows Scheduler • Apply critical patches on Database and Weblogic • Optimize Data Pump script, and reduce exportation time by a third • Analyse the performance of Oracle 12c databases • Install and configure WebLogic 12c Standalone and Cluster • Install and configure BI Publisher 12c Standalone and Cluster • Install and configure Dataguard 18c • Draft performance analysis documents • Maintain and monitor VMware 6.0 • Installation et configuration de MySQL 5.6

Oracle Infrastructure DBA

• Jun 2017 - May 2018

RBC is one of Canada's largest banks and one of the largest banks in the world, based on market capitalization. Responsibilities : • Led the installation of Oracle database 11g and 12c software • Created scripts and scheduled backups in cron for RMAN database backups and recoveries • Performed database upgrades • Updating TSS (Technical Security Standard) scripts • Cassandra installation and configuration (Version 3.10) • Shell scripting and statspack / AWR / ADDM reports

Bilingual Customer Service Representative

• Jun 2016 - Jun 2017

B2B Bank is a Schedule I Canadian bank that serves a network of some 27,000 financial professionals across key business verticals including financial advisors and their dealerships; deposit and mortgage brokers and their firms; mutual fund and insurance manufacturers; MFDA and IIROC members. Responsibilities : • Responds to inquiries regarding products in an efficient and professional manner Resolves client concerns regarding their file through close collaboration with other internal stakeholders

Oracle DBA

• Feb 2016 - Mar 2016

Axa is one of the biggest French insurance company. I had to manage 800 Oracle databases instances (10g, 11g, 12c) and 100 SQL Server 2005 databases in size of 500GB to1TB. Responsibilities : • Led the installation of RMAN backup with TSM (Tivoli Storage Manager) and TDPO (Tivoli Data Protection for Oracle) and worked closely with the team of system administrators for prerequisites validation • Managed Dataguard Databases. Shutdown and startup dataguard databases for patching. In charge of manual restart of databases

Oracle DBA – Weblogic Administrator

• Jan 2014 - Feb 2016

Aareon France is a software editor on property management. I was in charge of 80 Oracle Databases instances (10g, 11g, 12c) of 500GB and 10 Oracle Weblogic instances (Forms and Java). Responsibilities : • Restored databases with RMAN backup after disaster, always within de MTTR specified by the service level agreement (SLA) • Created and configured the RMAN catalog. • Led the installation of Oracle Database 12c engines and databases on Linux and Windows servers. • Databases support Level 1 and 2. • Day-to-day supervision, implementation of oracle profils,indexes,triggers. • Installed Oracle Weblogic and Oracle Application Server on Linux and Windows servers. • Led the monitoring and maintaining database security by writing scripts and creating oracle profile. • Apache implementation for Weblogic : editing weblogic.conf,dads.conf,ect… • Managed Oracle tablespaces and users by creating alert scripts and profiles to restrict users’ access to the database objects. • Led the deployment of Forms and SQR programs and provided support to the development team to test and deploy the products. • Led the installation of NFS and Samba for easier access to the Linux filesystem.

Oracle DBA - PL/SQL Developer

• Apr 2011 - Jan 2014

Pickup Services is a company that offers the pickup at store service. I was in charge of Oracle 10g and 11g databases (Cluster and single instances) and SQL Server 2005 databases. I also implemented an application that tracks and notifies the customer of the parcel’s status. Responsibilities : • Managed clustered databases on RAC (Real Application Cluster) on Windows and Linux plateforms : 3 databases of 500GB. • Led the creation, restauration, copy and backup of SQL Server 2005 databases. • Implemented RMAN scripts for backups and data export. • Created production bash shell scripts for exploitation • Provided technical support to clients from Switzerland and Portugal, about 10 calls per day. • Deployed Oracle database 11g software on client machines. • Led the patching of 10g and 11g databases. Reduce the execution time of oracle process. • Administered the Oracle Automatic Storage Management (ASM) by creating and deleting the group disks. • Resolved daily database administration tasks like full tablespaces maintenance, accounts lock, etc. • Worked closely with system administrators to design and implement databases on new servers. • Redesigned the notification system in PL/SQL and developed packages, procedures, functions, types, indexes and triggers. • Performed functional and technical analysis of the system and helped new participants with understanding the system. • Performed PL/SQL code review and improved the performance twofold.

Enterprise Content Management Consultant

• Jan 2011 - Mar 2011

e-foundation specializes in data management with Open Text Livelink software. Responsibilities : • Implemented the conversion of Microsoft Office 2007 documents to PDF using Microsoft Office Add-In. • Developed macro scripts to automate the conversion. • Wrote the user guide that explained how to use the converter. e-foundation specializes in data management with Open Text Livelink software. Responsibilities : • Implemented the conversion of Microsoft Office 2007 documents to PDF using Microsoft Office Add-In. • Developed macro scripts to automate the conversion. • Wrote the user guide that explained how to use the converter.

Visual basic Developer

• Jan 2010 - Apr 2010

This is a french leader in Aerospace, Space, Ground Transportation, Defence and Security. The application provided the management of buses, if on the road or not, the bus number, the name of driver, etc. Responsibility : • Implemented an interface in Visual Basic to connect to a Microsoft Access database. • Performed Visual basic code review and adjusted the code to be more readable. • Designed the Conceptual Data Model with PowerAMC. This is a french leader in Aerospace, Space, Ground Transportation, Defence and Security. The application provided the management of buses, if on the road or not, the bus number, the name of driver, etc. Responsibility : • Implemented an interface in Visual Basic to connect to a Microsoft Access database. • Performed Visual basic code review and adjusted the code to be more readable. • Designed the Conceptual Data Model with PowerAMC.

Technician

• Feb 2007 - May 2007

Resoserv is specialized in maintenance, network, system and services. Responsibilities : • Provisioned computers with all the software needed before sending them to the customers. • Hotline support of about 50 calls per day in average. Resoserv is specialized in maintenance, network, system and services. Responsibilities : • Provisioned computers with all the software needed before sending them to the customers. • Hotline support of about 50 calls per day in average.