SUMMARY:

Over 10+ years of experience as Oracle Production DBA including Core and Oracle Applications environment with 15+ years of IT experience. At present working as Lead production DBA in a very high SLA with 100% uptime environment. Proven track of being a Production support DBA in very high Demanding Environment. Proactive Database Monitoring, Incident RCA, 24x7 on call support, Large Database Platform Migration, Real time Replications for Mission Critical DR systems are the few key strengths among many others.

TECHNICAL SKILLS:

Database: 12c Rel 1 (12.1.0.2.0 ), 11gR2 (11.2.0.x). 10.x, 9.x, 8.x, 7.x

Golden Gate: 12c (12.1.2.1.0 ), 11g ( 11.1.1.1.1 )

ERP/E - Business Suite: R12 (Ver. 12.1.3), 11i (Ver. 11.5.10.2), 10.7

Database Monitoring/Management: OEM 12c, OEM 11g, Sql Developer, Toad, Sql Navigator

My SQL: Enterprise Edition Ver 5.6.20

Hyperion: EPM (ver. 11.1.2.2.0, Ver. 11.2.2.3.0 for Linux x86 64)

Fusion Middleware: OID, SSO, WebLogic, BPEL, BAM, B2B (All integrated with R12 Environment)

Virtualization: VMWARE ESX, Workstation, Virtual Box, AIX VM

Storage: Emc Clarion

Scripting: ksh, bash, perl

Hardware: Cisco UCS, Dell Blade, AIX P series, HP Superdome

Audit/Standards: SOX, PCI.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Lead Oracle Production DBA

Environment: Database: 12c Rel 1 (12.1.0.2.0 ), 11.2.0.3.0 PSU 9, 11.2.0.2 PSU 11, 11.2.0.4

Responsibilities:

• New DB Environment builds - Install Oracle CRS, Configure ASM Disk groups, Install 11gR2 database.
• Proactive monitoring of production system using OEM top activity for high load SQL.
• Review Explain plan for the SQL causing high load, identify the cause, suggest appropriate index and implement from non-prod to prod.
• Monitor GoldenGate replication - Prod, Backup and DR database, Identify GoldenGate Lags after PSU patch implementations - Flush out the old execution plan and generate new plans, Identify tables with no primary/unique key and implement the keys to improve replication performance,
• Setup GoldenGate Veridata for Weekly Comparison between Production, Backup and DR Replication sites. Identify the Out of sync tables and fix the issue.
• Apply Database PSU patches quarterly in - DR, Backup and Production Database.
• Partition Tables - Backup of Six months old partitions for log tables using expdp, truncate and drop partitions six months old partitions to free up spaces for new partitions.
• Build DR Environment - Build all schema from production using Expdp, Database Re-org of tablespaces, Implementation of Partition tables for large tables, Rebuild materialized views.
• Rebuild materialized view logs to avoid refresh performance slowness.
• Install OEM 12c, Build Standby OMS server, Build Physical Standby Database for OEM Repository for failover, Define Monitoring Templates, Migrate Monitoring templates from Existing OEM Repository, Install GoldenGate Plugins for OEM.
• Evaluate Oracle 12c multitenant Feature for implementation of - GoldenGate Replication in Multitenant Environment, Migration of 11gR2 Database to 12c Multitenant PDB.
• Administer All Database Backups maintain by 3rd Party Datacenter.
• Administer MYSQL database.
• Work with PCI auditor and implement audit compliancy requirement in Database for Data Protection and Security Vulnerabilities.

Confidential, San Jose, CA

L3 DBA - Production

Environment: - Oracle Application Version 12.1.3, 11.5.10.2, OEM 10g/12c, Oracle SSO (10.1.2), Oracle Identity Management (10.1.4), BPEL (10.1.3.4). Golden Gate, Database 11.x/10.x/9i, Cisco Linux UCS (x86-64).

Responsibilities:

