Resume

Sign in

Oracle Database Administrator

Location:
Cypress, Texas, United States
Posted:
January 05, 2018

Contact this candidate

Titi C. Akindele

Oracle Database Administrator

667-***-**** ac3xe6@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Certified Oracle Database Administrator with over 6 years of experience installing, configuring and administering Oracle Database versions 10g/11g/12c on UNIX, Solaris and Windows platforms. Experience managing databases in development, testing and production environments. Strong experience leading migration, high availability and disaster recovery initiatives. Recognized for superior troubleshooting and performance tuning capabilities. Demonstrated problem-solving skills with a commitment to customer/end user support.

TECHNICAL SKILLS

Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup, Recovery, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting and Documentation.

Extensive experience providing 24x7 Production and Development support.

Proficient in installation and configuration of High Availability infrastructure – Oracle Real Application Cluster (RAC) on multiple nodes with Automatic Storage Management (ASM) storage on Red Hat Linux operating system.

Experience installing and configuring Enterprise Manager Cloud Control 12C (OEM-Grid Control) to monitor/manage Oracle Targets.

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

Experience in implementing and planning physical and logical backup and recovery strategies using Recovery Manager (RMAN), Recovery Catalog and Data Pump.

Proficient in the installation and configuration of disaster recovery, data integration and replication infrastructure - Oracle Active Data Guard (Physical, Snapshot, Logical Snapshot) and Oracle Golden Gate 12c (uni-directional and bi-directional replication).

Experience in resolving bi-directional issue regarding Data looping.

Proficient in troubleshooting and resolving any abending issues with Golden Gate processes.

Proficient in the design and implementation of UNIX Shell Scripts to simplify database. support tasks including RMAN database backup/recovery, database refresh and CRONTAB jobs.

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.

Platforms: UNIX, Red Hat/Oracle Enterprise Linux 5/6/7, OEL, Windows 7/8/10, Windows 2008 /2012 Server, Sun Solaris.

Languages: SQL, T-SQL, PL/SQL, UNIX Shell Script, VBSCRIPT, HTML.

Database: Oracle Database 10g, 11g and 12c, SQL Server 2008/2012.

Tools: SQL*Plus, SQL*Loader, TOAD, Recover Manager (RMAN), Oracle Enterprise Manager (OEM), Grid/Cloud Control, Data Pump, Automated Workload Repository (AWR), ADDM, ASH, Oracle Scheduler, Oracle SQL Developer, OS Watcher, Statspack, TKPROF, SSH, TCP/IP, Putty, Xming, WinSCP.

PROFESSIONAL CERTIFICATIONS & EDUCATION

Oracle Database 11g Administrator Certified Associate (OCA)

Oracle Database 11g: Structured Query Language (SQL)

Bachelor of Science, Ogun State University

PROFFESIONAL EXPERIENCE

Oracle Database Administrator

Sun National Bank – New York 06/2014 – Present

Responsibilities:

Worked as Project Lead to upgrade/migrate oracle 11gR2 database and Grid Infrastructure to Oracle 12c on Oracle Enterprise Linux 6.

Worked with developers to review, test and install Oracle recommended patches to fix Oracle Applications issues/bugs and create database objects in Production.

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

Implemented Oracle Enterprise Manager Cloud Control (OEM 12c) for centralized monitoring and administration.

Setup Oracle Data guard 12c on Linux 7.3 Platform.

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

Perform database backup and recovery duties, establish standards and schedules for database backups, develop and test recovery procedures, and ensure backup schedules meet the recovery requirements.

Migrated databases across different servers and platforms using transportable tablespaces (TTS), Data Pump and performed database cloning using RMAN.

Rebuilding indexes, partitioning tables, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, AWR Report-Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) to optimize performance.

Planned and implemented disaster recovery solutions using Oracle Data Guard (Physical, Snapshot and Logical Standby) and performed data replication using Golden Gate technology.

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

As a Project Team Member - Installed and configured High Availability Infrastructure – Oracle Real Application Cluster (RAC) on multiple nodes including 3-Node RAC with Automatic Storage Management (ASM) on Red Hat Linux.

Proficient in troubleshooting Node Eviction in Oracle RAC Environment.

Successfully performed migrations from Oracle 10g to 11g RAC (Real Application Cluster) database.

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

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

Tune PL/SQL queries and create DML, DDL, Oracle tables, stored procedures, functions, cursors, triggers and UNIX shell scripts.

Environment: Oracle 11g/11g RAC, VMS, Sun Solaris, Windows server 2003, Red Hat Linux,

Tools Used: TOAD, RMAN, SQL server, OEM.

Oracle Database Administrator

Mckesson Corporation - Henrico, VA 06/2011 – Feb 2014

Responsibilities:

Provided 24/7 support for all the Production and Development databases.

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

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

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

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

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

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

Used SQL TRACE, TKPROF, EXPLAIN PLAN and SQL tuning advisor utilities for optimizing and tuning slow-running SQL.

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

Performed installation and configuration of Oracle 10.2.0.1 database on Linux platform.

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

Created, modified and maintained Oracle database objects and storage structures including tablespaces, tables, directories and indexes.

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

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

Environment: Oracle 10.2.0.1, Linux, Sun Solaris 10.0

Tools Used: RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

References: Available upon request/Green Card Holder



Contact this candidate