Manager Oracle

\

US CITIZEN

Skills Summary

I am a highly skilled IT professional with over 6 years of experience as an oracle database administrator. I have supported Different versions of the oracle database namely 12c, 11g and 10g. I have been a DBA for project work as well as production support.

Experience in translating business requirements into conceptual, logical, and physical data models.

Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisors, autotrace and execution plan.

Experienced with Database Security Administration, system monitoring including adding and removing users, configuring quotas, auditing, and analyzing security problems.

Experience providing 24x7 Production Support, troubleshooting / resolving various types of production issues.

Expertise installing, configuring and maintaining Oracle high availability solutions like Real Application Cluster (RAC) on Oracle 10g & 11g both on Windows and Linux platforms.

Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.

Experienced performing manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups. Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 10g 11g databases.

Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, indices.

Working experience in database cloning, database backup, recovery procedures and security.

Experience in application Support, SQL Loader, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces.

Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.

Hands on experience in installation and maintenance of enterprise manager 12c and Grid Control 11g and addition of targets for database Monitoring/Performance/Diagnostics purposes.

Installed Grid Control with RAC repository and configured cloning of agent installations

Resolved the crs issues in RAC database in different scenarios ( time synchronization, kernel parameters, inter instance communication bugs, ASM monitoring from OEM, SAN modifications, network modifications, cluster hung, temporary tablespaces)

Modified network interface for RAC public and private interconnects

Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases

Experience in Performance Tuning, Tuned various large critical OLTP and OLAP databases using various tools like AWR, STATSPACK, ASH, SQL-TRACE, TKPROF, ADDM and Explain Plan Utilities. Experience in the management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.

Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.

Adept at installation of OEM Database Control, OEM grid control and Deploying Agents

In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.

Installed and configure Veritas cluster(Veritas storage foundation) for RAC database installation an configuration and upgraded it from 10g to 11gR2

Migrated OCR and Voting disk from GPFS to ASM

Work Experience

Iowa Foundation for Medical Care - West Des Moines, IA

January 2016 – Present

Oracle Database Administrator

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.

Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Creating, granting and monitoring user access rights and privileges through roles and profiles.

Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.

Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.

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 PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

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

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements

Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.

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

Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 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. Monitoring and Performance tuning of GoldenGate sessions at OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and Log Dump utility.

Developed Shell scripts, SQL & PL/SQL scripts for monitoring GoldenGate processes and their stats running on 60+ servers from one single database repository providing table level granularity with end-to-end replication map and thus maintain history of all GoldenGate processes for later analysis.

Development of policy and procedures as they relate to database maintenance, security and archiving.

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

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.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, choosing the best hardware configuration for Oracle RAC.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

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

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

Xcel Energy - Minneapolis, MN

March 2012 – December 2015

Oracle Production Support Database Administrator

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 11g Grid Control.

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

Creating and assigning appropriate roles and privileges to users depending on the user activity.

Defragmentation of tables and indexes for improved performance and effective space management.

Responsible for support of Oracle Databases of sizes ranging from 100 GB to 40 TB.

Part of DB support team, providing 24/7 support for Production databases.

Responsible for design, installation, administration, capacity planning, upgrade, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 12c/ 11g, 10g databases, on Development, Test, QA and Production environments.

Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.

Loading data from flat files to database using SQL*Loader, External Tables.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

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

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

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

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

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Education

BUSINESS ADMINISTRATION & MANAGEMENT (BACEHLOR DEGREE)

COMPUTER SCIENCE (BACEHLOR DEGREE)

ORACLE DATABASE ADMINISTRATION CERTIFIED (OCA)

UNIVERSITY OF ORACLE.

Funke Adeyeye

Email: **************@*****.***

Phone: 301-***-**** OR 202-***-****)

FA

Contact this candidate