• As a L3 DBA primary responsibilities to do Root Cause Analysis (RCA) for every P1 incident related to Application/Database occurred and work with Oracle/System Administration team to resolve the issue and put the fixes in place.
• Daily task also includes Review and address all trouble tickets (JIRA) and resolve the cases with appropriate fixes,
• Review all upcoming change requests pertain to the supported databases and approve the same, Monitor SOX alerts and resolves the issues.
• Monitor Daily backup reports and address the failed backup for the supported database.
• Ensure all production EM targets are up and remove the blackouts.
• Monitor all cron jobs and make sure all missing cron jobs are in place. 11.2.0.2 Database upgrade to 11.2.0.3.
• PSU patching for database in ERP environments.
• Application patching.
• Address all users who are having issues with Single-Sign on by updating the GUID.
• OID de-registration/registration for missing environments.

Confidential, Dallas, TX

Application DBA - Production

Environment: - Oracle Application Version 12.0.6, SOA 10g, B2B 10g, Demantra 7.2, OTM 5.6, OEM 10g, EMC Clarion Disk Array, EMC RPA, EMC Unishpere, Replication Manager, AIX 5.3, VM Ware ESX Server 4.0, AIX Virtual I/O Server (VIO), VM Ware Guest OS Red Hat Linux 4.x, 5.x., IBM-TSM backup.

Responsibilities:

• Support of 3 Instances Prod, QA and Dev of Ebusiness, SOA, B2B, Demantra and OTM. Monitor instance activity through OEM, Monitor all concurrent Jobs, Month End processing monitoring and management for job distributions to appropriate service nodes, Change mangement and code migrations, Backup monitoring and fixing of failed backups, Patch application, Startup/Shutdown of different instances including E Business, SOA, Workflow Queue monitoring and bouncing of Deferred Agent listeners when queue has large number of request pending.
• Instance refresh support - Database cloning using EMC disks replications/replication manager. Re-create the control files. Database startup. Application file system refresh using SCP. Autoconfig execution. RMAN duplicate using TSM recovery, manually redirecting TSM server from prod to QA, TSM backup export/import across prod and non-prod network.
• Project Support - DR Activity - Monitoring of RPA replications from PROD to DR site, Shutdown of RPA replication for Image Access, Snap cloning of DR luns to target non-prod luns for database refresh, fracture of luns after snap-clone process completion, Adding of new luns to Production luns from storage pools.
• E-Business Database upgrade from 10g to 11gR2 - Up gradation of E-Business 12.0.6 instance 10g database to 11g R2 database, Forms/Application server upgrade. SOA repository database upgrade from 10g to 11gR2, Siebel, OTM and B2B database upgrade from 10g to 11gR2. Creation of SOA repository metadata database.

Confidential, Milwaukee, WI

Application DBA - Production

Responsibilities:

• Database using RMAN. Database Statistics collection using custom process COE stats, seeded FND Stats jobs. Database statistics export/import between production and cloned environments for performance benchmarking, Monitoring Daily and Monthly jobs and identify long running processes, extract the potential poor performing sql’s, Generation of SQLTXPLAIN reports using sqltxplain xtract method, concurrent manager jobs tracing from database server and generation of TKprof report for the concern trace files. Installation of SQLTXPLAIN, RDA agent, TRCANLZR and OSwatcher tools for performance data collection and metrics. Oracle application patching using adpatch. Analysis of current patch level and determining the candidate patches to maintain compliancy with Oracle support, Troubleshooting of Messaging Gateway for 11i environment, Materialized View Replication, Installations of Oracle Configuration Manager for 11i environment, Storage estimations for Quarterly Database Growth.
• IBS Application production database support - 3 node RAC with ASM and Oracle Database 10.2.0.3 database, CRS and ASM upgrade, change management, RMAN backup recovery scheduling, monitoring and troubleshooting, Shell scripting for Database monitoring and backupArchive and Purge project support - Installation of Applimation metadata for Archive/Purge Database, Export/Import of Applimation metadata from test to prod, Application of Informatica patches for E-Business integration, Creation of DB Links for History databases, Customization of Grant Scripts to enhance the admin option, Identify invalid views with history and combination schemas and apply manual fixes, Troubleshooting of Applimation web tier to troubleshoot the connection issues, Monitor Informatica Archive jobs for Standard Oracle Modules.
• Release 12 upgrade project support - Oracle Advance Queue and Messaging Gateway setup, R12 cloning using Rapid Clone for RAC and Non-RAC environments, Database Cloning, Scheduling of Database and Application Tier backups using Cron jobs, Oracle BI scheduling configuration, OBIEE presentation screen configuration, export/import of schemas using Data pump, creation of DB links, User, Roles and Tablespaces, ASM Disk group management, New instance setup including installations of CRS Application Cloning and Load Balancer Setup, LAD Patching, Localization for Brazil china, WebSphere upgrade for OBIEE, Instance Decommissioning, Parallel Concurrent Manager configuration

