SURENDRANATH REDDY                                                     surendranath99@yahoo.com

                415.225.2826 (mobile)

                360.323.6536 (fax)

______________________________________________________________________________

 

Summary

 

Ø       7 years of professional experience performing database administration, Unix system administration, programming and consulting.

 

Ø       4 years of experience as Oracle Applications DBA, which includes 3 years of experience as ORACLE Applications 11i DBA, with responsibilities like installation, upgrade, implementation, maintenance, production support, general administration, and performance tuning of ORACLE Applications.

 

SKILLS PROFILE

 

ERP Applications	ORACLE Applications Release 11i (11.5.1, 11.5.2, 11.5.3, 11.5.4,  11.5.5, 11.5.7, 11.5.8, 11.5.9), 11.0.x, 10.7 SC, 10.7 NCA   [Financial, Manufacturing and Supply Chain Planning, CRM, and HRMS ]
RDBMS	ORACLE 7.x/8i/9i, SQL Server 2000/7
DBA Tools	OEM 2.x, DBArtisan, Oracle Names Server, RMAN, OMNIBACK II Backup Utility,
Oracle Tools	Forms 4.5/5.X/6i, Reports 2.X/3.X/6i, SQL *Plus, TOAD, SQL Navigator, SQL Net 1.2/2.0, Net8, Import/Export,    SQL *Loader, 9iAS, AD utilities, Apache
Utilities	adpatch, adclone.pl, fndload, adident, adadmin, adaimgr, adctrl, adcfgclone.pl, admrgpch, adsplice, adlicmgr.sh, autoconfig.sh,
Hardware	Sun E5000, Sun 690, Sun E450, HP 9000 Servers and                                                   Workstations including L, N, and V Class Servers, Intel
Programming Languages	SQL, PL/SQL, Pro *C, UNIX Shell Scripts, Java,                                                    C++, Java Script, Schell Scripting
Operating Systems	UNIX, Solaris 9/8/7/2.6, SUN OS, HP-UX 10.2/11/11i, AIX, Windows NT/2000/XP, Windows Me/95/98, MS-DOS
Management /Leadership Skills	Effective in small to large teams, Mentored team members, Planning and Implementing Software Upgrades, and new product installations.

 

 

Education

 

• Master of Science, Indian Institute of Technology, Kharagpur, India.

Acquired University Grant Commission scholarship.

 

• Bachelor of Engineering, Osmania University, Hyderabad, India.

 

 

Training:

Oracle Technology Based Training:

·         Oracle 8i Database Administration

·         Oracle Applications 11i: Flexfields

·         Oracle Applications 11i: System Administration

 

 

Certification:

 

·         OCP: Oracle 8i SQL & PL/SQL

·         OCP: Oracle 8i Architecture & Administration

·         OCP: Oracle 8i Backup & Recovery

·         OCP: Oracle 8i Network Administration

·         SUN: Solaris 8 System Administration Part I

Oracle University for Partners Certification

o        Oracle 9i Technical Champion

o        Oracle E-Business Suite Technical Champion

o        Oracle E-Business Suite Implementation Champion – Applied Technology

 

 

 

PROJECT EXPERIENCE:

 

1) Medela, McHenry, IL                                                                                                            Jul’2002 to till date      

 

Role: Senior Oracle Applications DBA

 

Responsibilities:

 

• Installation, Maintenance and cloning of Oracle Applications 11.5.8
• Helping the Customer for smooth Go-Live with 24X7 Support
• Performance Tuning of Oracle Applications
• Migrating Custom Menus, Responsibilities, Request Groups from Development to testing and finally to production.
• Integrating Custom reports and forms into Oracle Applications
• Enabling field and block security using CUSTOM.pll
• Writing ALERTS for notifications as per the Customer Requirements

 

2) Solectron Corporation, Columbia, SC                                                     Jun’2002 to Jul’2003       

 

Role: Senior Oracle Applications DBA

 

Responsibilities:

 

·         Responsible for upgrading from the Oracle Applications 10.7 to 11.5.7 for Financials and Manufacturing suite.

·         Configured Workflow 2.6 and Workflow Mailer

·         Extensively used the Oracle Applications troubleshooting scripts and tools to resolve issues.

·         Involved in setting MultiOrg.

• Worked closely with Developers in resolving bugs and migrating customizations from 10.7 SC to 11.5.7
• ERP Applications printer support, concurrent manager support and monitoring
• End-user technical support and troubleshooting

·         Provided hardware and database sizing assistance

