CAREER SUMMARY:

• Around 8 years of IT experience in Oracle Applications Database Administration and Oracle Database Administration
• Expertise in Oracle Applications 11i and R12 system Installations, configuration, Cloning, Security, Patching, Upgrades, Maintenance using AD and other utilities.
• Patch analysis and applied in various test, development and Production instances & documenting the technical instructions for patch application.
• Expert in writing pl/sql queries and scripting.
• Upgrade of individual Oracle Applications products and product families by applying Mini - Packs and Family Packs.
• Handled upgradation of oracle applications from 11.5.10.2 to 12.1.3
• Effectively Handled Oracle R12 release upgrades (12.0.2 to 12.0.6, 12.1.1, 12.1.2, 12.1.3)
• Proficient knowledge in R12.2 installations and maintenance of 12.2.4, 12.2.5 and patching using adop
• To save storage space for clients performed OATM Migration and Table space Reorg.
• Upgradation of 12.1.3 to EBS 12.2.4, 12.2.5
• Based on the adhoc requests performed Cloning and Refresh for EBS, Fusion databases using Mystic tool and Delphix
• Administer and trouble shoot the concurrent managers, concurrent programs, users, menus and responsibilities.
• Extensively worked on AD utilities like ad config, adadmin, ad patch, adctrl, ad splice, ad relink.
• Configuration of Workflow Mailer, PCP, Discoverer
• Maintaining security using FNDCPASS.
• Uploading application objects/entities by using FNDLOAD.
• Good Knowledge on Web Logic Administration
• UPGRADING the Standalone, RAC, Standby Database from 10g to 11g,11g to 12c
• Production DBA Experience on Oracle releases 12c/11g/10g/9i/8i
• Implementing Backup strategies: Hot and incremental backups using RMAN.
• PSU Patching on Standalone, RAC, Standby Databases.
• Implemented RAC (Real Application Cluster) and Converted Single Node to RAC node on Various environments
• Expertise in enabling nodes and adding nodes in cluster environment.
• Sound knowledge in configuring the Automatic Storage Management (ASM).

TECHINICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.

RDBMS: Oracle 11gR2/11gR1, Oracle 10g, Oracle 9i, Oracle 11g (RAC), Oracle 10g (RAC)

ERP Applications: Oracle E-Business Suite 11i, R12, 12.2 - Sys Admin.

Tools: RMAN, Export, Import, expdp, impdp, Tkprof, Discoverer, Oracle Applications Manager (OAM), OEM (Enterprise Manager.), Toad.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Responsibilities:

• Continuous review of Business Critical Database to proactively identify space issues, performance tuning issues.
• Write script to monitor the database with shell and PL/SQL code or SQL code such as procedure, function and package.
• Analysed Stats pack/AWR Reports Monthly and Quarterly to identify on-going/proactive issues and worked with Primary DBA to resolve
• Experienced in tuning of ERP jobs, People Soft Jobs, time/CPU consuming SQL Queries
• Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Completed minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Solving Remedy requests for Confidential based on the business requirement
• Applied patches for 12.2.5 Oracle Applications through ADOP
• Cloning of Oracle Applications using RMAN
• Resolving issues related to Oracle RAC,ASM and Golden gate
• Working on People soft HCM 9.1 Incidents.

Environment: Oracle Applications 11i/R12,12.2, Oracle Database 11g, 12c, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OAM, OEM 13c, Toad, Sql Developer, mRemoteNG, Remedy

Confidential, CA

Responsibilities:

