PROFESSIONAL SUMMARY

• 8 plus years of professional experience in IT in the areas of Oracle Applications DBA, Oracle database administration, Oracle RAC DBA, Oracle 10g Application server administration, Oracle 10.1.4 portal administration, Oracle internet directory administration(Oracle Identity Management), Oracle discoverer administration, Oracle Label Security implementations and Oracle PL/SQL Development Migration and Support.
• Involved in Oracle Apps 11.5.5/11.5.8/11.5.10/12.0.4/12.1 administration. It includes cloning, patching, troubleshooting technical issues on the Application server, Concurrent manager setup and administration, installing oracle applications.
• Involved in Implementing High availability oracle applications 11.5.10 using PCP (Parallel concurrent Processing),10g/11g RAC and Data guard.
• Involved in Oracle database 10g/11g RAC administration on OCFS, GPFS,ASM file systems.
• Experience in basic and advance replication using Oracle Streams, Oracle Golden gate.
• Implemented Oracle 10g RAC for 11.5.10.2 applications using PCP on OCFS file system.
• Experience in Oracle Applications upgrade from 11.5.10 to R12 and preserving the customizations
• Experience in Oracle Applications upgrade from 11.5.5 to 11.5.9 on HP - UX 11.11.
• Experience in upgrading Oracle database from various versions from 7i to 9i, 8i to 9i, 9i to 10g,10g to 11g on Windows,HP-Unix,Sun Solaris, IBM AIX and Linux x86.
• Experience in upgrading Cluster Ready Services (CRS) from 10.2.0.4 to 11.1.0.7
• Experience in Upgrading Cluster Ready services(CRS) from 10.2.0.1 to 10.2.0.4
• Integrating Release12 Oracle Applications with 10.1.4 Portal and implemented Oracle single sign on.
• Installed APEX 4.0.2 with Oracle Application Server.
• Platform Migration of Release 12 Oracle Applications from Sun Solaris to Linux x86.
• Performance tuning using 10046, 10053 traces, SQL Profiles, SQL outlines and SQL Baselines.
• Identifying the Memory leaks of Oracle Applications JVM’s and fixing the memory leaks there by fine tuning the JVM’s.
• Implementation of SSL in oracle Applications, Oracle infrastructure, Oracle web cache and Oracle Forms.
• Implementation of Oracle webcache for Oracle E-Business environments.
• Experience in sharing the Application tier file system in oracle E-Business suite 11i (shared APPLTOP).
• Experience in implementation of autoconfig on Oracle Applications. 11.5.5,upgradation to oracle 9iAS(1.0.2.2.2) in oracle Applications 11.5.5.Involved in load balancing of oracle Applications forms using Metric server/Metric client methods and http layer load balancing using hardware load balancer.
• Experience in implementing Forms Listener Servlet in Oracle Applications 11i.
• Architect experience in assigning memory, CPU, storage space and creating virtual and logical partitions on HP Superdome,IBM P-series servers.
• Proficient in Application and Database Tuning (Tuning Memory, Tuning I/O and Tuning Contention).
• Thorough knowledge of RAID (0, 1, 1+0, etc) concepts with practical implementation experience.
• Recovered Oracle 10g database from an RMAN backup whose starting archive logs are missing through some undocumented methods by adjusting the SCN’s.
• Experience in implementing hot backup for Oracle 8i and Oracle 9i. Experience in backup and recovery on Oracle 8i/9i/9i RAC.
• Experience in 10g/11g physical standby database implementation for disaster recovery, Implementation of oracle data guard. Implemented 11g logical standby database.
• Versatile team player with excellent communication, inter-personal skills and highly self - motivated. Ability to learn appropriate technologies and being able to derive personal motivation with assigned

TECHNICAL SKILLS

Application: Oracle Application 10.7, 11i, R12, Oracle AS Discoverer 10g and Oracle Portal.

RDBMS: Oracle 7.3, 8.0, 8i, 9i, 10g, 11g.

O/SSolaris,: HP, AIX, Linux, Window NT, Windows 2000 / 2003

ToolsOEM,: OAM, Workflow 2.6, Exceed v7.1, Tivoli, QA Run 4.90, HP Open

View: Quest STAT ACM, TOAD.

Hardware: EMC Symmetrix, Clariyon, Sun Enterprise Servers, VERITAS NetBackup, NAS Storage systems, HP Enterprise virtual array, IBM Fast T, HP MC Service guard Cluster, OCFS2.

Languages: SQL, PL/SQL programming, Unix Shell Scripting, Java, HTML.

Modules: GL, AP, FA, PO, AR, INV, Iprocurement, FND, AU, AD, AK, SYSADMIN

PROFESSIONAL EXPERIENCE

Confidential

Sr APPS DBA

Responsibilities:

