SUMMARY

• Up to 10 years of professional experience in Information Technology as an Oracle Apps DBA, Oracle DBA, SOA Administrator & development expertise in all phases of software life cycle.
• Oracle Certified Professional in Oracle ERP Applications, Database Administration & Weblogic Server.
• Expertise in client interaction, requirements gathering, design, deliverables and deployment of various documents as per AIM Methodology.
• Expertise in ITIL framework.
• Team player wif excellent communication, ability to lead and written skills and also a self - motivated individual wif exemplary analytical and problem solving skills.
• Extensive Experience in Oracle E-Business suite applications (R12.2/R12.1/11i) on Multi Nodes.
• Expertise on Several Upgrades From 11i to 11i, 11i to R12,R12 to R12.1.3(latest).
• Expertise on Configuration, Installation, Support of SOA/ADF Applications on Weblogic Server & Oracle Application Server.
• Expertise on configuring OBIEE,Oracle Data Integrator & Discoverer wif Applications.
• Expertise on Upgrading OBIEE from 10g to 11g & applying Patchsets .
• Expertise on Installation & configuration of Discoverer 11g and Upgrading End User Layers.
• Expertise on Adminstering Datawarehousing Environment for Reporting purposes for upto 5000 Concurrent users.
• Expertise on CRS Configuration, Upgrade to Grid 11g & Patch set Upgrades.
• Expertise on ASM Configuration, Conversion of Databases From Non ASM to ASM Cloning & ViceVersa.
• Expertise on Configuring Multi node RAC Database & troubleshooting the cluster databases & maintaining RAC Instances.
• Expertise on Installation & Configuring EM Grid Control & Em Agents 10g/11g/12c.
• Expertise on Configuring Data Guard Broker in 11g/10g Environments.
• Expertise on Configuring Active Data Guard for Reporting Purposes .
• Expertise on Supporting Server Upgrades & Data Center Moving.
• Expertise on Installation, Upgrades, Maintenance of Oracle Databases 12c/11g/10g/9i.
• Expertise in handling Many Databases wif sizes varying from 30 GB to 14 Tera Bytes.
• Expertise on Replication Technologies like Shareplex, Streams, Golden Gate.
• Expertise on Performance Tuning of Applications and Database wif utilities available.
• Expertise on Transportable Tablespace Migrations for 9i/10g/11g Databases For o/s migrations.
• Extensively worked on cloning several test instances wif RMAN & wif Hot & Cold Backups.
• Extensively Worked on ERP R12/11i Cloning from Production to Test Instances.
• Expertise on OCFS2/ACFS2/NFS configurations & working on Various Storages.
• Expertise on performing pre patches analysis and troubleshooting after patch failures.
• Sound experience wif AD Utilities (adpatch, adadmin, adctrl, admerge, autoconfig, adrelink, adsplice)
• Extensively worked on Setups, Conversions, Interfaces, Customizations, Applications Security, Applications System Administration, and Concurrent manager.
• Expertise on configuring Workflow Mailer, SSO, SSL, PCP.
• Expertise on Installation, Configuration of Oracle Application Server 10g/11g For SOA Deployments.
• BPEL Cloning on Oracle Application Server from Production to test Environments.
• Installation & Administration of SOA Components on Weblogic Server/iAS.
• Expertise on Patching Inoperability, CPU, Cumulative, Family packs, Maintenance packs, Minipack patches & upgrading all utilities at both Application & Database level.
• Proficient in SQL*PLUS, PL/SQL, Designer tools, Developer tools, Discoverer, SQL Navigator, TOAD, Shell Scripting,.
• Expertise in creating TAR and issue resolution wif the Oracle & performing Metalink Administration.
• Expertise in Moving data between databases using utilities like Import, Export, DataPump, SQL loader and Transportable Tablespaces.
• Expertise in Job scheduling using dbms job and crontab.
• Expertise on Backup configuration, monitoring and scheduling using RMAN and Hot backups & Cold Backups & Sound Experience wif Recoveries.
• Expertise in Patching wif Opatch utility & Performing Upgrade on timely basis to cope up wif latest improvements of the database.
• Expertise in Configuring & maintaining Data Guard 9i/10g/11g for standalone environment.
• Expertise on Configuring Monitoring on alert log, trace files, listener log and other database job logs.
• Monitoring and Troubleshooting of Apache, Forms, Conc. Manager, Reports servers, and Database related issues.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 9,10,11, IBM AIX 5.3, Red Hat Linux 4,5,6, Windows XP/7/8 and 2003/8 servers,HP-UX,HP-Itanium,Cisco Linux(UCS).

