PROFESSIONAL SUMMARY

Experienced Oracle Applications DBA with over all 10 years of experience in Oracle products such as Oracle EBS, Oracle database, Oracle Fusion apps.

Worked as an Oracle application DBA, Technical Lead Oracle applications DBA, Solution Architect and Principal applications DBA in Oracle E-Business Suite Practice.

Strong Experience in installing, configuring, administering and troubleshooting of oracle fusion middleware.

Expertise and focused on supporting the client engagements requiring Oracle E-Business Suite admin, support applications and database needs and implementations.

Supported systems spans, flavours of UNIX and LINUX.

In addition to the hands on technical work, provided assistance to the project teams with architecture design, upgrades, tuning, system stabilization, documentation development and the creation of client deliverables.

Extensive experience and in depth knowledge of application administration in installing, configuring, administering, tuning and Oracle E-Business Suite on Linux and UNIX environments and strong Oracle DBA background in Oracle E-Business Suite.

Strong Database administration, RAC, ASM(ACSF), tuning, backup and recovery skills in oracle 9i,10g,11g,12c on Unix, Linux environments.

Excellent E-Business Suite concepts understanding and administration of 11i,R12.1,R12.2 Version

Deep Understanding of oracle’s current product line; RDBMS, Middleware, Application Suite Products.

Goal oriented with high standards for quality and performance.

Developed proof of concepts (POC) for clients.

Proven skills as a team member on full cycle implementations for R12.2, 12.1.3.

Mentor and manage junior team members.

Supported multiple project environments simultaneously.

Provided trainings to the internal Team and in corporate level.

Handled Technical Transitions for New projects and provide hyper care support till the project gets streamlined.

Raising, updating and monitoring ORACLE TARS for any issues, enquires and suggestions.

Supporting the customers on 24/7 basis.

Provided Recommendations to customers for CPU patches releasing quarterly.

Had Very good understanding of Oracle data appliance (ODA).

Initiated client discussions on DR drills, Prepared Plan of action for DR DRILLS, failover plans and performed them successfully.

Proficient in Installing LINUX & SOLARIS OS and implementing ERP on those Servers.

Implemented Mentoring and assignment Process for the new joinees in ORACLE APPS Team for their Technical and behavioural skills growth.

Working as an SLA in-charge for the ORACLEAPPS Team in order to maintain the 100% SLA for all the calls logged for the customers.

Performed Data Centre Migration for ORACLE ERP 12.1.3 and setup the DR for the migrated instances.

Good Team Player, lead with excellent Technical, Communication, Multi-Tasking, Leading and Interpersonal Skills.

CERTIFICATIONS, TRAININGS, HONORS & AWARDS

Oracle Certified Professional on oracle 11g database.

Provided multiple trainings on ORACLE E-BUSINESS SUITE 11i, R12 to the internal team members for their technical growth.

Provide corporate trainings on ORACLE E-BUSINESS SUITE –R12 and trained a batch of 30 Employees from entire WIPRO division.

Provided ORACLE E-BUSINESS SUITE training to Emerson Performance tuning Team.

Recognized with Top performer of performance group award in 2014-Q3 for working on continuous performance improvement in applications and database of Emerson ITS.

Recognized with an Award for dedication in fusion apps implementation in Emerson.

Recognized with an Award for dedication in handling the PMO process and performance issues in our major instances.

Received Multiple star performer awards in my stint at Wipro.

TECHNICAL SKILLS:

ORACLE EBS

ORACLE E-BUSINESS SUITE 11.5.8, 11.5.10.2, 12.0.4, 12.1.3, 12.2

Database

9i,10g,11g, 10g RAC,11g RAC, ASM

Middleware

oracle Weblogic, Oracle 10gAS

OS

RHEL,Oracle Linux, SOLARIS,AIX

Apps and DBA Utilities

AD utilities,OWB,APEX

Oracle Tools:

Oracle Enterprise Manager (OEM), Export/Import, RMAN

PROFESSIONAL EXPERIENCE

Project # 1

Harvard Pilgrim Health Care R12.2.4 support and Projects

Client

HPHC (VA, remote)

Role

Sr. Oracle apps DBA

Duration

Apr-2016 to Till Date

Environment

Oracle Linux5, Oracle Linux 6 EBS-R12.2.4,OBIEE, ADF, APEX database 11g, 12c, EXADATA,RAC,ASM

Responsibilities:

Working as a Sr. Oracle Applications DBA by being a part of Oracle applications DBA Team.

Majorly working on performance issues, Architecting, support related to EBS and other oracle databases from APPS DBA perspective in an exadata environment with RAC and ASM.

Activities include Project Management, System/Data Analysis, and Customer Interface for all the Business units.

Worked on the EBS databases of size 13.6 terabytes (TB) like data analysis, performance issues, Deployments of the Fusion Apps, Installation and configuring the oracle applications like ADF, OBIEE, APEX, ORDS and WebLogic.

Worked on the issues like Apex login issues, Timeout issues of the application, EBS login issues, troubleshooting the long runners, Invalid objects issue in R12.2.4.

Monitoring all the E-Business Suite instances using OEM 12c and proactively fixing the issues in order to avoid any business impact.

Well versed with OEM12c setup and now we are in process of upgrading OEM 12c to 13c and POC completed successfully.

Supporting the day to day issues and working on the tasks in a shared_appl_top 12.2.4 environment.

Well versed with R12.2 patching cycle process, cloning of R12.2 instance and did many iteration and applied July-16 CPU patches in all the EBS environments.

Prepared High level design documentation, understand the methodologies of the advanced SSL implementation.

We are having F5 Hardware Load Balancer, For SSL implementation of all the Oracle R12.2 and its integrated environments like ADF,OBIEE,SOA and other WebLogic and 10gAS instances, we used SSL OFFLOADING concept and implemented the SSL for all the environments.

Prepared Architecture Diagram for the Advanced SSL implementation using SSL offloading concept.

At the time of SSL implementation, we have issues with the Workflow mails delivery and resolved the same.

Prepared complete Low level design document for the SSL implementation and attended the project closure meetings. Received very good appreciation from client for SSL implementation on time and received much appreciation for the kind of documentation we made which is very much useful for the lifecycle management.

Setup Active guard for the SIT instances.

Resolved issues related to concurrent program slowness. In many of the cases, we found the fault sql_id and tuned those sql_id.

Implementing RWB tool from Polaris to replace Oracle discoverer. Since, Oracle is not providing new discoverer versions, TO achieve many business needs, reports work bench (RWB) from Polaris is a very good option. We attended the initial product description meetings, understood the concept of RWB and integrated the RWB with E-Business Suite environment.

Done several performances tuning activities in database as well as application like compression, table partitioning, re-org, and index rebuild, export and import of PLAN_HASH_VALUES for any poorly performed SQL_IDs.

Implemented RMAN backup strategy for all the database instances as per the business requirements.

For HPHC, there is no centralised repository for all the EBS SOPs, inventory. Prepared Documents for Inventory consolidation, created SOPs for the tasks needed and uploaded them to SharePoint.

Performed 11.2.0.4 to 12.1.0.2 database upgrade for all the EBS databases. In the process of upgrade, we prepared a clear high level and low level design documents with clear steps to be followed to upgrade the database to 12.1.0.2.

Migrated Oracle Apex from 10gAS to Weblogic on exalogic systems. Earlier, we have oracle apex installed on physical servers and now we have migrated Oracle Apex to Weblogic using ORDS in Exalogic environment.

Upgraded Oracle Apex from 4.2.6 to 5.0.4 on 12.1.0.2 databases.

Project # 2

Emerson Process Management

Client

Emerson(Onsite, Austin, TX )

Role

Sr.Oracle Applications DBA

Duration

Aug-2013 to Mar-2016

Environment

Solaris 10, Oracle Linux 6 EBS-11i, R12, database 10g, 11g

Responsibilities:

Working as a Sr.Oracle Applications DBA by being a part of performance tuning and Project Team.

Majorly working on performance issues related to EBS and normal oracle databases from APPS DBA perspective.

Activities include Project Management, System/Data Analysis, and Customer Interface for all the Business units.

Worked on the EBS databases of size 14 terabytes (TB) like data analysis, performance issues, approving the maintenance, critical downtimes.

By being a part of Process Management and operations group (PMO DBA), every maintenance, implementations, parameter changes, emergency or planned instance bounces and tasks needs to be technically reviewed and approved by PMO DBA group. Performed technical reviews as and when required and approved the tasks and suggested for any betterments in the plans.

Having good knowledge on oracle Golden Gate

Extensively worked on oracle Single Sign on implementation with Oracle EBS.