• Experience on working Refresh different versions of Oracle applications 11i,R12,12.2, Databases 10g,11g,12c
• Upgrading of 12c databases for Standalone, RAC, Standby
• Cloning the Code Trees for 11G,12C RDBMS/CRS, Non ERP Databases
• Clone of EBS 11i/R12 Instances Multi-Node to Multi Node, Multi node to Single Node using Mystic Tool
• Using PL/SQL generate the reports from database.
• Schema Migration using Export/Import Utilities
• Providing QE, year End, Month end production supports for cisco RAC production ERP and non ERP env's
• Experience in R12.2 installations and maintenance of 12.2.4,12.2.5 and patching using adop
• Experience in upgrading base R12 applications to 12.1.1, 12.1.2,12.1.3 releases
• Worked on upgrading oracle applications from release 11.5.10.2 to R12
• cloning a database from production Standby database
• Implemented RMAN backup strategy
• DB troubleshooting, Performance issues, ERP front end login issues, concurrent manager /concurrent request trouble shooting
• Taking care of MVDC DC1,DC2 Physical standby, DR env's
• Working archive purge/analyze script issues if in case it fails
• Installing 12c GRID and Database on Servers and cloning 12c Grid 
• Converting Single Node to Multi Node RAC Environments for 12C
• Experience in Creating Virtual Databases using Delphix
• Used OEM Cloud 12c for Monitoring the EBS 11i, R12.1.3 and R12.2.5 application and database server instances. 
• Creating the SR's with oracle and working with oracle to fix the production issues
• Experience in Mongo DB 2.2,3.2 versions and Expert in creating and accessing JSON
• Created Shards, Replica Sets and Clusters
• Created indexes, configured MMAP1,Wired Tiger Storage
• Experience in Security, Backups in Mongo DB.

Environment: Oracle Applications 11i/R12,12.2, Oracle Database 9i,10g,11g,12c, HP-UX, AIX, Sun Solaris, Toad, Delphix, Mystic, Red Hat Enterprise Linux, OAM, OEM, Mongo DB 3.2

Confidential, CA

Responsibilities:

• As part of Release management team member we handle upgrade tasks for entire on demand Customers.
• Worked on upgrading base R12 applications to 12.1.1, 12.1.2,12.1.3 releases
• Worked on upgrading oracle applications from release 11.5.10.2 to R12
• Upgradation of Oracle Applications from 12.1.3 to 12.2.4,12.2.5
• Single and Multi-node installations of Oracle Applications E Business Suite using rapid install.
• Applying patches with adop in R12.2.4
• Cloned Oracle Applications instances from production environments and created the Development and Test instances using Rapid Clone method.
• Expert in Upgradation of Databases from 10g to 11g, 11g to 12c.
• Application of CPU Patches, Application Patches and Database PSU patches
• Application of ATG RUP7, HRMS Family Pack, DST & Extended baseline patches
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers
• Monitoring the Oracle Applications threw OAM and Troubleshooting the issues
• Upgradation of JDK and JRE. Upgradation of Discoverer from 10g to 11g (32 and 64 Bit)
• Expert in OATM migration and Table Space Re-org.
• Troubleshooting Work flow mailer consequent to Cloning
• Monitoring, identifying and resolving user issues and gave support to development teams in general troubleshooting
• Implementation of NLS Languages and DMZ, MT Addition and Node Decommission.
• Defining Custom Managers to run specific type of requests and enhance the performance
• Creation of CUSTOM TOP/CUSTOM APPLICATIONS and integrating with 11i.
• Troubleshoot problems with web server, web listener, forms server, concurrent managers
• Design and Implement Backup & Recovery solutions based on the client’s SLA.
• Raising RFC’s for various purposes and following up with oracle.
• Involved in on-call support on a rotating basis with other team members to support production systems environments.
• Assisted developers with writing and tuning SQL Queries.
• PCP Implementation and troubleshooting the Concurrent Manager Issues.
• Applied EOY Phase patches and 1099 Patches
• Worked on Quantum, Vertex monthly updates for HRMS and
• Database Upgrades for Non-EBSO technologies (PeopleSoft, OBIEE, Hyperion, Siebel)

Environment: Oracle Applications 11i/R12, Oracle Database 9i,10g,11g,12c, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OAM, OEM

Confidential

