SUMMARY:

• Technically adopt multi skilled certified database administrator over 10.8 years of experience in Confidential Apps 11.5.10.2/12.1. x/12.2.x DBA Streams.
• Confidential 12.2 implementation and Upgrades.
• Applying the 12.2.2 AD and TXK Release Update Pack.
• Good knowledge on WebLogic.
• Proficiency in adop patching cycle. upgrade from Release 12.2.2 to 12.2.3
• Installation, administration, configuration, cloning, upgrading, patching.
• Experience in Installing and administering and managing Large databases
• Proficiency in Confidential Database 12c/11gr2/10g
• Proficiency in Confidential Enterprise Manager 12c (OEM 12c)
• 11g GI Setup and Deployment
• Upgrading Grid Clusters and RDBMS
• Setup, configuration and administering of 12c OEM Cloud control monitoring across DB infrastructure
• Administering OMS and Repository databases in OEM
• Setup and administration of Database Flashback
• Supporting customers by refresh UAT instances and setup new instances when required.
• Database refresh using RMAN Active Database
• CPU Patching on RAC, stand - alone and ASM homes
• Periodical switchover and failover of primary and secondary
• Working Knowledge of RAC
• Good Trouble shooter. Coordinating with stake holders and Technical Teams.
• Excellent written, communication, interpersonal, liaison & problem Solving Skills with ability to work in multi-Cultural Environment

TECHNICAL SKILLS:

Hardware / OS: Linux, Sun Solaris, Windows

Databases: Confidential 9i,10g and 11g

Applications: R12.2(12.2.0,12.2.2,12.2.3 and 12.2.5), R12.1 (12.0.4, 12.1.1.12.1.2, 12.1.3), 11i (11.5.9, 11.5.10), GRC, FMW11G, WebLogic 11g, OTM, APEX, UPK (Developer/content server)

Tools: /Utilities: OEM, OAM, Ad Utilities, Confidential Export/Import, TOAD, Net Backup 5.6, RMAN

3rdparty installation: Glwand, More4apps, Loftware, sabrix, ePrentise, markview, Vertex

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Apps DBA Implementation and Support

Responsibilities:

• Involved in upgrading E-Business Confidential applications from R12.1 to R12.2 and 12.2.3 to 12.2.5
• Supporting the development and testing team during implementation of the project and on all DBA related issues.
• Maintenance activities like patching, cloning, Code Migrations & Deployments.
• Applying patches on R12.2.3 & R12.1.3 instances based on client requirement.
• Cloning R12.2 Instances for Test and Development purpose using Rapid Clone.
• WebLogic administration and deployments.
• Upgraded JRE on client request for Confidential EBS R12.1.3 & R12.2.3 environments.
• Added new Custom Tops using adsplice and manually based on client requirements.
• Pro-actively monitoring the instances by performing health checks.
• Monitoring the Xenos alerts and working on priority basis. Monitoring alert logs, Blockers, Wait Events.
• Working on user tickets which have been raised by Service now tool.
• Coordinating with Confidential Technical Support (Meta-link) for SRs we raised.
• Being an active team member coordinating with onsite/offshore DBA/Developers for smooth operation.
• Supporting development and testing team during implementation of the project and on all DBA related issues.
• Interaction with the load testing team and creating Load test reports by generation of AWR reports/ADDM reports.

Environment: Linux, Confidential Apps R12 (12.2.3), Confidential Database 11g (11.2.0.3)

Confidential, Irving, TX

Apps DBA Implementation and support

Responsibilities:

• Installation and Upgrading Applications from 12.2.0.47 to 12.2.3
• Upgrading database from 11.2.0.1 to 11.2.0.3
• Applying Confidential Applications patches through ADOP
• Cloning the Confidential applications R12.2 Production to Non Production.
• Supporting developing team in day-to-day activities
• Applying CPU security patches
• Workings on the issues arise out of UAT
• NLS patching
• Worked with external implementers and attending project meetings
• WebLogic configuration activities.

Environment: Linux, Confidential Apps R12 (12.2.3), Confidential Database 11g (11.2.0.3)

Confidential

Apps DBA Implementation and support

Responsibilities:

• Installation and Upgrading Applications from 12.2.0.46 to 12.2.2
• Upgrading database from 11.2.0.1 to 11.2.0.3
• Applying Confidential Applications patches through ADOP
• Cloning the Confidential applications R12.2 Production to Non Production.
• Supporting developing team in day-to-day activities
• Applying CPU security patches
• Workings on the issues arise out of UAT
• Worked with external implementers and attending project meetings
• WebLogic configuration activities.

Environment: Linux, Confidential Apps R12 (12.2.2), Confidential Database 11g (11.2.0.3)

Confidential

Apps DBA Implementation and support

Responsibilities:

• Upgrading Applications from 11.5.10.2 to 12.1.3
• Upgrading database from 10.2.0.4 to 11.2.0.3
• RMAN backup and Monitoring Implementation
• Implementing PCP and Load balancing of Applications.
• PCP/RAC failover testing .
• Troubleshooting Issues related Applications and Database
• Applying Confidential Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
• Configuring workflow, discoverer etc
• Troubleshooting issues at various layers of Confidential Applications
• Supporting developing team in day-to-day activities
• Applying CPU security patches
• Working on user Management and responsibility management
• Creation of new table spaces and adding and resizing the data files.
• Creation of new schemas and proving access to database objects.
• Workings on the issues arise out of UAT
• Post Go-Live support

Environment: Linux, Confidential Apps R12 (12.1.3), Confidential Database 11g (11.2.0.3)

Confidential

Apps DBA Implementation and support

Responsibilities:

• Installing & configuring GRC AACG,CCG,PCG and PEA
• Installing WebLogic Server 11g & administration.
• Implementing PCP and Load balancing of Applications
• RMAN backup and Monitoring Implementation
• Creation of new table spaces and adding and resizing the data files.
• Configuring workflow, discoverer etc
• Workings on the issues arise out of UAT
• Troubleshooting Issues related Applications and Database
• Applying Confidential Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
• Troubleshooting issues at various layers of Confidential Applications
• Supporting developing team in day-to-day activities
• Applying CPU security patches
• Working on user Management and Resp management
• Creation of new schemas and proving access to database objects.
• Post Go-Live support
• Working with external implementers and attending project meetings

Environment: Linux, Confidential Apps R12 (12.1.3), FMW 11g, Confidential Database 11g (11.2.0.3)

Confidential

Apps DBA Implementation and support

Responsibilities:

• Installing Confidential Applications R12.1.1 and upgrade to 12.1.3
• Implementing PCP and Load balancing of Applications
• RMAN backup and Monitoring Implementation
• Creation of new table spaces and adding and resizing the data files.
• Configuring workflow, discoverer etc.
• Workings on the issues arise out of UAT
• Troubleshooting Issues related Applications and Database
• Applying Confidential Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
• Troubleshooting issues at various layers of Confidential Applications
• Supporting developing team in day-to-day activities
• Applying CPU security patches
• Working on user Management and Resp management
• Creation of new schemas and proving access to database objects.
• Post Go-Live support
• Working with external implementers and attending project meetings

Environment: Linux, Confidential Apps R12.1 (12.1.3), Confidential Database 11g(11.2.0.3)

Confidential

Apps DBA Implementation and support

Responsibilities:

• Offshore lead for Migration project
• Cloned the Confidential applications Production to Non Production with RMAN Backup.
• Implemented standby database in sync with production database.
• Applied various Confidential Applications & database patches like one off patch, Mini patches, family packs, Rollup Patches and latest cpu patches
• Implemented Shared TechStack and DMZ setup
• Worked on user login issues.
• Extensively used RMAN for restore and recovery.
• Installed and configured discoverer
• Working with external implementers and attending project meetings
• Troubleshooting issues during migration and post migration

Environment: Solaris, Confidential Apps 11i (11.5.10.2), Confidential 10g.

Confidential

Apps DBA Implementation and support

Responsibilities:

• Offshore lead for upgrade project
• Upgraded Confidential Applications 11.5.10.2 to 12.1.3 and Database 9.2.0.4 to 11.2.0.1
• Applying Confidential Applications patches Maintenance Pack, Interoperability patch, one off patch, Security patches etc.
• Implemented shared TechStack
• Implemented PCP Setup
• Configuring Discoverer, Workflow.
• Monitoring and Maintaining User Activities.
• Creation of new table spaces and adding and resizing the data files.
• Creation of new schemas and proving access to database objects.
• Working with support on the issues faced during the upgrade and UAT
• Post golive support handling all kinds of issues.
• Supporting developing team in day-to-day activities
• Working with external implementers and attending project meetings
• General troubleshooting, performance related troubleshooting

Environment: Linux, Confidential Apps R12 (12.1.3), Confidential 11gR2.

Confidential

Apps DBA Implementation and support

Responsibilities:

• Lead DBA for Implementation and production support
• Upgraded Confidential Applications R12 (12.0.4) to R12(12.1.2)
• Upgrading Confidential database from 10.2.04 to 11.2.0.1.
• 11g Database Installation
• Changing database block size from 8k to 32K
• Cloning the Confidential applications R12 Production to Non Production
• Applying security patches
• Making database backups and performing recovery when necessary using RMAN
• Configuring Discoverer, Workflow
• Working on the performance issues and tuning the database and sql queries
• Applying database, Application and Techstack patches
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new application messages and then generated message file for application.
• Troubleshooting Issues related Applications and Database
• Monitoring and Maintaining User Activities.
• Working with external implementers and attending project meetings

Environment: Linux, Confidential Apps R12(12.0.4,12.1.1,12.1.2,12.1.3), Confidential 10g,11g.