Christianah T. Akindele-Banwo

Oracle Database Administrator

667-***-****

ac2ffn@r.postjobfree.com

Skills Summary

As an Oracle Database Administrator with 6 years of experience across multiple platforms, I have worked in large-scale production environments such as data warehouse, using Enterprise Applications, Client and Server and ERP Applications. I have the capacity to give master level specialized technical support in all parts of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery. I am proficient in Oracle Real Application Clusters (RAC), GoldenGate and Data Guard.

6 Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support.

Extensive hands-on experience in installations, configuration, security, patching and upgrades of Oracle on different platforms like Windows, Unix, Linux, RHEL and Oracle Solaris.

Able to provide 24x7 production support and development support.

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

Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN), including block, data file and database recovery and using RMAN point-in-time recovery option.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).

Installation and configuration of Oracle 10g &11g RAC using clusterware and ASM.

Installed Oracle Golden Gate 11g and implemented uni-directional and bi-directional replication.

Experienced in installation and configuration of Oracle primary and standby (Data Guard) database and switchover/switchback of database in 10GR2 /11GR2 RAC

Experience in multi-node and RAC environments.

Experience in very large scale database environment and mission critical large OLTP and OLAP systems.

Created Development, Testing, Staging, Production, RAC and standby databases for OLTP, DSS and data warehousing using customized shell scripts and stepwise.

Highly experienced in cloning of Oracle databases from multi-node to single-node, and single node to multinode.

Enabling load balancing in multi-tier architecture.

Created clone databases for Development and Test environments using RMAN, user managed cloning and implementation of Flashback Technology.

Implemented data transfer using transportable tablespaces (TTS), Data Pump and export/import utilities.

Enforced security administration and system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

Setup procedure for database statistics gathering to determine the frequency, best time of the day to execute stats gathering jobs, and the correct level of statistics to gather.

Able to generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.

Configured Targets and used OEM to do daily tasks regarding database performance and maintenance.

Developed shell scripts and SQL scripts to carry out routine checks on databases.

Implemented proactive monitoring scripts for production databases.

Experience troubleshooting for slow performing SQL by enabling database tracing including session specific tracing.

Utilized SQL* Loader to migrate or load data to Oracle.

Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.

Experience in SQL tuning using Explain Plans and hints; performance tuning of databases using tuning applications; instance tuning, and tuning disk usage.

Worked on different types of storage structures (SAN/NAS).

Installed patches using Opatch utility and developed expertise in applying Oracle PSU and CPU patches.

Implemented multiple upgrades of Sun Solaris and Linux servers from 9i to 10g, 10g to 11g and 11g to 12c.

Experience with Oracle Support Process for technical requests using Oracle Metalink and other support procedures.

I am a results oriented, self-motivated, team player, with the ability to work independently, during weekends and on-call rotations for support and maintenance activities. I have a track record of meeting the SLA's within time, and I have the ability to learn any technology and become productive.

Career Summary

Sun National Bank - New York, NY March 2014 – Present

Role: Oracle Database Administrator

Responsibilities:

Supporting multiple databases for Production, Development, Test and Staging purposes on Sun Solaris and Windows environments.

Implementing switchovers on primary and standby databases as a part of planned maintenance activities.

Implementing Data Guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.

Implementing ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Participating in project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements.

Installing, patching and upgrading Oracle 10/11g & 12c to support internal Production and Test environments.

Installation of 12c OEM and customizing it to our needs.

Installing Oracle GoldenGate on RHEL and setting up table-level replication as well as DDL replication.

Migrating databases across different servers and platforms using transportable tablespaces (TTS), Data Pump, export/import and performing database refreshes and RMAN cloning.

Planning and implementing disaster recovery solutions using Oracle Standby Database / Data Guard and performing data replication using Golden Gate technology.

Rebuilding indexes, partitioning tables, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Statspack to optimize performance.

Solving ORA errors and applying bug fixes with the help of Oracle support/MetaLink.

