Oracle Data

OCA_ODb**gAdmin_clr

Career Objective: To obtain a challenging position in a high quality engineering environment where my resourceful experience and academic skills will add value to organizational operations as well as boost business growth.

Summary

An Oracle Professional over 7 years of experience as Oracle DBA. Worked extensively on Oracle 11g and 10g versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, ASM for storage management space management and security, RAC and Dataguard installation and monitoring for High Availability.

Technical Skills

Databases

Oracle 10g, 11g

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems

MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware

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

Experience Summary

* Full responsibility and expertise in database administration (DBA), performance tuning, database backup & recovery, security, optimization, data migration of Oracle instances and SQL-server databases.

* Successfully developed and implemented Client/Server applications on multiple platforms. Actively involved in software development, implementation, maintenance, support, troubleshooting, documentation and training.

* Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.

* Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.

* Authoritative in design, development, documentation and review according to standards.

* Excellent team player and works independently. Actively participates in team meetings and maintains good relations with everyone on the team and other teams.

* Backup and recovery (using OS scripts, RMAN and Log Miner)

* Database level performance tuning (using OEM, statspack, tkprof and trace analyzer)

* Use ASM for operation and performance optimization and storage management simplification.

* Oracle Server installation and patching

* Database creation, patching and migration

* SQL*Net configuration (over TCP/IP)

* Hands on experience in PL/SQL and SQL

* Replication (snapshots/materialized views)

* Bulk loads and data migrations (using SQL*Loader, data pump import/export)

* Unix shell scripting (Korn shell) and Windows command prompt (.bat & .cmd)

Professional Experience

JP Morgan Chase Bank - Wilmington, DE Feb 2011 – Present

Role: Oracle Database Administrator

* DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB (in ODS & EDW environments).

* Monitored Real Application Cluster (RAC) databases for high availability, scalability, manageability and load balancing with the use of TAF on both 2 and 3 nodes RAC databases

* Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.

* Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1

* Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

* Analyzed SQL queries causing performance problems and tuned them to improve performance up to 40%.

* Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities

* Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices

* Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

* Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins

* Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g expdp/impdp data pump.

* Analyzing schema of databases created to collect statistics using the DBMS STATS package.

* Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.

* Troubleshoot installation errors both independently and with Oracle support (via My oracle Support)

* Create oracle databases on configured servers using both the DBCA & Database creation scripts.

* Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).

* Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), SQL*Plus, as well as pre-developed UNIX shell scripts.

Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

BCD Travels, Atlanta - GA June 2009 – Feb 2011

Role: Oracle Database Administrator

* 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) Database.

* Supported the Implementation of Standby Databases on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

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

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

* Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

* Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

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

* Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

* Performed space management, capacity planning, disaster recovery and overall database maintenance.

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

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

* Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

* Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

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

Diebold - North Canton, OH May 2008 – June 2009

Role: Oracle Junior DBA

* Configure. Implement & Deploy Oracle 9i (9.2.0.8) & Oracle 10g (10.2.0.4), single instances on SunOS 5.9 using files systems for storage & VERITAS Clustering for high availability using IBM’s HACMP

* Create oracle databases ( single instance ) on configured servers using both the DBCA & Database creation scripts.

* Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

* Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.

* Backup/Recovery of Oracle 9i/10g databases using Oracle RMAN.

Tools Used: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Academic Details

* Advance Diploma in IT: Networking & Operations - Opportunity Industrialization College Buea.

* Bachelor of Science in Computer Engineering (BSc Cmp E) - University of Buea.

* Associate Degree in Communication Networks and Security - University of Information Science and Technology in Ohrid Macedonia.

* Oracle Certified Associate.

Contact this candidate