Sr Oracle Application DBA DBA

Commitment Leadership Integrity Results

• 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/VMware Oracle virtual box environment
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc.
• 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.
• Oracle shell scripting and Oracle Partitioning and working experience with very large database.
• Experience utilizing Oracle OEM 12C and Experience in Unix shell scripting

PROFESSIONAL EXPERIENCE

Confidential

• 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/VMware 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

Confidential

Job Profile:

• 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.

Confidential

Job Profile:

• Configure frame relay network for remote access, ISL trunk on Fast Ethernet channel between switches as well as set up VLANs and DMZ node for iRecruitment with SSL Accelerator at OLF
• 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.

Job Profile:

• 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

Job Profile:

• 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 training 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

Confidential

Job Profile:

• 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