Rajesh Chadalawada

469-***-****

ac4la1@r.postjobfree.com

IT professional with over 10+ years of experience specializing in Oracle technologies. Capable of working remotely, onsite, independent or as a team player. Professional with deep expertise in Oracle Applications administration and Oracle High Availability, Clustering technologies using Oracle RAC, ASM, RMAN. Hands on experience in Data Guard. Proven record as Oracle applications Database Administrator and Oracle instructor for DBA, Data Guard and Backup & Recovery courses. Supported Data warehouse/Data mart instances to resolve performance issues, temp issues, managing de normalized tables, parallel processing etc.

Oracle Applications database administrator skills:

Over 10 years of Oracle Applications DBA experience in R12.2.5, R12.1.3, 11i(11.5.10/11.5.9) Financials, and Manufacturing, SCM, Inventory, Order Supply, Incentive Compensation, Healthcare, HRMS and Payroll applications install and upgrade.

E-business suite applications upgrade from 11.5.10.2 to 12.2.5.

Oracle database upgrade from 10.2.0.4 to 11.2.0.3 & 11.2.0.4 to 12c.

Experience in oracle applications cloning, multi-node to multi-node, multi-node to single-node.

Experience on database Instances and cluster databases in RAC (real application clusters) environment.

Support experience on oracle OPC (oracle open cloud) environments.

Expertise in adop (R12.2) patching cycle.

Experience in oracle enterprise SSO (single sign-on).

Install and setup WEBLOGIC server 11g (10.3.6), oracle application server.

Experience in oracle Demantra, Endeca and GRC with EBS.

Configured DMZ setup, JDK upgrade, and Monitoring performance using AWR, SQLT, OEM Installing and managing third party software.

Configure,Maintaining and troubleshooting Exadata machines

Experience in grid 11g/12c, Grid 12c upgradation.

Extensive hands-on experience in setting up multiple clusters and implementing Load Balancing, High Availability and Failover functionality.

Hands on experience with SYSADMIN tasks like workflow mailer, creating users, adding responsibility, creating menu, monitoring concurrent managers, profile options, creating concurrent program etc.

Extensively used oracle applications AD utilities like adconfig, adadmin, adpatch, adctrl, adsplice etc.

Securing oracle applications by periodically changing APPS and schema password using FNDCPASS.

Troubleshooting apps components like forms, apache and concurrent managers.

Managing system configuration by using AUTOCONFIG.

Patch analysis, providing technical instructions for patch, application in various test, development and production instances & documenting the same.

Have expertise in analyzing and applying CPU, PSU patches.

As part of support I did evaluate, test, and work with the Infrastructure group to deploy HR/Payroll maintenance and security patches as required.

Supported HRMS and applied all HRMS related patches.

Experience in database installations like 9i, 10g, 11g & 12c.

Working knowledge on shell/Perl scripting.

Hands on Experience in DR setup on UNIX cluster software HACMP and maintaining along with Oracle Data Guard.

Worked thoroughly on database backups/restore methodologies including: RMAN, hot and cold backups.

Experience in export, import & data pumps.

Database maintenances like create, modify, and drop schema objects.

Tracking invalid objects, compiling and validating the invalid objects

Created and maintained database users and Roles.

Experience in database patching & cloning (rman duplicate).

Refreshing development/test database from production.

Professional Experience

Appstek Corp Sep’16 – Till Date

Project: CDB ERP Implementation & OMCS Hosted EBS Support

Client: Veritas L.L.C

Role: Sr. Consultant

EBS 12.1.3 Implementation for Centralized Customer Data. This Data will be used by business and other systems which include OBIEE Hyperion and OMCS Hosted EBS Instance.

Responsibilities:

Install R12 (12.1.1) with 11.1.0.7.

Upgradation of Applications from 12.1.1 to 12.1.3

Database Upgrade from 11.1.0.7 to 11.2.0.4

Sanity Check and scheduling required cron to monitor and standard Programs for performance

Cloned New instance(QA) from gold instance with same architecture

CDB UAT instance built with wider footprint

Install Grid infrastructure(12.1.0.2) for RAC Configuration

Configuring ASM Storage for Database

Converting non-RAC database to RAC

Addition of two more application node to existing architecture

Configuring Load balancer

Configuring Parallel Concurrent Processing.

Golden Gate Installation

Configure uni directional replication from OBIEE/EBS to CDB Instance.

Installing Veridata

Configuring Veridata Agent.

CDB Prod built by performing RAC TO RAC Cloning

CDB Prod Go Live with 2 node RAC, 4 Node Applications, PCP, Load Balance and Golden Gate

Complete documentation for Implementation of UAT & PROD.

AppsTek Corp Feb’16 – Aug’16

Project: EBS Upgrade (Transactional & Configurator) from 11.5.10.2 to 12.2.5

Client: Laitram L.L.C

Role: Sr. Consultant

Responsibilities:

Create a cloned instance for cloning.

11g pre upgrade steps which include database and application tasks.

11g installation on 64 bit server for update

12.2. installation on 64 bit server to upgrade application from 11.5.10.2

Backup of instance to revert in case of any issue

Upgrade of database from 10.2.0.5 to 11.2.0.4(Manual and export/import)

Performing 12.2 pre upgrade steps.

Applying 12.2 Maintenance pack and troubleshooting, documenting issues.

Backup instance for rollback in case of any issue.

