Oracle DBA

JOHN MBA

**********@*****.*** 301-***-**** Greenbelt, MD 20770

ORACLE DBA

Key skills:

Consolidation Database Administration SQL Shell Scripting Linux Operating Systems UNIX Backup

Application Development Performance Analysis Perl Relational Databases Oracle PL/SQL

Microsoft SQL Server Data Warehousing

PROFESSIONAL EXPERIENCE & ACHIEVEMENTS

Over 6 years of strong experience in Oracle Database Administrator in heterogeneous system environment including Solaris, UNIX, and Windows. Excellent experience in Installation and configuration of Oracle 10g, 11g, 12c, in UNIX/LINUX and Windows environment. I have complete SDLC life cycle knowledge including production and project support. Proficient working on Oracle 10g, 11g and 12c versions involving database administration, production support, upgrades, patches, migration, backup and recovery, performance tuning, installation, configuration, upgrades, cloning, space management and security.

KBC Health Care, Washington, DC 2015 to 2018

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

Primary DBA for 10+ databases of Oracle 10g/11gR2 and GOLDEN GATE, RAC

administration on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.

Data guard - configure primary - standby using duplicate from active database

command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.

RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11GR2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM.

Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

Installation of 3 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices.

Expertise in the creation of databases, table spaces, tables, indexes and other database objects.

Installed and manage Oracle Enterprise Manager.

Install and configure relevant network components to ensure database access as well as database consistency and integrity.

Troubleshoot and resolve various Oracle connectivity problems.

Provide network troubleshooting and administrative support for the development staff.

Designed daily, weekly Backup and Recovery procedures for production, non-production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Used explain plan and stats pack/TKPROF utility to Improve response time of query.

Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies.

Monitoring the CPU, memory usage, I/O contention on servers using top, iostat,sar, glance, vmstat etc.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.

Implemented Point in time recovery using RMAN.

Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new OEM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management.

Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.

Support 24/7 on call rotation.

Configuration and implementation of Oracle for high availability. Implemented downstream capture at the destination database using Oracle Streams.

Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Experienced in Data Warehouse. Proficient with ETL tools like SQL*Loader and External Tables.

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

Experienced in configuration of ASM for RAC and NON- RAC environments.

Configured Repository and clients for GRID Control and also implemented DB Control for some databases.

Extensively worked on setting up auditing in many databases we supported

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Installed ASM environment and migrated databases from NON-ASM to ASM. Monitored different databases and application servers using Oracle Enterprise

Manager (OEM) 12c Grid Control.

Mecury Insurance Group, Bridgewater, NJ 2012 to 2015

ORACLE DATABASE ADMINISTRATOR

Responsibilities:

Primary DBA for 100+ databases of Oracle 10g/11gR2 on Linux REHL, HP-UX.

Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT)

call.

RAC - Administration/Trouble-shooting of 2 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.

Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

Data guard - configure primary standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archive logs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.

Managed Data Guard using Data Guard broker.

Troubleshoot and resolved log gap in Data Guard Configuration

Managed Container and pluggable databases

Cloned 12c database

Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment.

Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.

Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies

Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.

Tuning performance using Advisors, AWR, ADDM, SQL tuning.

Implemented Point in time recovery using RMAN.

Experience using like - Real Application Testing, Table and partition recovery

Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results

Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

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

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

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

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

EDUCATION & TRAINING

Bachelors of Science in Information Technology, University of Buea

PROFESSIONAL CREDENTIALS

Oracle Certified Associate - Oracle

Oracle certified Associate (OCA)

ACHIEVEMENTS

OPERATING

SYSTEMS:

Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 11g/10g/12c.

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/

APPLICATIONS/

TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise

Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle

Management Service (OMS), Real Application Clusters (RAC),

ASM, Sql Navigator, TOAD, Data Pump

(expdp, impdp), SRVCTL, SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and

ADDM

WEB TOOLS: HTML, XML

Contact this candidate