SUMMARY:

• Working as Oracle APPS DBA on multiple ORACLE Database & E - business suite 11i to 12.2 Support, Upgrade and implementation Projects
• Extensive experience in oracle Database upgrades, installations, configuration and troubleshooting on various platform
• 10 Years of Experienced with 5 Oracle EBS/Database upgrades, 3 implementation and 7+ Database/EBS support projects
• Experience in 10g/11g Oracle RAC/ASM installation, administration, patching and troubleshooting
• Worked extensively on RMAN tape/disk backup-recovery,Dataguard, OEM, Performance Tuning and EBS configuration
• Hands on sysadmin, RAC-ASM cloning, patching, installations activities for Oracle apps 11i/R12
• Experience in OID, SSO, Weblogic, OAM installation & Administration
• Deft at project delivery of various sizes, teams & client coordination, Database and application activities.
• Excellent analytical, problem solving and learning skills
• Adroit at analyzing information system needs, evaluating architectural requirement, proposing solutions, server sizing for application and presentations
• Strong communication skills in English, both oral and written

TECHNICAL SKILLS:

Technology and Tools: Hospitals& Hotels Manufacturing Consulting Communications institutes Applications Oracle E - Business suite 11i/R12/R12.2 Oracle Application Server Middleware: Oracle Weblogic OAM OID SSO, Discoverer RDBMS Oracle (9i,10g,11g,12c) Operating Systems AIX/HP-UX/Linux/Sun/windows Oracle Database Products RMAN,RAC,ASM,, Data guard, Standby

PROFESSIONAL EXPERIENCE:

Confidential

Technology: EBS 12.2.4/12c DatabaseOperating System: HP-UX, RHEL

Lead Oracle APPS DBA

Responsibilities:

• Planning and initiation for dba activities for EBS upgrade
• Performed several upgrade iterations before go-live for EBS R12.2 upgrade
• Database migration from 11g(HP-UX) to 12c (Solaris sparc)
• EBS application upgrade from 12.0.6 to 12.2.4
• Database & Application migration from HP-UX to Solaris 11.2 Engineering System.
• Good knowledge with adop utility issues and fixes
• Data guard configuration with EBS 12.2 application
• Sound knowledge on exadata components
• Responsible to build pre-production and non-production environment
• Experienced with ETCC, GSCC checkers for 12.2 upgrades
• Registration of custom tops, custom top migrations, advise to development to adhere adop compliance
• Configuration of Multi node, SSL and jarsigner for EBS 12.2
• Evaluating & analyzing system to diagnose performance issues,Monitor EBS system to identify performance obstacles
• Multi-node to Multinode & Single node cloning on ASM and non ASM platform.
• Automate health check process to proactively monitor EBS and database services. Setup important alert and notifications like weblogic threadstuck, FRA, Undo, temp usage, Monitor HTTP and LB ports, concurrent managers etc..
• Co-ordination & communicate with different teams for ongoing issues and suggestion
• Good knowledge on JIRA,SVN system,Commvalut & Veritas backup tools
• Good at documentation and standardizing processes for support
• Onsite coordinator for offshore DBA team

Confidential

Technology: EBS 12.1.2/11gR2 Database Operating System: HP-UX, RHEL

Lead Oracle APPS DBA

Responsibilities:

• EBS database migration from HP to RHEL
• Evaluating & analyzing system diagnose performance tuning issues
• Monitor EBS system to identify performance obstacles
• Solution development for performance related issues
• Monitor system to automate health check process
• Co-ordination & communicate with different teams for ongoing issues and suggestion
• Act as lead DBA to assist Jr DBA for migration and performance related issues

Confidential

Technology: EBS 12.1.1/12.2 & 11gR2 Database Operating System: RHEL 5 64bit

Lead Oracle APPS DBA

Responsibilities:

• EBS database upgrade from 11.1.0.7 to 11.2.0.3
• Installation of database & EBS12.2
• Upgrade 12.1.3 to 12.2.4
• Enable Online patching tool
• Pre & Post upgrade validations and fixes
• Backups and restore during the upgrade

Confidential

Technology: Oracle EBS 11.5.10.2 & 12.1.3 Operating System: RHEL 5

Lead Oracle APPS DBA

Responsibilities:

• Acted as front channel to review effort and timely delivery for DBA activities from offshore
• Executed various critical EBS and database activities
• Worked closely with Load testing team to carry out performance impact after upgrade and to diagnose and fix various performance issue
• 11g RAC installation and migrations
• Database migrations from 10g to 12c
• Oracle EBS 11.5.10.2 upgrade to R12.1.3
• Cloning of EBS & non EBS system from RAC to RAC and non RAC
• Troubleshooting and quick resolution for critical activities during RMAN restoration and cloning
• Co-ordinating with network, hardware and security team to prepare RAC environment
• Configuration of Dataguard/standby along with RAC on Development, QA and production environment
• Quick resolution and issue fixing during customization retrofitting and validation phase of EBS upgrade
• Support for several multi node QA, Development and production database with largest size of 7TB database along with EBS environment
• Support for several NON - EBS databases for patching/cloning/restorations/schema refreshes
• Sound tracking and documentation during Upgrade & new environment creation
• Responsible to pre-indicate expected security, hardware, network challenges during configuration of new environment
• EBS, Database patching, workflow mailer troubleshooting, mailer configuration, concurrent manager performance troubleshooting

Confidential

Oracle DBA/Webcenter/Weblogic admin

Responsibilities:

• Understanding the client requirements by studying technical document
• Installation and configuration of Oracle Identity Management 11g
• Configuring OID, OAM
• Configuring Database repository for OIM 11g
• Creating Weblogic Domain for OIM 11g
• Support on Webcenter portal deployments and other functional requirements.
• Installation of Weblogic, database, OAM, OID, Webcenter PS 5
• Upgrade, configuration and integration of Webcenter PS5 with other interfaces and software’s
• Communicate with client to understand future plans and design, architecture requirement. Co-coordinating with team and other stakeholders to resolve other technical issues

Confidential

Oracle APPS DBA

Environment: Oracle R12, OID, SSO (RHEL 4)

Responsibilities:

• Understanding the client requirements by studying technical document.
• Defining road map to resolve existing synchronization issues, testing, resolving and performing fixes on production
• Assisting team members to define fallback, upgrade, and configuration strategies.
• Oracle EBS 12.1.4 HRMS RUP patching,
• Preparing iteration to test AD to OID sync with new patchsets. Resolving & troubleshooting various patchset upgrade and AD sync issues

Confidential

Oracle APPS DBA

Environment: Oracle EBS11i, R12 - HP-UX, AIX

Responsibilities:

• Providing 24/7 support to a client’s having Oracle Application with Multi & Single Tier Instances.
• Managing the client databases for their availability & for any problem that may occur.
• Verifying the daily backups & taking manual/RMAN backups, if any failure is reported.
• Refreshing development/test databases from production using manual hot backups & RMAN backups.
• Performing database restoration & recovery tests from tape backups.
• Taking exports/imports as well as doing schema refresh tasks.
• Space management so as to provide 24 x 7 functionality. Handling size growth for various table spaces & creating new table spaces and adding or resizing or shrinking the data files.
• Migration & Upgradation between Oracle Databases (10x-11x) and application 11x-12x.
• Monitoring & handling locks & deadlocks & wait events.
• Monitoring Server’s (OS) performance like server load averages & CPU & Memory utilizations & other system performances.
• Responsible for meeting SLA’s related to the Customer and showed great degree of ownership in handling problems and issues.
• Responsible for day to day operations, administrating the Oracle Applications using the AD Utilities.
• Troubleshooting the Concurrent Manager, Forms and Apache Servers issues.
• Validating & creating grants & synonyms on apps schema, relinking the oracle apps programs.
• Changing Apps, Applsys passwords using with FNDCPASS.
• Manage backup and recovery procedures in all production and testing instances.
• Work closely with Development Team and resolve if they are facing any database or application issue related to dba.
• JRE upgrade and IE8 compliance patching for database and application.
• Managing Standby Databases (Data guard).

Confidential

Oracle APPS DBA

Environment: Oracle 11.5.10.2 OS: HP-UX 11.23

Responsibilities:

• Managing the key task of changing APPS password & migrating Application & Database to a high end server.
• Applying patches using AD utilities; cloning from Dual Node to Single Node; Database Health Check up & administering Concurrent Manager.
• Creating Users and Assigning.

Confidential

Oracle APPS DBA