Enable online patching and perform pre R12.2.5 maintenance pack.

Apply R12.2.5 maintenance pack and validate.

Configure custom top using adsplice.

Configurator configuration.

Apply DB PSU patch and validate.

Take a Gold Backup copy and release instance to technical and functional team.

Oracle Corporation Sep’13 – Nov’15

Project: Oracle Managed Cloud Services (OPC – Oracle Open Cloud Team)

Client: 15+

Role: Technical Service Lead

Responsibilities:

Supporting oracle OPC (open cloud) environments.

Upgradation projects for multiple customers through oracle managed cloud services

Cloning instances for dry run purpose and doing multiple iterations.

ADOP online patching (12.2.4, 12.2.5, 12.2.6).

Supporting GRC, Endeca, Demantra instances.

Administer all WebLogic servers, domains, clusters in all environments: Production and non-Production.

Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 10g platforms.

Integrated Oracle Access Manager (OAM) 11g, OID 10g/11g on WebLogic 11g with OHS 11g web server.

Implement, Maintain and Troubleshoot WebLogic SSL/LDAP integration with SSO (OSSO 11g).

Troubleshooting e-business applications and database issues.

Performing Production assessment (PA) before go live.

Initiating Go live assistance Program (GAP) before 1 week of go live and till one week after go live.

Providing support for 1 month after go live which is considered as stabilization period.

Transition of Instances from Implementation phase to Production phase after stabilization period.

Project: 12.2 EBS Implementation

Client: Air Liquide

Role: Technical Service Lead

Responsibilities:

Validating the initial provisioned instance.

Applying patches using ADOP to reduce the overall downtime for patching.

Managing WebLogic server which is part of 12.2 architecture.

Managing RAC Instances for High performance and availability.

Planning and implementing Backup Strategy.

Space management, reorg and purging for better performance.

Oracle Database upgraded from 10.2.0.2 to 12.1.0.2

Oracle Database upgraded from 11.2.0.4 to 12.1.0.2

Applying latest CPU patches to keep instances secure and deliver optimum performance.

Cloning 12.2 instances for creating test and development environments.

Planning and working with customer in completing the tasks in given time lines.

Managing instance by performing space management, patching, monitoring performance.

Scheduling Calls with customer and management to keep team, management and customer in sync.

Performing Production assessment (PA) before go live.

Initiating Go live assistance Program (GAP) before 1 week of go live and till one week after go live.

Providing support for 1 month after go live which is considered as stabilization period.

Transition of Instances from Implementation phase to Production phase after stabilization period.

Hitachi Consulting Jan’12 – Aug’13

Project: Apps Support

Client: 16+ (Shared Pool)

Role: Senior Consultant

Engaged with 16+ clients to monitor troubleshoot and assist on project related tasks. Technical support and used in advisory roles for clients gathering requirements for upcoming projects.

Upgradations:

Upgrade E-Business Suite from 11.5.10.2 to R12.1.3

Trouble shooting of various issues that encountered during upgrade and after upgrade.

Cloning and Patching of Oracle applications.

Post upgrade Support.

Complete Technical documentation with flow and known issues.

Upgraded Oracle 9i database to 11g

Trouble shooting of various issues that encountered during upgrade and after upgrade.

Cloning and Patching of Oracle database.

Post upgrade Support.

Complete Technical documentation with flow and known issues.

Jindal Group Nov’10 – Jan’12

Project: 12.1.3 EBS Implementation

Client: JSW Group

Role: Database Administrator

Managed 6 Oracle Production Instances with RAC, ASM and their respective test and dev instances. Managed oracle core databases with 10g, 11g versions supporting different custom applications. Successfully created, tested & managed DR database. Worked on 2Node RAC Production support environment with PCP enabled and shared application file system. Recovered the standby database which was very much lagging from primary database. Database migration from file system to ASM and vice versa. Database upgradation from 10g to 11g, Upgrading Oracle applications from R12.1.1 to R12.1.3, Installation of ASM and 11g R2 grid control for the production database

Path Infotech Apr’07 – Oct’10

Project: 12.1.3 EBS Production Support

Client: LG Electronics

Role: Support Analyst

Responsibilities:

Installed and upgraded Oracle 9i to 10g databases at numerous client sites.

Data design and migration consultation.

Managing Oracle databases of more than 3.5 TB in size on AIX

Daily database refreshment for MIS instance from production

Cloning of 10g, databases depend on user requirement

Using Database utilities for 10g instance management

Sysadmin activities like user creation, managing concurrent manager, creating new menus & request groups, Using OAM, addition of new reports, managing profile values, printer configuration

Purging of historic data for better performance (concurrent requests, workflow)

Maintaining Standby database, Test database and Development database

RMAN full / Archive backup of databases

Basic database tuning.

Key Technical Skills

ERP

Oracle Applications (12.2, R12,11.5.10.2, 11.5.10)

Database

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

Tools

Golden Gate, Veridata, Export/Import, RMAN, Data Loader, OEM,

PPM (kintana), Data pump, FNDLOAD, Stat Tool, BMC Control-M, Appworx

Application Server

WebLogic

Languages

SQL, Shell scripting

Environments

AIX, HPUX, Solaris, Linux, Windows

Education

M.Sc. (Computers) from Nagarjuna University.

B.Sc. (Computers) from Nagarjuna University.

Contact this candidate