SUMMARY:

• Oracle Certified Professional, Oracle Apps DBA Certified Professional, RAC certified (Real App Cluster) with 7+ years of experience seeking challenging assignments as Senior Oracle Application DBA
• Involved in cloning additional node on the DMZ server, maintenance of single node & multimode Architecture of Oracle Application R12.1.2, R12.1.3. And database.
• Expertise in Oracle 9i & 10g, 11g, RMAN & Data Guard, working knowledge of RAC (real application cluster) & ASM.
• Well versed in installation of Oracle HRMS R12.1.1 on Linux and AIX6.1 environments with Oracle Database 11g as database platform, patching of Oracle HRMS for global legislation.
• Skilled in upgrading Oracle Application instance from 11.5.9 to 11.5.10.2 and R12 upgrading from 11.5.10.2, installation of CRS HOME & RDBMS HOME for RAC systems and zero downtime patching, ASM configuration & migration of database from clustered file system to ASM & TAF configuration, Primary DB Server, Log Shipping and configuring Standby on Apps Tier.
• Proficient in analyzing information system needs, evaluating end - user requirements, custom designing solutions, troubleshooting for complex information systems management.
• Polished leadership skills with ability to motivate teams to increase productivity.
• Worked on Middle ware and Oracle Real Application Clusters (RAC) with Data guard/or other replication technologies.
• Worked on Flash back, High Availability with Oracle Linux Red Hat/ Confidential & Oracle virtual box environment
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc.
• Oracle shell scripting and Oracle Partitioning and working experience with very large database.
• EBS Service Lead for R12 implementation of Depot Repair and Service Parts Planning.
• Full life cycle implementation including business requirements definition, solution design, configuration, test and deployment.
• Experience utilizing Oracle OEM 12C and Experience in Unix shell scripting

TECHNICAL SKILLS:

Scripts: Linux Shell Scripts

Databases: Oracle 9i & 10g,11g

Oracle tools: PL/SQL, Toad, SQL*LOADER

Tools: &Technologies: Export, Import, RMAN

Server O/S: Red Hat Linux & Windows 2000 Server

Oracle E Business Suite: 11.5.9, 11.5.10, 11.5.10.2, R12.1.1

PROFESSIONAL EXPERIENCE:

SR Oracle Application DBA& DBA

Confidential

Responsibilities:

• Involved in application cloning using Rapid Clone Utility, troubleshooting post clone issues and Application Patching using AD utilities & patch management.
• Involved in Oracle 10g, 11g, RMAN & Data Guard, working knowledge of RAC (real application cluster) & ASM.
• Skilled in upgrading Oracle Application instance from 11.5.9 to 11.5.10.2 and R12 upgrading from 11.5.10.2, installation of CRS HOME & RDBMS HOME for RAC systems and zero downtime patching, ASM configuration & migration of database from clustered file system to ASM & TAF configuration, Primary DB Server, Log Shipping and configuring Standby on Apps Tier.
• Worked with multi node environment for Oracle Apps DBA & DBA
• Involved in cloning additional node on the DMZ server, maintenance of single node & multimode of Oracle Application R12.1.2, R12.1.3. And database.
• Oracle Database installation, patching and upgrading and configuration.
• SQL and PL/SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc.
• System monitoring and health check and standards/best practice implementation.
• Oracle Apps DBA 11i & R12.1.2.3 experience with Oracle DBA 10,11g and R12C.
• Oracle Real Application Clusters (RAC) with Data guard/or other replication technologies.
• Worked on Flash back, High Availability with Oracle Linux Red Hat/ Confidential & Oracle virtual box environment
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc.
• Proficient in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management

SR Oracle Application DBA

Confidential

Responsibilities:

• Conduct patch analysis on test instance & application on prod instances, cloning using rapid clone.
• Involved in cloning additional node on the DMZ server, maintenance of single node & multimode of Oracle Application R12.1.2, R12.1.3. And database.
• SQL and pl/sql Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc.
• Involved in troubleshooting of concurrent manager, login issues & forms, report and Apache server.
• Register DB for SQL ignite monitoring in Non Prod Node.
• Worked on performance tuning in database level and application level like.
• Ensure Prompt resolution of SR in coordination with oracle.
• Involved in performance of failover, monitoring & health checking of all DEV/CRP3G/PROD databases apart from administration & maintenance of Oracle Application with AD utilities - ad patch, ad admin, ad ctrl, ad clone, ad comfit etc.
• Conduct patch analysis on test instance & application on prod instances, cloning using rapid clone.
• Involved with team for Apex installation on non-prod ENV.
• Monitoring RAC, Application node for non-Prod instance.
• Expertise in Oracle 9i & 10g, 11g, RMAN & Data Guard, working knowledge of RAC (real application cluster) & ASM.
• Skilled in upgrading Oracle Application instance from 11.5.9 to 11.5.10.2 and R12 upgrading from 11.5.10.2, installation of CRS HOME & RDBMS HOME for RAC systems and zero downtime patching, ASM configuration & migration of database from clustered file system to ASM & TAF configuration, Primary DB Server, Log Shipping and configuring Standby on Apps Tier.
• Proficient in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management.
• Business Requirements Documentation, Solution Configuration Documentation, Design Documentation, Test Scripts and Scenario.

SR Oracle Application DBA

Confidential

Responsibilities:

• EBS Service Lead for R12 implementation of Depot Repair and Service Parts Planning.
• Full life cycle implementation including business requirements definition, solution design, configuration, test and deployment
• Involved in cloning additional node on the DMZ server, maintenance of single node & multimode of Oracle Application R12.1.2, R12.1.3. And database.
• Focus on profile setup & troubleshooting based on requirement as well as workflow troubleshooting issues.
• Involved in printer setup on server side & for oracle apps R12, application of various types of ad patches like languages on PROD, DEV, CRP3, and QA instance.
• Ensure prompt resolution of SR in coordination with Oracle.
• Worked on health check for database and application.
• Involved in performance of failover, monitoring & health checking of all DEV/CRP3G/PROD databases apart from administration & maintenance of Oracle Application with AD utilities - ad patch, ad admin, ad ctrl, ad clone, ad comfit etc.
• Conduct patch analysis on test instance & application on prod instances, cloning using rapid clone.
• Database and application are in Multinode Architecture.
• Liaise Oracle Bi Discoverer admin, desktop and setup for R12 on different modules. (HRMS, AP, Functional) apart from performance tuning like generate AWR etc.
• Set Standby for Business Continuity for Oracle E-Business Release 12 using Oracle 11g; configure Dataguard on Primary DB Server & Log Shipping as well as configuration of Standby on Apps Tier.
• Involved in troubleshooting of concurrent manager, login issues & forms, report and Apache server.

Sr. Oracle Applications DBA

Confidential

Responsibilities:

• Upgraded Discover 4i to 10g with E-Business, Oracle Application instance from 11.5.9 to 11.5.10.2 and R12 from 11.5.10.2, rendered implementation support of Oracle Applications (patching, troubleshooting errors, Concurrent Managers Management).
• Involved in application cloning using Rapid Clone Utility, troubleshooting post clone issues and Application Patching using AD utilities & patch management.
• Integrated OID & SSO on 10g AS (Application Server) Integration with E-Business Suit.
• Updated knowledge in SQL, Linux Shell Script Writing.
• Installed 10g Application Server Infra & Middle tier integrated with E-Business, OEM grid console & configured with Diff server.
• Applied various types of patches & patch set for upgrading of database & AppsDBA and set up SSL in R12.
• Administered & maintained Oracle Application with AD utilities - ad patch, ad admin, ad ctrl, ad clone, ad comfit etc besides performing patch analysis on test instance and application on prod instances, cloning using rapid clone.
• Troubleshooting concurrent manager & login issues & forms, report and Apache server.
• Upgraded apps database to 10.2.0.1 on test environment using DBUA and enable autoconfig on dbTier.
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc
• Sql tuning and pl/sql Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc

Confidential

Consultant - Applications DBA

Responsibilities:

• Upgraded Discover 4i to 10g with E-Business, assisted in installation of Oracle HRMS R12.1.1 on Linux & AIX6.1 environments with Oracle Database 11g as database platform and patching of Oracle HRMS for global legislation.
• EBS Service Lead for R12 implementation of Depot Repair and Service Parts Planning. Full life cycle implementation including business requirements definition, solution design, configuration, test and deployment.
• Upgraded Oracle Application instance from 11.5.9 to 11.5.10.2 & R12 upgraded from 11.5.10.2, rendered implementation support of Oracle Applications (patching, troubleshooting errors, Concurrent Managers Management).
• Upgraded cluster ware from 10.2.0.1 to 10.2.0.4 by CPU patch using Opatch and RAC database.
• Installed CRS HOME & RDBMS HOME for RAC systems and zero downtime patching.
• Configured & migrated database for ASM from clustered file system to ASM and TAF configuration.
• Involved in cloning process using RMAN as well for RAC database, managed backup & recovery of OCR and CSS files.
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc
• Managed application cloning using Rapid Clone Utility, troubleshot post clone issues & Application Patching using AD utilities and patch management.
• Integrated OID & SSO on 10g AS (Application Server) with E-Business Suit.
• Performed basic DBA/ system administrative activities spanning application maintenance, troubleshooting of applications and database issues during the conference Room Pilot (CRP) and Development phases (profile setting, logging SR with Oracle etc).
• Prepared scripts for automation of shutdown & start up in cron jobs, required for backup of DEV and CRP instance.
• Assisted in patching of Oracle HRMS for global legislation, technical design documentation-OID/SSO and ADS.
• Involved in implementation support for Oracle applications (patching, troubleshooting errors, Concurrent Managers Management).
• Performed system administration activities based on requirements besides troubleshooting concurrent manager issues, forms, Reports and Apache servers.
• Highlights:
• Acknowledged for completion of projects within SLA parameters.
• Conducted sessions for DBA & Apps in USA & India.
• Acquired knowledge in developing Stored Procedures, Functions, Triggers, Cursors, Views, SQL*LODER, TOAD, UTL-File Package, Linux Shell Script Writing

Technology used: ORACLE 12.1.1, Red Hat Linux5.3, oracle 11g, AIX6.1 IBM product.

Oracle EBS - Support & Maintenance

Confidential

Responsibilities:

• Upgraded Discover 4i to 10g with E-Business, assisted in installation of Oracle HRMS R12.1.1 on Linux & AIX6.1 environments with Oracle Database 11g as database platform and patching of Oracle HRMS for global legislation.
• Cluster application database to Normal application database.
• Normal application database to Cluster application database.
• Knowledge Performed up gradation of cluster Ware from 10.2.0.1 to 10.2.0.4 and databases from 10.2.0.1 to 10.2.0.4...
• Handled Oracle instance cloning activities and reconfiguration after refresh using Rapid clone.
• Applied interim patches using Opatch utility. .
• Made policies for database hot backup, cold backup and RMAN backup.
• Resolved the concurrent request log/out files view and also concurrent manager’s startup issues.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Creating users, assigning responsibilities, troubleshooting the issues, Cloning of Production to test.
• Proactive monitoring and health checking of all DEV/STAGING/PROD databases.
• Applied database patches using OPatch utility.
• Applied oracle application patches using ad patch.
• Performed OCR & CSS files backup and Administrated RAC database using SRVCTL.
• Applied interim patches using Opatch utility on RAC RDBMS HOME.
• Generated Stats pack as per the requirement. Performance Tuning: Explain plan, TKPROF, STATSPACK, and Explain Plan.
• Performed regular activities like monitoring the alert logs, redo log status, listener. Offline Cloning of the Database.
• Cloned and refreshed of Database. Performed different methods of backups like hot, cold. Applied patches using Opatch Utility.
• Backup and recovery strategy databases using RMAN.as well as standby, up gradation, migration, Disaster recovery.
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc