prashanth nandyala - sr oracle apps DBA

PRASHANTH NANDYALA

EXPERIENCE AND SKILLS SUMMARY:

Over 9 years of IT experience

Being a Oracle DBA/APPS DBA has worked on all releases of Oracle Applications 11i and RAC

Handled Migrations and Upgrade of Oracle Applications for various clients successfully within the allocated time and targeted Budget

Implemented SSO/OID - AD to OID and EBS to OID

Implemented Canadian French Language

Oracle installation, Database creation and Administration

Can effectively and efficiently handle any Implementations, Upgrade/Migrations of any Oracle Application Versions successfully within the stipulated timeframe and allocated Budget

Conversant with Upgrade Methodologies, Structural Designs

Implemented 11g RAC on Redhat ES 5

Implemented 10g RAC on Solaris 5.10

9i to 10g RAC upgrade on HPUX Itanium

Disoverer Upgrade from 4i to 10g

Implemented Oracle Enterprise Manager (OEM)

Worked on large environments

Implemented Data Guard (Physical stand-by database set up in production)

Implemented Apps 11i and 10gAS Portal integration (Portal , OID/SSO)

Experienced in database administration on Unix platforms

Skilled with developmental works and understanding of various business practices like Finance, Manufacturing, HRMS, Health, CRM etc

Good knowledge about Unix/Linux/Windows System Administration

Experienced in Tar tracking and remedy support

Excellent communication skills, dedicated and hard working in achieving the desired results

TECHNICAL SKILLS

Operating Systems: UNIX (HP-UX, Sun Solaris, AIX & Linux), MS DOS, and Windows (95/98/NT/2000AS)

Languages: C, C++, Perl, J2EE, XML, SQL and PL/SQL

GUI: Developer2000(Forms9i/6i/5.0/4.5,

Reports9i/6i/3.0/2.5)

RDBMS: Oracle 10g/9i /8i

Tools: SQL*DBA, Enterprise Manager, SQL*Net, RMAN, SVRMGRL, SQL*Plus, SQL*Report, SQL*Loader, X windows clients such as Exceed and Reflection, secured shells like PUTTY, Tera Term, F-Secure, pcAnywhere, RDA, VNC, SSH etc.

ERP: Oracle Applications (11.x, 11.5.x)

WORK EXPERIENCE:

Activision Blizzard JUL ‘08 – Current

Los Angeles, CA

Role: Oracle Database/Application Administrator

In-charge for maintaining and supporting various Instances 11.5.10 oracle application on RAC system and providing 24*7 support Design, Installation, Configure and upgrade of Databases Design, Installation and configuration of 11g and 10g RAC Cluster, ASM and Databases.

Providing Remote DBA Services to the Clients situated in USA, UK, Australia , France, Canada.

Instance planning from patch to production instances.

9i to 10g RAC upgrade on HPUX Itanium.

Implemented SSO/OID - AD to OID and EBS to OID

Implemented Canadian French Language

Discoverer Upgrade from 4i to 10g.

Implemented Oracle Enterprise Manager (OEM) and configured all the databases to it.

Cloning the Application Instances as per functional and technical requests from RAC to RAC and RAC to non RAC.

Maintaining stand alone databases on ASM.

Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.

Using Ring Master, SQL Backtrack, 10g OEM and Remedy software.

Upgraded Database from current version to 10g and 11g (From 8i,9i to 10g and 11g).

Troubleshoot problems with Concurrent Managers, All application Server Process and Database Performance.

Implemented 10g RAC on Solaris.

Recover databases and clone applications Using RMAN.

Installed Release 12 (Development stage not Production yet)

Applying patches in production and test instances, using AD utilities to maintain the integrity of the Applications and Database.

Day to day Application maintenance such as creating or modifying users, assigning Responsibilities to users, creating and running Request and troubleshooting.

Day to Day code migrations.

Creating custom responsibilities, request group, menus and concurrent program.

Tackling the user issues accessing Applications if any.

Taking care of backups of various instance that are critical for the new launches.

Registered different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports.

Resolved various Problems that occurred while re-linking the application executables and generating report files.

Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.

Creating the Users and groups in the O/S. Creating the NFS mounts in the system, setting up Printers on the Unix machines.

Interaction with Client and Oracle Support.

Administration of the Unix Operation Systems.

Provide the technical assistance to the developers.

Environment: Oracle Applications 11i (11.5.10) on HP-UX, Sun Solaris, Linux

Oracle Database 10.2.0.4 (RAC)

Vivendi Games Mar ‘07 – July 08

Los Angeles, CA

Role: Oracle Database/Application Administrator

In-charge for maintaining and supporting various Instances 11.5.10 oracle application on RAC system and providing 24*7 support Design, Installation, Configure and upgrade of Databases Design, Installation and configuration of 11g and 10g RAC Cluster, ASM and Databases.

Providing Remote DBA Services to the Clients situated in USA, UK, Australia , France , China, Taiwan

Instance planning from patch to production instances

Setup and managed custom application development environment to incorporate customizations into Oracle E-Business suite

Cloning the Application Instances as per functional and technical requests from RAC to RAC and RAC to non RAC

Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.

Most recently Implemented 11g Clusterware with ASM and installed the database on Redhat ES5

Upgraded Database from current version to 10g (From 8i,9i to 10g)

Troubleshoot problems with Concurrent Managers, All application Server Process and Database Performance

Implemented Data Guard

Recover databases and clone applications Using RMAN

Applying patches in production and test instances, using AD utilities to maintain the integrity of the Applications and Database

Day to day Application maintenance such as creating or modifying users, assigning Responsibilities to users, creating and running Request and troubleshooting

Day to Day code migrations

Tackling the user issues accessing Applications if any

Taking care of backups of various instance that are critical for the new launches

Resolved various Problems that occurred while re-linking the application executables and generating report files

Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files

Creating the Users and groups in the O/S. Creating the NFS mounts in the system, setting up Printers on the Unix machines

Interaction with Client and Oracle Support

Administration of the Unix Operation Systems

Provide the technical assistance to the developers

Environment: Oracle Applications 11i (11.5.10) on HP-UX, Sun Solaris, Linux

Oracle Database 9.2.0.7 (RAC)

WORK EXPERIENCE:

Diodes Inc Mar ‘06 – Feb 07

Westlake Village, CA

Role: Oracle Database/Application Administrator

In-charge for maintaining and supporting various Instances of Oracle Application 11.5.10 in the client which consisted of single and two nodes

Providing Remote DBA Services to the Clients situated in USA, China, Taiwan and Hong Kong.

Most recently Implemented Apps 11i and 10gAS Portal integration (Portal , OID/SSO)

Upgrading the Applications and Database from current version to the higher version (11.5.9 to 11.5.10.2) using maintenance patches

Troubleshoot Problems with Concurrent Managers, All application Server Process and Database Performance

Upgraded Jinitiator from 1.1.8.16 to 1.3.1.26

Implemented 10g RAC on Red hat ES4

Installed OCFS and configured ASM for the database storage.

Implemented Data Guard (Physical stand-by database set up in production)

Applying patches in production and test instances, using AD utilities to maintain the integrity of the Applications and Database

Day to day Application maintenance such as creating or modifying users, assigning Responsibilities to users, creating and running Request and troubleshooting

Creating custom responsibilities, request group, menus and concurrent program

Tackling the user issues accessing Applications if any

Configured load balancing on HTTP , Apache Jserv and forms layer

Taking care of backups of various instance that are critical for the new launches

Cloned the Application Instances as per functional and technical requests using the RAPID CLONE .

Registered different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports

Resolved various Problems that occurred while re-linking the application executables and generating report files

Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files

Registering the Custom Applications, installing the Custom Docs into Oracle Application

Installed Discoverer on the client machine and created the End User Access Layers

Creating the Users and groups in the O/S. Creating the NFS mounts in the system, setting up Printers on the Unix machines

Interaction with Client and Oracle Support

Administration of the Unix Operation Systems

Provide the technical assistance to the developers

Environment: Oracle Applications 11i (11.5.10) on AIX,

Oracle Database 9.2.0.6 and ADI 7.1.35

Creighton University Jan 05 -Mar 06

Omaha NE

Role: Oracle Database/Application Administrator

In-charge of the Oracle Applications and has lead the Upgrade on the Applications and database From 11.5.8 to 11.5.9

Tackling all the day-to-day issues as well as accomplished all the statutory requirements as required in the effective maintenance of Oracle Applications and the Databases

Applying family packs, Rollups, Minipack and one-off patches accordingly.

Cloning Oracle Applications experienced with different cloning skills like manual, adclone and Rapid clone.

Jinitiator upgrade from 1.1.8.16 to 1.3.1.21

upgraded 9i databases to 10g

Developed/maintaining the Backup and Recovery Strategies based on the Client requirement

Configured load balancing on HTTP , Apache Jserv and forms layer

Maintaining and troubleshooting issues with both Oracle Applications and the database

Installed Discoverer on the client machine and created the End User Access Layers

Installed Application Desktop Integrator ADI and created the Database Connectivity

