SUMMARY:

• 10+ years of global experience in Oracle ERP Design (11i & R12, 12.2), Implementation and Production support including team management in 24/7 model.
• Oracle EBS R12 / 11i, Oracle database server 12c/ 11g R2 / R1 /10g / 9i / 8i.
• Oracle databases on Real Applications clusters (RAC) and ASM.
• Expertise experience on installing, configuring and troubleshooting Golden Gate.
• Has good experience on installing, configuring teh Informatica ILM Smart Partitioning End to End implementation for EBS instances for production instances. (Performance Improved by 40 % overall).
• Has good experience in Implementing Subset Clone to reduce storage in test and dev instances. (Restoring only current year data for quick testing).
• Has good experience in creating Incremental Move partitions quarterly/yearly.
• Created access policies at user level, concurrent program level and module level by using Smart Partitioning Tool to boost up production performance.
• Created physical and logical standby databases using Data Guard.
• Oracle Identity / Access management, Single sign on, Oracle TM.
• Oracle Apps cloning, Apps instance upgrades, database / CRS / ASM upgrades.
• Oracle database 12c/ 11g R2, 11g R1, 10g / 9i on 11g / 10g CRS / ASM.
• Oracle database 11g R2 infrastructure configuration, 11g R2 ASM / CRS upgrade.
• Configuration of Workflow Notification Mailer, OAM, OEM 10g and tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Worked on Fusion applications 11.1.6/11.1.7 for POC setup.
• Implemented DMZ setup on Oracle EBS R12.
• Expertise experience on GPG Version Upgrade to 2048 keys to Encrypt Programs.
• Handled POC setup for 12c upgrade and Installation methods.
• Trainings handled on Oracle EBS / Oracle databases and associated technologies.
• Oracle Apps cloning, patch analysis, instance propagation planning of Apps instances.
• Apps Instance Planning, capacity planning, monitoring, instance tuning, best practices.
• Platform migration of Oracle database, database storage analysis, ASM / File systems.
• Oracle on Demand implementation experience on EBS, OBIEE, Fusion apps etc.
• Expertise on various architectures of Oracle Apps and database configurations.
• Oracle Apps database performance tuning, troubleshooting issues.
• Oracle application server, Oracle discoverer 10g / 4i, Oracle workflow.
• Oracle Grid control / OEM, RMAN, SQL *PLUS, PL/SQL, Forms, Reports
• Oracle Standby database / Data guard configuration in Oracle Apps environment.
• Hands on experience on Appworx for scheduling jobs.

TECHNICAL SKILLS:

Operating Systems: Linux (RH, OEL), UNIX (Sun Solaris, HP - UX, NEC UX, SCO, AIX), Windows 95, Windows 98, 2000, Windows NT 4.0 and XP

Oracle RDBMS: 12c/ 11g R2 / R1, 10g (with RAC / ASM) 9i RAC, 8i

Oracle EBS: Oracle Applications R12, 11i (11.5.2 through 11.5.10.2), 11.0.3, Fusion Apps 11.1.6, 11.1.7

LANGUAGES: SQL, PL/SQL, UNIX SHELL, C.

TOOLS: TOAD, X-Manager, Putty, OEM & OAM, ILM Smart Partitioning.

PROFESSIONAL EXPERIENCE

Confidential

DBA

Responsibilities:

• Installed new Production Instance and activity working on implementation assessments for Oracle Apps R12, Release 12.2.4.
• Archived OID/OAM integration with 12.2.4 for Proof of Concept in Project initial scope.
• Experienced in Oracle Exadata X2, X3 machines &ERP 12.2.
• Upgraded Oracle Apps 11i, Release 11.5.10.2 to 12.2.4.
• Upgraded Oracle Apps R12, Release 12.1.1 to 12.1.3 (One HRMS and One Manufacturing Instance).
• Upgraded Oracle Apps R12, Release 12.0.4 to 12.1.3 and database upgrade 10g to 11g.
• Installed and upgraded Oracle Applications 11i e-business suite version 11.5.10.2 to R12 in multimode configuration.
• Copy/Clone of Oracle application environment using Rapid clone.
• Proactively tuning JVM for performance issues, creating JVM islands.
• Oracle application upgrades from 11.5.10.2 to R12.2 on VCP instance.
• Having hands on experience on online patching.
• Oracle Database Infrastructure experience on Single node, multi-node and RAC with E-business R12 (12.1.1).
• Worked on Fusion applications 11.1.6/11.1.7 for POC setup.
• Worked on ZFS storage for POC setup.
• Creation of new scripts to automate teh procedures to generate statistics on database space management, performance and for proactive monitoring.
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• Implemented DMZ setup on Oracle EBS R12.
• Experience in Installation, configuration of Oracle RAC, developed 2 node RAC environments for a 1TB database by implementing WAN technology to reduce teh network traffic.
• Configuration of Workflow Notification Mailer, OAM, OEM 10g and tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Installed and configured Golden Gate and has worked on latency issues and proactivity troubleshooting teh issues.
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
• Worked on different modules and has a good technical noledge about and has in depth noledge of teh tables involved in these modules HRMS/FIN/MFG.
• Supported Finance Month end closure for AR, PO, INV, AP, FA and GL.
• Has experience in enabling teh new Languages and New currencies by applying teh patches.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Manage teh Oracle 11g RAC environment and troubleshoot performance problems.
• Applied RDBMS patches using Opatch
• Created a number of database instances for development, testing and production.
• Created and managed teh Database objects and schemas
• Managing teh Concurrent Managers and its operations like starting, stopping teh concurrent managers, re-schedule teh requests, purging teh concurrent requests historical data, tuning of concurrent managers and monitoring of teh concurrent manager operations.
• Supporting Hyperion databases during month end data loads for consolidation.
• Application user creation / responsibilities assignment
• Analyze design and data model solutions for business needs in cooperation with various levels of business and systems personnel.
• Perform database analysis, design, coding, testing and implementation of database structures.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Review database access code and recommend tuning opportunities.
• Advise less experienced team members in all phases of teh assignments and assist in teh coordination of team activities and conducted trainings if needed.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Install, test, evaluate, implement and maintain DBMS related system software and tools.
• Design and implement database backup and recovery procedures (RMAN).
• Installing 10g Cluster ware, ASM, Oracle 10g Database, Configuring Data Guard
• Monitor and tune database performance including SQL tuning.
• Autopilot/ILM Smart Partioning Tool implementation and support.
• Implement effective database security practices and procedures.
• Implement complex enterprise changes as they pertain to teh database environment.
• Develop, document and enforce database standards and procedures.
• Maintain and improve high availability and disaster recovery.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.
• Migrate data to other databases.
• Restore & Recover lost databases.
• Database storage management.
• Finest granularity approach to Oracle implementation and defragmentation.
• me/O distribution analysis.
• Capacity planning, capacity monitoring and management.
• Calculate disk space requirements.
• Oracle’s Enterprise Manager (OEM), Stats pack Reports, Explain Plans, SQL Trace and TKPROF.
• Data guard, upgrades, patches, partitions, RAID arrays, etc.
• High Availability Data Replication - Golden Gate Implementation.
• Implemented High availability using Golden Gate Replication Implanted Bi-directional replication using golden gate.
• Experience in replication using golden gate, materialized views.

Confidential

Responsibilities:

• Handling Production system which is a 3 node RAC environment.
• Managing Milestone Backups weekly.
• Creation Responsibilities and Descriptive flex fields.
• Migrating codes to proxy and QA and Production.
• Closely working with developers and resolving their issues on priority basis.
• Applied patches and checked teh patch impact and reduced teh timelines of patching using features such as defaults file, merge patch and distributed workers concept.
• Code reviews as per standards.
• Meeting Project time lines and attending daily calls and coordination with onsite team.
• Code migrations and Chain-link setups (Object Migrator)
• Autopilot/ILM Smart Partition implementation and new segmentation creation module wise.
• Subset cloning using RMAN and ILM Smart partitioning tool features.
• Cloning from Multi node RAC to Multi and Multi Node to Single node.
• Expertize in Mobile warehouse setups, configurations and issues.
• Installed, Configured BI Apps Financials, Supply Chain, Procurement modules.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Configured and merging teh repository with new business logic based on teh requirement of business.
• Worked effectively with Noetix team to generate and refresh views in OLTP database.
• Created workflows for full load and incremental loads to be used by DAC.
• Monitoring Incremental & Full load through DAC.
• Responsible for installing, configuring, support and maintenance of teh BI APPS.
• Effectively interacted with teh end users for requirement gathering and defined requirement specifications document.

Confidential

Responsibilities:

• Applications Patching
• Rapid Cloning
• Troubleshooting
• Expertize in Mobile Warehouse Applications (MWA) setups and configurations.
• Database Upgraded from 9.2.0.4 to 10.2.0.4 PSU 2. (Manual Upgrade).
• Configured PASTA printer setup in 11.5.10.2 for a PCL Based Printer.
• Configured and Automated RMAN Backup Process for all Text, UAT and Production instances.
• Configured Oracle Enterprise Manager Repository for R11i Databases.
• Performed setup of Workflow Notification Mailer in R11i.
• Proactively Handled Service Request Management.
• Performed all other DBA activities.
• Documented all teh issues and maintained connectivity, patching and Backup info in excel sheet and sharing them weekly with teh Client DBA’s as part of my activities.
• Applied RDBMS patches using OPatch.
• Managed and troubleshot apps components such as apache/forms.
• Created application user accounts and assigned teh responsibilities.
• Monitored table spaces for space usage and added required space whenever it reaches threshold.
• Monitored alert log file for errors.
• Managed backups of teh apps instances and maintained daily backups of database of PROD/QA/UAT instances.
• Participated in maintenance of oracle 11i Applications, Cloning, Patching, and troubleshooted issues related to Oracle Applications.
• Supported development teams, general troubleshooting and Support in administration of production and test instances.
• Monitored Concurrent Manager and its operations such as starting, stopping teh concurrent managers and Troubleshooting problems, resolved teh view log/out files issues of concurrent requests.
• Assigned specific concurrent requests to a concurrent manager.
• Generated context.xml files, and environment files related to apps.
• Monitored, identified and resolved user issues.
• Monitored teh Application System with Oracle Applications Manager (OAM).

Confidential

IT Consultant

Responsibilities:

• Offshore Apps DBA Support for R12 EBS Production
• Handling Confidential R12 Production system which is a 2 node RAC environment.
• Handling OTM Production 10g databases
• Applications Patching and Cloning
• Monitoring Scheduled RMAN Backups
• Monitoring OEM Grid Control Alerts and working on severity
• Also Handling 20 other test/dev/qa instances
• Troubleshooting issues in R12 EBS and 10g Databases
• Proactively Handling Service Request Management
• Proactively resolving issues related to space management
• Closely working with developers and resolving their issues on priority basis.
• Completed patch analysis, applied patches and checked teh patch impact
• Altered several components configurations such as port numbers and made them functional
• Reduced teh timelines of patching using features such as defaults file and merge patch
• Troubleshooted several worker issues while patching
• Applied RDBMS patches using OPatch.
• Managed and troubleshot apps components such as apache/forms
• Created application user accounts and assigned teh responsibilities
• Monitored table spaces for space usage and added required space whenever it reaches threshold
• Monitored alert log file for errors
• Managed backups of teh apps instances and maintained daily hot backups of database of dev./test and involved in recovery of database
• Helped users while initial setup of application launch and resolved DB Connectivity issues, Resolved yellow bar issue for users
• Cloned teh oracle apps instances from prod to test using rapid cloning process
• Responsible for Export, and import of schemas and tables from production to test/dev
• Gatheird apps tables, schema statistics manually
• Done R12.0.6 up gradation from R12.0.4

Confidential

IT Consultant

Responsibilities:

• Offshore Apps DBA Support for Financials Implementation Project in R12 with RAC environment.
• Applications Patching
• Rapid Cloning
• Troubleshooting
• Performed Up gradation of Oracle Applications from 12.0.4 to 12.0.6 (RUP6)
• Configured PASTA printer setup in 12.0.4 for a PCL Based Printer
• Configured and Automated RMAN Backup Process for UAT instance
• Resolved many issues in R12 by working with Functional Folks closely
• Configured Oracle Enterprise Manager Repository for R12 Databases
• Performed Cloning of Oracle Applications with RAC database to non-RAC environment
• Performed setup of Workflow Notification Mailer in R12
• Proactively Handled Service Request Management
• Performed all other DBA activities.
• Documented all teh issues and maintained connectivity, patching and Backup info in excel sheet and sharing them weekly with teh Client DBA’s as part of my activities
• Applied RDBMS patches using OPatch
• Managed and troubleshot apps components such as apache/forms
• Created application user accounts and assigned teh responsibilities
• Monitored table spaces for space usage and added required space whenever it reaches threshold
• Monitored alert log file for errors
• Managed backups of teh apps instances and maintained daily backups of database of QA/UAT instances
• Participated in maintenance of oracle 11i Applications, Cloning, Patching, and Troubleshooter issues related to Oracle Applications
• Supported development teams, general troubleshooting and Support in administration of production and test instances
• Monitored Concurrent Manager and its operations such as starting, stopping teh concurrent managers and Troubleshooting problems, resolved teh view log/out files issues of concurrent requests
• Proficient in Installing, Cloning, Patching of Oracle Apps (Release 11i) and Proficiency with several AD admin tools such as Rapid clone, AD patch, Ad admin, AD controller, Ad splicer.
• Assigned specific concurrent requests to a concurrent manager
• Generated context.xml files, and environment files related to apps
• Monitored, identified and resolved user issues
• Managed passwords of apps and Product passwords
• Monitored teh Application System with Oracle Applications Manager (OAM)
• Maintained instances, maintenance of file system and taking appropriate backups for security and consistency
• Performed research for patches for specific problems and downloaded patches.