SUMMARY:

• 8 years of experience as Oracle Apps DBA(R12&11i) & Oracle DBA. Proficient in Oracle Database and Application Installation and Administration.
• 3 years of experience on Fussion Middleware& Weblogic on Oracle Transportion management
• 3 Year experience on Weblogic Bpel SOA&Sabrix Implemention and support
• Hands on Experience on Installation of Oracle Application wif single node/multi nodes/shared appl top on Linux/Unix environments.
• Good experience on R12 ERP.
• Good Experience in Installation and Configuration of Oracle Application Server (Oracle 11g/10g/9i).
• Good experience on converting Non ASM to ASM on RAC nodes
• Extensive Use of Oracle Services for Application Partitioning in a multi node FE and multi node RAC env and administration of cluster and services
• Strong experience in Patching and Cloning Oracle Applications on different platforms
• Good at Applying patches of Oracle Applications and Maintenance Activities using AD Utilities.
• Good in optimizing Patching and ERP Upgrades, extensive use of admrgpch, defaults file,modifying u - drivers to speed up patching/upgrade process.
• Very strong hold on AD utilities
• Strong experience in Creating Users, Responsibilities, Menus and Form Functions.
• Hands on experience wif Oracle 9i database and Oracle 10g/11g database.
• Woked on Upgradation of Apps database from 9i to 10g and also on Oracle Applications at multiple 11i levels to R12.
• Conversion from OFA tablespaces in ERP to OATM - zero downtime (part of DB migration )
• Worked on database backups and Recovery strategies using RMAN, Export, and Transportable Tablespace, Recovery disaster recovery for monitoring and backing up the Oracle databases.
• Database Character Set Conversion from WE8ISO8859P1 to UTF8 using csscan/csalter, fixing issues related to scan
• Extensive use of Datapump and Transportable Tablespaces for DB Migration
• Basic Knowlegde on SSO&LDAP and Integration to EBS.
• Knowlegde on troubleshooting SSO-user login related issues.
• Performed Application admin tasks using ADADMIN utility.
• Managing system configuration by using AutoConfig / Parallel AutcoConfig (R12 feature)
• Securing Oracle Applications by periodically changing Apps and schema Credentials.
• Using tools like FNDLOAD, FNDCPASS for application users and security maintenance.
• Applying RDBMS and Application patches using Opatch and Adpatch utilities.
• Extensive DBA experience in maintenance, development, Export/Import, Backup/Recovery.
• Worked on different flavors of UNIX for supporting 11i Oracle E-Business Suite.
• Good Knowledge on Performing Regular Application Health Checkups.
• Good experience in server move.
• Experience in restoring a database using RMAN on a different node wif different backup directory structures and different database directory structures.
• Use of RMAN Duplicate using Backup Based and Active Duplication (new feature in 11g)
• Good upgradation experience from 10g to 11g
• Good experience on BACKUP and RECOVERY in oracle DB.
• Good Experience on performance tuning on oracle DB.
• Ability to do multitask, be flexible under pressure, and work wif changing priorities in a dynamic environment.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite R12.0.4/12.0.6/12.1.1/12.13, 11.5.10, 11.5.9

Fusion Middleware: Weblogic,Bpel SOA,OTM, Oracle Fusion Middleware 11g

Databases: Oracle 11g/10g/9i

Operating Systems: Oracle Enterprise Linux3/4/5,Solaris 5.10 64bit,Red hat Linux 2.1/3.0/4.0/5.0,Windows NT.

Tools: SQL, PL/SQL, TOAD, OEM, OAM, SQL*Plus, SQL*Loader, FNDLOAD, FNDCPASS RMAN, ADI

PROFESSIONAL EXPERIENCE

Confidential, CA

Responsibilities:

