PROFESSIONAL SUMMARY:

• I am currently working with Confidential as a Sr. Associate, having 7 Years and 8 months of experience as an Oracle Apps DBA, Oracle DBA and WebLogic Administrator.
• Experienced in handling Production and Non - Production Databases.
• Have worked for multiple clients managing their Oracle EBS Application and Databases.
• I have been involved with multiple upgrade projects and platform migration projects. I have excellent analytical, interpersonal, communicational and organizational skills aimed at achieving project milestones.
• My role as an Application & Database Administrator is to install and upgrade oracle applications and database along with third party applications.
• 7 years and 5 months experienced and proficient in technologies like EBS R12, EBS 11i, RDBMS 10g/11g, RAC, ASM, RMAN, Database and Application Installation, Upgrades and Enterprise Manager (EM) Grid Control 11g, Cloud Control 12C EM.
• 2 Year experienced with Oracle 12c Database.
• Experienced with WebLogic Installation and Administration, Middleware installation and support like OBIEE, SOA, OTM.
• Have exposure in a variety of environments like Windows XP, HP-UX Itanium, HP-UX PARISC, Red-hat Enterprise Linux
• Successfully implemented migration of Databases and Applications across data centres.
• Performed instance migration across platforms and DB upgrade from 10.2 to 11gR2
• Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.
• Proficient in applying Oracle Application patches, Database patches, Upgrades, Apps cloning and Oracle Apps SYSADMIN functionalities.
• Proactive Monitoring to identify areas that needs to be modified to improve performance in the application and database using OEM 11g/12C Monitoring.
• Performed database and application cloning from production to development environment and resolved various issue encountered during cloning.
• Experienced inOracle E-Business Suiteimplementations and Upgrades from CRP, Development and UAT to production as an Oracle Applications DBA.
• Involved in installation of R12 E-Business suite and upgrading to R12.1.3.
• Involved in upgrading of 11.5.10.2 to R12.0.3 oracle instance.
• Performed instance build for Oracle Database in RAC.
• Experience in setting up HTTP Load balancing and implementing Shared APPL TOP and PCP.
• Expertise in troubleshooting Workflow and Notification Issues.
• Successfully implemented Oracle 10g, 11g Data Guard on HP-UX and Linux environment.
• Experienced with data pump, export and import utilities in backup and recovery of database.
• Expertise in implementing OATM.
• Involved in Daily monitoring of mission critical Production and Development System, which includes application, as well as database monitoring.
• Managed multiple production databases on 10g and 11g.
• Writing shell script for automation of DB RMAN backup and cloning of Oracle Databases and Applications.
• Tuning the databases for optimal performance and monitoring CPU performance.
• 5 years Experienced working with Oracle Exadata
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
• 24x7 DBA support for multiple production, test, and development environments.
• Ability to build professional relationships and capable of multi-tasking for various projects and prioritizing the work.
• Mentoring the junior team members and making them well equipped about the processes followed and technologies involved.

SOFTWARE’S AND TECHNOLOGIES:

• Oracle Database 10g, 11g, 12c.
• Oracle RAC Custer.
• Oracle EXADATA
• Oracle SQL Tunning
• RMAN (Database Recovery Manager Utility).
• Oracle Datagaurd
• Oracle Golden Gate
• Oracle EBS 11i & R12.
• AD Utilities (ADADMIN, ADPATCH, ADMRGPCH, ADCTRL, ADIDENT)
• Oracle WebLogic.
• SOA 11g
• Repository Creation Utility (RCU).
• Oracle Enterprise Manager 12C
• OBIEE Administration
• Apache Tomcat.
• Oracle Discoverer.
• BMC Remedy Tool.
• HP-Quality Center.
• HP-Kintana (Code deployment tool).
• HUDSON (Code deployment tool).
• SVN (Code repository tool).

SKILLS:

Databases: Oracle 11g/10g/12c

Languages: SQL and PL/SQL

Application Servers: Oracle Application Server (10g & 11g), Apache, WebLogic

Applications: EBS 11i/R12, OEM 11g, 12c

High Availability: (RAC) Cluster ware 11g and 10g

Operating Systems: HP-UX Itanium, HP-UX PARISC, Red-hat Enterprise Linux, Windows XP

Tools: SQL*Plus, SQL*Loader, Export & Import utility (regular and data pump), OEM, ASMCMD, FNDLOAD, DBUA, DBCA, SQL trace, tkprof, RMAN, TSM TDPO, BMC Remedy, SVN, Hudson, Import/Export, TOAD,SQL Developer, SQL*Loader, OEM, Putty, WinSCP, Kintana, Control M

Programming Languages: SQL, PL/SQL, UNIX Shell Scripts

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

OracleApplications Database Administrator, Oracle DBA, OBIEE Admin

Responsibilities:

• Patching coordinator for all Critical patch update and application patch
• Regular Support for all production and non-production environment
• Point out the key risk and enhancement for betterment of infrastructure.
• Working on internal project and support them as database administrator.
• Planning and administering backup and recovery strategies.
• Maintained and provided PROD support for EBS Application and Database.
• Performing SYSADMIN activities like user maintenance and setting up profiles.
• Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.
• Providing DBA support during month end activities.
• Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.
• Maintaining Databases including backups, restores, recoveries, imports, exports.
• Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Perform weekly cloning activities of non-prod instances, both application and database.
• Responding to different types of alerts automation using oracle alerts.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• OBIEE Administration and support.

Environment: EBS R12, RDBMS 11g/10g, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA Oracle Linux, SQL*Plus, WebLogic, SOA Admin, SABRIX,CONTROL-M, ODI

Confidential, Charlotte, NC

OracleApplications Database Administrator, Oracle DBA

Responsibilities:

• Oracle Application Day to day Support of EBS 12.1.3 and 11.2.0.5
• Alert and Production EBS application and database Monitoring and take required action to prevent high risk production issue.
• Worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Planning and administering backup and recovery strategies.
• Involved in the Database design and deciding the requirements for migrating Database to new servers.
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Involved in Oracle Applications Tablespace Management (OATM) as part of the upgrade.
• Migrating databases from PA-RISC environment to HP-UX Itanium.
• Performed the installation of oracle 10g RAC database and have good knowledge in basic concepts of RAC.
• Installed and configured GRID and ASM as part of the migration.
• Performed the conversion of Non-ASM instance to ASM instance.
• Converting Database to 2-Node RAC.
• Maintained and provided PROD support for EBS 11i Application and Database.
• Performing SYSADMIN activities like user maintenance and setting up profiles.
• Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.
• Providing DBA support during month end activities.
• Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.
• Maintaining Databases including backups, restores, recoveries, imports, exports.
• Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Applying patches in EBS 11i and R12 application.
• Perform weekly cloning activities of non-prod instances, both application and database.
• Responding to different types of alerts automation using oracle alerts.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Provided application support to users and created a log of all the problems with solutions for future reference.

Environment: EBS R12, RDBMS 11g/10g, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA Oracle Linux, SQL*Plus, WebLogic, SOA Admin, crontab.

Confidential, New Kensington, PA

OracleApplications Database Administrator, Oracle DBA, WebLogic Administrator, System Administrator

Responsibilities:

• Performed SYSADMIN activities like enabling and disabling traces, user creation, assigning menus, responsibilities to users as per requests, workflow navigator and maintained concurrent managers.
• Maintenance included relinking applications objects and regenerating forms and reports using all AD utilities Autoconfig, adctrl, adadmin, adpatch etc. Also worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Apart from the above-mentioned tasks, daily monitoring is carried out before start of business to ensure database availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, concurrent managers are running, Unix error messages, disk space availability, checking for alert logs and trace files, checking for invalid objects etc.
• Worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Planning and administering backup and recovery strategies.
• Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
• Validating & Creating grants & synonyms on Apps schema, Performed jar file/forms generation as a post patch step, relinking the Oracle apps programs.
• Setting up scripts in CRON to purge concurrent manager log and out files, database trace files periodically.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Maintained and provided PROD support for EBS 11i Application and Database.
• Performing SYSADMIN activities like user maintenance and setting up profiles.
• Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.
• Providing DBA support during month end activities.
• Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.
• Maintaining Databases including backups, restores, recoveries, imports, exports.
• Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Applying patches in EBS 11i application.
• Perform weekly cloning activities of non-prod instances, both application and database.
• Responding to different types of alerts automation using oracle alerts.
• Configured Workflow Notification Mailer for inbound and outbound processing.

Environment: EBS R12, RDBMS 11g/10g, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA, Oracle Linux, SQL*Plus, WebLogic, SOA Admin, crontab.

Confidential, Milwaukee, WI .

OracleApplications Database Administrator, Oracle DBA, WebLogic Administrator, System Administrator

Responsibilities:

• Supported 100+ databases ranging in size between 30GB to 7TB.
• Installed and configuredRACand Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.
• Performed health checks in RAC instances usingCRSCTL andSRVCTLutility.
• Performed Database refresh from Production RAC environment to TEST RAC environment.
• Experience in monitoring and managing of Oracle instances usingEnterprise Manager Grid Control(OEM grid) 10g /11g/12c.
• Starting and stopping the agents to clear metric alerts and collectingADDMreports in OEM.
• Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
• Involved in Tuning the RAC interconnect Finding RAC wait events. In addition, tuning the RAC using theEnterprise Manager Grid Control.
• Performed various tasks onASM, creating a disk group, adding a disk, making disk online and offline and troubleshooting issues in ASM environment.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
• Generated and automatedStats pack/AWRreports from Oracle 11g/10g database and analyzed the reports for Oracle wait events, time-consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying the join methods (Nested/Hash/Merge join/Sort merge join) between the row sources for tables, to improve the performance of SQL statements.
• Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.
• Planned and Implemented Disaster Recovery (DR), Standby databases with High Availability usingRAC, andData Guard.