• Solving different types of Oracle APPS DBA issues for different Customers in across the world on 11i(11.5.10, 11.5.10.2) and R12(All Versions)
• Providing the solutions to the customers on time.
• Analying the Patching issues and providing the solutions
• Analying the TK Proof and Trace files of the issues and providing the solution
• If the issue is related to new Bug, Raising Bug with the development team
• Conducting Web Confercing with customer and taking control of customers system and solving the issues
• Created Metal ink Notes after solving the issues
• Working on Bug processing for the Code fix issues.
• Reproducing the issues in Test Instances internal servers for solving, as well as preparing the test cases.
• Raising the ER's(Enhancement Request ) as per customer requirements to solve.
• Queue management.
• Working and providing the solutions to Critical issues on priority basis.
• Contributed a good deal in the successfully running of the Oracle Global Support Created Unit Test plans and involved in primary unit testing.
• Involved in on-call support rotation to support the application 24 x 7

Confidential

Sr APPS DBA

Responsibilities:

• Supporting Oracle On-demand Customers running various versions of Database (Oracle 8i, 9i, 10g and 11g), Oracle Applications (11.5.8, 11.5.9, 11.5.10 and R12.x), Tech Stack (Discoverer, iAS, Discoverer, JDK, Jinitiator, and Developer6i) and Oracle Application Server
• Providing all round DBA support to resolve DB, Application, Tech Stack outages on production, development, test and staging Ondemand Customer environments.
• Daily responsibilities include trouble shooting and restoring Oracle Applications components Apache, Forms, Reports, Concurrent Managers, Workflow Managers, Discoverer plus/viewer, iAS, Single Sign-on
• Running autoconfig, setting up DMZ, Discoverer, Oracle Sysadmin activities and other maintenance acitivities
• Performed Oracle Database and Applications Installations, Upgrades, Cloning, done extensive patching (both DB and Applications), applied CPU patches, Family Packs, Patchsets and Single off patches.
• Identifying, analyzing and resolving technical problems related to Oracle software systems.
• Restore failed services; find workarounds to reduce business outage situations.
• Worked on multi-node RAC DB and mutli-node Mid-tier Apps.
• Performance tuning on DB and Applications.
• Performing dry run for disaster recovery test for Ondemand Customer instances.
• Monitor and Support Apps in new 11g RAC, 11g ASM.
• Support Oracle OID/SSO Integration.
• Integrating Oracle E Business Suite with Microsoft Active Directory.
• Performed Oracle Apps/Database performance Tuning.
• Experienced in Shell Scripting.
• Handling Database locks and Sessions.
• Status of database like Table space free space, Invalid objects, Tables reaching their maximum extents
• Disk space checking, Alert log and Trace monitor.
• User managed Backup, restore and recovery (Hot and Cold backups).
• Apply patches to the database using opatch tool.
• Oracle Custom Application Creations Created Custom Application, menu, function and attached custom forms and custom reports. Also created custom table space and oracle database user.
• Rising SR and monitoring them. Responsible all SR update and providing all needed information to Oracle from Oracle Diagnostics Tool, files versions, SQL scripts Run.
• Handling the DBA Activities (Patching, Cloning, Installation, and Backup) Applied Application and database patches to fix the issue. Upgraded R12 Application from 12.0.1 to 12.0.4. Making the Cloning of database and application from production server every month on Window 2000 server. Installed Fresh R12 Production and Vision Instance on Window 2000 server environment. Taking Cold backup every week of database and application.
• Installed Needed Software on Client Machines for Technical and Function Training. Installed J2SE, Configure host file to access Application R12, added tnsname to access database using Toad.
• Maintain user security and created users for client to access Application. Created users and attached them needed responsibility by using Data Loader Tool
• Installed Oracle Desktop Software on desktop Oracle Report Builder, Oracle Form Builders, Oracle XML Publisher and Oracle 0g Developer Suite.
• Configure barcode printer with oracle application Attached the barcode printer to desktop and fetched barcode information from printer to form and save
• Configuration and troubleshooting Data guard.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database monitoring the concurrent Reports status if need monitor corresponding concurrent manager and fix the issue. Monitoring the table spaces of database and increased if needed.
• Worked on XML publisher report SQL Query Development, Query Optimization, Report Template Design, and Registration with Applications. Developed the XML publisher graphical Reports for clients to show the data in graphical form.
• Oracle RDF Reports. Used Data Wizard according to the report’s requirements and developed the query developed the graphical Reports for clients to show the data in graphical form. Make the Conditional Formatting to data according to defined exceptions or conditions. Wrote and Called Stored Procedure from reports
• Form personalization Form folder Management, Custom Field validations, shown the customization on particular Responsibility.
• Interfaces and data migration. Uploaded Customers from Legacy system to Oracle Applications R12 using interface Program, Uploaded Payable and Receivable invoices from legacy system to Oracle Application R12. Integrated legacy Web engine to oracle Application for web user customers.
• Restricts access to those with appropriate clearance—Allows administrators to classify every row in a table, ensuring access to sensitive data is restricted to users with the appropriate clearance level using Oracle Label Security Tools
• Writing\Manipulating the database queries, Packages, Stored Procedures, Functions, Triggers in Oracle DB etc using TOAD.

