SUMMARY:

• Total 8+ 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, HPUX
• Oracle Applications Release R12, 11i installation & Configuration Good problem - solving capabilities.
• Responsible for installation, upgrades, patches, TAR support, concurrent manager administration, Troubleshooting.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Provided technical assistance for development of physical and logical architecture models on all Oracle server platforms.
• Coordinated with project teams for designing and implementation of database infrastructure designs by documentation and system testing.
• Working knowledge of key Exadata features such as Smart Scan, HCC (High Columnar Compression), Smart Flash Cache and Storage Indexes.
• Configured OLTP databases on Oracle Exadata platform using Exadata database machine X4-2Half Rack.
• Considerably reduced the I/O performance migrating the databases from regular storage to Oracle Exadata thus utilizing some of its key features such as smart Scan and Storage Indexes.
• Fixed grid control alerts on the database and monitored the database using grid control including managing of templates.
• Suggested procedures for database performance and tuning of all database machines and related components.
• Created certified processes and procedures for maintenance and upgrading of all database machines.
• Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
• Duties included database creation, database tuning, Web Server, backup/recovery General, troubleshooting, script development& scheduling, and documentation.
• Installed and patched 12.2.2, 12.1.3, 12.1.1, 11.5.10.2 instances and Discoverer 10g,11g & portal Applications server 10g,OID,OAM.
• Installed WebLogic server (10.1.3.X) and its support.
• Configure and support Oracle Golden Gate, SharePlex, and Oracle Streams.
• Implemented high availability using Golden Gate Replication. Implanted bi-directional replication using Golden Gate.
• Worked on AD utilities like adpatch, adadmin, adctrl, adrelink, adsplice, admerge, adclone, adconfig
• Cloning R12, 11i databases using through oracle applications and rapid clone technique.
• Appling the OS patches with coordinating with Unix Teams and Patches CPU,PSU for Linux R12, 11i and Oracle Application patches and upgrade the Application databases from 9.2.0.4 to 9.2.0.5/10g/11g. Very strong in Auto Patch, Upgrade, cloning.
• Performed backups and tested crash recoveries using conventional Hot& Cold,RMAN&export and Import
• Expertise in installing, maintaining and administering Oracle Applications 11i (11.5.9, 11.5.10, R12) instances. Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Upgraded the RUP version from 3 to 7 in Oracle Applications 11.5.10.2. Upgraded the Oracle Applications from 11.5.8 to 11.5.10.2. Upgraded the database from 9.2.0.8 to 10g to 11g.
• 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
• DMZ implementation for clients with I supplier and isourcing module implementation
• Experience in supporting Oracle Application modules like Oracle Financials - Financials Accounting Hub(Sub ledger Accounting),AP, AR, GL, FA, FCG, CM, HRMS, I procurement, I expense
• Performed Sysadmin activities on Oracle Financials - Financials Accounting Hub (Sub ledger Accounting) module by creating module users, responsibilities, menus, submenus, request groups, profile options.
• Interacted with Oracle Financials - Financials Accounting Hub (Sub ledger Accounting) users and fixed the users issues on the technical side as well as on Oracle application side.
• Interacting with the developers of Oracle Financials - Financials Accounting Hub (Sub ledger Accounting) team fix the development issues related to the Financials Accounting Hub module and migrate the Codes from dev. to uat and Prod environments.
• Tune and applied patches on the Oracle Financials - Financials Accounting Hub (Sub ledger Accounting) module.
• Implementation of High Availability solutions with Oracle 10g&11g RAC, Physical Standby Databases (Data Guard), ASM, RMAN. 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.
• 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 NDM, Autosys jobs and Kinata applications for code migrations.
• Installation of OEM 10g 11g, 12c and its support.

TECHNICAL SKILLS

RDBMS: ORACLE 9i, Oracle 10g, Oracle 11g,Exadata,Golden gate, Oracle Streams, Quest Shareplex

ERP: Oracle Applications11i (11.5.8,.9,11.5.10.2),ReleaseR12 (12.2.2,12.1.3,12.1.1,12.0.6)

