SUMMARY

• A competitive professional having 8+ years of total experience in Oracle Applications DBA and as well as core DBA.
• Expert in Administration of Oracle Applications ERP systems
• Extensively worked on R12 and 11i Oracle Applications and 11g,10g and 9i Databases
• Hands on experience in Cloning R12.2 Environments
• Experience on middleware technologies like SOA11g, OBIEE11g & OTM etc.
• Implementation Support of Oracle Applications (Patching, Troubleshooting errors, space management, Concurrent Managers management, Backup & Recovery)
• Excellent working skills in installation, cloning, maintaining concurrent managers, Patching, User management issues and space management issues related to Oracle Applications.
• Involved in Upgrade of Oracle Applications from 11.5.10.2 to R12.
• Experience in RMAN, Hot, Cold and logical (Export/Import) backups.
• Sound knowledge in supporting and managing Production, Development and Test instances of Oracle Applications environments of varied complexity.
• Having good exposure on Oracle Applications working from offshore.
• Sound knowledge in AD utilities and Cloning activities
• Diagnostic Ability to go to the core of the problem.
• Handling critical situations and worked for multiple clients and capable of performing multi - tasking.
• Very much comfortable with Kintana tool.
• Good knowledge on RAC and WebLogic and good exposure on trouble shooting WebLogic servers
• Expert in Configuring Workflow Mailer.
• Experience in Security Management and Database Auditing.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX)
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel
• Good team player, self-motivated and a quick learner
• Ability to work effectively with all levels of personal & other groups and provide 24/7 production support

TECHNICAL SKILLS

Oracle Applications: 12.2.|12.1.3|12.0.4|11.5.10.2|11.5.9

Database Related: Oracle 11g, 10g & 9i Weblogic 11g

Operating Systems: AIX/RHEL/OEL 4, 5 | Windows Server 2003 | Windows xp.

Oracle Tools: Autoconfig | Rapid Clone | Opatch | AD Utilities | RMAN | Export/Import | Putty | Winscp | VNC | SQL Loader | netca & netmgr.

PROFESSIONAL EXPERIENCE

Confidential, TX

Oracle Apps DBA

Environment: Oracle E-Business Suits 11i &R12

Responsibilities:

• Monitoring alert through OEM and scheduling the Jobs
• Scheduling and performing all clones from different Divisions
• Performed clones using Delphix tool.
• Cloning Database/Applications through Manual and Rapid clone methods.
• Database Clones through RMAN and Restoration from backup’s as per requirement. RAC to non-RAC and non-RAC to RAC after clone.
• Resolving issues related cloning and recovery of database.
• Applying Application patches using Auto patch utility adpatch and adop. Performing RDBMS patches using Opatch. Trouble shooting Workers related issues while applying patches. Minimizing patch time though merging the patches and using options
• Performed Vertex instatllation on EBS 12.2
• Installation of Off cycle products through AD splice.
• Forms patch set 19 and JRE upgrade ( 1.7.0.17 )
• Resolved Concurrent requests & Concurrent Managers issues
• Deploy the .ear files in WebLogic server and managing WebLogic components
• Install APEX 4.0 on Oracle Database.
• Apply the latest PSU patches to the RDBMS Oracle Home
• Performed the Table Fragmentation.
• Configuration of workflow setup for EBS R12 and resolving the issues
• Resolving day to day user related issues ( user login and user specific ) and Application issues on EBS ( Form server, Report server, Apache ) & Database
• Used Adadmin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and relinking executables and also, performed generate and compile forms manually
• Monitoring Backup’s ( Scheduled Hot backup’s and RMAN backup’s )

Confidential

Oracle Apps DBA

Environment: Oracle E-Business Suits R12- RAC with ASM.

Responsibilities:

• Working on ticketing system (Service Now) on Severity and Priority basis
• Resolving the MWA related issues
• Start and Stop the MWA services.
• Weekly Code-Migrations on Dev, Test and Productions
• Scheduling Gather Schema Stats weekly.
• Applying Application patches using Auto patch utility adpatch and adop.
• Performing RDBMS patches using Opatch. Trouble shooting Workers related issues while applying patches. Minimizing patch time though merging the patches and using options
• Performed application patching by adop on 12.2 on test instance.
• Hands on experience in Cloning R12.2 Environments
• Created test environment through cloning production environment for developers to test on live data
• Cloning Database/Applications (R12) through Manual and Rapid clone methods. Performed clones using Delphix tool. Database Clones through RMAN and Restoration from RMAN backup’s as per requirement
• Implementation of SSL on EBS, Shared Appltop and DMZ configuration on EBS R12.
• Involved in up-gradation of both EBS and Non-EBS databases from 10g to 11g.
• Resolving Concurrent requests & Concurrent Managers issues.
• Resolving day to day user requests
• Monitoring the tablespaces and adding required space whenever it reaches threshold
• Setting up the thresholds for Mount points and cleaning up when it reaches threshold
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases
• Configuration of workflow setup for EBS (R12) and resolving the issues
• Monitoring Backup’s ( Scheduled Hot backup’s and RMAN backup’s )
• Performing re-org activity on regular basis
• Documented database setup and updating the document whenever there is a change in the database structure, backup strategy

