Ngo Mpondi Marie Florence

Oracle Database Administration

adabwh@r.postjobfree.com

240-***-****

Oracle Database Administrator

Dedicated Oracle Database Administrator with over 6 years of experience in developing, designing, and managing databases, including administering to over 400 databases in various environments. Excels at supporting full life cycle development for 10g, 11g, and 12c versions on systems including UNIX, Linux, Solaris, and Windows. Adept at all aspects of database administration including migration, cloning, and replication to ensure data integrity. Areas of expertise include:

OPERATING SYSTEMS AND HARDWARE:

MS Windows

UNIX

Solaris 8/9/10

AIX

HP-UX

Linux

Sun Fire 15K

Sun 6320 Storage

Sun Enterprise Servers 890/880/420/450

Sun StorEdge 6320

Hitachi

EMC

Dell Servers

Compaq Servers 6000/3000/1600/ 800

HP/UX-9000

Red Hat Linux 6.2

DATABASES AND DATABASE TOOLS:

Oracle 10g, 11g, 12c

Oracle Enterprise Manager (OEM)

OEM Grid Control

SQL*Plus

SQL Loader

DB Configuration Assistant

TOAD

RMAN

Export/Import

Datapump

Goldengate

Net Configuration Assistant

Net Manager

Netstat

Log miner

Statspack

AWR

Shareplex Top

DBCA

DBUA

ADDM

Migration Workbench

Erwin

QDesigner

Remedy

RAC

ASM & ACFS file systems

Explain Plan

TKPROF

SQL*TRACE

SQL Tuning Advisor (STA)

SQL* Analyzer

Patch Sets

ASM

Flashback Recovery

Data Stage

Oracle Streams

CDC

PROFESSIONAL EXPERIENCE

M&T Buffalo, NY

Oracle Database Administrator Oct. 2016 – Present

Successfully upgraded and migrated databases from 10g and 11g to 12c, while setting up, configuring and installing 12c on Solaris 10 and RHEL 6 while applying necessary patches

Maintained database security and functionality through application of upgrade, maintenance, and interim patches

Utilized RMAN and RMAN active clone to setup Dataguard and creating backups and rebuild Dataguard

Collaborated with application development team to resolve issues

Used ASM and Scan Listener technology for implementing 11gR2 RAC

Troubleshot and supported all daily user issues and creating roles, privileges, user accounts, and grants

Managed data in SAN with ASM and EMC storage

Extensively used OEM 10g Grid Control to monitor all database and application servers

Used SQL*Loader and external tables to load flat file data to databases

Performed periodic performance tuning using AWR, ADDM, and Explain Plan

Improved performance significantly by reorganizing databases, schemas, and tables with Datapump and export/import

Became experienced with Multitenant databases

Implemented and managed an optimum physical database design and carefully monitored storage, growth, and file system space to analyze database capacity

Recovered massive 1 TB database when UNDO tablespace was corrupted in RAC

Used RMAN for remote server and SRVCTL for RAC database to create a clone database

Implemented high availability and performance configurations for Dataguard and ran Dataguard failover tests

Monitored all data transfers between database servers

Extensively used RMAN to implement hot and cold backups and recovery

Maintained aggregates, compression, partitions, and indexing to performance tune queries

Monitored all databases through skillful installation and configuration of Database and Cloud Control 12c

Created monthly and annual performance reports to analyze trends and capacity plan

Properly diagnosed database performance issues at all levels including SQL, PL/SQL, design, tables, indexes, memory, and java calls

Highly familiar with data warehouse DBA skills regarding administration and management of VLDB environments and OLTP

Provided accurate reports through efficient writing of UNIX/SHELL scripts

Bank of Oklahoma Tulsa, OK

Oracle Database Administrator Mar. 2013 – Sep. 2016

Installed, configured, and maintained all 10g/11g RAC

Created an effective Grid monitoring solution for large databases

Installed Clusterware to configure public, private, and VIP data

Implemented and configured Grid Control on RHEL server

Utilized Crontab to schedule and perform logical backups of critical application database

Created all RMAN catalog databases, registered them in catalog database, and used RMAN duplication to clone production RAC to development and QA systems

Optimized performance by defragmenting tablespace data blocks and partitioning large databases

Reduced complexity inherent in Oracle streams through Goldengate evaluation and configured Oracle Steams for data replication, monitoring them with Grid Control

Skillfully performance tuned queries, DBMS, and individual production databases

Conducted migration review meetings for the application team to devise appropriate migration strategies

Enforced data confidentiality, integrity, availability, and auditability depending on data access controls at database level

Extensively used AWR, ADDM, and ASH to perform SQL and PL/SQL tuning and production database monitoring

Utilized GRID infrastructure on RHEL 5.5 to install, setup, and create 4-node cluster RAC database

Used Dataguard to effectively install and maintain a physical standby database for 11.2.0.3 and 10.2.0.5 RAC databases

Planned maintenance activities to include primary and standby database switchovers

Used 10g Grid Monitoring tool to proactively monitor database health

Tuned databases and performed extensive performance tuning using SQL*TRACE, STATSPACK, Explain Plan, TKPROF, memory (SGA) tuning, net backup, EMC (time finder and SRDF), RAID, and RAW Devices

Setup test and development databases by cloning databases

Oversaw all optimization of queries and application tuning

Aided developers in coding PL/SQL and performed all SQL tuning

Coordinated and collaborated professionally with system administrations, application developers, and other database administrators.

Certifications

Oracle Administration 12 SQL Fundamental

Oracle Certified Associate 12C.

Education

Bachelor’s in information systems management, university of YAOUNDE

Contact this candidate