Modules: Sub ledger Accounting, AP, AR, GL, FA, INV, HRMS, SCM, I procurement, I expense

Languages: C, C++, SQL, PL/SQL (Basics)

OS: UNIX (Linux), AIX 5.3, 6.1, SUN Solaris 8.0, 9.0, HPUX & Flavors of Linux

Tools: SQL*PLUS, SQL Server 2005 Reporting Services, Toad, PPM Tool, SERVICE NOW, Tivoli, Remedy, RMAN, Tkprof, Stats pack, Forms and Reports6i, Discoverer, Cronjob (UNIX), Oracle Enterprise Manager 10g,11g&12c

Specialization: Oracle Application 11i, Release R12 DBA, Oracle 9i DBA, Oracle 10g, 11g DBA, 12C, RAC, ASM, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Providing Support to 12.1.3 Application users through ticketing system.
• Providing end to end support for all the instances of Oracle Apps R12&11.5.10.2
• Migration of Forms/Reports/procedures/queries of developers for production migration
• Worked on 9i, 10g, 11g databases & R12, 11i applications.
• Maintaining, Monitoring and Administering for R12&11ii Instances
• Performed Multi Node installation of Oracle EBSR12& 11.5.10.2
• Cloning the Oracle Applications 11i environment from Production to UAT, QA, DEV boxes.
• Installed and supported oracle application server (10gAS) for portal services.
• Worked and supported the application user SSO Issues.
• Worked and implemented OID, OAM for R12 applications.
• Worked as OEM admin to monitor and configure the application to monitor the jobs.
• Scheduling and monitoring the jobs by using OEM utility.
• Creating user in OID and sync with e-business suite and troubleshooting the issues with accelerate.
• 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 R12 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.

Environment: Oracle 10g/11gr1/11gr2 RAC, 11.2.0.3, 11.1.0.1, 10.2.0.5, SQL, IBM AIX, Unix, Red Hat Linux, Windows 2003, Data guard, Golden Gate 11.2.0.1,SQL Loader, 12c Grid Control, TOAD

Confidential, Tampa, FL

Oracle Apps DBA

Responsibilities:

• Providing Support to Oracle R12.0.6, R12 (12.1.3) & 11i (11.5.10.2) Application.
• Providing 24*7 support to P2P by Monitoring Performance of production instance
• Resolving Remedy tickets raised by users and performing approved production change requests by using Resolve-It, Services Now Tools
• Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.4
• Installation of 12.2.2 on test and Dev servers with required patching.
• Cloning of the 12.2.2 applications servers.
• Patching the 12.2.2 environment by using ADOP with options to automate patching.
• Troubleshooting User management issues.
• Applying the WebLogic patches by using BSU utility.
• Worked on 10g, 11g databases, and 12.0.6, R12.1.3 applications.
• Implemented 12.2.2 application on Dev& UAT servers
• Worked as WebLogic server administrator for SOA, IPM services.
• Integration of SOA, IPM services with E-business suite.
• Installed and integrated OID, OAM with R12 E-business suite.
• Worked on certificates installation by using wallet for e-business suite http and Key tool utilities for WebLogic server http servers.
• Configured hardware load balancer for the servers.
• Maintaining, Monitoring and Administering for Oracle applications environments of both standalone on RAC architecture
• Resolved issues with Golden Gate components like Extract, Replicate, Trail Files, GGSCI commands, Tran log options etc.
• Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
• Installed and Evaluated Golden Gate and its components.
• Set up Printers and Workflow mailer in Oracle Applications R12.1.3,12.0.6 & 11i Prod, UAT,QA,DEV Environments
• Worked closely with Functional/Developers and helping them in fixing issues
• Migration of 12.0.6 application database11g to RAC 11g
• 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.
• Cloning 11i & R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
• Backups- Logical and Physical for Multiple Instances.
• Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Table space Quotas.
• Raising the Service Request and working with Oracle Team.
• Installed and configured 10g Discoverer on a Oracle Application environment.
• Installed Web ADI on the user’s desktops and fixed the Application Problems.
• Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD in Oracle Applications Environment.
• Scheduled the Rman Backup scripts in a cron job.
• Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications
• Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
• Oracle Applications Concurrent Manager Administration & tuning for R12 applications.
• Installed the Oracle 10g, Oracle 11g databases and Created Table spaces on ASM environment.
• Done Full Exports and Imports of the database at schema as well as table space level for different customers.
• Installed Oracle Golden Gate for EBS Reporting Databases.
• Installed, configured and supported Golden Gate (11g) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Performed the Restore of Oracle 10g/11g databases on a three node RAC environment.
• Install, configure and write shell scripts
• Daily DBA activities as Performance Monitoring, Instance Health Check etc.
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided 24*7 Production support in Oracle Production Databases as well as Oracle Applications environments.
• Experience in supporting Oracle Financial modules like (AP, AR, GL, FA, FCG, CM)
• Cloning the Oracle 9i/10g/11g Databases from Production to UAT, QA, DEV databases through rman.
• Configuring of OEM to monitor all the environments from OEM utility.
• Trouble shooting long running sql and finding top activities from OEM tool and configuring sql advisor for performance tuning.
• Supported NDM, IPM, 170 mark view servers and its services.
• Working closely with Oracle, HP, mark view systems team to debug the issues for imaging and package updates.

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