Confidential, Exeter, PA

Oracle Apps DBA

Environment: Oracle E-Business Suits 11.5.9/11.5.10.2

Responsibilities:

• Supported database which is on Exadata server.
• Regularly performed Code-Migrations on Dev, Test and Productions
• Resolving the MWA related issues
• Resolving Concurrent requests & Concurrent Managers issues
• Cloning Database/Applications (11i) through Manual and Rapid clone methods on exadata server.
• Database Clones through RMAN and Restoration from RMAN backup’s as per requirement
• Added new application node to existing system
• Implementation of Shared Appltop and implemented Load balancer on 11i environment.
• Upgraded EBS databases from 10g to 11g.
• Applying Application patches using Auto patch utility adpatch
• Minimizing patch time though merging the patches and using options
• Apply the latest PSU patches to the RDBMS Oracle Home .
• Mount point clean up when it reaches threshold as per standard retention
• Used Adadmin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and relinking executables and also, used f60gen to generate and compile forms
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases
• Monitoring Tablespace for space usage and adding required space whenever it reaches threshold

Confidential, Hicksville, NY

Oracle Apps DBA

Environment: Oracle E-Business Suits R12

Responsibilities:

• Working on ticketing system (Connect Wise tool) on Severity and Priority basis
• Closedly worked with technical and functional teams in onsite.
• Assigined the work to of shore dba team and scheduling the downtime actvities.
• Performing re-org activity on regular basis
• Configuration of Active Data Guard and make sure it is always in sync with Primary.
• Resolving day to day user related issues ( user login and user specific ) and Application issues on EBS ( Form server, Report server, Apache ) & Database
• Creating DB links and assigning roles/profiles to the users
• Performed Vertex instatllation.
• Applying Application patches using Auto patch utility adpatch. Performing RDBMS patches using Opatch.
• Trouble shooting Workers related issues while applying patches.
• Minimizing patch time though merging the patches and using options
• Apply the latest PSU patches to the RDBMS Oracle Home .
• Resolving Concurrent requests & Concurrent Managers issues
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases
• Monitoring Tablespace for space usage and adding required space whenever it reaches threshold
• Mount point clean up when it reaches threshold as per standard retention
• Monitoring Backup’s ( Scheduled Hot backup’s and RMAN backup’s )
• Monitored backups from commvault tool.

Confidential

Oracle APPS DBA

Responsibilities:

• Supporting all advanced technology components like Outerbay / iprocurment / MWA
• Maintaining 3+TB databases and supporting multiple instances
• Kintana administration and migration of objects
• Performing re-org activity on regular basis
• Maintaining STDBY DRP instances and trouble shooting the issue related to it
• Involved in Oracle Application upgrade from 11i to R12.
• Responsible for applying RUP/CU patches in application technology layers
• Performed the JDK/JRE upgradation in many Application environments
• Patching for oracle applications using adpatch utility and for oracle Tech stack using opatch
• JVM’s memory changing and taking care customizations as well
• Applied developer 6i patches as well to application oracle homes
• Cloning as and when required using rapid clone, resolved several cloning related issues
• Performing reorg activity to save the space and improve the performance.
• Scheduling Gather Schema Stats at Table level and Schema level as well.
• Configuring workflow notification mailer and resolving issues related to it
• Responsible for monitoring, identifying and resolving user issues
• Giving remote suppot to the end users, as and when required conducting OWC.
• Trouble shooting issues related to concurrent manager and request related issues
• Resolved several connectivity issues, Apache related issues
• Maintaining different kind of backups like RMAN,HotBackup and ARC backup
• Enabling tracing for the long running concurrent programs and session and finding out the root cause for the problems
• Worked with different Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, Auto Patch, Rapid Install, FNDCPASS, f60gen, CONCSUB etc
• Forms, Reports, Libraries and Formula compilation at OS level
• Responsible for application utilities such as ad-admin, ad-relink, ad-ctrl, auto-config,ad-splice
• Creating DB links and assigning roles/profiles to the users
• Troubleshooting both database level and applications level
• Resolved few database connectivity issues, space management issues
• Having good knowledge on implementation activities and co-ordinating with development team for many issues
• Interacting with end users and involving in escalation calls and making the user to understand the thing
• Have good trouble shooting skills and making the the changes to permanent fixes rather than doing workaround
• Shift co-ordination and assigning the tasks according to work load
• Following the Processes like configuration management, change mangement, release management.
• Installation of Oracle EBS on Different Platforms of UNIX
• Performing database refresh and apps refresh as and when required.
• Done patch analysis, applied patches to application environments as well as databases.
• Reducing the patch timings by merging different patches like Language patches and as well using Auto Patch options (like nocompiledb, nocompilejsp, etc).
• Resolved the forms login issues to users.
• Managing apps password, application user passwords and schema passwords
• Creation of application user accounts and assigning the responsibilities.
• Installed off-cycled products using adspilce utility.
• Performing stats collection by schedule / on-demand.
• Relinking the Oracle application objects.
• Co-ordinating with release co-ordinators as well as the concerned developers while implementing the PLC

Environment: OracleApplication11.5.10.2,R12.1.3, Oracle10g & 11g SQL*Plus,AIX, Solaris & Linux.