Responsibilities:

• Experienced in Oracle Apps Administration and Sysadmin tasks
• Installation, Configuration & Deployment of Oracle E- Business Suite 11i/R12
• Implemented Oracle Apps 11.5.10.2 with Oracle RAC.
• Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases.
• Expert in 11i and R12 Cloning.
• Application of CPU Patches, Application Patches and Database patches
• Application of ATG RUP7, HRMS Family Pack, DST & Extended baseline patches
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers
• Validating & Recreating grants & synonyms on Apps schema, Performed jar file/forms generation
• Troubleshooting Workflow mailer consequent to Cloning
• Creation of CUSTOM TOP/CUSTOM APPLICATIONS and integrating with 11i.
• Troubleshoot problems with web server, web listener, forms server, concurrent managers
• Proficient in Database and Applications Administration activities such as Upgrades, Patches, SR support, Backup and Recovery.
• Raising Requests for change for various purposes and following up with oracle.
• Involved in on-call support on a rotating basis with other team members to support production systems environments.

Environment: Oracle Applications 11i/R12, Oracle Database 9i,10g,11g, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, RMAN, OAM, OEM

Confidential, Austin, TX

Responsibilities:

• Administering, Maintaining and troubleshooting Oracle Applications Release 11i E-Business Suite.
• Splicing of off cycle products and registering them with the Oracle Applications E-Business Suite.
• Upgradation of Developer to Patch set 17,18
• Upgrading individual tech stack components to the latest versions.
• Cloning the instances for the TEST upgrades.
• 9iAS installation from iAS 1.0.2.2.2 rollup 4 to 1.0.2.2.2 Rollup Patch 5
• Upgradation of JDK 1.3,1.4,1.5/1.6,1.7
• Upgraded jinitiator 1.1.8.16 to 1.3.1.21
• Application of DB patches using OPatch. Fixing Inventory corruption issues
• Maintaining Autoconfig Customizations
• Defining and managing application users, assigning and revoking responsibilities
• Performed tracing for various user sessions and for various conc. Programs.
• Purging Unwanted requests output and log files.
• Monitoring the Application System with Oracle Applications Manager (OAM).
• Troubleshooting Post patch, autoconfig, cloning issues
• Maintaining tablespaces, data files, control files, redo log files, rollback segments etc.
• Managing archive logs and Database links.
• Regeneration of forms, reports, graphics and jar files using ad utilities
• Documenting the database setup & updating the document whenever there is a change in the database structure, backup strategy etc.
• Raising SR’s for various purposes and following up with oracle.
• Involved in on-call support on a rotating basis with other team members to support production systems environments.

Environment: Oracle Applications 11.5.10, Linux AS 4.0, Oracle 10.2.0.4, OAM

Confidential

Responsibilities:

• Installed Oracle Applications 11i on RHEL (Multi Node and Single Node)
• Handled administration of 24*7 Production and Development Databases.
• Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, Rapid Install etc.
• Patching the Application System using ad patch (minipacks, one-offs)
• Designed proactive patch analysis in Oracle Application
• Proficiency in DBA tools like Export & Import utilities
• Sys admin activities like Concurrent Manager Management, Printer Setup, User Creation
• Managing Oracle Applications user accounts
• Maintaining Application and Patch Documentation.
• Performing pre health check on 11i E-business suite
• Oracle Applications Cloning/Refresh using various Oracle Utilities.
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Taking Database Backup Hot/Cold Backup
• Application of Quarterly release of Oracle Critical Patch Updates to Oracle Application databases.
• Working with Oracle Support for Bug fixes by raising TAR/SRs.
• Alert log and User managed hot & cold backups of databases.
• Oracle Applications Rapid Cloning
• Reduced the timelines of patching using features like defaults file and merge patch.

Environment: Oracle Applications 11.5.10.2, Linux AS 4.0, Oracle 9.2.0.8, 10.2.0.4