SUMMARY

• Around 10 years of experience as Oracle Applications DBA in Implementation, Upgrade and Support projects.
• Proficient in EBS Installation, Upgrade (EBS and Database), Patching, Cloning, Database Refresh, Disaster Recovery, High Availability and Backup & Recovery in EBS 11i, R12.1.x and R12.2.x., PCP,Shared appltop.
• Experience in Upgrading Oracle EBS from … to R12.1.3 with database from11gR2 to R12.1.0.2 and R12.1.3 to 12.2.6.
• Experienced in cross platform Migrated (solarise to Linux and& upgrade the of E - business suit from 11.5.10 to R12.1.3
• Upgrade Experience of Database from 11g to 12c and within 11g versions also.
• Good knowledge on reducing Oracle EBS upgrade cut over time.
• Expertise in ad utilities like adop, adpatch, adadmin, adconfig, adclone, adctrl, admrgpch, adident, adsplice, adrelink, adtimrpt and adutconf.
• Good Experience in Patch Analysis using Patch Wizard and Patch Application Files.
• Experience in supporting multiple Production, Test, Development and Migration instances.
• Proficient in Oracle … Database Administration.
• Excellent understating and resolving skills of Database, Technical and Application Issues.
• Expertise in troubleshooting performance issues using SQL Profiles, Trace (10046 & 10053), AWR and ASH.
• Good experience in shell script for automating integration of other application with Oracle E-Business Suite.
• Configure PCP Parallel Concurrent Processing for multi node environments.
• Good Experience in EBS Security by following Single-Sign-On, Limit on Access and Authentication, Audit Trail, Read Only Access, Software up to date, Change passwords for seeded database and application user accounts, Tighten logon and session profile options, Review database links.
• Expertise in Handle Security Issues: SSL certs installation for Web/App servers.
• Migrated the process from oracle wallet manager to Java Keystore in order to handle the SHA-2 certificates.
• Setup and configured the DR site for E-business suite with the help of backup and UNIX team to setup Zerto tool.
• Apply patches to various Oracle Retail Applications including J2EE applications. Analyze and retrofitting patches into custom environments.
• Design and Implement Disaster Recovery redundant Oracle Retail environment by closely working with UNIX and DBA teams.

TECHNICAL SKILLS

• ERP: EBS 11.5.10, R12.1.3, R12.2.X
• Oracle Retail application: RMS13.1, RPM 13.1,RIB13.1,SIM,13.1,Reim 13.1
• Middleware Applications: OBIEE 10, 11,, Weblogic, OAS 10, Portal, OID, Informatica,, AIA, Discoverer 10g, OAM 11g
• Oracle Technologies: SQL, PL/SQL, Oracle Workflow
• RDBMS: Oracle 9.x, Oracle 10g, Oracle 11g
• Languages: SQL, PL/SQL
• Tools: TOAD, SQL, Oracle SQL developer, MS Office Tools
• Operating Systems: Windows, Linux, Solaris, AIX, HP - UX Itanium/PA-RISC
• Backup Tools: RMAN, NetBackup tool
• Monitoring Tools: Foglight, Oracle Enterprise Manager 12C/11G, AMP 12C

PROFESSIONAL EXPERIENCE

Confidential

Onsite Principal AppsDBA Lead

Responsibilities:

• Platform migration from Solaris 5.10 to RHEL 5
• OATM Migration.
• Upgrading the Instance’s from 11.5.10.2 to 12.1.3.
• Upgrading the database from 10.2.0.2 to 11.2.0.3
• Implemented PCP.
• Applying the latest Application & Database RUP patches
• Configuring Custom top
• Password change as part of quarterly activity.
• Change management process for migrating the code /patch from dev to Prod.
• Applying of application and database patches using adpatch and opatch utility
• Troubleshooting Concurrent program failures.
• Using admerge Utility to Merge Application Patches.
• Working with performance related issues.
• Working with SRs to deal with Performance issue during upgrade.
• Configuring workflow Notification Mailer.
• Configuring of Printers with Oracle Application.

Environment: EBS 12.1.3 hosted on VMware, Database 11.2.0.4, RHEL 5.8, PCP, Shared appl top. SOA suit, Informatica, Revitas etc.

Confidential - San Francisco, CA

Lead Oracle Retail DBA

Responsibilities:

• Performing regular Patching for all Non-Prod/SIT instances.
• Supporting the Implementation during the Cut Over from Offshore/Onsite.
• Troubleshooting regular support issues and communicating with Oracle support on different SR‘s.
• Developing automation scripts to perform majority of the Cloning steps automatically with time capture.
• Performing SOA 11g and Fusion Middleware 11gR2 POC.
• Cloning the instances from Production to Test, Development instance
• Used the AD utilities as when required.
• Ensure that the database and application up and running by checking the E-mails & pager
• Tracking invalid objects, compiling and validating the invalid objects if it is not complied automatic
• Managing users as creating and assigning responsibilities to Apps and DB users
• Planning, Installation and Integration of different modules in Oracle retail application from CRP to production
• Developed Customized user security access for Retail applications by using SSO
• Integration between Oracle retail and E-business suite also different third party tools.
• Upgraded the Production/Dev/Test/Training from 13.0.1 to 13.0.4.5 for critical Retail application servers and Database from 10.1.2 to 10.2.4.

Environment: EBS12.1.3,Database:11.2.0.4, Retail 13.x(ORMS,ORPM,RIB,RESA,REIM etc)

Confidential

Senior Application DBA

Responsibilities:

• Working with SRs to deal with Performance issue during upgrade.
• Troubleshooting Application Patch Issues.
• Troubleshooting Environment related issues.
• Using Admerge Utility to Merge Application Patches.
• Configuring workflow Notification Mailer .
• Providing Patch Analysis via patch wizard.
• Applying of application and database patches using adpatch and opatch utility
• Creation of identical Application Users with all responsibilities across Instances.
• Applying Datafix. & Migration of code across Instances
• Troubleshooting Concurrent program failures.
• Using utility FNDLOAD & WFLOAD to upload and Download data across Instances.
• Administering concurrent manager, defining Custom concurrent managers and work shift.
• Interacting with End users to schedule the concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times and purging concurrent request queue.
• Creating database users, Application users, assigning responsibilities to Application users and changing their passwords.

Environment: EBS 12.1.4, retail application like RMS, SIM, RPM, REIM, RESA of version 13.1, with database 11.2.0.2.

Confidential

Onsite Lead Oracle Retail and Application DBA

Responsibilities:

• Installing and Configuring Oracle Retail 13.x
• Meeting of all the SLA's set for the system to meet business standards
• Leading the performance testing team and ensuring the load testing of the application including the modules(ORMS,ORPM,RESA,REIM,ALLOCATIONS,SIM,RIB) is completed in time for Go Live
• Handling Severity -1 issues on database servers, application servers and providing production support
• Handling core performance issues with business process, with the database, overall infrastructure and optimizing the application design as required to meet the SLA's
• Redesigning processes and procedures to meet SLA's to cut down batch processing times to 6 hours from 12 hours
• Designing the high availability for all Oracle databases (ranging from 300GB to 5 TB) and Application servers and provided failover procedures using replication and clustering techniques
• Capacity planning for Oracle implementations
• Performance tuning of batch programs(PL/SQL,PRO*C), Oracle forms in ORMS,ORPM to meet the SLA's
• Going Live as per schedule with all the critical business process completely tested for performance with 150% volume, SLA's met and signed off by business.
• Documenting the detailed results of the performance test for each component complete with artifacts such as metrics from monitoring of infrastructure
• Upgraded the Production/Dev/Test/Training from 13.0.1 to 13.0.4.5 for critical Retail application servers and Database from 10.1.2 to 10.2.4.
• Upgraded the Oracle Retail Integration Bus (RIB) from 13.0.3 to 13.0.4
• Monitoring & Troubleshoot of the RIB issues which is works as real time transactions (RDMT,RIHA
• Coordinating and propagating the changes proposed as the result of optimization of various components including Database, Servers, SAN, Network and Application code through Change control process.
• Working for client Confidential Appleton USA As Lead Application DBA/SME (Subject Matter Expert). This project consist of E-Business suite 12.0.5 and Oracle Retails Application 13.0.4
• This project is interface of E-Business Suit, SSO, SOA, OBIEE, LDAP, LPAR, OID, 10gAS, Replica, Appworx, Foglight, PVCS, Oracle retail.
• Cloning the instances from Production to Test, Development instance.
• Used the AD utilities like ADADMIN, ADCONFIG, APATCH, ADCTRL, ADMRGPCH, ADRELINK, ADIDENT, and ADSLICE.
• E-business Suit fully monitored by Scripts, written different script and which is used as Assert in IBM India for different E-business suit projects
• Ensure that the database and application up and running by checking the E-mails & pager.
• Tracking invalid objects, compiling and validating the invalid objects if it is not complied automatic
• Checking the status of important services like concurrent manager, form server, web server, application listener and database listener are up (Status E-mail) .
• Managing users as creating and assigning responsibilities to Apps and DB users.
• Monitoring different logs and fixing the errors if any.
• Monitoring of concurrent managers and concurrent requests from fronted and backend
• Resolving user issues/ performance issues
• Applying patches and performing ad activities and managing patch history across release instances using ADPATCH AND OPATCH utilities.

Environment: EBS 12.1.3, Database 11.2.0.2 & Oracle Applications-Oracle Retail 13.x (ORMS, ORPM, ORESA, ALLOCATIONS, RIB, SIM,REIM

Confidential

Senior system engineer

Responsibilities:

• Single node & Double node cloning of E-Business suit as per client requirements.
• Creating new Environments/Databases as per client requests and relevant entries in Listener.ora, Tnsnames.ora, Oratab.ora, Shell Scripts etc.
• Taking cold backups as per schedule through Crontab. D Refresh Stage/Development with Production using Export/Import.
• Rollout enhancements in Production/Stage & Development environments.
• Generating reports through OEM like Top SQL etc. to watch workload in different business hours.
• Other Database Administration activities like User Creation, Tablespace Creation, Space Management, Access Control, Resolving lock problem etc. as required time to time.
• Participating in weekly meeting with GE Team to review project progress and planning downtime and activities like Patching, Migration etc.
• Involved in Managing INFORMATICA Repository like User creation, Assigning Groups, Giving Privileges, Creating Folders & Assigning Permissions, Replicate folders from one Repository to another.
• Applying all Patches (RDBMS & Applications)on Oracle for Sun Solaris.
• Upgrading of oracle database 9.2.0.6 to 10.2.0.3
• Upgrading the Instance from 11.5.10.2 to 12.1.3.
• Working with SRs to deal with Performance issue during upgrade.
• Troubleshooting Application Patch Issues.
• Troubleshooting Environment related issues after upgrade.
• Using Admerge Utility to Merge Application Patches.
• Configuring workflow Notification Mailer.
• Providing Patch Analysis via patch wizard.
• Applying of application and database patches using adpatch and opatch utility
• Creation of identical Application Users with same responsibilities across Instances.
• Applying Datafix.
• Migration of code across Instances
• Troubleshooting Concurrent program failures.
• Using utility FNDLOAD & WFLOAD to upload and Download data across Instances.
• Administering concurrent manager, defining Custom concurrent managers and work shift.
• Creation of tablespaces, adding datafiles to tablespaces.
• Generating sqltxlplain plan/ sqltxtract of sql’s given by developers.
• Generating AWR, ADDM reports as per developers Request.

Environment: Oracle database 10.2.0.4, 11.2.0.4, EBS12.1.3, 11.5.10.2.

Confidential

Onsite Application DBA

Responsibilities:

• Upgraded the Test Instance Database from 8.1.7 to 10.2.0. Along with the application of Security patches including Jan 2006 patch updates.
• Upgraded 9iAS along with upgrading JInitiator to version 1.3.1.25.
• Upgraded Oracle Application from 11.5.9 to 11.5.10 CU2.
• Performed cloning of Oracle applications 11.5.8 from two-node environment to two node environment with Oracle 8i/9i databases in Sun 5.8.
• Performed patching in Oracle applications- applied mini packs, family packs etc.
• Performed System Administration Task for all the users in SIT/DEV and Patch instance.
• Maintained three instances namely SIT/UAT, Development and Patch Instances for the project.
• Communicated with Oracle support on different iTAR and Bugs related to Oracle Applications and Oracle databases.
• Created Data-loader scripts for different frontend related activities like user creation, responsibilities assignment.
• Provided 24*7 Post Production support for issues due to the database upgrade
• Applying of application and database patches
• Administering concurrent manager, defining concurrent managers and work shift.
• BCV RMAN Backup using IBM Mainframe.
• Applying of Production datafix on PROD Server.
• Monitoring of ESP RMAN Backup Jobs from IBM Mainframe.
• Creation of tablespaces, adding datafiles to tablespace.
• Interacting with End users to schedule the concurrent request, changing the schedule of specific requests to reduce the load on the system at peak times and purging concurrent request queue.
• Creating Application users, assigning responsibilities to users and changing their passwords
• Applying datafix on Prod and Non Prod Instances

Environment: Application: 11.5.5 to 11.5.10.2 Database: Oracle 10.2.0.3