Oracle Project

Krishna Kumar email : ************@*****.*** Phone : 858-699-

4309

EXPERIENCE HIGHLIGHTS

. More than 18 years of diversified experience in the IT industry, out of

which 14 years of extensive experience on Oracle Database and tools and

more than 9 years as Oracle Database Administrator.

. Worked at Qualcomm Inc., San Diego, CA as Senior DBA and Technical

Member for Oracle ERP Applications.

. Experience in installation/upgrade procedures of most of the Oracle

Database products for multiple releases on different hardware platforms.

In addition, familiar with Application/Development Administration tasks.

. Implemented Oracle 10g RAC, and evaluated various cluster technologies

such as Oracle Clusterware vs Service guard, Raw space vs File System,

ASM vs Standard database install etc...

. Implementation of Oracle Streams to Replicate Data to different remote

location to meet different business needs such as DR, HA,

Datawarehousing etc.

. Involved in Oracle ERP 11i implementation, initial setup & interfaces

with different third party and home grown application.

. Familiar with Oracle Applications 11i architecture and installation,

upgrade techniques

. 9 years experience in Oracle Database Administration. Very proficient in

DBA related skills such as Performance Tuning, Capacity Planning,

Backups, Disaster Recovery, Liaison with Software Vendors, etc.

Experience in Implementation, Installation, Maintenance, Upgrading of

Oracle Databases and variety of DBA/Developer Oracle and third Party

tools such as different versions of Symantec I3 suits and Enterprise

Manager.

. Expertise in Oracle networks, Statspack, Explain Plan, SQL Tracing,

materialized views, transportable tablespaces, Oracle ASM, RAC, and

DG

. Experience in Project Management.

. Developed and implemented corporate wide Databases standards and

enforced all the Database standards. Periodically Auditing all the

Database Standards across all Business Unit

. Good Experience in Physical and Logical Design of the Databases.

. Experience of Data Modeling using Case Tool

. Training Development Team and the DBA team on different new Oracle

Technology

. High Energy, Result Oriented team player with excellent inter-personal

communication and presentation skills.

. Designed Database and Application Release Process. Handling and

coordinating Application release process among different groups like

Users, Development Team and different Infra.

. At Database level, Designed many in-house application using the Case

tool.

. Ability to work after hours / weekends for planned and unplanned jobs or

maintenance jobs.

EDUCATION

B.S from Institute of Engineering and Rural Technology, Allahabad,

Post Diploma in Computer Application from I.E.R.T, Allahabad, India

HARDWARE

SUN Enterprise level Servers, SUN E6000/4500/Ultra, HP 9000, PRIME 2755,

PENTIUM/486/386 PCs

OPERATING SYSTEMS

SOLARIS 2.6/2.8, PRIMOS, SCO UNIX, XENIX, NOVELL 3.11, Different flavors

and versions of Microsoft O/S

SOFTWARE, TOOLS and UTILITIES

ORACLE ERP Applicationn11i, ORACLE Enterprise Database 10g, 9i, 8i, 7.3.x

(RDBMS), FORMS 6i, Oracle Enterprise Manager, SYMANTEC I3 ver 8.0,

Silverrun (Case Tool), ITG (Formerly known as Kintana), Designer 2000, SQL

Navigator, Designer and Developer 2000, SQL Loader, Oracle Export and

Import, Oracle Data Pump, Oracle Data Guard, Oracle Streams, RMAN, MS-

Office/Project/MS-Visio, INFORMATION (RDBMS), PowerBuilder 4.0

PROGRAMMING LANGUAGES

PL/SQL, COBOL, INFO/BASIC, FORTRAN, BASIC

Professional Training :

Data Modeling: Silverrun Case Tools

Oracle: DBA Basics, Oracle New features of different versions, Back and

Recovery, Oracle Performance Tuning, Distributed Database, ORACLE RAC,

Oracle Internals and many other Oracle based Training offered by Oracle

University

Other: PRIME O/S, INFORMATIN (RDBMS), NOVELL 3.11 etc.

PROJECT EXPERIENCE

Jenny Craig September' 08 - Till

Date

Carlsbad, CA

Worked as a Sr. DBA

. Installing, Configuring and Maintaining of Company's Database and

Database Infrastructure for their home grown application and the

Siebel application, running on Oracle 10g RAC (10.2.0.4) on Linux

. Developed and implemented corporate wide Databases standards and

enforced all the Database standards.

. Implemented Oracle Streams to meet different business requirement

. Implemented Database Monitoring using Oracle Grid control

. Involved in SIEBEL implementation, initial setup & interfaces with

different third party and home grown application

. Installed and Implemented Database Replication process, Setup and

maintain Standby database for recovery and other purposes.

. Database and Application tuning and provided support to the Developer

community for Application tuning. Used ORACLE 10g GRID and many third

party tools like TOAD, and all Oracle tools like TKPROF etc

.

Qualcomm Inc.

March'97 - May'08

San Diego, CA

Worked as a Senior DBA & technical member of Oracle ERP Applications

. Lead the efforts in "Prototyping"/Fit/Gap Analysis, Architecture

Planning, Customer approval for Oracle 10g RAC implementation.

. Lead the project and technical efforts involved in Oracle 10g Cluster