Environment: Oracle E-business (11.5.10.2, 12.0.4), Oracle Database 10.2.0.3, 11.2, HP-UX 11.23, IBM-TSM (Ver 5 Rel 5), CRS, Symmetrix BCV, Informatica/Applmation (Ver 5.3) For Oracle E-Business, RMAN, OSWatcher, RDA, SQLTXPLAIN, TRCANLZR, Tkprof, Unix Shell (Csh and Korn), OEM (Ver 10.2.0.5.0 ), TOAD (Ver 10.6.0.42), DB Artisan (Ver 8.7.3), SQL Developer (Ver 2.1.1.64).

Confidential, St. Louis, MO

Application DBA

Responsibilities:

• Production Support of Confidential ’s 80+ Oracle Database Monitoring trouble ticketing system (Magic and Team Track) and Address On-Call pager support new issues log into the system. User and Password maintenance. Database and Schema refresh using Data Pump and Export/Import.
• Address all Grid Control including - Space alerts, ORA-0600 error Alerts, Max process alerts.
• Address all RMAN backup failure issues for nightly backup jobs including full, incremental and archive log backups.
• Address all Database performance issues including - SQL Slow response’s creating lock in the database, Application freezing issues, Identical SQL spawned multiple times causing high CPU usage.
• Log metalink Service Request for Oracle Database issues and Follow up with oracle for existing service requests Magic and Team Track queue maintenance and assignments of tickets to offshore team every day. Database Patching, Cloning, Upgrade.
• Build Altiris package for automated deployment of Oracle Client for Windows Server and Workstation. Bi-yearly production release for all database related deployment. Reviewing all Grid Control and ITO alerts and prioritizing alerts based on the criticality. GoldenGate replication implementation for multiple site replication process.

Environment: Oracle 11g(RAC)/10g(10g RAC)/9i/8i,ASM, SQL, PL/SQL, RMAN, AWR, Statspack, ADDM, IBM-AIX 5.x, RedHat AS 4.5, Enterprise Manager, Toad, Symantec I3, Altiris. GoldenGate. Unix Shell Script.

Confidential, Kansas City, MO

Oracle DBA

Responsibilities:

• Database Migration from OpenVMS Oracle 9i to HP-UX/AIX/Redhat Linux Oracle 10.2.0.3 Linux Setup for Oracle 10gR2 RAC environment including Verify Packages for Oracle 10g compatibility, Update Kernel Parameters for Oracle 10g, Verify /etc/hosts, Create Linux Groups/Users, Setup SSH for the Oracle/Users, Setup SSH for Root Users, Verify Hostname and Gateway, Setup BONDING in /etc/modprobe.conf, Public Networking Configuration, Private Networking Configuration, NTP Setup, Hang check-Timer, Sun JDK Installation - Option, HP PSP Installation, Verify SELinux is Turned OFF, DM-Multipath Failover, QLogic Failover, Install ASMLib, Determine LUN UUID Mapping to Linux Devices, Create Oracle Volume Group, Ceate Raw Devices for Cluster Files and ASM Spfile. Partition LUN with fdisk, UDEV Setup, RAW Device Setup, Partition Hard Drives for ASMLIB, Linux File system Management including Increase size of existing file system online, Create new file systems.
• Create Stating area for Oracle 10gR2 CDS, Install CRS using the silent installation scripts as well install manually, Install RPM for cvuqdisk, ROOTPRE.SH - Prerequisite checks by oracle, Install CRS, Manually Run VIPCA, Install 10.2.0.3 Patchset for CRS, Pre RDBMS Install Check, Install 10.2.0.3 RDBMS for DB Kernel, Install 10.2.0.3 RDBMS for ASM Kernel, Oracle Network Configuration, Install OPatch 10.2.0.3.3, Create "patches" directory, Install one-off patches, Install critical patch updates, Install patchsets, Setup HugePages for Oracle SGA, RAC Failover Testing, CRS Management, Database Start/Stop using srvctl, ASM Start/Stop using srvctl, CRS monitoring using crsctl.
• Create Tablespace, Adding Data Files to Existing Tablespace, ASM and File system environment, Adding Tempfiles to TEMP tablespace, SPFILE - Create, Dump and Change parameters, 10g Database standadization including initialization parameters, Golden Gate Replication setup, RMAN duplicate,including point-in-time recovery, Database export/import using Pipe and dump files, Standby database with RMAN duplicate., DBA Toolkit setups using Crontab, Performance monitoring using Enterprise manager, Monitor Buffer cache, Monitor SQL for Highest CPU, Disk Usage and Locking, Identify bad sql and tuning with application team., Database Administrations using TOAD including, Schema Refresh, Schema comparison and differences, User maintenance Scheduled job maintenance, Database monitoring, Cross platform database migration using Golden Gate and, Export/Import from Open VMS to RedHat Linux, AIX and HP-UX, - SQL Tuning Using 11g Plan Management Framework, Explain Plan, Database Character set conversion.

Environment: Oracle 10g(10g RAC)/9i, RedHat Linux AS 4.5 and 5.0, Open VMS 7.x, Golden Gate, PL/SQL, RMAN, AWR, Statspack, ADDM, ASM, HP-UX 11.x, IBM-AIX 5.x.

Confidential, Richmond, VA

Oracle Application DBA

Responsibilities:

• Installations of Oracle Databases and clients, On call support 24x7, Upgrade 9.2.0.6 to 9.2.0.8, Creation of the Development, Test and Production Oracle 9i/10g databases, Cloning of production database to the test environment using Recovery Manager (RMAN), Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc, Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup, Monitoring Enterprise Manager Alert Logs for taking corrective actions including tablespace sizing, Production support on Windows Based 2-node RAC systems.

Environment: Oracle 10g/9i(9i RAC)/8i, RHEL 4.5 AS, Enterprise Manager, SQL PLUS, PL/SQL, RMAN, AWR, Statspack, ADDM, VNC, SQL*Plus, TOAD, MS SQL Server 2005.

Confidential, Richmond, VA

Database Application Administration

Responsibilities:

• Create target Database in 10g utilizing HP-UX platform. Identify Database objects require migration. Identify each object with sizing criteria including large, medium and small.
• Sizing estimations and create appropriate tablespaces.
• Create Import/Export scripts.Migration of large tables (Over 2GB of size) using Unix pipe features and Oracle TWO TASK.Configuring Database to schedule Database monitoring scripts. Configuring Database to make ready for Hot Backup using Veritas NetBackup and Oracle RMAN.
• Identify potential failures of Export/Import Jobs and resolution of the problem including resizing the tablespaces.
• Generate migration scripts using SQL-TOADS for migration of Views/Indexes and other objects. Create Database users and roles and implement appropriate user security.
• Setting up enterprise wide RAC implementation strategies for Confidential .
• Support of 4 Oracle Application instances (Ver 11..5.8), Periodic cloning of production systems to create Pre-production/Quality and Test environment, Upgrade of Oracle Projects module from 11.5.8 to 11.5.9, Patching using Autopatch, Oracle Application security including responsibility, menu and user maintenance, start/stop concurrent manager jobs.

Environment: Oracle 10g(10g RAC)/9i/8i, RHEL 4.5 AS, HP-UX IBM-AIX 5.x,Enterprise Manager, SQL*PLUS, PL/SQL, RMAN, AWR, Statspack, ADDM, Ebusiness 11i, SQL Server 2005.