Resume

Sign in

Oracle Database Administrator

Location:
Houston, TX
Posted:
September 14, 2018

Contact this candidate

Resume:

Christianah T Akindele

Oracle Database Administrator

667-***-****

Houston, TX

ac61ui@r.postjobfree.com

PROFESSIONAL CERTIFICATIONS & EDUCATION

Bsc in Computer Science

Olabisi Onabanjo University, Nigeria.

Visa Status: Green Card

Oracle Database 11g Administrator Certified Associate (OCA)

Oracle Database 11g: Structured Query Language (SQL)

Skills Summary

An Oracle Database Administrator with over 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), Golden Gate 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, 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 database instances.

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.

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.

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

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.

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.

Career Summary

Sun National Bank - New York, NY 05/2017 – Present

Role: Oracle Database Administrator

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. 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.

Administer multi-terabyte Oracle 11g databases on Linux as well as 11g and 12c databases on Oracle Exadata. Apply and develop knowledge of cluster and HA technologies, including Data Guard, in multiple geographically dispersed data centers.

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.

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.

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

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.

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

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

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

Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing recommendations to make database healthy and running

Worked on Database Wallet and TDE (Transparent Data Encryption) for encrypting the Sensitive data using column encryption and tablespace encryption.

Created, managed and maintained databases supporting Oracle E-Business Suite applications (Oracle Financials and Customer Relationship Management).

Proficient in troubleshooting Node Eviction in Oracle RAC Environment.

Applying PSU patches and other database related patches. 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.

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

Mckesson Corporation - Henrico, VA 03/2015 – 04 /2017

Role: Oracle Database Administrator

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 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.

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 supports 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.

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

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

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

Implemented proactive monitoring scripts for production databases.

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.

Oracle Database Administrator

Bartlett & West – Bismarck, ND 01/2012 – 02/2015

Responsibilities:

Implemented backup strategies which involved taking an incremental backup and enabled the block change tracking feature.

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

Constantly monitoring the database performances by viewing alert log files & trace files, and consulting V$ dynamic performance views at peak load time and executing space management scripts.

Configured database system management, creating database, Tablespaces, users, roles and granting privileges.

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

Configured backup strategy, Database restores and database recovery using various tools.

Hands on experience in Hot/Cold Backup, Recovery & Cloning of databases using RMAN and stored backup.

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

Experienced with UNIX and SQL commands

Experienced in implementing Data Pump, Export and Import using transportable tablespace.

Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Installation of Oracle 10g, 9i on window, RH Linux, Sun Solaris and upgrading to a new version and applying patches as required.

Involved in capacity planning

Experienced in maintaining database security using auditing.

Environment: Oracle 10.2.0.1, Oracle 11g/11g RAC, VMS, Sun Solaris, Windows 2003 Server, Red Hat Linux, SQL server,, HP-UX 11, Sun Solaris 10.0, Oracle Streams.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Tools Used: OEM, TOAD, RMAN, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, SQL*Loader, TKPROF, Toad, OEM, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Developer.

`



Contact this candidate