SUMMARY

• Involved in cloning additional node on the DMZ server, maintenance of single node & multimode Architecture of Oracle Application R12.1.2, R12.1.3, R12.2.4 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..
• Experience utilizing Oracle OEM 12C and Experience in UNIX shell scripting,
• Upgrading EBS environment from 11.5.10 to R12.1.1 & R12.1.3, R12.2.4 and has strong knowledge of Oracle E-Business Suite application architecture, configuration, and troubleshooting.
• Identifies solution to meet gaps between existing Oracle architecture and business requirements.
• Oracle 10G, 11g, 12c, RMAN, OEM 11g & 12c, Grid Control, Perform Backup and recovery, database refresh and handled MDM (Master Data Management).

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.
• Prepared Build Procedure and IQOQ documentations/Compliance for oracle database 11.1, 11.2, 12c and Oracle EM12c cloud control on rhel 6.5 and 5.5.
• Working experience in Oracle 11i/R12 Applications 11.5.10.2 - R12.2.3 and Oracle Workflow.
• Installation/Configuration/Compliance documentation of Oracle Enterprise Manager 12c cloud control on 11.2 databases on Linux.
• Prepared IQOQ Evidence-Oracle 11.2.0.4 and SCS Execution - Oracle 11.1, 11.2 and 12cInstallations/Configuration of Oracle database 11.2, 11.1 and 12c on rhel 6.5/5.5 for 64 bits.
• Configuration of SNMP TRAP Notification on oracle Enterprise Manager- EM 12c cloud control and EM7 integration with Oracle EM 12c cloud control.
• Oracle EM 12c agent deployment on Host and added 25 oracle database in Oracle EM 12c cloud control.
• Written RMAN shell script for QA/DEV/PROD/TEST for NetBackup setup for Oracle Migration through RMAN.
• Migrated from Source 11.1.0.7 on HP UX Server to Target is 11.2.0.4 on RHEL 6.5 Through using Export and Import Dump methodology and Golden Gate with huge and different types of database size.
• Charge of cloning, patching, performance, and security patches andworking on an upgrade plan for the next release level for the apps and database - Version 12.2.3 and Oracle 12c Rel1.
• Worked on Oracle 12c multitenant features for the new database implementations.
• Patch database environments to latest CPU & PSU by following patching plan.
• Installation, configuration and administration of OEM 12c cloud control and monitoring hosts, databases using OEM Grid/cloud control.
• Oracle 10G, 11g, 12c, RMAN, OEM 11g & 12c, Grid Control, Perform Backup and recovery, database refresh via alternate restore using Netbackup.
• Administer databases in the enterprise using Grid/cloud control and Work with Application support/development team to resolve performance issues.

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.1.3 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.
• Upgrading EBS environment from 11.5.10 to R12.1.1 & R12.1.3 and has strong knowledge of Oracle E-Business Suite application architecture, configuration, and troubleshooting.
• Identifies solution to meet gaps between existing Oracle architecture and business requirements.
• 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.
• 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 exadata 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.
• 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, exadata
• 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:

• 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, NY.
• 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.
• Upgrading EBS environment from 11.5.10 to R12.1.1 & R12.1.3 and has strong knowledge of Oracle E-Business Suite application architecture, configuration, and troubleshooting.
• Identifies solution to meet gaps between existing Oracle architecture and business requirements.
• Focus on profile setup & troubleshooting based on requirement as well as workflow troubleshooting issues.
• Progressive experience in working in planning, implementation, rollouts, support, upgrade and maintenance of various modules in Oracle e-Business suite. handled MDM (Master Data Management
• Demonstrated capability in all different modules phase of implementation—requirements Gathering, gap Analysis, Testing, CRP, UAT, User training etc.
• Integrated OID & SSO and Identity Management on 10g AS (Application Server) Integration with E-Business Suit.
• 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, exadata.
• 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 and Identity Management 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.

Consultant - Applications DBA

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.
• Upgrading EBS environment from 11.5.10 to R12.1.1 & R12.1.3 and has strong knowledge of Oracle E-Business Suite application architecture, configuration, and troubleshooting.
• Identifies solution to meet gaps between existing Oracle architecture and business requirements.
• Progressive experience in working in planning, implementation, rollouts, support, upgrade and maintenance of various modules in Oracle e-Business suite.
• Demonstrated capability in all different modules phase of implementation—requirements Gathering, gap Analysis, Testing, CRP, UAT, User training etc.
• 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

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