SUMMARY

• Having 10+ years of experience in IT Industry as an Oracle Apps DBA with FMW, Core DBA in Administration, Maintenance and support& its upgrade both Applications and Databases. Extensive experience as an ORACLE Applications DBA in a variety of different environments like AIX, SUN SOLARIS, Linux,
• Architecture, Installing, monitoring and maintaining (Single Node and Multi Node) Oracle Applications (E - Business Suite Version 11i & R12, R12.2).
• Experienced in cloning Production environment to Test and Development environments.
• Hands on experience with AD Utilities: Adadmin, Adpatch, Adconfig, Adctrl, Adsplice & Adrelink.
• Monitoring and Troubleshooting of Apache, Forms, Conc. Manager and Database related issues.
• Application of Patches using AD patch and consequently troubleshooting the errors during patching.
• Tracking Invalid Objects, Compiling and Validation them from Ad-admin tool.
• Good experience in database patching and application patching and its trouble shooting.
• Good experience in database and application cloning and its trouble shooting.
• Export and Import of Database, DB link creation. Expertise in handling Many Oracle Applications Databases with sizes varying from 300 GB to 12 TB. Providing application support and backend database support. Experienced in Oracle Apps Administration and Sysadmin tasks
• Has done manual & automatic database up gradation from 9.2.0.6 to 10.2.0.1, 10. .2.0.3 and from 10. .2.0.3.
• Migrated databases using GG and RMAN for 2 node RAC.
• Resolved replication issues in Golden gate.
• Installed Golden Gate software in Test and dev instances.
• Configured Golden gate on production servers.
• Upgraded Oracle golden gate v10 to v11.
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Performed Data Guard and Golden Gate installation/configuration/support for production/STG/Development databases.
• Implemented replication site for Oracle migration project using Golden Gate.
• Implemented the end to end Oracle cloud migration from Dev to Production (PAS).
• Upgraded Golden Gate to new version and migrated Golden Gate (in Classic Mode) processes from standalone Golden Gate Sever to Oracle database server to allow Transparent Data Encryption configured.
• Setup classic capture replication mechanism using golden gate.
• Configured Golden Gate to achieve unidirectional and bidirectional replication.
• Performed Installation, configuration of multiple versions of Mongo DB (2.x, 3.0.x, 3.2.x).
• Used various Mongo DB utilities (mongostat, mongotop, mongoperf, etc) to monitor database.
• Monitored and tuned user-developed JavaScript using explain plan.
• As part of the Upgrade team involved in Upgrading from 12.1.3 to 12.2.4.
• Having the hands on experience with 11g OEM and knowledge on 12c OEM.
• Monitoring Alert Log for errors. Running tkprof, Stats-pack & AWR reports.
• Experienced in creating user, setting up proper privileges for a user.
• Installed weblog and created domain for web center content imaging.
• Experience in setting the permissions and changing the ownerships.
• Appling the OS patches with co-ordinating with Unix Teams and Patches CPU,PSU for Linux R12, 11i
• Set up, testing and implementation of backup/recovery strategies using Oracles Recovery Manager (RMAN).
• Implementation of High Availability solutions with Oracle 10g&11g RAC, Physical Standby Databases (Data Guard). Thorough Experience with supporting the Production Database with Complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard.
• Implemented the fresh R12.2 installation.
• Experience in patching and upgrade in RAC by applying patch set.
• System Administration of Oracle Application using Application Object Library and System administration module, using listed tasks: Registering New Application, Registering New schema, Registering Customized Tables using Application Standards, Creating new customized responsibilities, Menus, Request group, Functions, Concurrent programs. Administering Concurrent Processes and Managers and Automating the Requests.
• Supporting the Kinata applications for code migrations.
• Creating Database links. Export/Import of schemas and tables from production to test.
• Experience in supporting Oracle Application modules like Oracle Financials - Financials Accounting Hub(Subledger Accounting),AP, AR, GL, FA, FCG, CM, HRMS, LM, SCM, Iprocurement, Iexpense
• Migrated the databases from non ASM to ASM.
• Follow up with Oracle Support (Metalink) SR and resolving the issues.

TECHNICAL SKILLS

Operating Systems: RHEL, OEL, AIX,Solaris,Windows 9x/2000, NT

Languages: SQL.

ERP: OracleApplications11i(11.5.10.2),ReleaseR12 (12.2.5,12.1.3,12.1.1,12.0.6)

Database Server: Oracle Database Server 9i,10g and 11g

Utilities and Tools: SQL*Plus, Import/Export, RMAN, OAM, Adadmin, Adpatch and other Ad utilities, Sql Developer,TOAD, VERITAS Net Backup, RMAN, Toad, PPM Service tool,tkprof,statspack,Discover, cronjob (Unix),OEM 10g&11g,Jira, Confluence Specialization:Oracle Application 11i, Release R12,R12.2 DBA, Oracle 9i DBA, Oracle 10g, 11g DBA, 12C, RAC, ASM.