Confidential, TX

Oracle Apps DBA

Roles and Responsibilities:

• Providing Support to 11.5.10.2 Application users through ticketing system.
• Providing end to end support for all the instances of Oracle Apps R12&11.5.10.2
• Migration of Forms/Reports/procedures/queries of developers for production migration
• Worked on 9i, 10g, 11g databases & R12, 11i applications.
• Maintaining, Monitoring and Administering for R12&11ii Instances
• Performed Multi Node installation of Oracle EBSR12& 11.5.10.2
• Cloning the Oracle Applications 11i environment from Production to UAT, QA, DEV boxes.
• Installed and supported oracle application server (10gAS) for portal services.
• Worked and supported the application user SSO Issues.
• Worked and implemented OIDOAM for R12 applications.
• Worked as OEM admin to monitor and configure the application to monitor the jobs.
• Scheduling and monitoring the jobs by using OEM utility.
• Creating user in OID and sync with e-business suite and troubleshooting the issues with accelerate.
• 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 Table spaces.
• Done Full Exports and Imports of the database at schema as well as table space 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)

Environnent: Oracle Applications 11.5.10.2, Oracle 9.2.0.8, Multinode Solaris 5.9. RAC, UAT

Confidential

Oracle Core + Apps DBA

Roles and Responsibilities:

• Providing 24*7 support to SICO by Monitoring Performance of production instance
• Cloning, Patching, and Administering the Concurrent Mangers.
• Interacting with development team, carrying out the jobs as and when required/ as per schedule.
• Monitoring and supporting Production server issues.
• Troubleshooting the day to day issues of end users of SICO along with developer and functional team
• Applying Patches and doing Clones of Production depending on demand of Business
• Resolving DEV/UAT/TEST/Reporting issues on day to day basis
• Migration of Forms/Reports/procedures/queries of developers for production migration
• Monitoring long running, Schedule concurrent request, alerts from the system and taking action
• Monitoring the Backups of Production
• Responsible for communication with the Client and end users
• Refreshing the database.
• Troubleshooting the user issues, interacting with the end users/ coordinating between development team / Users to carry out the Patching/ implementing new changes to the system.
• Applying patches on production servers.
• Performed AD Utilities such as ADADMIN, Auto patch and ADCTRL etc.
• Periodically cloning the production server on to Development Server.
• Maintenance of 13 Apps 11i instances involving 8 Production and 5 UAT servers, 24X7 Production Database Support and maintenance.
• Concurrent Manager Administration & tuning.
• Developing Hot, cold and logical backup scripts to automate the backup procedures. Planning for storage spaces requirements and placing them for optimum I/O performance.
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management, and Security Administration.
• Tuning the databases for optimal performance.
• Meeting the end users to know database issues like performance
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Up gradation of Oracle Server and applying Database and Application patches. Writing scripts for the system and database for the effective functionality and report generation.
• Installation of Solaris and other OS and applying patches at OS level.
• Verifying the backups

