PROFESSIONAL SUMMARY:

• An Oracle Applications Database Administrator offering more than Ten years of Oracle Database Installations, Upgrade, Cloning, Patching, Backup and Recovery, Troubleshooting and Support of Oracle 11i/R12 Applications with 11G/10G RAC/Exadata Databases on Linux/Oracle Enterprise Linux platform.
• 24x7 Production Oracle Applications Administration.
• Maintaining production, development & test databases and applications.
• Extensive experience in development/test and production environments.
• Extensive expertise as an Oracle Apps DBA supporting various products and different applications versions of Oracle Applications including version 11.5.5, 11.5.8, 11.5.9, and 11.5.10.2 &12i On Linux, AIX Platforms.
• Proficient in Oracle Apps DBA/ Oracle Apps DBA with RAC
• Installation, Administration and Maintenance of Golden Gate
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced and proficient with Oracle E - Business suite application (R 12 12.1.3/12.0. x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Red Hat Linux and OEL.
• Worked Intensively with Solix EDMS tool to archive and purge Data
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues.
• Expert in Cloning using ADCLONE, Rapid clone and ADCONFIG.
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Experience in Installing, configuring and maintain Oracle RAC, data warehousing and Data guard.
• Database Upgrading from one server to another using Export and Import utility.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mail.
• Experience in general troubleshooting, firefighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Experience in Installation, Administration and Maintenance of Oracle Apps11i/R12 (EBS)
• Installation of Oracle Applications (EBS) R12. Installation, administration and maintenance of RAC 11gR2, 10gR1, 10gR2 on Linux and AIX platforms
• Expertise on Backup and Recovery of Single and RAC Databases using RMAN
• Expertise on Patching and Cloning of Oracle Apps 11i/R12 and 10gR2/11gR1 RAC Database on Linux and AIX Platforms
• Expertise in Oracle advanced Technology like RAC, ASM, Dataguard, OEM, Grid Control and Replication
• Installation, Administration and Maintenance of Oracle Application Server
• Expertise on Cloning of RAC clusterware and Database, Oracle Apps 11i/R12 Single node/Multi node, Oracle Apps 11i/R12(EBS) with RAC and ASM
• Load balancing of RAC Database, Load balancing of forms tier, and configuring parallel concurrent processing and Transaction manager
• Exposure to different Hardware like Compaq Server, IBM Server, Sun Fire v1280, Sun Fire v480, HP Blade Servers (BL e-class), DELL, EMC Storage and Fire wire
• Configuration and maintenance of Shared APPL TOP in Linux Platforms
• Experience in Application support activities to the offshore development team (Technical/Functional)
• Space Management, and performance management with respect to applications
• Proficiency in creating business and technical project documentation.
• Expertise is working with global and distributed project teams. Ability to work as a strong team leader to ensure quality and timely project execution

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10,11, AIX 5.1, 5.2, 5.3, 6.1, 7.1Red Hat Linux RHEL 2.x, 3.x, 4.x, 5.x, 6.x and Windows NT/2000//XP.

RDBMS: Oracle12c/11g/10g/9i

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting

Tools: TOAD, SQL Tools, OEM, OBIEE and SQL*Loader, Export/Import & Data Pump EXPDP/IMPDP, TOAD and Share point, Jira tool, Solar Winds, Solix, Sabrix

Oracle Tools: RAC, RMAN, ASM, OEM(11g), CC(12c/13c), exp/imp, expdp/impdp, Oracle Golden Gate

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SPA, RAT, SQL Profiles, SQL BaselinesOther: Data Domain (DD BOOST Backups)

PROFESSIONAL EXPERIENCE:

Confidential, Huntersville, NC

Sr. Oracle EBS Database Administrator

Responsibilities:

• Interacted with the Client/offshore to plan the installation.
• Installed 11gR2 Clusterware and ASM to upgrade from 10gR2 to 11gR2.
• Cloned/Upgraded 11gR2 RAC and ASM with 10gR2 data using data pump’s and went live on new hard ware
• Installed and configured RAC setup for 11i (EBS) on 11gR2 RAC and ASM.
• Key Part of EBS 11i to R12.1.3 Upgrade
• Key part of Exadata Platform Migration
• Worked on Exadata Databases and Exadata Patching activities
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced and proficient with Oracle E-Business suite application (R 12 12.1.3/12.0. x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Red Hat Linux and OEL.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues.
• Expert in Cloning using ADCLONE, Rapid clone and ADCONFIG.
• Worked Intensively with Solix EDMS tool to archive and purge Data
• Upgraded Solix EDMS from 5.1 to 6.0 to 7.0 successfully
• Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using NetBackup/DD BOOST on single, multi and RAC to RAC cloning
• Expertise in implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Experience in Installing, configuring and maintain Oracle RAC, data warehousing andData guard.
• Database Upgrading from one server to another using Export and Import utility.
• Expertise in RMAN for recovery and cloning.
• Expert in Configuring Workflow Mail.
• Experience in general troubleshooting, firefighting, and development of scripts, documentation, issue resolution, and TAR support.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings.
• Experience in Security Management and Database Auditing.
• Applied patches on RAC databases and Clusterware.
• Configured PCP (parallel concurrent processing) in Multinode RAC environments
• Installation, Administration and Maintenance of Golden Gate
• Implemented uni directional and Bi Directional Golden Gate Replication with Extracts and replicats
• Upgraded Golden gate from 11 to 12c
• Worked closely with Middleware, BI, OBIEE, LAMP teams and Maintained their Databases
• Performance Tuning slow running sql’s and creating Base lines and Profiles to improve the performance
• Implemented and Configured OEM 11/12C and configured Monitoring and OS level jobs in OEM for all Databases.
• Applied Developer Patch sets.
• Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using ADCONE utility and ADCFGCLONE on single, multi and RAC to RAC cloning.
• Created users and assigned the responsibilities to them. Enabled Multi-Org after interacting with functional team members
• Created new responsibilities and menus for multiple organizations
• Configured Concurrent managers and Apache web server for applications (EBS)
• Enabled Mobile Web Application (MWA) server through telnet
• Created Cronjobs for database alerts
• Installed printers and registered them with Oracle Applications
• Supported Oracle APPS 11i with 11gR2 for day to day activities
• Troubleshooting day to day user problems in oracle apps with functional and DBA perspective.
• Implemented level0, 1 and incremental backup strategy’s using RMAN.
• Placed Cronjobs for backups and for clearing up all logs and a dump files on daily scale.
• Administrating and responding to Oracle Tar’s
• Manage and executing daily DBA tasks for offshore installation, administration and maintenance of 11gR2 (11.2.0.4) RAC Database with 11i/12i (EBS) in a multi-tier architecture
• Health checkup of oracle application instances (Vision, Test, Development and Production)
• Checking Alert log, Apache log, and concurrent manager log files daily
• Supporting of various modules include AP, AR, GL, INV, I Store, WMS, PO, OM, Telesales, BOM etc.
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc.
• Cloning TEST, QA and DEV instance’s monthly once for resolving PROD issues and applying patches
• Administration and maintenance of Oracle Apps 11i(EBS) (11.5.10 ATG RUP4) with 11gR2 RAC
• Used AWR, TKPROF and ADDM for resolving performance issues
• Installed new languages and products for rollover to other countries
• Worked with Rapid Install, Data installer, AD Patch, AD admin, AD relink, AD splicer, Adctrl utilities for oracle applications (EBS) for maintenance
• Configured OEM on RAC 10g/11g database
• Designed Online/Off-line Backup and recovery strategy using RMAN. Upgraded Discoverer 4i to 10g. Implemented Shared Appltop.
• Created users and assigned the responsibilities to them. Enabled Multi-Org
• Extensively worked on Oracle Financial s (AP, AR, and GL)
• Developed scripts to Monitor Table space issues
• Applied Critical patches, one-off, Family pack patches on DEV, TEST and PROD, used OPATCH for applying database patches
• Health check and troubleshooting

ENVIRONMENT: Exadata, Oracle E-Business Suite R12/11i, Oracle 12c/11g, SQL, PL/SQL, SQL Developer, TOAD, UNIX shell scripting, RHEL, OEM 12c, Solix, Sabrix, Solar Winds, Oracle 10g Application Server, OEM 10g/11g Grid Control, OAM, Oracle Database 9i /10gR2/11gR2, ASM, Data guard, RMAN,, SRVCTL,, OCRCHECK, OCRDUMP, CRSCTL, Solar Winds, MWA.

Confidential, Hebron, KY

Oracle EBS Database Administrator

Responsibilities:

• Interacted with the Client/offshore to plan the installation.
• Installed 11gR2 Clusterware and ASM to upgrade from 10gR2 to 11gR2.
• Cloned/Upgraded 11gR2 RAC and ASM with 10gR2 data using data pump’s and went live on new hard ware
• Installed and configured RAC setup for 11i (EBS) on 11gR2 RAC and ASM.
• Applied patches on RAC databases and Clusterware.
• Configured PCP(parallel concurrent processing ) in Multinode RAC environments
• Applied Developer Patch sets.
• Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using ADCONE utility and ADCFGCLONE on single, multi and RAC to RAC cloning.
• Created users and assigned the responsibilities to them. Enabled Multi-Org after interacting with functional team members
• Created new responsibilities and menus for multiple organizations
• Configured Concurrent managers and Apache web server for applications (EBS)
• Enabled Mobile Web Application (MWA) server through telnet
• Created Cronjobs for database alerts
• Installed printers and registered them with Oracle Applications
• Supported Oracle APPS 11i with 11gR2 for day to day activities
• Troubleshooting day to days user problems in oracle apps with functional and DBA perspective.
• Implemented level0, 1 and incremental backup strategy’s using RMAN.
• Placed Cronjobs for backups and for clearing up all logs and a dump files on daily scale.
• Administrating and responding to Oracle Tar’s
• Manage and executing daily DBA tasks for offshore installation, administration and maintenance of 11gR2 (11.2.0.1) RAC Database with 11i/12i (EBS) in a multi-tier architecture
• Health checkup of oracle application instances (Vision, Test, Development and Production)
• Checking Alert log, Apache log, and concurrent manager log files daily
• Supporting of various modules include AP, AR, GL, INV, I Store, WMS, PO, OM, Telesales, BOM etc
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc
• Cloning TST and DEV instance monthly once for resolving PROD issues and applying patches
• Administration and maintenance of Oracle Apps 11i(EBS) (11.5.10 ATG RUP4) with 11gR2 RAC
• Used AWR,TKPROF and ADDM for resolving performance issues
• Installed new languages and products for rollover to other countries
• Worked with Rapid Install, Data installer, AD Patch, AD admin, AD relink, AD splicer, Adctrl utilities for oracle applications (EBS) for maintenance
• Configured OEM on RAC 10g/11g database
• Designed Online/Off-line Backup and recovery strategy using RMAN. Upgraded Discoverer 4i to 10g. Implemented Shared Appltop.
• Created users and assigned the responsibilities to them. Enabled Multi-Org
• Extensively worked on Oracle Financial s (AP, AR, and GL)
• Developed scripts to Monitor Table space issues
• Applied Critical patches, one-off, Family pack patches on DEV, TEST and PROD, used OPATCH for applying database patches
• Health check and troubleshooting
• Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, Database and Application
• Created users and assigned the responsibilities to them. Enabled Multi-Org
• Applied Critical patches, one-off, Family pack patches on PROD,DEV and TST on both DB and APPS environment
• Applied NLS Patches, Globalization Patches, I-Payment Patches for Rolling out US Organization to Canada
• Enabled MWA server through telnet. Installed Oracle Application server 10g
• Administrating and responding to Oracle Tar’s
• Health check and troubleshooting

Environment: Oracle Database 11g/10g/9i, Oracle E-Business Suite R12/11i, Oracle 10g Application Server, OEM 10g/11g Grid Control, OAM, Oracle Database 9i /10gR2/11gR2, ASM, Dataguard, RMAN,, SRVCTL,, OCRCHECK, OCRDUMP, CRSCTL,, SQL*Plus, PL/SQL and its associated tools, OEL 5.

Confidential, NJ

Oracle EBS Database Administrator

Responsibilities:

• Responsible for maintenance of various developments, test and 10gR2 upgrade instances.
• Responsible for supporting production environment and production path development environments.
• Responsible for maintenance of 11.5.10(EBS) upgrade assessment instances.
• Installed and configured RAC setup for 11i(EBS)
• Configured PCP(parallel concurrent processing ) in Multinode RAC environments
• Support development team for 10g and 11i (EBS) upgrades.
• Manage and executing daily DBA tasks for offshore installation, administration and maintenance of 10gR2 (10.2.0.3) RAC Database with 11i/12i (EBS) in a multi-tier architecture
• Administration and maintenance of Oracle Apps 11i(EBS) (11.5.10 ATG RUP4) with 10gR2 RAC
• Migration of single instance 9i and 10gR2 database to 10gR2 RAC (10.2.0.3) with/without ASM
• Maintenance of two nodes RAC 10gR2 (10.2.0.3) with 10gR2 streams
• Cloning of RAC PROD instance to TEST and DEV (involves cloning CRS, ASM, database and applications) using ADCONE utility and ADCFGCLONE on single, multi and RAC to RAC cloning.
• Configured Concurrent managers and Apache web server for applications (EBS)
• Used AWR,TKPROF and ADDM for resolving performance issues
• Installed new languages and products for rollover to other countries
• Worked with Rapid Install, Data installer, AD Patch, AD admin, AD relink, AD splicer, Adctrl utilities for oracle applications (EBS) for maintenance
• Upgraded CRS from 10.2.0.2 to 10.2.0.3. Configured OEM on RAC 10g database
• Designed Online/Off-line Backup and recovery strategy using RMAN. Upgraded Discoverer 4i to 10g. Implemented Shared Appltop.
• Created users and assigned the responsibilities to them. Enabled Multi-Org
• Extensively worked on Oracle Financial s (AP, AR, and GL)
• Developed scripts to Monitor Table space issues
• Applied Critical patches, one-off, Family pack patches on DEV, TEST and PROD, used OPATCH for applying database patches
• Enabled MWA server through telnet. Installed Oracle Application server 10g
• Administrating and responding to Oracle Tar’s
• Health check and troubleshooting

Environment: OracleDatabase11g/10g/9i, OracleApps11i (EBS), OEM 10g Grid Control, Oracle Database9i/10gR2/11gR2, ASM, RMAN, SRVCTL, CLUVFY, OCRDUMP, CRSCTL, SQL*Plus, PL/SQL and its associated tools, Shell, Perl, OEL 5

Confidential

Jr. Oracle EBS Database Administrator

Responsibilities:

• Interacted with the Client to plan the installation. Installed 11.5.10.2 Oracle Applications on single node and multi node.
• Created users and assigned the responsibilities to them. Enabled Multi-Org after interacting with functional team members
• Created new responsibilities and menus for multiple organizations
• Applied patches
• Enabled Mobile Web Application (MWA) server through telnet
• Created Cronjobs for database alerts
• Health checkup of oracle application instances (Vision, Test, Development and Production)
• Checking Alert log, Apache log, and concurrent manager log files daily
• Checking and compiling invalid objects, clearing cache and bouncing the Apache
• Administrating and responding to Oracle Tar’s
• Performing system administration and AOL
• Trouble shooting various issues during day-to-day activities
• Administering and maintaining 3 databases (Production, Test and Development)
• Supporting of various modules include AP, AR, GL, INV, I Store, WMS, PO, OM, Telesales, BOM, WIP etc
• Installed printers and registered them with Oracle Applications
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc
• Performing Applications System Administration tasks like Registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, Creating APPS Users etc

Environment: - Oracle Database 8i & 9i, Oracle Apps 11i, SQL*Plus, iSQL*PLUS, PL/SQL & its associated tools, Oracle Forms 6i and Reports 6i, Oracle Apps 11i AD Tools, Oracle 9i Dataguard, Oracle 9i/10gR1 RAC, RMAN, Red Hat Linux4 AS 21, SCO UNIX, WinXP, WinNT, TCP/IP, UDP, HTTP/HTTPS