Senior Oracle DBA Engineer Resume Roanoke, VA - Hire IT People

SUMMARY

Install, configure High availability, Oracle 10g/11g/12c and 19c RAC, Replication, with ASM or Cluster File on Unix/Linux or VM
Install, configure and implementation of Oracle Database Replication using Oracle Golden Gate software v12 and v13 for last 4 years.
Server build: Size, Estimate and Build Oracle RAC servers for Cluster Databases in 10g/11g which includes design of required CPUs, Physical Memory, SAN Disks storage to provide maximum performance of database
Tune, size, analyze and migrate Oracle instances with QUEST/OEM and UNIX Shell Scripts
Design/model DB structures to support a variety of software applications in 24x7 environments
BCV /SRDF SAN Configuration with Service Guard, Metro Cluster, VERITAS and OCFS2
Configure/implement/testing of Rman/In - house scripts backups using various backup software's like Autosys, Legato, Tivoli, and NetVault
Support developers in tuning DB and Apps for optimal performance and generate Database Performance Metrics.
Monitor DB growth and provide DB capacity planning for Apps expansion/retention
Migration of databases between software versions, platforms, and DB products
SQL and PL/SQL: scripts, triggers, procedures, packages, automation projects

PROFESSIONAL EXPERIENCE

Confidential, Roanoke, VA

Senior Oracle DBA Engineer

Responsibilities:

Linux (RedHat RHEL 4,5,6,7,8 and Oracle Enterprise Linux) and AIX 5/6/7
Oracle 10g/11g/12c/19c RAC as well as Single instance on AIX and Linux Clusters with ASM on physical as well as on VMs
Oracle Exadata - Performed in-depth POC for Exadata implementation and performance testing
Oracle Enterprise Manager 12c/13c Grid Control, TOAD, SQL Navigator
People Soft Applications modules Finance/HR and ELM
Oracle Golden Gate Replication between two data centers using GG v12 and v13
Warehouse application Red Prairie
Oracle Retail Application RETEK and OBIEE
Other home grown Apps for Credit Card processing and Order system

Confidential, Richmond, VA

Senior Oracle DBA

Responsibilities:

Working as senior member of DBA's Team to Support DEV, TEST, QA and PRODUCTION database Clusters in 10g RAC/Single instance Environments as well as 8i/9i Legacy Systems
Handle Database model reviews/capacity planning/build out process
Prepare Database performance metrics for database availability and SLA compliance from both a database and end-user perspective
Involve in major upgrades planning and implementation
Work with Oracle Support on major performance/outage issues
Identify critical patches CPU/PSU and manage installation process
Monitoring daily DB activities, performance issues (IO, Memory, CPU, Lock/Latch contention) with DBA tools like TOAD, OEM, Symantec In-Depth and Cluster Scripts.
Help Developers with Physical Database Design, Storage Growth Estimation and approval.
Identifying High Resource consuming SQL statements and help developers to solve the problem with explain plans, indexing and code rewrite.
Help Application Teams to migrate Apps from 8i/9i Legacy Systems to 10g RAC/Single instances.
Mission Critical Production database Administration for 24x7 supports
Development and Testing of DR (Disaster Recovery) Systems.
Successful migration of critical Brokerage Applications from 8i/9i to 10gVersion Databases.