• Involved in Upgradation of Oracle Apps from 11.5.10.2 to R12 and 11.5.10 to R12.1.1/12.1.3
• Converted Non ASM to ASM devices using RMAN wif oracle service partitioning on 5T database.
• Implemented Oracle Rapid Plaining producat on Weblogic and integrated wif R12 ERP.
• Integrated Oracle Rapid plaining wif Oracle 12.1.3 EBS.
• Involved in Database migration of 12T size from HP to Linux server including Oracle Applications (ERP) .
• Enable MVDC Setup ERP(R12) and BPEL SOA domain on 2 data centers active & active services
• Converted 4 RAC node to 8 RAC node wif ERP and PCP setup on 8 Concurrent Nodes wif 6 Web Nodes, 2 External Nodes, 2 $U nodes wif Cisco ACE Load Balancer
• DMZ Node setup on R12 instance
• Externalization of Oracle Sourcing(PON)/Oracle i-Supplier(POS) modules
• Hardening Setup on External DMZ Nodes of ERP
• Configuring external node to use Oracle Connection Manager (OCM) for DB connectivity
• Configuring external Load Balancer URL
• SSO&LDAP Integration to EBS(R12)
• Involved in Point release upgrade from 12.1.1 to 12.1.3
• Installation of a new language on ERP System and generating TSP patches and applying them
• Converted ERP file system from 32 bit to 64 bit on linux
• Worked on Installation of Oracle Transportion management (OTM) applications wif Weblogic and regular support for issues.
• Implemented Fusion Transportion intellgies(FTI) on OTM wif ROD database.
• Involved in Weblogic integration wif OTM applications.
• Implemented BPEL SOA on Weblogic and integrated wif ERP using Data Sources
• ACE-Load Balancer - http url configuration setup on context file as per http&forms load balance
• Installation for oracle database as per business requirement.
• Monitoring Daily production&Release instances.
• Applying functional patches as per the Requirement and for fixing issues.
• Implemented both Servlet and Socket mode connection configurations on forms tier.
• Databases Upgradtions from 9i to 10g and 11g.
• Application Upgradtions from 11.5.10 to 11.5.10cu2 and R12.
• Applying Database patches using Opatch utility
• Good noledge on Troubleshooting and debugging Concurrent issues.
• Work Flow Notifications setup and troubleshooting the user issues in worlflow services.
• Applying CPU patches on Quaterly basis on both database and application side.
• New user creation and maintenance
• Monitoring Reports Server, Forms Server, Concurrent Managers, and Apache Listener.
• Troubleshooting application issues like web server, Forms server and Report server.
• Installation of Oracle Apps on single node and multi node environments
• Monitoring Table space, data files utilization using the Custom XPM scripts.
• Troubleshooting on custom shell scripts.
• Using Rman to restore and recover the database.
• Using tools like FNDLOAD, FNDCPASS for application users and security maintenance.
• Creating RMAN setup utilities wif catalog.
• Applying Patches Using adpatch and maintaining Application using adutilities.
• ADI issues Debuging as per user requests.

Confidential

Responsibilities:

• Cloning the environments using AD Clone/Rapid Clone/Rman Duplicate Database Clone.
• Good work experience on Oracle database 10g.
• Monitoring Production databases and other Test environments.
• Applying patches as per the user request wif prof of RFD in Production.
• Implemented both Servlet and Socket mode connection configurations on forms tier.
• Databases Upgradtions from 9i to 10g and 11g.
• Application Upgradtions 11.5.10 to 11.5.10cu2 and R12.
• Applying Database patches using Opatch utility
• Good noledge on Troubleshooting Concurrent issues .
• Work Flow Notifications setups and monitoring the user issues in worlflow services.
• New user creations and reset the password and assign the Responbilities to the users.
• Monitoring Reports Server, Forms Server, Concurrent Managers, and Apache Listener.
• Troubleshooting application issues like web server, Forms server and Report server.
• Installation on single node and multi node environments.
• Monitoring Table spaces, data files utilization using the Custom XPM scripts.

