Manager Oracle

MBAH CHARLES

Oracle Database Administrator

*************@*****.*** 202-***-****

I am a proactive Oracle/PostgreSQL database administrator, detailed oriented, team player with six (6) years of experience working on different oracle/PostgreSQL versions oracle (10g,11g,12c, 18c and 19c) PostgreSQL (9 and 10). existing on different platforms such as Linux. Unix and Windows. I have good experience in backup and recovery, performance tuning, security, migration and refreshes. I have participated in projects like. Data guard, Golden Gate, RAC, patches, upgrades Migration from Oracle to PostgreSQL. I have done installation and configuration of oracle and PostgreSQL software’s.

CONSUMERS ENERGY - JACKSON, MI

AUG 2019 – Present

Oracle/PostgreSQL Database Administrator

Responsibilities:

Installed, configured, and maintained Oracle 11g and 12g, 18c and 92c on Linux and windows. Also Upgraded from Oracle 11g to 12c and 12c to 18c & 19C.

Database Oracle and PostgreSQL performance monitoring and tuning. Backup and recovery and instituting backup strategies.

Migration from Oracle to PostgreSQL using EDB MTK (EDB ‘s Migration tool kit) and exposure to AWS migration procedure.

Configure Physical standby data guard for disaster recovery.

Configure enterprise manager and AppDynamics tools for monitoring databases.

Cloning and refresh of database from prod to lower environments.

Appling of patches and upgrade to booth Oracle and PostgreSQL databases.

Involve in setting up PostgreSQL replication involving AURORA POSTGRES

Prepare, update and automate scripts for database management and monitoring activities on PostgreSQL and Oracle

PostgreSQL replication binary and logical replication

Configure and managed Golden Gate replication of schema and full database.

Performance monitoring including network, operating system and database.

Database export using data pump and transportable tablespaces.

NEWEDGE - Chicago, IL

Feb 2016 – June 2019

Oracle/PostgreSQL Database Administrator

Responsibilities:

Installed, configured, and maintained Oracle 10g and 11g R2 and 12c on Linux and Upgraded from Oracle 10g to 11g and 11g to 12c.

Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.

Configure and monitor Goldengate unidirectional & bidirection for real time repliation

Database monitoring and performance tuning using OEM Cloud Control, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,

Performed Database refresh from Production RAC and Single instance environment to TEST RAC Single instance environment.

Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.

Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning) involving Golden Gate and Data Guard environments.

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain

Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 11g/12c environments.

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed/edit PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Responsible for configuring datagaurd physical and standby database setup for high availability and handling synchronization issues between primary and standby.

Done migration of non ASM database to ASM database.

Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

Set up failover for oracle clusterware for 11g r2 database with ASM.

Monitoring, Troubleshooting RAC cluster using SRVCTL and TAF(high availability failover).

Performed multiple cross platform migration from regular file system to ASM for TB of databases.

Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.

Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab and OEM.

Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.

Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.

Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.

Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Have installed and setup Oracle 12c databases on test servers to test the

Experience in configuring Goldengate unidirectional and bidirectional and monitoring the performance of golden gate.

Configure and monitor performance of E-business suites application.

Experience in implementation, configuring and monitoring Exadata

Experience in migration to Exadata

Assist in migration to AWS.

NEW BREED LOGISTIC - Greensboro, NC

Feb 2013 – Jan 2016

Oracle DBA

Responsibilities:

Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine-tuned them.

Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in linux environment.

Implemented and troubleshooting Golden gate (unidirectional and bidirectioal) for real time replication purpose both on homogenous and heterogenous environments. .

Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing Oracle processes and increasing SGA overall.

Coordinate, allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.

Tuned performance of databases. Found bottlenecking queries that impede application performance and fine-tuned them.

Periodically clone terabyte databases to QA and UAT.

Troubleshooting Golden Gate issues involving collusion, replication erros and lags.

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), ASH report, SQL tuning advisor, SQL access advisor, Segment advisor, SQL profiles, SQL baselines, SQLT reports, TOP, SAR, VMSTAT, IOSTAT, GLANCE for Performance tuning

Implemented Dataguard Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.

Hands on experience in E-business suite application monitoring, configuring and instalations.

Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2..

Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Invole in Exadata implimenation, monitoring, upgrade, patching and migration.

Implemented and troubleshooting Data Guard and GoldenGate for high availability/disaster recovery purpose. .

Operating Systems

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000, UNIX

RDBMS

Oracle 10g, 11g, 12c, 18c and 19c & PostgreSQL 9 and 10 AURORA POSTGRES, AWS

Languages

SQL, PL/SQL

Tools

TKPROF, EXPLAIN PLAN, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client Pgadmin, Psql,

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import basebackup, pg_dump, pg_upgrade, initdb

UNIVERSITY OF BUEA Cameroon

-Bachelors of Science in Banking and Finance, graduated with honors 2012

-ORACLE 12c CERTIFIED ASSOCIATE

-Scrum master

-SQL Fundamental 12c

Work Experience

Education

Contact this candidate