Environment: Oracle 11.5.7, R12 (12.0.6) - TRU64, Linux AS 4 64 bit

Responsibilities:

• Creating upgrade plans and choosing the best suitable upgrade plan for client environment.
• Analyzing current configuration and estimating required software/patches for upgrade process.
• Cloning, patching and troubleshooting on 11.5.7 application.
• Performed Oracle EBS 11.5.7 to R12.0.4 upgrade.
• Migrating database from HP Tru64 server to RHEL server.
• OATM migration.
• Migrating Application database from 8.1.7 to 10.2.0.3
• Troubleshooting on various issues encountered during upgrade, migration and installation process

Confidential

Oracle APPS DBA

Environment: Oracle 11.5.7 - 11.510.2, Database 10g - HP-UX-11.11

Responsibilities:

• Upgrading application from 11.5.7 database 8.1.7.3 to application 11.5.10.2 and Database 10.2.0.4
• Analyzing current configuration and estimating required software/patches for upgrade process
• Configuration of Virtual IP with EBS 11i system for maximum availability architecture
• Appling latest Technology stack /India localization /interim patches
• Troubleshooting on issues encountered during upgrade
• Discoverer, ADI, Workflow configuration
• Cloning from multi to multi node
• Cloning from multi node to single node
• Implementing backup strategy

Confidential

Oracle APPS DBA

Environment: Oracle 11.510.2, Database 10g - TRU64, Linux AS 4 32 & 64 bit

Responsibilities:

• Oracle 10g Grid installation, agent installation /configuration.
• Discoverer installation /configuration
• Jinitiator migration to JRE
• Database upgrade (9i to 10g)
• RMAN Configuration and Testing
• Custom top configuration

Confidential

Oracle DBA

Environment: Oracle 10.2.0.3 - IBM AIX 5.3L 64bit

Responsibilities:

• Implementing Oracle two Node RAC with ASM.
• Creating Test environments on request basis
• Export/Import for dropping and migrating users for testing purpose.
• Implementing RMAN backups for two nodes RAC.

Confidential

DBA & Oracle Apps DBA

Environment: Oracle 11.5.7 - Linux 2.1

Responsibilities:

• Configured Dataguard for production database.
• Configured Discoverer on Standby Database to maximize performance of production system.
• Workflow mailer configuration and Troubleshooting.
• Carried out Database cloning, patching, maintenance activities.
• Configured Shared file system and Alias for the Application to hide a actual web server url from the users.(security)
• As a team member involved in Installation and configuration of Oracle Email Center module with Apps 11i.
• Monitoring mail logs and troubleshooting incoming, outgoing mail issue for Email Center module.
• Email center migration, Troubleshooting.
• Oracle 10g AS installation (Discoverer), services administration.
• Configuration/Reconfiguration of EM web browser.
• Troubleshoot and resolved forms hanging and index corruption issue.

Confidential

DBA & Oracle Apps DBA

Environment: Oracle 11.5.10.2 - AIX 5.3

Responsibilities:

• Database migration, up gradation from 8.1.7 to 9.2.0.8/10G
• Cross platform database migration (Windows to AIX)
• Creating standby databases as per client requirement.
• As a Team member involved in DMZ implementation on reverse proxy for irecruitment module.
• Tuning sql queries (Creating indexes)
• Reorganizing schema /refreshing schema objects, Patching through India localization tool
• Creating Database 9i/10g(Manually),Database Health Checkups, Routine maintenance, Performance monitoring
• Implementing database hardening, Administer Concurrent Manager, Raise the iTAR, Space Management.
• Physical Database Backup (Hot and Cold Backups), Logical Backup and Recovery using Import and Export, scheduling backups.
• Performed Recovery activities when needed
• Oracle 9i AS, Oracle 9i/10g client, oracle 9i/10g installation on Windows/Aix platform.
• Define Concurrent Requests, Configuring STATSPACK Report, changing APPS password, Performed database cloning activity from Production to Testing environment
• Configuring EM web browser on AIX/windows
• Troubleshooting user queries at the database and application level to verify and eliminate their issues.

Confidential

DBA & Oracle Apps DBA

Environment: Oracle 11.5.7 - Linux 2.1

Responsibilities:

• Release 11.5.10.2 Upgrade from 11.5.7 for Fine Organics.
• 12.1.1 installation and upgrade 12.1.3 EBS system