SUMMARY:

• Extensive experience working on databases over 5 Terabytes (VLDB)
• Installed and configured Oracle 10gR2, 11gR2, 12c with ASM storage on Linux RHEL
• Installed and configured 3 - node database cluster with 11gR2 Grid Infrastructure
• Extensive experience in upgrading RAC and Non-RAC databases from 11.2.0.3 to 11.2.0.4 and 12c
• Strong experience in upgrading 11gR2 Grid Infrastructure from 11.2.0.3 to 11.2.0.4 and 12c for RAC and standalone
• In-depth knowledge and experience with installation, configuration and management of Oracle Enterprise Manager (OEM) 10g and 12c
• Extensive experience with database cloning using RMAN duplicates, storage snapshots and 3rd party software Delphix
• Working knowledge in Oracle E-Business Suite Administration (ERP)and Architecture EBS 11i (11.5.10.2) and EBS R12 (12.2.3)
• Extensive experience working with Linux on Virtual (VM) and Physical servers
• Experience in analyzing and applying quarterly CPU patchset (security) on all Oracle products
• Experience in designing and implementing enterprise-wide database backup and recovery strategies
• Lead and supervise a team of 4 off-shore DBAs on a 4 year project on Oracle E-commerce implementation
• Data corruption handling
• Working knowledge of Oracle RAC implementation and administration
• In-depth knowledge and experience in full database lifecycle including data architecture and logical/physical database designs
• Experience in performance tuning using OEM, Explain Plan, AWR and ADDM
• Extensive experience of PL/SQL programming and shell scripting
• Extensive experience in Patch Analysis and Patching (Opatch and Adpatch)
• Well experienced in data conversion and data loading using SQL* Loader
• Strong UNIX/Linux administration skills
• Administration, Monitoring, and complete lifecycle management of production and nonproduction Oracle environments
• Provide 24x7 technical support for production database and maintenance
• Working knowledge in Oracle Data Guard (Physical or logical standby) on Oracle 11gR2.
• ETL support for Business Intelligence and reporting team
• Security Hardening implementation based on Oracle best practices
• Train and mentor Junior DBA
• Extensive experience in managing off-shore resources timelines and projects
• Thoroughly conversant with System Design Life Cycle (SDLC)
• Expert in System Documentation
• Self-motivated team player with excellent communication and writing skills.

TECHNICAL SKILLS:

DBA Tools/utilities: Toad 10.6, Toad 11, SQL Developer, OEM Grid Control

Backup Tools: RMAN, Data Pump, Delphix

Storage: X-IO, Pure, EMC-Clarion - T2, EMC-VMAX - T1, EMC-VNX, EMC-NS240 & NS480, SAN

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Senior/Lead Oracle DBA

Responsibilities:

• Multi-node installation of 11gr2 Oracle databases on ASM
• Review, analyze and apply quarterly CPU security patches
• Database and Grid Infrastructure upgrade from 11.2.0.3 to 11.2.0.4 with HugePages
• Database and Grid Infrastructure upgrade from 11.2.0.4 to 12.1.0.2 with HugePages
• Administration and support of Active Oracle DataGuard 11gr2
• Lead, prioritize and manage a small DBA team (5 members) with project goals, timelines and requirements.
• Create custom shell scripts for daily monitoring of database health and automate routine tasks such as database cloning.
• SQL performance tuning
• Baseline collection of top queries for SQL Tuning
• Implement PCI compliance security measurements as needed
• Cloning and refreshes using RMAN duplicate, data pump and storage snapshot, Delphix
• Manage 3rd party cloning software (Delphix) to implement quick cloning strategies
• Disaster recovery and comprehensive backup and recovery strategies
• Monitor database size and growth using custom shell scripts and OEM reporting
• Provide administration support on Fusion Middleware components
• Collaborate with storage team with implementing daily reports on storage performance of LUNs in Production
• Install and configure Oracle Enterprise Manager 10g, 12cR1, 12cR2 and 12cR5 on Linux RHEL 6.x
• Configure and defined custom rule sets and metric collections for system monitoring notifications. Notifications through emails at warning thresholds and both emails and SMS text messages at critical levels. Rule set metrics included targets/HTTP server availability, agent/agent upload/listener, host/database/tablespace usage
• Collaborate with Storage team with storage implementations and Linux template builds for VM creation
• Deployed SOA Management Pack, BI Management Pack and Application Management Pack to Production environments
• Configure compliance framework/standards for PCI compliance regulations
• Create data masking definitions and custom scripts for masking sensitive data
• Implement configuration topology for graphical representation of EM infrastructure components and their associations based on line of business
• Create and maintain OEM jobs
• Prepare Root Cause Analysis (RCA) documentations for all issues and outages on a needed basis
• Good experience in troubleshooting and handing severity issues on a timely basis
• Manage and lead off-shore DBA team
• Provide DBA support 24x7