Oracle Applications: R12.2,R12.1.3,R12.1.1,11.5.10.2,11.5.10,11.5.9.

RDBMS/Databases: Oracle 12c/11g/10g/9i, Sql Server,Essbase,mysql.

Database Tools: Oracle Enterprise Manager,Grid(OEM), (DBCA, RMAN, Rapid clone, RAC, Data Guard, Oracle11gGrid,ASM,DMZ,OAM,PCP,SQL*Plus, ADCRI,SQL*Loader,Export/Import,Datapump,SQLDBA,Security Backup & Storage Manager,Oracle Trace, Oracle Table Space Manager, Oracle Expert, Oracle Designer, SQL*Analyze, TOAD, Putty, Chainlink / Kintana,Sitescope,Nagios,SSH,Sql Deveoper,Informatica,SIMBA,Sabrix,Equity Edge,Access.

Programming Languages: SQL, PL/SQL, HTML, JavaScript, BPEL, XSLT, XML, XSD, Unix Shell Scripts.

Application/web Servers: Oracle9i/10g/11g Application Server, Apache 2.0, IIS 5.0, Weblogic Server 12c/11g.

Oracle Technical: Payroll Fast formulas, Discoverer, Reports, Interfaces, Extracts, PL/SQL Wrapper Programs, HRMS API Calls, Data Conversions.

Software Tools: Novell,HEAT,Remedy,Mercury,Groupwise,Lotus,Outlook,Office,TCP/IP, Telnet, FTP, LOG4J, JUnit, CVS, PVCS.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Applications DBA & Middleware Administrator

Responsibilities:

• Provided 24x7 Production support of oracle E-Business suite R12 containing Multi Node Apps wif 4 node RAC ASM Database.
• Upgraded OBIEE From 10g to 11g Moving from OC4J to Weblogic Server.
• Upgraded Oracle Data Integrator from 10g to 11g then 12c.
• Upgraded Oracle Discoverer from 10g to 11g .
• Upgraded Existing ERP Database from 10g to 11g.
• Upgraded Several Production Core Databases from 11.2.0.1 to 11.2.0.4.
• Upgraded Existing R12 Instance From R12.1.1 to R12.1.3.
• Installation,Configuration & Administration of Several ADF Applications running on Weblogic Server.
• Secondary for Essbase,Hyperion & HFM Applications.
• Configuration of Standby Databases For Production Databases.
• Cloning R12 Instances from Production to Test Environments.
• Patching Oracle R12 Instances wif the latest patch sets.
• Installation & Administration of SSO on R12 Instances.
• Administering Oracle Enterprise Manager & configuring alerts and backups from OEM11g.
• Concurrent queue Management based on run time and pending time SLA. Implemented Parallel Concurrent Processing ( PCP)
• Managed the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Performance Tuning of Applications and Databases.
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• ORACLE Printer Configuration.

Environment: Oracle Applications (R12), Oracle 10g/11g, Discoverer10g/11g, SQL, PL/SQL, SQL*Loader,Toad,Solaris10,Remedy,SSO10g,Weblogic(10.3.5/6),OEM11g/12c,iAS10g,OID,OBIEE 10g/11g,ODI11g/12c,Grid11g, Solaris 10/11, Linux 5/6.

Confidential, Santa Clara

Oracle SOA/ERP/BI DBA

Responsibilities:

• Administering Oracle Applications 11i Along wif many Databases for 3rd party applications like SOA,IPM,EquityEdge,SalesForce,HelpDesk,Kintana,BI.
• Provided 24x7 Production support of oracle E-Business suite 11i containing Multi Node Apps wif 4 node RAC Non ASM Database.
• Upgraded Existing Oracle Applications 11i to R12.1.3.
• Performed general technical troubleshooting and working wif Functional teams for possible solutions for various issues during the entire upgrade.
• OATM Migration along wif 11g Upgrade from 10g Database.
• Upgrade to 11g Grid from 10g CRS wif Non ASM to ASM Conversion.
• Installation,configuration, maintenance and administration of standby databases (Data guard) for disaster recovery on 10g/11g RAC.
• Worked on basic and advance replication using Oracle Streams, oracle golden gate.
• Integrated Oracle Single Sign on (SSO) wif Release 12/11i EBIZ.
• Installation, configuration & Administration of Weblogic server For Oracle SOA Suite,Intellectual property management (IPM),ADF Mobile platform, Sabrix & Grid 11g.
• Installation,Configuration & admistration of oracle business Intelligence (OBIEE) Built on Dataware House wif feeds from several sql & oracle databases.
• Creation and configuration of SOA domains,Clusters for all Dev,QA & production environments.
• Deployment of Composite Applications from console and jdeveloper.
• SOA datasource management and performance tuning.
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution etc . scenarios for the various Environments using the Grid Control 11g.
• Worked on ADR Command Interpreter for Creating Incident packages, Viewing Incidents and packing Incidents.
• Supported Recent Data Conversions & Finance Implmentations after several Small Acqusitions.
• Worked on Several HR,Finance Related Data Loads Year Round & supported Payroll Weekends.
• Supported Day to Day Monitoring,Administering of all Exisiting Applications & Databases on a 24*7 Basis.

Environment: Oracle Applications (11i/R12), Oracle 10g/11g, Discoverer10g, SQL, PL/SQL, SQL*Loader, Toad, RHEL 5.6,SiteScope,Remedy,SSO10g,Sabrix,Weblogic(10.3.4/5),OEM11g/12c,iAS 10g,OID,OBIEE

Confidential, San Jose

Oracle SOA/ERP DBA

Responsibilities:

• Database Upgrades from 8i/9i to 10g/11g.
• Migration of 10g/11g Databases using Transportable Tablespace & Data pump.
• Database patchset Upgrades from 9.2.0.7 to 9.2.0.8 & 10.2.0.3 to 10.2.0.5.
• Oracle E-Business Suite 11.5.9 CU2 to R12.1.1 Upgrade.
• Installation & Configuration of Fresh R12 Instances.
• BPEL Cloning From Production to non Production Environments.
• SOA/ESB Administration & Clustering on Oracle Application Servers.
• Plat Form Migration wif Endian Conversion from HP-UX, Solaris to Linux Platform.
• Built & Maintained 2/4 Node multiple RAC Instances (Add, Delete nodes).
• CRS Upgrades 10g to Grid 11g & patch set upgrades from 10.2.0.4 to 10.2.0.5.
• Forms Patchset 19 Upgrade on 11.5.9 Instances.
• Installation of Oracle Application Server 10g & Upgrade from 10.1.3.1 to 10.1.3.4.
• Configuration of Standby Databases & Data Guard Broker On Production Databases.
• Configuration of Monitoring Standby Databases for High Availability.
• Developed Deployment Strategy & Stabilized Custom Applications Deployed.
• JDK Upgrades on ERP & SOA Instances.
• Designed & Implemented BPEL Cloning Technology into Production which is the First ever BPEL Cloning in Cisco.
• IOP & CPU Patching on Database, Apps Patching on the ERP, MLR, DST patching On SOA Environments.
• ERP 11i/R12 Cloning From Production.
• Backup Verification & Configuration for 10g/11g databases.
• ERP & Non ERP Database Cloning wif cold/hot Backups, RMAN.
• Configuration & implementation of Parallel Concurrent Processing ( PCP) wif Failover Testing, Shared Appl Top, Load Balancing.
• ERP/SOA Applications Integration wif SSO.
• Involved in implementing Dashboard-based ERP Monitoring solution by developing shell scripts and SQL scripts.
• Administering ORACLE Applications E-Business Suite R12/11i wif AD Utilities (Adadmin, Adpatch, Adctrl etc.), OAM.
• Workflow mailer configuration and Tuning .
• Custom code migrations using Kintana tool.
• 24 x 7 technical support and troubleshooting issues thru REMEDY ticketing systems.
• Performance Tuning of Applications and Databases using tkprof, explain plan,adcri utilities.
• ORACLE TAR Management: Raised and monitored TAR s wif Oracle Corporation for issue resolutions.
• Responsible for setting-up and managing Standby databases using Data guard for DR sites.
• Storage management, sizing the database objects, monitoring file systems, and table space growth.
• Cron Job Validations & Additions for DBA Jobs like Analyze, monitoring.

Environment: Oracle Applications R 12.1/11.5.10 CU2/11.5.9CU2,OracleApplicationServer10g/11g, SOA/Bpel/Wsm/Esb, Oracle 9i/10g/11g, Developer 6i/10g, Discoverer, SQL, PL/SQL, SQL*Loader, Toad, Sun Solaris 9/10, Cisco Linux,HP-UX,HP-Itanium,Weblogic (10.3.1/10.3.4 ),sabrix,OEM10g/11g,Kintana,SSO 10g.

Confidential, Las Vegas

Oracle Apps DBA

Responsibilities:

• Managed 30 instances of Production, Test & Development Environments.
• Upgrade from 11.5.9 to 11.5.10.2 wif Autoconfig Enabling.
• OATM Conversion wif 10g Database Upgrade.
• Worked as a part of R12 Assessment team for future upgrade.
• Cloning of RAC to RAC and RAC to NON-RAC Instances.
• Installation of GRID and agents to monitor various instances .
• Performance Tuning of Applications and Databases using tkprof, explain plan.
• Application Patch management: Patch impact analysis, patch application and trouble shooting.
• Application: Concurrent Manager Throughout, Long Running Jobs, Application Locks, Application File Systems, and General Operating System Monitoring.
• Day to day activities: Cloning, Patching, Code Migration, Database monitoring, User Management, Backup/Recovery Management, TAR Management, Monitoring Applications and its services.
• Gatheird database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Space Fragmentation monitoring and reorganizing tables and rebuilding indexes, tablespace usage monitoring.
• Worked closely wif functional consultants & developers in scheduling concurrent jobs to reduce load on the system at peak times.
• Co-ordinated wif data centre & network teams to monitor and fix server & network related issues.
• Involved in the implementation of Oracle HRMS. Converted Demographic data from Legacy system to Oracle using Oracle SQL*Loader, SQL, PL/SQL and Oracle seeded API’s.
• ORACLE Printer Configuration, ORACLE TAR Management, and USER Account Management.
• Developed various PL/SQL packages in conjunction wif standard Oracle API’s.
• Worked on Deferred Comp (401a,401k, 457) File Generations and FTP Processes to send the files to Different Providers.
• Designed and developed several Packages, Functions, Procedures during Implementation.
• Worked on setting up Self Service for Adhoc Reporting.
• Developed custom reports from several modules using developer 6i at the time of implementation reducing the load on the technical consultants.
• Design, develop and built several interface programs from Oracle HRMS system to third party systems.
• Involved in setup & preparation of Government Mandatory Reports.

Environment: Oracle Applications 11.5.10.2(HRMS, Financials), Oracle 9i/10g, Developer 6i, Discoverer, SQL, PL/SQL, SQL*Loader, Toad, Sun Solaris 10, Redhat Linux AS4,SiteScope,HEAT,SSO10g.

Confidential, Santa Clara

Oracle Applications DBA

Responsibilities:

• Maintained Multi Node RAC environment wif Oracle Applications.
• Maintained Multi Node Application Tier wif Load Balancing.
• Administering Oracle Database and Applications wif AD Utilities.
• Application Patch management: Patch impact analysis, patch application and trouble shooting.
• Concurrent Manager Queue Management: Involved in Concurrent Manager Profiling based on run time and pending time.
• Application and Database Monitoring: Concurrent Manager Throughput, Long Running Jobs, Application Locks, Application File Systems, General Operating System Monitoring.
• Oracle Printer Configuration, Oracle TAR Management, USER Account Management,
• 24 x 5 Technical Support, 24 x 7 during Quarter and month close & Weekends Oncall Support.
• Responsible for backup/recovery & Automation using Scripts.
• Installation,maintainance & Reporting for SOX/Audit/PCI Compliance Purposes.
• Troubleshooting the cluster databases & 11i Applications along wif many Databases for 3rd Party applications.
• Involved in Integration of Data & consolidating Databases for Company Acquisitions during this time.
• Job scheduling using dbms job and crontab.
• Taking backups, recoveries & cloning using RMAN.
• Performed 11i Cloning from Production to Dev environments on timely Basis.
• Moving data between databases using utilities like Import, Export, Data pump, SQl loader and Transportable Tablespaces.
• Provided Scripts for Monitoring Databases,Standby Databases,Applications & other database job logs.
• Patching the Database & Applications 11i.
• User creation and providing necessary Roles, Privileges and quota as per the requirement.
• Decommissioning of Schemas as per approved requests.
• Resolve the trouble tickets immediately depending on the Severity.
• Built And manged Dual Standby databases (Dataguard) For ERP & standalone for other Production Databases.
• Perform regular database activities like space management, database health check-up activities on memory, I/O, user connections.
• Performed Troubleshooting for Issue resolutions & performance analysis for tuning the database.
• Performed maintenance activities in the given down time and released the instance for application testing.
• Used Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF to analyze timing and execution plan for SQL query to tune the SQL statements.

Environment: OracleApps11.5.10,RAC10g,Oracle 9i/10g,WindowNT/2000,TOAD,Linux,OEM,Discoverer.

Confidential, Omaha

Oracle Applications DBA

Responsibilities:

• Patched and Maintained the EBusiness Suite Multilanguage instance 11.5.9 on RAC 2 node database.
• Troubleshooting the technology stack components (web server, forms server, Concurrent Manager, etc.).
• Also, configuring the Apache web server, Metric server, Forms servers and Admin server.
• Managing the Concurrent Managers and its operations like starting, stopping the Concurrent Managers, re-schedule the requests, purging the Concurrent requests historical data, and tuning of Concurrent Managers.
• Standby/Data guard configuration using physical standby method.( Disaster Recovery).
• Configured Discoverer & oracle Developer Suite for Reporting Purposes.
• Responsible for Oracle Discoverer Administration, EUL creation, Discoverer Desktop Edition Maintenance.
• Very well versed in creation of Workbooks, Business areas, Custom and Ad hoc Reports. Supported All Discoverer issues.
• Performed several refreshes of UAT, TEST and DEV environment using RMAN & Rapidclone.
• Maitained Several Databases for 3rd party applications.
• Implemented scripts for space, database and concurrent managers alerts.
• Prepared the backup strategy for the Oracle APPS Instances and Implemented Backup scripts.
• Estimation and Planning future storage requirements for the database / Application system.
• Involved in Configuring the external and internal and reverse proxy DMZ servers.
• Performed End to End Sysadmin Activities.
• Participating in team lead meeting, weekend plan meeting and process meetings
• Patch analysis and Application.
• Cloning of oracle application environments from production to Test, Development instances.
• Interacting wif oracle support to resolve application issues.
• Analysis of SQL plans using SQL performance analyzer and getting the new plans from dbms advisor and fixing the resource intensive SQL in TEST systems and then moving them to PROD.
• Tuning of Database and applications wif change of relevant parameter changes and tuning of concurrent managers.

Environment: Linux,Solaris, Oracle 9i(9.2.0.6/7)/10.2.0.2,Oracle Applications 11i,peoplesoft.