Worked on Golden gate implementation Project. Since Golden Gate is not able to replicate few of the objects and data types in E-Business Suite Environment, the project has been called off.

Extensively worked on Oracle E-Business suite upgrade projects like 12.1.3 to 12.2.4 upgrade. As a part of the upgrade prepared the technical architecture diagram, prepared high level design. Since R12.2 is new by the time we are implementing, raised SRs with Oracle support to get the latest updates on software binaries and implementation Process. Prepared pre-requisites, binaries installation, configuration, online patching enablement, ADX and TXK DELTA patches application, R12.2.4 RUP patch application to upgrade from R12.2.0 to R.12.2.4. Successfully finished the project and made R12.2.4 live in major 8 environments.

Well versed with R12.2 patching cycle process, cloning of R12.2 instance and did much iteration.

Prepared High level design documentation, understand the methodologies of R12.2.5 implementation, provided the server configuration information for procuring the servers and Implemented R12.2.5 instance for Emerson Process Management

At the time of migrations, there were many issues related to the performance in many of our instances. Identified the sql_id causing the slowness and tuned them by implementing sql_profilers, indexes and recommending them to rewrite the codes.

Prepared 11i to R12 upgrade process document and did POC for 11i to R12 upgrade, handled the up gradation of many ORACLE E-BUSINESS SUITE databases successfully along with project team.

Resolved issues related to concurrent program slowness.

Done several performances tuning activities in database as well as application.

Implemented RMAN backup strategy for all the database instances as per the business requirements.

Performed 11.1.0.7 to 11.2.0.3 upgradation of databases in R12.1.3.

Upgraded Oracle databases from 10.2.0.4 to 11.2.0.3, from 11.2.0.3 to 12.1.0.2

By Being Performance APPS DBA, recommended many apps as well as database level tuning tasks and implemented the same which helped business to improve performance.

At the time of migrations, design, Development team mistakenly dropped the database objects in the databases, recovered those objects from the recycle bin and helped the team to complete the projects on time.

Installed and configured ORACLE APEX on 11g databases and integrated Apex into WebLogic server by using Apex Listener.

Identified the root cause on the top growing objects and reduced the size by doing row movement, compressing of objects.

Performed and enabled the team to identify the candidates for re-org and scheduled monthly re-org for databases.

Did capacity planning and the service improvement plans (SIP) for the Oracle E-Business Suite and normal databases which enable the optimal utilization of resources.

Implemented ASM for all the databases. Did Capacity planning to procure the disks, provided the pre-requisite rpms to Linux Team and enabled the disks with Oracle ASM. Installed configured and migrated ASM and migrated the databases instances to ASM. Finished full cycle of ASM implementation successfully and provided support to instances.

Setup the load balancing for the application nodes by configuring the context parameters and by running the autoconfig.

Implemented oracle Fusion middleware (Oracle Weblogic) instances for many of the application instances and supporting them. As a part of this implementation, we did capacity planning, SIP and provided the hyper care support till the instances get stabilized.

Configured ORACLE Flash storage and reduced I/O in the system to enhance the performance.

Identified the bottle necks of the EBS instances in peak times and used to resolve such problem, so that the instance will work smoothly. If there is any modification needs to be done on code level, co-ordinate with the developers to enhance the code for optimal performance.

Resolved block corruption issues and recovered the databases.

Resolved the issues related to data guard and setup Data guard.

Been a part of the proof of concept work for up gradation of Oracle E-Business Suite from 11.5.10.2 to 12.2.4.

Trained the Team on Oracle E-Business Suite, ASM and Oracle Weblogic technologies.

Implemented Oracle E-Business Suite R12.2.5 for Emerson Application support group on Linux.

Approved the change, incident and service request tickets in HPSM as per the process

From PMO DBA side, worked on oracle security project to discuss the levels of security and the task involved and the risk mitigation in the process of implementing the security.

Below are the projects worked through WIPRO

Project # 3

Critical Infrastructure Virtualization(CIV)

Client

Southern Water Services LTD, United Kingdom(Onsite, Worthing UK)

Role

Technical Architect-Oracle Applications DBA

Duration

Aug-2012 to Jul-2013

Environment

Solaris 8, Solaris 10, oracle Linux 5, EBS-11i, database 9i,10g, 11g

Responsibilities:

Worked from UK and Involved in end to end Virtualisation of Southern water, UK environment from physical to virtual in CISCO UCS hardware. This virtualisation includes racking, stacking, connecting the FCOE to FI, installing the ESXI 5.1 on top of the blades, creating the data stores and resource pools, installation of database binaries and the performed the migration for 60 databases.

Prepared implementation plan for the Project and got it approved from the customer.

Prepared High level design for the Project which contains discovery phase, reduction in total cost of ownership, risk mitigation of end of life or unsupported hardware and software, modernization of current setup, testing and quality processes, deliverables, architecture summary, sizing, implementation plan and got it approved from customer.

Prepared Low level design which provides detailed information of the points in high level design which included the technical information of the implementation phase, details explanation of the proposed architectural design and got it approved from client.

Performed 9i database migration from Solaris 8 to 10 by using RMAN backups.

Performed bit conversion from 32-bit to 64-bit for 9i database using utlirp.

Once the databases are converted to 64-bit, migrated the databases from 9i to 11.2.0.3 database Solaris 10 by installing 11g binaries and catupgrd.

Performed cross-platform migration of Oracle 11g database from Solaris 10 to Linux 5.8 in virtual environment using Transportable table spaces methodology.

Prepared all the implementation documents like for the activities performed and got signoff from the customer.

Implemented DR setup for Southern water services which includes sizing, planning, documentation, POC and implementation.

Project # 4

COGNOS Warehouse Upgradation and Migration

Client

Southern Water Services LTD, United Kingdom(Onsite, worthing UK)

Role

Technical Lead- Oracle Apps DBA

Duration

Sep-2011 to Jul-2012

Environment

Solaris 8, Solaris 10, oracle Linux 5, database 9i,10g, 11g

Responsibilities:

Involved in end to end Virtualisation of Southern Water, UK environment from physical to virtual in CISCO UCS hardware. This virtualisation includes racking, stacking, connecting the FCOE to FI, installing the ESXI 5.1 on top of the blades, creating the data stores and resource pools, installation of database binaries and the performed the migration for 15 databases.

Prepared implementation plan for the Project and got it approved from the customer.

Prepared High level design for the Project which contains discovery phase, reduction in total cost of ownership, risk mitigation of end of life or unsupported hardware and software, modernization of current setup, testing and quality processes, deliverables, architecture summary, sizing, implementation plan and got it approved from customer.

Prepared Low level design which provides detailed information of the points in high level design which included the technical information of the implementation phase, details explanation of the proposed architectural design and got it approved from client.

Performed 9i database migration from Solaris 8 to 10 by using RMAN backups.

Performed bit conversion from 32-bit to 64-bit for 9i database using utlirp.

Once the databases are converted to 64-bit, migrated the databases from 9i to 112.0.3 database Solaris 10 by installing 11g binaries and catupgrd.

Performed cross-platform migration of Oracle 11g database from Solaris 10 to Linux 5.8 in virtual environment using Transportable table spaces methodology.

Prepared all the implementation documents like for the activities performed and got signoff from the customer.

oImplemented DR setup for Southern water services which includes sizing, planning, documentation, POC and implementation.

Project # 5

Maintenance and support of Oracle Applications 11i,R12 instance

Client

Sony Electronics Inc., San Diego (offshore, Bangalore INDIA)

Role

Technical Lead- Oracle Apps DBA

Duration

Apr-2009 to Aug-2011

Environment

Solaris 10, Oracle EBS 11i,R12, database 9i,10g

Responsibilities:

Identified the existing risks and presented the risk management sheet to the client and mitigated the risks.

Prepared Service improvement plan (SIP) for the instances and implemented the recommendations as per the SIP.

Worked as a Technical Lead and maintaining a total of 14 instances of RAC out of which 12 are 2 nodes RAC and 2 are of 3 node RAC.

Provided Hyper care support until instance gets stabilized.

Shutdown and startup of the RAC, ASM instances for DB and redundant ERP application servers.

Performed DB up gradation from 10.2.0.2 to 10.2.0.4 by using catupgrd.

Did a POC for 2 node RAC setup and got the sign off from the customer.

Performed 11i to R12.1.3 Up gradation.

Resolved issues related to huge concurrent programs queues.

Resolved issue related to XML publisher reports are warning out by identifying the root cause.

Resolved the issues related to Shared memory which effected workflow requests.

Cloned of the ERP from RAC environment to NON-RAC environment.

Applied the patches as and when required to fix the bugs.