Installed tools required by the end users like Oracle Clients SQLPLUS, SQL loader, TOAD etc

Creating SQL*NET server configuration files such as tnsnames.ora and listener.ora and starting the listener for making database available to users

Taking care of the unresolved Oracle User Issues

Keep in Synch with the Oracle Security Alerts

Administration of the Unix Operation Systems

Assisted the application development team in the functional and technical aspects

Altogether responsible for maintaining 2 instances of Oracle Applications and couple of custom Oracle Databases.

Environment: Oracle Applications 11i (11.5.9) on HP-UX,

Oracle Database 9.2.0.3 and ADI 7.1.23

Microfinance Information exchange inc Jan 04 - Dec 04

Washington DC

Role: Oracle Portal Administrator

Remote Installation and Administration of the 10g AS on Redhat Linux AS 3

Providing Remote DBA Services

Involved in the process of Export/Import of the database schema’s, Page groups, Providers from development instance to production instance

Involved in the process of Database Migration from MS SQL to 10g database using Oracle Migration Work Bench

Integrating applications on different operating platforms to Oracle 10g AS on Linux

Installation of Discoverer

Implement RMAN backup and recovery features

Installed tools required by the end users like Oracle Clients SQLPLUS, SQL loader, TOAD etc

Creating SQL*NET server configuration files such as tnsnames.ora and listener.ora and starting the listener for making database available to users

Managing Database (User management, Tablespace management, Performance related issues)

Controlling and monitoring user access to the database

Performance monitoring and tuning

Planning for backup and recovery of database

Creating, updating and monitoring TAR activities

Environment: Oracle10g AS, Oracle Discoverer, Toad, SqlNavigator,

Oracle Migration Workbench

Jacmel Jewelry Mar ‘03 – Jan 04

Long Island NY

Role: Oracle Database/Application Administrator

In-charge of the Oracle Applications and has lead the Upgrade on the Applications and database from 11.5.8 to 11.5.9

Involved in R11.5.9, 11.5.8, 9i and Tech-stack new enhancements end to end verification

Installation Testing

Tackling all the day-to-day issues for maintenance of Oracle Applications and the Databases

Applying family packs, Rollups, Minipack and one-off patches accordingly.

Cloning Oracle Applications experienced with different cloning skills like manual, adclone and Rapid clone.

Jinitiator upgrade from 1.1.8.16 to 1.3.1.21

Developed/maintaining the Backup and Recovery Strategies based on the Client requirement

Maintaining and troubleshooting issues with both Oracle Applications and the database

Installed tools required by the end users like Oracle Clients SQLPLUS, SQL loader, TOAD etc

Creating SQL*NET server configuration files such as tnsnames.ora and listener.ora and starting the listener for making database available to users

Taking care of the unresolved Oracle User Issues

Keep in Synch with the Oracle Security Alerts

Administration of the Unix Operation Systems

Assisted the application development team in the functional and technical aspects

Environment: Oracle Applications 11i (11.5.9) on Solaris

Oracle Database 9.2.0.3

CES Pvt Ltd Feb 01- Mar 03

Hyd,India

Role: Oracle Database Administrator

Installed Oracle 8.0, Forms Server, Implemented ODBC features

Created databases & objects, configured Forms server

Created additional table spaces, Rollback Segments, Redo log Groups for production support

Creating the web documents using Active Server Pages 2.0

Writing the front-end validation using the Java-Scripts/VB-Scripts.

Configured SQL*Net for Oracle

Created additional table spaces, Rollback Segments, Redo log Groups for production support

Implemented more effective backup procedures of databases

Created tables, views, Synonyms, DbLinks, Snapshots and Indexes

Allocated system storage and planned for future storage requirements for the database

Enrolled users, maintained system security, monitored user access to the database by assigning profiles and roles

Running the database on ARCHIVELOG Mode and Mirroring control files

Responsible for maintenance and trouble shooting the database

Performance monitoring and tuning

Used Data Definition Language (DDL) to create, alter and drop tables, Views, sequences, and indexes. Used Data Manipulation Language (DML) to issue SELECT, INSERT, UPDATE, DELETE statements including Sub-queries

Created different kind of constraints on table established Referential integrity between tables

Environment: : Oracle 8.0, SQL*Plus 8.0

ACADEMIC CREDENTIALS:

Bachelor Of Information Technology

Diploma Of Information Technology

Oracle Apps DBA

Oracle 9i Database administration

Personal Details:

Marital Status: Married

Age: 31 Yrs

Visa status: H1b

Contact Number : 310-***-****

Email Address : ***********@*******.***

Contact this candidate