(RAC) implementation and upgrade. This project involved:

o Defined the strategies to migrate environments from Oracle 9i to

Oracle 10g RAC

o Upgrade infrastructure, single servers to multithreaded servers

with vPar and nPar

o Evaluated various cluster technologies such as Oracle clusterware

vs Veritas/Service guard, Raw Space vs File System, ASM vs

Standard database install etc...

o Defined the installation procedures to install Oracle 10g r2 RAC

o Perform various upgrades 10.2.0.2.0, 10.2.0.3.0 and CPU

Automated processes such as Database Monitoring and data Capture, Code

promotions, On-line table and index re-orgs, audits, audits, environment

refreshes from production and Application fail over

Architect, design, installation, configuration, and rollout of

varieties of engineering & business application on different version of

Oracle databases.

Involved in building environments on Database, Application, Form

Servers in Production, Staging, Integrated String and Development

Environments.

. Implemented Oracle Streams to meet different business requirement.

. Involved in maintenance of Database Replication process, Setup and

maintain Standby database for recovery and create Replica Database for

Reporting and publishing data on Information Highway.

. Installed Oracle Client/Server software. Performed numerous database

upgrades.

. Setup Oracle RAC environment for the Enterprise computing

. Designed, Implemented and enforced Database Standard across the Business

Unit

. Designing Application using the Case tool (Silverrun) for home grown

application and designed interfaces to different In-house developed

applications and third party applications.

. Database and Application tuning and provided support to the Developer

community for Application tuning. Used many third party tools like TOAD,

Symantec I3 and all Oracle tools like TKPROF etc.

. Involved in Development of fully automated Application and Database

Cloning procedure of Oracle ERP 11i using the ITG tool.

. Implemented Symantec I3 tool as a corporate wide Performance Tuning Tool

for the Databases and Application

. Configured OEM with repository and OMS on Solaris

. Configured and Installed Physical Standby at remote site for Disaster

recovery and load balancing and offload some of the database task from

Primary database using Data guard.

. Designed and Implemented database level security .

. Supported Business-unit development using ITG Case tracking tool

. Organized weekly meetings with customer, set and maintain expectations,

planning and communication for different Upgrades and new rollouts

. Supported, administered as a 7/24 DBA, VLDB databases

. Mentored new members of the Database Team

. Published weekly Database Matrix report for the higher management

. Recognized with various excellence awards

Motorola, Lake Zurich, IL Aug'96 -

Dec'96

(As a consultant)

Developed new reports and enhanced existing reports using Oracle Developer

for their Oracle ERP Application. Also developed various Bar-coded labels

using Zebra Printers. The database used was Oracle 7.3.4

TrailMobile, Charlston, IL Jun'96 -

Jul'96

(As a consultant)

Designed verity of Higher Management Reports using Oracle Report 1.1 for

the ERP, JIT, running on Oracle Database version 7.3

IFFCO, INDIA

Jun'90 - May'96

Payroll system :

Designed, developed, tested and maintained Payroll system, which was

completely in-house, first in COBOL to digitize manual systems. Work

included requirement analysis, database design, project planning, user

interface design and rollout. Later this has been converted and migrated to

RDBMS environment, INFORMATION which was a proprietary RDBMS running on

PRIME 2755 super mini computer. The 4GL language used was INFOR/BASIC

running on O/S PRIMOS. In 1994, the Payroll system was migrated to ORACLE

7.1 running on Novell 3.11 and PowerBuilder 4.0 as a front-end.

Materials Management System :

Designed, Developed and maintained Materials Management system, completely

in-house, first in COBOL to digitize manual systems. Work included

requirement analysis, database design, project planning, user interface

design and rollout. Later this has been converted and migrated to RDBMS

environment, INFORMATION which was a propriety RDBMS running on PRIME 2755

super mini computer. The 4GL language used was INFOR/BASIC running on O/S

PRIMOS. In 1994, the Payroll system was migrated to ORACLE 7.1 running on

Novell 3.11 and PowerBuilder 4.0 as a front-end. Also, trained user

community to migrate from the manual system to Computerized system.

Maintenance Management System :

Designed and Developed Maintenance Management System, completely in-house,

first in COBOL to digitize manual systems. Work included requirement

analysis, database design, project planning, user interface design and

rollout. Later this has been converted and migrated to RDBMS environment,

INFORMATION which was a propriety RDBMS running on PRIME 2755 super mini

computer. The 4GL language used was INFOR/BASIC running on O/S PRIMOS. In

1994, the Payroll system was migrated to ORACLE 7.1 running on Novell 3.11

and PowerBuilder 4.0 as a front-end..

Personnal Information System :

Designed, Developed and maintained Personal Information System, completely

in-house, first in COBOL to digitize manual systems. Work included

requirement analysis, database design, project planning, user interface

design and rollout. Later this has been converted and migrated to RDBMS

environment, INFORMATION which was a proprietary RDBMS running on PRIME

2755 super mini computer. The 4GL language used was INFOR/BASIC running on

O/S PRIMOS. In 1994, the Payroll system was migrated to ORACLE 7.1 running

on Novell 3.11 and PowerBuilder 4.0 as a front-end.

References: Shall be furnished on demand, if required

Contact this candidate