SUMMARY:

Result oriented, analytical and self - driven professional seasoned with 15+ years of working in a dual role of design/architecture and production support in varying. Experience in Installation/Administering Oracle 12c, 11g, 10g, 9i, 8i Databases of varying landscapes and sizes in ERP and Non-ERP environment. ­

TECHNICAL SKILLS:

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

Mysql: Enterprise Edition Ver 5.6.20

PostgreSQL: 9.6.1 on Linux Environment.

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

Replication/HA: Goldengate 12c, 11g, Oracle Dataguard

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

Performance Tuning: Oracle Enterprise Manager Performance and Diagnostic Pack, Explain Plan, SQL Confidential -Explain, Tkproc, Trace Analyzer, AWR, ASH, Statspack.

Scripting: Shell, Perl, Python.

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

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

Storage: Emc Clarion

Unix/Linux: Red Hat Linux Enterprise Ver 4/5/6/7, Oracle Linux Ver 4/5/6/7

Audit/Standards: SOX, PCI.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect/Production Support, Denver, CO

Environment: 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:

• Responsible for all Prod and Non-prod environment DB deployment.
• Responsible for all Database Refresh using - Expdp, Sql Loader and data copy/movement using db link.
• Monitor all DB alerts and address the required fixes including - space management, connectivity issues including down listeners, file system cleanups including purging all old audit and trace files.
• Maintain and Monitor all Golden Gate replication process including - address fixes for all abended extracts/replicat processes.
• PSU patching for all production and non-production databases with Confidential & Confidential provided guidelines.
• Support all OS patching activity including - start/stop database, listener and golden gate processes.
• Monitor all RMAN backup and address all backup failure and resolve with Unix team including all Netbackup policy related backup failure.
• Generate AWR report after system performance test, analyze the AWR report and provide appropriate feedback to Performance team.
• SQL Peformance tuning - xplain plan generation, AWR/ASH/ADDM report generation.
• OEM Failover/switchover from primary to standby and vice versa.

Confidential, CA

Senior Oracle DBA

Environment: 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, 11g (Ver 11.1.1.1.1 )

Responsibilities:

• New DB Environment builds - Install Oracle CRS, Configure ASM Disk groups, Install 11gR2 database.
• 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.
• GoldenGate setup during server move - setup three way replications to between current prod environment and the new production environment. Using SCN based recovery during cut over of production environments.
• 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.
• Install MySQL databases and setup replication between prod and DR databases.
• Implement DB SSL and Cost for - Database security.
• Extensive SQL Tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Extensive backup and recovery operations using Export/Import, Data Pump and RMAN
• Proactive Database monitoring using – Shell Scripting and automation.

Confidential

Senior Oracle DBA, San Jose, CA

Environment: Cisco UCS Blade Server

Responsibilities:

• Installations of Oracle Applications R12.2/R12.1/11i using Rapidwiz.
• Maintenance of Oracle Applications Environment including Cloning, Patching, Upgrade, Language installation.
• Oracle Applications Utilities including AD Admin, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, FNDCPASS, f6ogenfrmcmp.
• Upgrading of Oracle Application 12.1.1 to 12.1.3 (Patch set update 3)
• Upgrade database 11.1.0.7 to 11.2.0.3 and 11.2.0.3 to 12.1.0.2
• Upgrade Oracle iAS home 10.1.0.5 to 10.2.3
• Cisco Specific DR environment Build – Dataguard Configuration including broker and observer.
• Migrate Oracle Applications raw/cooked file systems to ASM
• Database Patching using ADPatch, ADOP and Opatch
• Oracle Applications patching
• SSO Registration and De-Registration for Oracle Ebusiness (R12)
• Discoverer Installation and Integration with Oracle Apps.
• Oracle Applications Security including Responsibilities and User maintenance.
• Installed and supported Oracle Application Server, Oracle APEX instance, WebLogic server. Configured Oracle HTTP Server (OHS), MOD PLSQL, Service Oriented Architecture (SOA). Configured SSO and SSL for E-Business suite.
• CRS and Oracle home cloning using the Backup of Oracle Binaries.

Confidential, Minneapolis, MN

Environment: Oracle Exadata X3 Quarter Rack, Oracle Exadata X2 Quarter Rack.

Responsibilities:

• Understanding of Current Hardware and Software infrastructure.
• Oracle Hexadata Architecture review
• Review of multiple instances in different data centers.
• Review of Oracle GoldenGate features.
• POC sessions and review of GoldenGate best practices including Extracts and Replicats.
• Installation of GoldenGate (Ver 11) in POC Environments and setup Extracts and Replicats.
• Architecture diagram for Proposed GoldenGate Solution.
• Review All Applications Stacks and identify possible schemas for replication candidate.
• Review all db objects and identify incompatible GoldenGate objects.

Confidential

Senior Apps DBA, Dallas, TX

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.
• 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.
• 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

Senior Application DBA, Milwaukee, WI

Responsibilities:

• Supporting 11.5.10.2 Oracle Financial database for Production, Test and Development environments with 6 instances. Application and Database cloning using Rapid Clone and manual database cloning, Production database backup using BCV and IBM-Tivoli, Development and Test
• 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).