Confidential

Oracle Apps DBA

Responsibilities:

• Installed, configured and administered Oracle Application 11i (11.5.8,11.5.9,11.5.10) and database in a Multi-tier architecture..
• Upgrading databases from 9i to 10g
• Upgrade from 11.5.9 to 11.5.10cu2
• Installing 10g OEM Grid, installing OEM agents on all application and database nodes and configuring OEM
• Applying patches for Oracle Applications and Database using Adpatch and Opatch utilities.
• Monitoring Reports Server, Forms Server, Concurrent Managers, and Apache Listener.
• TAR Management for the issues in Production Instance.
• Regular monitoring of Alert log file on day-to-day basis.
• Strong experience in Installation, Setup, Implementation, and Customization & Product Support of Oracle Applications 11i
• Monitoring concurrent jobs for Oracle E-Business Suite.
• Implemented both Servlet and Socket mode connection configurations on forms tier.
• Configuring the Concurrent Managers efficiently.
• Using tools like FNDLOAD, FNDCPASS for application users and security maintenance.
• Reset ORACLE schema passwords by using FNDCPASS.
• Cloning the environments using AD Clone/Rapid Clone
• Prepared the action plan for Oracle Apps Installation and Cloning.
• Applying patches as per the user request.
• Performed Application admin tasks using ADADMIN utility.
• Used Ad clone Utility for the Cloning of the Test Instance, Installing and upgrading the ORACLE Server and application tools.
• Enrolling users and maintaining system security.
• Applying Patches Using Ad patch, adctrl, and other Ad utilities
• Prepare the backup and restore strategy for the client, implement the custom scripts in place for performing the hot backup as well as cold backups
• Controlling and monitoring user access to the database.
• Trouble shooting application issues like web server, Forms server, and concurrent managers.
• Planning for backup and recovery of database information.
• Troubleshooting of various issues during installation and day-to-day activities
• Monitoring Table spaces, data files utilization.
• Installation on single node and two nodes
• Backing and restoring the database.

Environment: Oracle Applications11i, Oracle10g/9i, SQL*Plus9.0.0, PL/SQL8.0.6, SQL*Loader 8.0.6, TOAD, RMAN, FNDLOAD, FNDCPASS, Red Hat Enterprise Linux AS release 4(RHEL4.0)

Confidential

Oracle Apps DBA

Responsibilities:

• Installation of Oracle Application 11.5.9.
• Cloning of Application Instance -- Single node to two node Using AD Clone.
• Applied the patches using ADPATCH.
• Performed Application admin tasks using ADADMIN utility..
• Created Responsibilities and Application Users.
• System Administration of 11i.
• Maintenance of concurrent processing requests and concurrent managers.
• Created and resized the new Data files.
• Reset ORACLE schema passwords.
• Update configuration-related profiles.
• Set rollback segments for normal use.
• Validate and compile APPS schema.
• Creation of Schema objects and Space Management.
• To take backups as per the corporate policy and perform recovery as and when required.
• Performed the maintenance of Database and Production Support.
• Administration of oracle 9i database including installation, creation and planning the backup strategy on Linux A.S. 3.0.
• Managing primary database structure and objects.
• Monitoring alert log file.
• Managing users, password security, roles, privileges and resources.
• Database backup includes daily, weekly and monthly.
• Database space management, which includes creation of table spaces.
• Planning for backup and recovery of database and maintaining hot backups and cold backups.
• Creating users, assigning roles and profiles, maintaining system security though monitoring user access to the database.
• Installation of oracle 9i and 10g software
• Cloning the database.
• Worked as anOracle DBA on Linux platform
• Database backup includes daily, weekly and monthly
• Refreshed the database for testing purpose.
• Tested thoroughly wif data and database objects.
• Creating users, assigning roles and profiles, maintaining system security though monitoring user access to the database.
• Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader,Nid,Dbverify, Win NT and UNIX

  .