SUMMARY

• Oracle Applications DBA/ Oracle DBA / WebLogic Administrator / Oracle Cloud Fusion Apps DBA professional with more than 12.6 years of progressively strong experience in Oracle Technologies under Solaris, Linux, AIX, HP - UX and Microsoft Windows
• Excellent experience with Oracle Apps (11i and R12) Installations/Implementations/Upgrade/Platform Migration, AD Utilities, Management of Concurrent managers, Database Tuning, Client/Server Connectivity, Application Tuning, Backup /Recovery, ODI, WebLogic 9/10/11, OBIEE, Discoverer 10G/11G, Cross technology integrations…
• Specialized in Oracle Databases (Versions 12c, 11gR2, 11gR1, 10gR2, 9i), Oracle Apps Database Administration (R12.0.6, R12.1.1,R12.1.3, R12.2.2,11.5.10.2) and Fusion Middleware (10g AS)
• Enable Online patching in R12.2
• Performance tuning experience on R12 EBS Apps running on 12c Database
• Experience in installing, configuring and managing Oracle 11gR2 RAC with ASM
• Experience in Installing Discoverer 11G, SOA11g (Service Oriented Architecture Suite) Fusion Middleware, OBIEE
• Experience in Installing 9/10/11g WebLogic
• Expertise in Maintenance, Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications E-Business Suite
• Production Experience in administering Oracle Apps 11i, and upgrades from 11.5.10 to R12.
• Experience on EBS, Oracle Database up gradations and platform migrations.
• Client Meetings, Customer Satisfaction, Recommendations, Mentor and Managing Team.
• Lead a group of DBAs and Developers
• Experienced in Upgrade 9i/10G/11G databases.
• Implemented Shared APPL TOP with Parallel Concurrent Processing (PCP) and load balancer Configuration.
• Established Disaster Recovery Setup for EBS.
• Configured applications with SSL.
• Experienced in Performance Tuning of all Modules and Concurrent Programs
• Cloning and patching of Oracle applications R12/11i and Databases
• Experienced in implementing Single Sign-on (SSO), I-Recruitment External web tier DMZ setup, Printer Configuration.
• Experienced in Implementing Discoverer 10/11G with EBS R12.
• Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, Jinitiator and database)
• Applied oracle apps tech stack patches (10.1.2, 10.1.3, iAS, 8.0.6 MT tech stacks + 9.2.0, 10.2.0, 11.1.0.6 DB tier tech stacks), 10g RAC fix patches using opatch
• Applied product specific fix patches, family packs, maintenance packs - all types of patches - adpatching and adop
• Experienced in Space Management, security and auditing, Memory Tuning and Application Tuning
• Well versed with UNIX Shell Scripting.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing Databases on Oracle Applications
• Skilled in using 11gR2/10gR2 features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Control Monitoring
• Skilled in taking backups using Cold, Hot and RMAN backups and also tested different recovery procedures also Cloning/Refresh.
• 24 * 7 Production Database and application Support and maintenance.
• Very strong in handling pressure and system downtimes.
• Strong interpersonal skills, ability to interact with people at all levels good communication and presentation skills.
• Working with Severity 1 Oracle support request (SR)continuously monitoring and resolving the issues.
• Excellent hands on experience with MSSQL server

TECHNICAL SKILLS

Operating Systems: Solaris, AIX, Linux, Windows.

RDMS: Oracle 11gR2/10gR2/9i/8i, 11gR2RAC/10gR2 RAC, SQL Server 2005/2008

ERP: Oracle EBS R12 12.2.4, 12.2.2, 12.1.3, 12.1.1/12.0.611 i 11.5.9, 11.5.10.2

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: RMAN, SQL*Loader, EXP, IMP, Datapump, SRVCTL, CRSCTL, OCRDUMP, TOAD, Remedy, RDA,SQLT, OEM

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, Oracle Tuning Pack

Other: 10G AS, Discoverer 11G/10G, ODI, SOA, Jdeveloper, Weblogic 9/10/11, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Bozeman, MT

IT Principal Consultant

Responsibilities:

• Provide shift and non-shift support for Oracle Fusion Middleware tech stack and infrastructure.
• WebLogic Administration.
• Build and support all different components of Oracle Fusion Middleware 11g and 12c, viz, SOA, OSB, BPM, ODI, ADF applications, including the WebLogic App server and related Oracle 11g and 12c Database.
• Support mission critical systems in a 24X7 Highly Available (clustered) environment.
• Performance test planning & execution and tuning of Fusion Middleware products, including WebLogic, SOA, JRockit / JDK and Coherence.
• Manage multiple domains on oracle cloud.
• SR support to cloud customers.
• Support and maintain databases on cloud.
• Patch and upgrade WebLogic server.
• Incident Management.

Confidential

Senior Oracle Apps DBA

Responsibilities:

• Installation and upgrade of EBS 11.5.10.2 to R12.1.3
• Upgrade Database from 9i to 10G to 11G
• Fresh Installation of Oracle Apps R12.2.0 and upgraded to 12.2.4 from Advanced supply chain planning
• Apply 12.2.4 patch to upgrade EBS R12.2
• Complete Infrastructure Revamp
• Migration of Oracle EBS environment from non 24*7 to 24*7 environment by implementing Backup solutions
• Migrate Oracle DB from non RAC to 11g RAC with ASM
• Migrate Oracle EBS from Single Node to Multi Node with Shared APPL TOP and PCP
• Implemented Load Balancer for Oracle Applications
• Enabled SSL for Oracle Applications
• Lead Implementation of Oracle Audit Vault and DB Firewall.
• Lead Implementation of Sales force automation with cross technology Integration
• Lead OBIEE implementation and support
• Oracle EBS database compression and table partitioning
• Build disaster recovery site for Oracle EBS and MS SQL servers
• Lead Implementation of in house application for performance appraisal (PDR)
• Cloning, patching, maintenance of instances using utilities like adop, adautoconfig, adcfgclone, adadmin etc
• Working with Oracle support to resolve issues on priority
• Helping Development and functional team with issue resolution and follow-ups.
• Lead and manage a team of technically advanced Oracle, .Net & OBIEE Developers to provide industry leading support
• Direct team to follow documented standard operating procedures as well as guide the development and thoroughness of existing documentation to constantly improve the environment
• Configuration of Workflow Notification Mailer
• Fusion Middleware Product installation.
• Using the AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink, adsplice)
• Worked closely with user groups to ensure timely upgrade of an ERP.
• Performing tuning of Oracle Database (Memory tuning by altering PGA and SGA values).
• Developing Strategies for Oracle Application Upgrades from a lower version to higher version and performing the upgrades
• Measure and manage team performance for incident resolution, environment alert resolution and change management execution
• Communicate information both to senior management as well as functional team regarding necessary process/procedures adjustments
• Participate in a change management team to ensure modifications and improvements made to the environment are executed in a safe, validated, and fully understood manner
• Participate within post mortem investigations and provide review and resolution suggestions to the internal and external teams
• Participate in external vendor meetings to review and address received escalations and communicate next steps in experience improvement
• Lead and Manage teams of Oracle DBA, OBIEE Administrators, MS SQL DBA’s and Oracle Apps DBA’s
• Responsible for recruitment of new members of staff as well as management of holiday rotation s, overtime, absence and staff appraisals
• Install, Clone, Upgrade of R12.2.x and enable online patching
• Project specific module upgrades for Oracle EBS modules
• Patching R12.2.x using adop
• Applying one-off fixes to Database Oracle Homes (both RAC and non-RAC) using Opatch utility Cloning Oracle Applications instances both R12 and 11i instances
• Applied all latest recommended product and security patches
• Written RMAN backup shell script to perform fullback and archivelog backup
• Created SR’s through metalink for troubleshooting issues related to all Oracle Production environments
• Upgrade Java and R12 technology stack components.
• Upgrading JDK versions and JRE/Jinitiator
• Securing Oracle Applications by periodically changing Apps and schema passwords

Confidential

Technical Specialist

Responsibilities:

• Oracle Application Implementations
• Upgrades Oracle Application from 11.5.10.2 to R12.1.3
• Platform migrations between multiple OS platforms
• Customer support for 24*7 and non 24*7 Environments
• Installation of Fusion middleware 11.1.1.3, webcenter and OHS
• Installation of weblogic server and jrocket
• Cloning Oracle Applications
• Refreshing schema for configurator using exp/imp
• Synchronizing database tables using golden gate
• Installation and setup of Golden Gate 11G
• Clone weblogic and webcenter
• CPU patch analysis for EBS R12.1.3
• Using the AD utilities for maintenance of EBS nodes of 11i and R12 (adpatch, adctrl, adadmin, adrelink)
• Cloning EBS 12 from multinode to multinode multimode to single node
• Configuration of Workflow Notification Mailer
• DB link setups
• Implemented 2 - node 11gR2 RAC with 6 node middle-tiers in Production environment for Oracle R12 E-business and administration
• Upgraded many Oracle Applications from 11.5.10.2 to 12.1.3
• Apply NLS patches for 16 languages
• SSL Setups
• Written RMAN backup shell script to perform fullback and archivelog backup
• Created SR s through metalink for troubleshooting issues related to any production issues
• Using the AD utilities for maintaining the application systems (adpatch, adctrl, adadmin, adrelink, adsplice)
• Worked closely with user groups to ensure timely upgrade of an ERP.
• Performing tuning of Oracle Database (Memory tuning by altering PGA and SGA values).
• Leading Offshore/Onsite DBA and functional teams.
• Enable Localization For Hungarian, Chinese, Indian localization patches
• Applied all latest recommended product and security patches
• Client Meetings, Requirement Gathering
• Upgraded the Oracle Database from 11.1.0.7 to 11.2.0.4 for EBS R12
• Configuration of Workflow Notification Mailer
• Implementation of inbound processing for workflow mailer
• Setup of external Web tier DMZ server for I Recruitment.
• Responsible for upgrade and platform migration of Oracle Applications 11.5.10 on windows to R12.1.3 on Oracle Linux.
• Migrate Non RAC EBS database to RAC.
• Platform Migration and upgrade of Oracle 10G EBS database on Solaris to 11gR2 RAC databases with ASM on RHEL5
• Performing Complex RAC setup with Multiple Appl-Tier system.
• Load Balancing Mid-Tier web servers with BigIP Load balancer
• Load Balancing Concurrent Processing tier PCP
• Applying Post upgrade R12.1.3 recommended and security patches for AP, AR, FA, HR, I-Recruitment modules.
• Upgrade of individual Oracle Applications product and product families by applying Mini-Packs and Family Packs
• Worked in DBA teams to Integrate Oracle Applications R12 with OID/SSO
• Creating documentation during project planning, project execution and project maintenance phases Monitoring users activity.
• Tuning Concurrent Managers, Defining Work Shifts, configuring specialization rules, Defining primary & secondary nodes for PCP setup
• Documentation
• Maintenance of oracle databases and other non-ERP databases
• Cloning DEV and UAT instances from production for testing
• Day to day troubleshooting of the environments (part of team maintaing Oracle Applications R12 with database size ranging from 20Gb to more than terabytes) which includes fixing all the issues coming in them and supporting the various components of Oracle Applications - Forms, Apache, Concurrent Manager, DB, Listener
• Monitoring of databases using 10g OEM grid control
• 24*7 Monitoring of databases
• Work with Presales team in estimation activity and preparing solutions for proposal.
• Primary point of contact for client problems, Implementation, Deployments and Root causes analysis for the issue and solution implementations.