PROFESSIONAL EXPERIENCE

Confidential, Shelton, CT

Oracle Apps DBA

Responsibilities:

• Worked on EBS R12.1.3/R12.2 environments. Provisioning of R12.2 environments and apply latest patches using ADOP utility on environments as suggested by development and Quality people.
• Performed cloning of Production instance to test, Development envronments.
• Performing Daily checks for Database and Apps servers.
• Checking the Status of Application Listener, ICM, Forms & Report server, Apache server.
• Applying patches for Database and Apps servers
• Day to Day database maintenance tasks like checking the alert logs, analyzing tablespace mgt. and purging trace files and clearing udump,cdump,bdump directory.
• Installing of Oracle Applications using rapidwiz.
• Securing Oracle Application by periodically changing apps and schems passwords using FNDCPASS.
• Cloning and maintaining of application server and Data base.
• Worked with various Oracle Applications Utilities such AD Administration, AD Controller, Auto config AD patch, AD ctrl etc.
• Maintaining the development, test instances and Production with cooperation of onsite team.
• Data migration between environment using export / import utility.
• Performing the Code migrations useing Kintana and Manual migrations.
• Implemented 12.2.2 application on Dev& UAT servers
• Maintaining, Monitoring and Administering for Oracle applications environments of both standalone on RAC architecture.
• Compiling forms / pll's, DB invalids objects, creating the DB links, user creation and termination.
• Space Fragmentation monitoring and reorganizing table and rebuilding indexes, tablespace usage monitoring.
• Raising, updating and monitoring the differnet SR related activites using metalink.
• Patchset application to move the database from 10. .2.0.4 and 11. .2.0.4
• Performed database adminstration activities including tablespace re-organization, user management.
• Granting roles and privileges to users.
• Installed the weblogic, SOA and created the Domain for web center content imaging.
• Providing the Administrative support on SSO, OID and SOA migration.
• Installed the discover 10g and integrated with EBS 12.1.3.
• Upgrade the ERP from 12.1.3 to 12.2.4.
• Providing the Administrative support on 12.2 ERP.
• Having the hands on experience with 11g OEM and knowledge on 12c OEM.
• Monitoring DB growth, Creating tablespaces, Adding, Resizing, Renaming and Relocating Datafiles.
• Backup, Restore, Recovery and DB cloning using RMAN.
• Implemented Weekly Cold and Hot backup strategies.
• Used tools like Statspack, tkporf, explain plan to resolve the performance issues.
• Migrated databases using GG and RMAN for 2 node RAC.
• Resolved replication issues in Golden gate.
• Installed Golden Gate software in Test and dev instances.
• Configured Golden gate on production servers.
• Upgraded Oracle golden gate v10 to v11.
• Setup classic capture replication mechanism using golden gate.
• Replication and Extracting data and applying on production using Golden Gate.
• Performed Data Guard and Golden Gate installation/configuration/support for production/STG/Development databases.
• Implemented replication site for Oracle migration project using Golden Gate.
• Upgraded Golden Gate to new version and migrated Golden Gate (in Classic Mode) processes from standalone Golden Gate Sever to Oracle database server to allow Transparent Data Encryption configured.
• Clone the instances using Rapid Cloning for R12.
• Set up Printers and Workflow mailer in Oracle Applications R12.1.3 & 12.2 Prod, UAT, QA, DEV Environments.
• Maintain and administer RAC 3 node databases of portal and webceneter imaging and oltp databases.
• Applying latest CPU, PSU patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
• Involved in 12c upgrade for core databases.
• Cloning R12.2 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Worked closely with Functional/Developers and helping them in fixing issues.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
• Raising the Service Request and working with Oracle Team.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Applied Patches in different modules for fixing the bugs and smooth running of applications
• Checking the status of important services like concurrent manager, form server, web server, application listener and database listener.
• Monitoring the long running requests and monitoring the locks.
• System administration tasks like create users, assigning responsibilities.
• Working on 24x7 Support with offshore model.

Confidential, Redwood city, CA

Oracle Apps DBA

Responsibilities:

• Worked on EBS R12.1.3/R12.2 environments. Provisioning of R12.2 environments and apply latest patches using ADOP utility on environments as suggested by development and Quality people.
• Having Full knowledge on R12.2 environment architecture and adop (R12.2 patching utility) online patching. Integration Weblogic server with application services.
• Worked and resolved Forms performance issues.
• Creation of Custom Applications, menus and responsibilities.
• Maintenance of Oracle Databases and Oracle Applications.
• Working on System Administrator Activities.
• Installation of Oracle Database and Oracle Applications.
• Responsible for supporting multiple instances, activities include installation, maintenance and upgrade of Oracle E-business Suite.
• Supported cross-product support across entire EBiz suite and solved database/middle-tier issues with the development and release of Application products.
• Install, configure and troubleshoot all components of Oracle Applications techstack and maintained multiple Oracle databases.
• Implemented 11g RAC for non EBS databases.
• Migrated databases using GG and RMAN for 2 node RAC.
• Resolved replication issues in Golden gate.
• Installed Golden Gate software in Test and dev instances.
• Configured Golden gate on production servers.
• Upgraded Oracle golden gate v10 to v11.
• Setup classic capture replication mechanism using golden gate.
• Replication and Extracting data and applying on production using Golden Gate.
• Performed dataguard and golden gate Installation/configuration/support for production/STG/development databases.
• Implemented replication site for Oracle migration project using Golden Gate.
• Upgraded Golden Gate to new version and migrated Golden Gate (in Classic Mode) processes from standalone Golden Gate Sever to Oracle database server to allow Transparent Data Encryption configured.
• Perform day-to-day database administration and ensure integrity, security and availability of applications environments.
• Create, maintain and provide support to Oracle Cluster databases
• Conduct training and mentor new hires on the core environment management platform.
• Upgraded EBS Database to 11g (11.2.0.3) RAC in both TEST and PRODUCTION environment.
• Worked closely with technical, functional teams and Oracle Support to troubleshoot and resolve issues during upgrade.
• Maintaining and patching Shared APPL TOP
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Configured RMAN backups.
• RMAN used in scheduled recovery, hot and cold backup of Oracle11G database.
• Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.

Environment: Oracle Applications R12, R12.2 & 11.5.10.2, ASM, Oracle 11.2.0.4, Multi node AIX 6.1&linux 5.6 of ASM, RAC, OEM &12c

Confidential, Tampa, FL

Oracle Apps DBA

Responsibilities:

• Providing Support to R12 and 11.5.10.2 Application users through ticketing system.
• Providing end to end support for all the instances of Oracle Apps 11.5.10.2 at Cummins
• Migration of Forms/Reports/procedures/queries of developers for production migration
• Worked on 9i, 10g, 11g databases & 11i applications.
• Maintaining, Monitoring and Administering for 11ii Instances
• Performed Multi Node installation of Oracle EBS 11.5.10.2
• Cloning the Oracle Applications 11i environment from Production to UAT, QA, DEV boxes.
• Support & Administration of Oracle 11i,R12 Applications
• Cloning of Oracle 11.5.10 and R12 instance.
• Set up Printers and Workflow mailer setup in Oracle Applications 11i Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in fixing issues
• Raising the Service Request and working with Oracle Team.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications 11i environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another, compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for 11i applications.
• Installed the Oracle 10g databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Approving code approval through TKprof of Database for the Developers
• Configuring Printers, creating db links, creating updating SR’s, checking locks on the system
• Provided 24*7 and On Call support in Oracle Databases and Oracle Applications (11i).
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)

Environment: Oracle Applications 11.5.10.2, R12 DB 10.2.0.4 and 11g Linux and Solaris.

Confidential

Core DBA and Oracle Apps DBA

Responsibilities:

• Interaction with the customers to understand their requirements and their technical queries as the part of maintenance activities.
• Checking the status of important services like concurrent manager, forms server, web server, application listener and listener up.
• Providing Support to 11.5.10.2 Application users through ticketing system.
• Providing end to end support for all the instances of Oracle Apps 11.5.10.2 at Cummins
• Migration of Forms/Reports/procedures/queries of developers for production migration
• Worked on 9i, 10g, 11g databases & 11i applications.
• Maintaining, Monitoring and Administering for 11ii Instances
• Performed Multi Node installation of Oracle EBS 11.5.10.2
• Cloning the Oracle Applications 11i environment from Production to UAT, QA, DEV boxes.
• Support & Administration of Oracle 11i,R12 Applications
• Cloning of Oracle 11.5.10.2 and R12 instance.
• Set up Printers and Workflow mailer setup in Oracle Applications 11i Prod, UAT,QA,DEV Environments
• Working closely with Functional/Developers and helping them in fixing issues
• Raising the Service Request and working with Oracle Team.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Applied Patches for Developers Bug fixes and Scheduling Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications 11i environment as per Client Standards.
• Migrated the Oracle forms and reports from One sever to another, compiled them through f60gen in Oracle Applications Environment.
• Oracle Applications Concurrent Manager Administration & tuning for 11i applications.
• Installed the Oracle 10g databases and Created Tablespaces.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Approving code approval through TKprof of Database for the Developers
• Configuring Printers, creating db links, creating updating SR’s, checking locks on the system
• Provided 24*7 and On Call support in Oracle Databases and Oracle Applications (11i).
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Created a number of databases instances for development, testing and production.
• Creation of Database Users and Registering in Oracle Applications.
• Regular database activities - monitoring the log files, creating the custom schemas and maintaining the Archive logs.
• Tracking the invalid objects, compiling and validating the invalid objects.
• Applying Application patches using AD utility - AD patch.
• Applying RDBMS patches using Opatch utility.
• Performed logical backups using exp and expdp utility.
• Performed backup and recovery operations using RMAN.

Environment: ORACLE 10g, ASM, Applications 11.5.10.2,R12, Linux 5.x,6.x, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, RAC.