Environment: Oracle Applications 11.5.10.2, DB 10.2.0.4, UNIX

Oracle Core + Apps DBA

Confidential

Roles and Responsibilities:

• Performing OATM Migration for oracle apps 11.5.9
• Getting Business Knowledge for the systems involved in OATM Migration
• Preparing the execution plan for the upgrade and migration in collaboration with the client DBA’s
• Responsible for the analysis, testing of the system before conducting OATM Migration
• Testing the plans on Test Environment
• To Check the pre - requisites before performing OATM Migration
• Troubleshooting OATM Issues and maintaining an Error Log Repository
• Supervising the team during the actual OATM migration on the production system
• Solely responsible for communication with the Client
• Handling Tars
• Done Full Exports and Imports of the database at schema as well as table space level.
• Solely responsible for communication with the Client.

Environnent: Oracle Applications 11.5.9, Oracle 9i, LINUX

Confidential

Oracle Core DBA+Oracle Apps DBA

Responsibilities:

• 24 X 7 Production database administrations, support and monitoring to ensure Proactive problem recognition and resolution of database issues.
• Involved with installation and maintenance of ORACLE RAC 3 node and adding a node to this cluster database for high availability on Linux.
• Installation, Configuration and Maintenance of RAC, Standby database.
• upgraded Databases from 10.2.0.4 and to 11.2.0.1.
• Knowledge in handling and Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database using OEM.
• Duplication of Databases from Production RAC to test RAC using RMAN active cloning. Involved in migrating non - RAC databases to RAC environment on ASM.
• Converted single instance database to RAC Database using R-CONFIG.
• Configured and installed 15 standalone DR servers on ASM.
• Implementation and configuration of Oracle golden gate.
• Worked on databases sizes 8TB and involved in scheduling backups.
• Applied patches to Oracle Databases using Opatch utility and upgraded databases manually.
• Involved in migrating HP-Unix databases from 9i, 10g, and 11gR1 to 11gR2 Linux.
• Implemented Disaster recovery for production databases using Data guard.
• Have hands on experience in creating physical standby databases, and involved in converting physical to snapshot standby.
• Implemented 11g new features for building Active Data-guard.
• Configured Data guard-broker and involved in registering of databases in Data guard broker using utility DGMGRL.
• Extensively used data-pump at schema level and Database level for moving data from Solaris to Linux during migration
• Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Installed and Implemented Backup & Recovery procedures using RMAN.
• Performed Block Recovery, data file recovery using RMAN.
• Configured RMAN retention policy, archive log deletion policy for Production databases. Maintained catalog server and registered databases in catalog server. Performed Database refresh using RMAN active cloning and data-pump.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Taking periodic Backup of the Database and the software using RMAN and supporting VERITAS - Netback up Team.
• Involved in SQL tuning by generating explain plan, ADDM, AWR and TKPROF.
• Installed 12C GRID CONTROL and registered databases in GRID control.
• Upgraded the Oracle applications from 11.5.10.2 to R12
• Getting Business Knowledge for the systems involved in Oracle Applications Upgrade
• Responsible for the analysis, testing of the system before conducting Upgrades
• It includes Communication with the Onsite Client & solving Technical problems
• To Check the pre - requisites before performing Upgrade
• Troubleshooting Upgrade Issues and maintaining an Error Log Repository
• Responsible for upgrading Oracle Applications version 11.5.10.2 to R12.
• Includes checking of upgrade logs etc. to ensure successful upgrade of the Installation
• Working closely with Functional/Developers and helping them in issues
• Handling Tars
• Done Full Exports and Imports of the database at schema as well as table space level and loaded data into database.
• Working and installing OEM, Golden gate and its maintenance.
• Created users, Profiles, Assign Grants, Granted Roles and Quota to users
• Solely responsible for communication with the Client.

Environment: ORACLE 10g/11g, Oracle 10g/11g RAC, ASM, Applications 11i R12, Oracle Solaris 10, Linux 5.x,6.x, Toad, SQL, PL/SQL, Toad, Data-Pump, OEM, RMAN, XML, Shell Scripting.