·         Responsible for Database Upgrade & Migration from Oracle 7.3.4 on NCR UNIX to 8.1.7.4 on Solaris 8.

·         Responsible for pre-install analysis, activities, and installation of 8.1.7 software on server, and post-install testing and analysis.  

·         Resolved issues with the installation and upgrade process as they appeared.

• Provided application System Administration function as needed.
• Patch Management and documenting patch spreadsheet.
• Upgrading Jinitiator from 1.1.8.13 to 1.1.8.19.

 

 

3) E R MOORE / Big Orbit Solutions, Chicago, IL                                                  Jan’2002 to Jun’2002

 

 

Role: Tech Lead Applications DBA

 

Responsibilities:

 

• Instance Management (11.5.4 Oracle Applications, HP UX 9000)
• Installation, Maintenance and Cloning Applications
• Responsible for HP UX 11.11 System Administration.
• Upgraded Oracle Database from 8.1.7.1 to 8.1.7.3
• Backup & Recovery Strategy and Recovery Manager Implementation
• Patch Management and documenting patching spreadsheet.
• Participate as part of a team providing 24X7 support.
• Monitoring and tuning System performance
• Mentoring others in the team for setting up security, printer configuration, patch research and maintenance.
• Cross train with other DBA’s and System Administrators on the team.

 

 

4) KPMG/ACNielsen, Chicago, IL                                                                      Jul’2001 – Dec’2001

 

Role:  Senior Database Administrator

 

ACNielsen is a research data services company that helps manufacturers and retailers gain critical insights into their business, their competition and their consumers.

 

Responsibilities:

 

·         Installation, configuration and maintaining of Oracle Applications 11.5.3 on Sun Solaris 8

·         Upgraded Oracle Applications from 11.5.3 to 11.5.4 and Oracle database from 8.1.6.3 to 8.1.7.1

·         Implemented Oracle Enterprise Manager 2.2 for managing Oracle Applications 11.5.4 Database

·         Apply patches and patchsets including Family Packs for the applications (AP AR CE CZ GL INV PO OE ONT QP WIP WSH MRP DRP) and documenting the patching spreadsheet.

·         Involved in Implementation of Forms Load Balancing on Oracle Applications 11.5.4 Production Environment

·         Monitor system performance and tune when applicable

·         Work with Oracle by logging software bugs/ problems, enhancement requests and mass changes

·         Participate as part of a team providing 7x24 support.

·         Develop documentation relative to technical aspects to facilitate current support, development, upgrades and migrations

·         Configured Work Flow Mailer to receive notifications of outstanding work items and respond to those notifications using their E–mail application of choice

·         Worked closely with Configurator Developers in resolving bugs and migrating Configurator data from one instance to the other

·         Conducting Sizing/Capacity Planning efforts for the ORACLE Database and Applications

·         Involved in developing application architecture and participate in overall technical architecture design

·         Involved in developing disaster recovery and business continuity plan

 

5) Avasta Inc, San Francisco, CA                                                                      Jan’2001 – Jun’2001

 

Role: Senior Database Administrator

Avasta provides applications management, monitoring and support for custom and enterprise software.

Responsibilities:

·         Installation & Maintenance of Oracle Applications 11.0.3

·         Involved in Upgrade of Oracle Applications 11.0.3 to 11.5.2.

·         Configured Multi-Org & Multiple Reporting Currencies.

·         Installation and Maintenance of Oracle 9i Server on Sun Solaris 2.8

·         Implementation of Oracle Enterprise Manager for managing Oracle Databases

·         Installation of Oracle Server, front-end tools Developer 2000, Discoverer 2000, and Oracle Enterprise manager.

·         Monitoring multiple databases using HP Open View and trouble shooting the alerts thrown by DBSPI.

·         Documenting Installation, maintenance, backup, recovery and other maintenance procedures.

·         Recover Manager Configuration with HP OMNIBACK II for Multiple databases and automating the daily, weekly and monthly backups.

·         Data modeling using ER Win

·         MC Service Guard Implementation to Oracle Applications for Fail Over

·         Backup and Recovery, Database Tuning, Query optimization and establishing Client Server connectivity.

·         Shell scripts for automatic startup and shutdown of databases as well as automated backups.

·         Apply patches and patchsets including Family Packs for the applications (AP AR CS INV OE FA PO BOM CRP MFG MRP PA PAY PER QA WIP) and documenting patching spreadsheet.

Pay Map

·         Installation and Maintenance of Oracle Applications 11.5.3 (AP AR CE FA GL PN) on Sun Solaris 2.8

