BONAVENTURE ENCHO

Email: ad1wfo@r.postjobfree.com

https:// linkedin.com/in/bonaventure-tataw-335422251

Address: 2Treeman Drive Unit 302 Hillsborough NJ

Phone: 908-***-****

PROFESSIONAL SUMMARY:

I’m a Self-reliant, diligent and confident Oracle Database Administrator with over 7 years of hands on experience, who has extensive knowledge in modeling, designing, maintaining, managing and upgrading 12c to 19c Oracle databases in UNIX/Linux environments. I have experience with Oracle Database Administration in project and production support, installation, configuration, upgrades, patches, performance management/tuning, backup and recovery, space management, database security, cloning, migration, shell scripting, documentation and maintain database solution for complex business needs using wide selection of technologies like Oracle RAC, ASM, Data Guard, Enterprise Manager Cloud Control, Golden gate and others. Worked on UNIX, LINUX, and Windows operating systems. AREAS OF EXPERTISE INCLUDE

Backup & Recovery

Monitoring and performance tuning

Database Security

Database Upgrades and Patching

TECHNICAL SKILLS AND TOOLS

Installation, configuration and update of

Oracle 11g, 12c and 19c using OUI, DBCA,

DBUA,

Monitoring and performance tuning using

OEM Console, Toad, SQL Developer, Grid

Control, Explain Plan, Stats pack/AWR,

ADRCI, ADDM.

Database migration

Oracle Data Guard

Application database architecture

High availability RAC, DG, OGG

SQL, PL/SQL, UNIX Shell Scripting

Oracle ASM (clusters) and RAC

configuration and administration

Database security

installation/administration for High

availability and Disaster Recovery (DR)

Database migration using Data Pump

Exp/Imp and SQL LOADER

WORK EXPERIENCE:

AMERICAN FAMILY INSURANCE: JULY 2019 - PRESENT

ORACLE DATABASE ADMINISTRATOR

● Upgrade of GRID and Oracle Databases Software from 12.1.0.2 to 19c, as well as convert non-CDB to CDB databases.

● Application of Oracle Database 19c Patch Release Update in both QA and Production environments.

● Perform scheduled maintenance and support release deployment activities during regular working and after working hours

● Perform Oracle database administration tasks including configuration management, backup/recovery, and performance optimization define bottlenecks, manage testing and production implementation, and space management.

● Work with the System/Application Administrators and the Application Development teams to initiate and perform capacity planning across database environments.

● Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution.

● Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning using tools like AWR, ADDM, EXPLAIN PLAN, ASH, SQL TUNING ADVISOR, TKPROF, SQL TRACE automated via OEM grid control 12c and command line.

● Implemented Oracle ASM 12c/19c software installation and configuration (Grid infrastructure) and partitioning disks in Linux.

● Restored and recovered database and ARCHIVLOG using RMAN from backup on same servers and on different servers.

● Continuous review of Business-Critical Database to proactively identify space issues, performance tuning issues.

● Patching of Exadata (8-Node, 4-Node and 2-Node RAC) in Rolling and Non-Rolling methods

● 24x7 Production database administration, support and monitoring to ensure a proactive problem solving.

● Upgrade of Oracle Enterprise manager (OEM) 13.3 to 13.4 and also applied OMS, Agents, Grid and Database Patches.

● Implementation for Disaster Recovery Worked in setting up the Data guard broker for automatic failover and switchover by enabling Fast Start Failover.

● Extensive experience implementing Oracle Advanced Security: Transparent Data Encryption (TDE) to enforce data-at-rest encryption and Data Redaction to reduce the risk of unauthorized data exposure in applications/redacting sensitive data before it leaves the database.

● Performed Patch set updates, CPU patches on RAC Databases to minimize security issues and provide bug fixes.

● Unix Shell scripting for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.

● Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from block corruption).

● Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances

● Restore and recover databases from file system backup in order to bring database to the original state as per the business and user requirement within SLA.

● Experience in support active development teams with DDL script creation, database change management and data modeling

● Experienced in documentation, provided documentation for database design, analysis, modifications, and creating schemas.

● Hands on experience using Oracle Golden Gate 19c for replicating data across homogeneous and heterogeneous databases.

● Performed Initial load and Change Sync replication using OGG SAINT PETER’S UNIVERSITY TEACHING HOSPITAL Il: APRIL 2016 – JUNE 2019 ORACLE DATABASE ADMINISTRATOR

Extensive experience implementing Oracle Advanced Security: Transparent Data Encryption (TDE) to enforce data-at-rest encryption and Data Redaction

Monitoring and performance tuning using oracle Enterprise Manager cloud console and SQL Developer to manage daily task regarding performance and maintenance

Participate in 24x7 on-call support and planned downtime maintenance activities

Experience with SQL Server High Availability Solutions such as Clustering, and Always-On, Availability Groups

Execute daily health checkup of production which includes testing database and performance of the oracle Infrastructure.

Check and monitor Oracle database environments health and security using Oracle Database Security Assessment Tool (DBSAT) and ORACHK

Plan and manage project tasks, schedules, and resources related to database administration

Experience in implementing 12c new feature, Fast-start Failover (FSFO) setup in Data guard as a solution to High Availability

Performed data and metadata migration to newly installed servers using Data Pump Expdp/Impdp

Implementation and Setup of Physical standby databases, Data Guard and provide support for Oracle Data Guard

Planning and implementing the Backup strategy using RMAN, User managed backup and Logical Backups.

Responsible for problem escalation to Oracle Support and third parties as necessary

Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.

Created scripts and scheduled backups in Cron for RMAN database backups and recoveries.

Database upgrades, resource capacity planning, platform migrations, application

Maintained database security via unique database roles and object permissions.

Plan and manage project tasks, schedules, and resources related to database administration

Responsible for configuring and backing up databases using RMAN (Incremental backups, Conventional hot and cold backups, physical and logical backups).

Managed Automatic Storage Management (ASM) and Non-ASM database file systems

Perform technical analysis of Patches and open SRs with the product owner as required EDUCATION AND CERTIFICATIONS

Bachelor of science Degree in Mathematics with minor in Computer Sciences COMPETENCIES

• Good interpersonal, communication, athletic, good teamwork, and personal dedication skills.

• Organization and time management.

• Good listening skills.

• Fluent in English/French

Contact this candidate