Environment: Oracle 11gR1, 11gR2, 11.2.0.3, 12c RHEL 5.8, HP-Unix 11.23, Solaris 10, OEM, DBUA, RMAN, Oracle Enterprise Manager Grid Control, RAC, ASM, Data guard, SQL*LOADER, AWR, Data pumps, Exports/Imports.

Confidential, Pittsburgh, PA

Oracle Apps Admin/DBA, WebLogic Administrator

Responsibilities:

• Performed SYSADMIN activities like enabling and disabling traces, user creation, assigning menus, responsibilities to users as per requests, workflow navigator and maintained concurrent managers.
• Maintenance included relinking applications objects and regenerating forms and reports using all AD utilities Autoconfig, adctrl, adadmin, adpatch etc. Also worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Apart from the above-mentioned tasks, daily monitoring is carried out before start of business to ensure database availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, concurrent managers are running, Unix error messages, disk space availability, checking for alert logs and trace files, checking for invalid objects etc.
• Worked with various Oracle Applications Utilities like Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
• Planning and administering backup and recovery strategies.
• Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
• Validating & Creating grants & synonyms on Apps schema, Performed jar file/forms generation as a post patch step, relinking the Oracle apps programs.
• Setting up scripts in CRON to purge concurrent manager log and out files, database trace files periodically.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Maintained and provided PROD support for EBS 11i Application and Database.
• Performing SYSADMIN activities like user maintenance and setting up profiles.
• Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.
• Providing DBA support during month end activities.
• Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.
• Maintaining Databases including backups, restores, recoveries, imports, exports.
• Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Applying patches in EBS 11i application.
• Perform weekly cloning activities of non-prod instances, both application and database.
• Responding to different types of alerts automation using oracle alerts.
• Configured Workflow Notification Mailer for inbound and outbound processing.

Environment: EBS R12, RDBMS 11g/10g, Red Hat Linux, RHEL 5.2, OEM, RAC, ASM, HP Kintana, EXADATA, Oracle Linux, SQL*Plus, WebLogic, SOA Admin, crontab.

Confidential, Milwaukee, WI

Oracle Apps DBA, Oracle DBA

Responsibilities:

• Involved in the Database design and deciding the requirements for migrating Database to new servers.
• Successfully upgraded Database from 10.2.0.3 to 10.2.0.5.
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Involved in Oracle Applications Tablespace Management (OATM) as part of the upgrade.
• Migrating databases from PA-RISC environment to HP-UX Itanium.
• Performed the installation of oracle 10g RAC database and have good knowledge in basic concepts of RAC.
• Installed and configured GRID and ASM as part of the migration.
• Performed the conversion of Non-ASM instance to ASM instance.
• Converting Database to 2-Node RAC.
• Migrating the database to VMAX file system.
• Maintained and provided PROD support for EBS 11i Application and Database.
• Performing SYSADMIN activities like user maintenance and setting up profiles.
• Monitoring of Concurrent Managers and troubleshooting long-running concurrent programs.
• Providing DBA support during month end activities.
• Automation of DBA monitoring activities like purging older archive logs, concurrent manager log/out files, Gather schema statistics.
• Maintaining Databases including backups, restores, recoveries, imports, exports.
• Set up and administer tablespaces, data files, tables, indexes, views, sequences, synonyms and DB links.
• Good Experience on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Applying patches in EBS 11i application.
• Perform weekly cloning activities of non-prod instances, both application and database.
• Responding to different types of alerts automation using oracle alerts.
• Configured Workflow Notification Mailer for inbound and outbound processing
• Provided application support to users and created a log of all the problems with solutions for future reference.

Environment: EBS 11i, RDBMS 11g/10g, HPUX PA-RISC, RHEL 5.2, OEM, RAC, ASM, BMC Remedy

Confidential

Oracle Apps DBA, Oracle DBA

Responsibilities:

• Proactive monitoring of databases for table space sizes, monitoring database growth, setting system and object privileges, user log-ins and passwords.
• Creating and maintaining users.
• Involved in alert monitoring, space management issues and user management.
• Clone application and database tiers after patches are applied. With inputs from the implementation team (functional/technical), evaluate and implement patches/packs on required instances.
• Cloning of oracle database using cold backup and hot backup.
• Involved in SYSADMIN responsibilities like creating users, assign responsibilities and maintaining concurrent managers.
• Creating Shell scripts for automation purposes.
• Administering the tablespaces for better space utilization.
• Performed logical backups using export/import, data pump.
• Performance tuning of the Oracle database by enabling traces, tkprof, oradebug.
• Trouble shooting issues caused by wait event, resolving locks etc.
• Maintenance and development of database objects like Tables, indexes, Stored Procedure, constraints, triggers, DB links, users, roles, profile and SQL NET and Listener. Configured and managed databases on UNIX environment.
• Performed Application and database cloning in both 11i and R12 and resolved issues faced during or post cloning.
• Exposure in applying maintenance and family patches in Oracle Apps 11i as well as R12 environment.

Environment: Oracle 10g PL/SQL,SQL*Loader, Shell scripting, PVCS, Kintana, Oracle Applications 11i/R12