Confidential

Oracle APPS DBA

Environment: Solaris 10, Oracle 10g,Oracle Application 10g Oracle 10g Developer Suite, Toad, SQL Developer, XML Publisher, Data guard, Oracle Application Manager, 10gAS,11g RAC, ASM, OID/SSO and Microsoft AD. HA (Multimode Database RAC (2 Nodes) and Apps on 2 Node).

Responsibilities:

• Upgraded oracle applications from 11.5.10 to R12 HP-UX 11.11.
• Involved in Cloning and patching of oracle applications 11.5.10/R12
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Responsible for Installation of 11g database on 2 nodes RAC, 11g Grid Infrastructure with ASM files systems.
• Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.
• Provided Database Administration support (24x7) for 3TB production oracle 11g Databases.
• Responsible for installation, creation of 11gR2 RAC databases for Development and user acceptance test.
• Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6.Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for SQL query tuning, optimization. Performance tuning using 10046, 10053 traces, SQL Profiles, SQL outlines and SQL Baselines.
• Responsible for undo rollback management. Created database objects, users, roles and profiles
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Configuration of Oracle golden gate for replication between two databases.
• Responsible for automation of startup and shutdown on all production and development databases.
• Involved in scheduling transaction log backups and notifications.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Extensively used LVM on both AIX and RHEL, created VGs, LVs, File systems and disk mirroring.
• Setup and configured network TCP/IP on LINUX and AIX servers including RPC connectivity for NFS. Created mount points for Server directories, and mounted these directories on the Servers.
• Restricts access to those with appropriate clearance—Allows administrators to classify every row in a table, ensuring access to sensitive data is restricted to users with the appropriate clearance level using Oracle Label Security Tools
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.

Confidential

APPS DBA

Environment: Solaris 10, Oracle 10g,Oracle Application 10g Oracle 10g Developer Suite, Toad, SQL Developer, XML Publisher, Data guard, Oracle Application Manager, 10gAS,11g RAC, ASM, OID/SSO and Microsoft AD. HA (Multimode Database RAC (2 Nodes) and Apps on 2 Node).

Responsibilities:

• Upgraded oracle applications from 11.5.10 to R12 HP-UX 11.11.
• Involved in Cloning and patching of oracle applications 11.5.10/R12
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Responsible for Installation of 11g database on 2 nodes RAC, 11g Grid Infrastructure with ASM files systems.
• Expert in effective troubleshooting of those problems encountered on a daily basis in production & development database environments along with the problems encountered in performance monitoring.
• Provided Database Administration support (24x7) for 3TB production oracle 11g Databases.
• Responsible for installation, creation of 11gR2 RAC databases for Development and user acceptance test.
• Responsible for Upgrading the Database from 10.2.0.3 to 11.1.0.6.Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Responsible for SQL query tuning, optimization. Performance tuning using 10046, 10053 traces, SQL Profiles, SQL outlines and SQL Baselines.
• Responsible for undo rollback management. Created database objects, users, roles and profiles
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability. Created and Managed Services using DBCA.
• Excellent in depth understanding of Oracle automatic Undo Management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• Updated development databases by using import/export and SQL loader utilities.
• Responsible for monitoring Oracle database activities using Oracle Enterprise Manager.
• Responsible for configuration and implementation of backup and recovery using RMAN.
• Installed and configured Recovery Manager Catalog Database.
• Configuration of Oracle golden gate for replication between two databases.
• Responsible for automation of startup and shutdown on all production and development databases.
• Involved in scheduling transaction log backups and notifications.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Extensively used LVM on both AIX and RHEL, created VGs, LVs, File systems and disk mirroring.
• Setup and configured network TCP/IP on LINUX and AIX servers including RPC connectivity for NFS. Created mount points for Server directories, and mounted these directories on the Servers.
• Responsible for User Acceptance testing and supporting the end users by resolving problems faced by them.

Confidential

Oracle DBA

Responsibilities:

• Installing of Oracle 9i on Windows and Linux Environments.
• Creating and managing multiple instances.
• Creating and Maintaining of Tablespaces.
• Performing Logical Backups (Using exp and imp Utilities)
• Performing Incremental Backups.
• Performing Hot and Cold Backups.
• Performing Transportable Tablespaces.
• Creating Database links
• Creating Materialized views