Administered RAC instances using utilities like srvctl/crsstat and crsctl.

Handled day-to-day activities like creating users, granting and revoking roles, dropping users, creating synonyms, creating tablespaces, adding data files, general health check of databases, working with Oracle support for SRs

Performing applications Maintenance tasks using adadmin tools like ad-patch, auto-config, ad-admin, adctrl.

Project # 6

Maintenance and support of Oracle Applications R12 instance

Client

Chola DBS Bank (offshore, Bangalore, INDIA)

Role

Sr.Oracle Apps DBA

Duration

July-2008 to Mar-2009

Environment

AIX, Oracle EBS 11i,R12, database 9i,10g

Responsibilities:

Served as Oracle Applications DBA on a large scale Oracle EBS.

User account management - creating users, disabling users, responsibility management.

Managing concurrent managers - ensure system is running smooth, monitoring throughput, watch for long running jobs.

Performed adadmin tasks.

Performed Sysadmin tasks as per the requirement

Installed ORACLE E-BUSINESS SUITE - R12 (12.0.4).

Deploying new forms, reports, custom code to production environment

Patch Application to implement new feature and product specific bug fixes, family packs, and maintenance packs -- all types of patches – adpatch.

DB Refresh/Cloning of Oracle Applications using rapid clone as well as manual cloning.

Implemented Dataguard for the client.

Purging the frequently generated workflow data using Concurrent request periodically

Troubleshoot problems related to web server, web listener, forms server, concurrent managers, and database.

Upgraded oracle ERP system from 11.5.10.2 to 12.0.4(R12).

Configured Shared APPL_TOP by adding a node to the existing setup.

Scheduling the monitoring scripts like tablespaces health check, backup status, fragmentation, long runners, tracking performance issues.

Created DR setup for the Customer and performed DR DRILL as per the requirement

Troubleshoot issues related to cloning.

Performed Disaster recovery at the time of critical failovers by using the DR site and archive logs.

DB performance related activities like index rebuilding, space claiming activity and scheduling gather schema stats analyzing the tables for better performances

Resolved database cloning issues like db not coming up at the time instance

Performed DB recovery whenever recovery is required through RMAN

Performed import and exporting the data from one database to other as per the requirement.

Applying CPU patches quarterly as per the oracle recommendation.

Performed Block recovery at the time of corruption issue in DB.

Provided Year End support to the customer as an APPSDBA from client location as it is very critical to close the financial year smoothly.

Project # 7

Maintenance and support of Oracle Applications 11i,R12 instance

Client

Direct Energy, Addison, TX(offshore, Bangalore, Hyderabad INDIA)

Role

Sr.Oracle Apps DBA

Duration

Jul-2007 to May-2008

Environment

Solaris 8, Oracle EBS 11i, database 9i

Responsibilities:

Used to provide Checklist for the customer for the instance status especially month ends more frequently.

Managing concurrent managers - ensure system is running smooth, monitoring throughput, watch for long running jobs.

Performed adadmin tasks

Installed ORACLE E-BUSINESS SUITE – 11.5.10.2

Performed Sysadmin tasks as per the requirement

Copying new forms, reports, custom code to production environment

Administration by using AD Utilities

Patch Application to implement new feature and product specific bug fixes, family packs, and maintenance packs -- all types of patches – adpatch.

Performed M$LOG management for the instance.

Performed Workflow Table administration as per the requirement.

Refresh/Cloning of Oracle Applications using rapid clone.

Purging the frequently generated workflow data using Concurrent request periodically

Troubleshoot problems related to web server, web listener, forms server, concurrent managers, and database

Scheduling the monitoring scripts in Cronjobs to monitor concurrent users, sessions, tablespaces health check, locks, long running requests in the databases.

Performed Weekly COLD backup for the ERP instance.

Performed DB recovery whenever recovery is required through RMAN when there is a corruption in the database.

Documented tasks performed by our team with the Help of Team Members.

Designed prepared documentation and implemented DR site for the production databases.

Performed Cloning activity as per the requirement.

Troubleshoot issues related to cloning.

Perform DB related activities like index rebuilding, space claiming activity and scheduling gather schema stats analyzing the tables for better performances

Whenever there is a data loss, performed import and exporting the data from one database to other as per the requirement.

Educational Qualification:

B.Sc (Computer Science)-Acharya Nagarjuna University-2007-Andhra Pradesh, GUNTUR.

Contact this candidate