Installation of OEM 10g grid agent on servers and configuration of OEM 10g Grid Control.

Administering RAC database servers using SRVCTL, VIPCA, OEM Grid control, V$/GV$ views and system-wide tuning using UTLBSTAT and UTLESTAT.

Automating the data replication process using Materialized Views for reporting databases.

Configuring EM agent on multiple database servers and using Oracle Enterprise Manager (OEM) 11g Grid Control to monitor multiple databases, and manage database alerts and notifications.

Implementing Data Pump, conventional export/import utility of Oracle 11g, 10g for re-organizing databases/schemas/tables to improve performance.

Using import/export utilities for cloning/migration of small sized databases and Data Pump import/export to move data between 9i and 10g/11g 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.

Developing PL/SQL packages, DML, DDL, Oracle tables, stored procedures, functions, cursors, triggers and UNIX shell scripts.

Alert management: creating and setting up alerts to notify application users wherever necessary.

Performing day-to-day activities like backup-restore, space management, monitoring database alerts, and performance tuning.

Proficient in troubleshooting Node Eviction in Oracle RAC Environment.

Applying PSU patches and other database related patches.

Administering Oracle clusterware components.

Configuring ASM and handling administration of a RAC database including: suggesting workarounds for ASM metadata corruption and configuring user logs on load balancing and failover on RAC database.

Responsible for SQL query tuning and optimization. Performed database tuning and optimization using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.

Efficient installation, setup and creation of two node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for high availability, scalability and performance by determining the best Cluster architecture, and choosing the best hardware configuration for Oracle RAC.

Successful installation/maintenance of physical standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases.

Implementing proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning using OEM (Oracle Enterprise Manager).

Environment: Oracle 11g/11g RAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, Unix, TOAD, RMAN, SQL server, OEM.

Mckesson Corporation - Henrico, VA June 2011 – Feb 2014

Role: Oracle Database Administrator

Responsibilities:

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

Implemented recovery strategies and successfully recovered databases from crashes, and data files from media/disk failures by using RMAN.

Scheduled physical backups (hot & cold) in CRONTAB using RMAN utility and monitored the scheduled jobs.

Responsible for creating users, groups, roles, profiles and assigning the users to groups and granting necessary privileges to the relevant groups.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Responsible for continuous monitoring of CPU usage, I/O contention, memory paging, identifying bottlenecks, and reorganizing resources to ensure high performance.

Monitored queries with high response time and high disk read per execution (Top SQLs) and tuned slow-running SQL using Explain Plan, TKPROF and SQL tuning advisor.

Increased performance by defragmenting data blocks in tablespaces, and by partitioning large tables.

Responsible for database administration such as user management, space management, and database security management.

Applied patches to Oracle database versions: 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.

Constantly monitored the performance of databases by viewing alert log files & trace files, and consulting V$ dynamic performance views at peak load times.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24 X 7 support for all the production and development databases.

Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Implemented Oracle's transportable tablespace (TTS) feature using Data Pump export/import (Oracle 11g, 10g) allowing users to move a user tablespace across Oracle databases.

Implemented data refreshes (at database, schema & table level) using RMAN utility, Data Pump, and conventional export/import in Oracle 11g, 10g.

Performed installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application Cluster) database.

Ran scripts to check the status of databases for growing table sizes, extent allocation, free space, used space, and fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Created physical standby databases using RMAN with zero downtime, and performed failover and switchover using both Data Guard Broker and the manual method.

Worked extensively with physical standby databases, troubleshooting, and performing switchover and switchback with physical standby setup.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Education

Ogun State University, Lagos, Nigeria

Bachelor of Science in Industrial Chemistry

Technical Skills

Front-End Tools:

MS Excel, MS Word, MS Visio, MS Project

Databases: Oracle 11g, Oracle 10g, Oracle 12c

Oracle Database Tools:

SQL*Loader, TKPROF, Toad, OEM, Toad, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Developer, Grid Control

Operating Systems:

Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2000/2003 server

Contact this candidate