·         Upgrading to Platinum Environment, to provide a near fully patched environment up to the latest patch level.

·         Installed Omni Back agents on Solaris server and integrated with Recovery Manager Configuration.

·         Trained customer in setting up Application Desktop Integrator & troubleshooting.

·         Configured DBSPI agents in all production, test and development environments to monitor through HP Open View.

·         Applying patches to development, test and Production environments.

·         Refreshing Test Environment regularly from the production environment.

 

6) People PC, San Francisco, CA                                                                              May’2000 – Jan’2001

 

Role:  Database Administrator

 

Responsibilities:

 

·         Installation of Oracle Applications 11.5.1 on HP UNIX 11.

·         Migration of Oracle Applications data from Sun Solaris to HP UX 11

·         Upgrading to Oracle Applications 11.5.1 to 11.5.2 on HP UX 11 platform

·         Installing Configuring and Supporting  Self Service purchasing on 11.5.1.

·         Upgrading Self Service Purchasing 4 to Self Service Purchasing 5 (iProcurement).

·         System administration activities (Managing concurrent managers, Creating of users, customizations and printer installs)

·         Documenting complete installed architecture and all issues logged with Oracle Support.

·         Conducting Sizing/Capacity Planning efforts for the ORACLE Database and Applications

·         Cloning and refreshing Environments from production to Test

·         Configured MC Service Guard (Fail Over) on Production environment.

·         Regular monitoring of applications & database and tuning when applicable

·         Apply patches and patchsets for Applications (AP AR ALR BIS CE FA FII GL INV ONT PO SSP WSH) and documenting patching spreadsheet.

 

7) CySphere.com, Hyderabad India,                                                                    Dec’1999 – May’2000

 

Role: Database Administrator

 

Responsibilities:

 

·         Remote administration of Oracle 8 web Casino Databases on Sun Solaris 2.7 (Luckyland, Megaplay, BigCat, planetluck, Zantana, StarLuck)

·         Upgraded Casino Database of size 120 GB from Oracle   7.3 to 8.0.5 running on Solaris 2.7.

·         Developed distributed database environments between different Oracle servers.

·         Optimized INIT.ORA parameters to best utilize the new system’s resources.

·         Involved in Installation of Oracle Web Application Server 3.0 and writing reports and stored procedures.

·         Designed and developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

·         Implemented nightly backup routines, which include database exports, tape backups

 

 

8) ICFAIN Center for Information Technology, India,                                    Feb’1999 – Dec’1999

 

Role: Database Administrator

 

Responsibilities:

 

·         Installation and Maintenance of Oracle Applications Release 11.0.2 on Sun  Solaris 7.

·         Automated backup procedures for Production, Test and Development environments

·         Responsible for development and customization of reports.

·         Performed the duties of Oracle Applications system administrator.

·         Optimized INIT.ORA parameters to best utilize the new system’s resources.

·         Developed distributed database between different Oracle servers.

·         Provided training to developers in writing and tuning PL/SQL stored procedures.

 

9) Indian Institute of Technology, Kharagpur                                                   Aug’1997 – Dec’1998

 

Role: Systems and Database Administrator

 

Responsibilities:

 

Tasks accomplished are

 

• Created database links and Snapshots to update corporate database for billing purposes.
• Designed and developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Install Oracle 7.2.3 on SCO-Unix server. Establishing SQL*Net V2 between SCO UNIX Box and Windows-NT Workstations using TCP/IP Protocol.
• Automated Backup shell scripts for incremental and full backups on a daily, weekly and fortnight basis and   involved in Media-Recovery Procedures of ORACLE Database
• System maintenance, and performance tuning
• Installation of Solaris 2.X and SCO 5.X, and Windows NT 4.0
• Configuration of DHCP, DNS, MAIL, NFS, NIS+ servers
• Customization user and system environments in the Systems Laboratory         
• Configuration of File Systems and automation of jobs (Cron, at)
• SCO-Unix with WIDE-SCSI-RAID controller with Level-5 option for fault-tolerance and maximum throughput.

 

                                                                                                         

10). Visaka Industries Ltd, Hyderabad, India                                                      Jun’1996 – Jul’1997

 

Role:    Programmer/DBA

 

Designed the logical and physical Models of the database, written stored procedures, functions, packages and database triggers. I was also responsible for DBA activities such as application tuning, backup, creating new database users and also created the database scripts for the application.

 

Environment:                 Novel NetWare 3.12, Oracle 7.X, Developer 2000 (Forms 4.5 & Reports 2.5)

 

 

References:

Available up on request