[pic]

Lakshminarayana Kukkala

abik2n@r.postjobfree.com

Cell: 804-***-****

Profile

Lakshmi - SQL Server Certified Professional with project experience of SQL

Server 2008 and 2005 Administration and 9+ Years of Sr. Oracle Database

Administration experiences on 11g, 10g, 9i, 8i and 7.x for various kinds of

Applications such as Oracle, SAP and Costpoint on UNIX and NT Environments.

Well experienced in Unix admin IBM AIX 5.1, HP-UX 11.0, SUN Solaris 9, 10,

Windows-NT/2000/2003, and Linux 7.2 and Backup & Restore strategy with

RMAN. Over 14 Years of IT Working experience with proven background of

technical problem solving. A self motivated, and reliable team player with

a very strong technical skills. Perform database administration and

development on Windows/Unix/Linux servers for hybrid OLAP/OLTP systems and

Web applications. Worked knowledge of data warehousing and data mining

support. Experienced in business environments providing analytical

assessments on various projects with the US Army, US Marshals Service, CPB,

DLA and other government agencies

Status

US CITIZEN

Clearance

Current/Active DOJ Secret

Current/Active DLA-DoD Secret (IT-2)

Experience Summary

. 9+ Years of Oracle Database Administration with RMAN on UNIX and

Windows servers.

. Production Oracle Database 11g support for Federal department.

. SQL Server 2008 and 2005 Database Administration knowledge in SSIS,

SSAS and SSRS and crystal reports.

. Responsible for Installation and Management of Oracle RDBMS 11g, 10g

and 9i logical and physical database design on UNIX and Windows

environment.

. Maintaining the Oracle RDBMS for the Metadata for the Warehouse.

. Creating Logical and Physical Data Models for the EDW using

ERWIN3.5.2, VISIO2000.

. Hands on Knowledge of Project2007.

. Provided Oracle database administrative support.

. Installed, upgraded and patched Oracle software. Setup brand new

machines including Oracle software installation, Oracle side

configuration, third party backup software Legato troubleshoot and

backup testing.

. Managed and resolved design issues during development.

. Moved database Schema changes to stage or production.

. Migrated and upgraded databases from version 7 to 8i and 9i to 10g.

. Developed some Unix Shell scripts to automate database operation and

database monitoring.

. Developed or modified some Oracle backup and recovery scripts. Used

Oracle backup utility RMAN to implement Oracle backup and performed a

number of times of disaster recovery.

. Implemented database refresh with the hot backup using DUPLICATE or

full export. Used EXPORT/IMPORT using expdp/impdp utilities to do

table level and full database defragmentation.

. Performed database tuning using Explain Plan, hints,

utlbstat/utlestat, Toad, PowerExplain, and Enterprise Manager.

. Provided on-call production database support.

Skills:

Software

Oracle RDBMS 11g, 10g (from 4.0 to 9i),

SQL, PL/SQL, SQL Loader, EXP and EXPDP and IMP and IMPDP

Oracle Enterprise Manager, RMAN, TOAD 7.0, Erwin3.5.2, Visio2000

VAX COBOL, MS COBOL, RDB, DTR, FMS (Forms Management System)

Microsoft Office and Project, MS ACCESS, MS SQL Server2000, 7.0, JAVA,

XML, HTML

Business Objects, SAP Enterprise Portal 7.0 the Netweaver 2004s.

SAP R/3 ERP 2005,2004, ECC 600, 500, Enterprise 4.7, BI/BW 7.0/3.5,

KW, NW 2004 and 2004s, WAS 620, 3.1H, ABAP/4, BW - SEM 4.1, APO - SCM

4.0,

Legato Backup Scheduling, NETAPPs Backup, NetBackup From Veritas.

Hardware and OS

HP Superdome, UX-IA64

Sun Solaris / HP UX / SGI IRIX / Linux

Compaq & DELL Servers with Windows 2000, NT 4.0, 3.51, Syncsort Backup

Express

DEC VAX/VMS, MicroVAX VMS, VAX Mainframe, VAX5000 Series-Ultrix

IBM RS/6000 & P550, P570 AIX, AS/400 OS/400

IBM Storage DS6000, Brocade and AIX

Window NT workstation, Window 2000, Windows ME, WIN98, WIN95, Windows

3.1

DELL SAN Storage Array from EMC, Clariion CX400 with Storage Tech Tape

Library.

General Information

Diploma in Computer Software Technics - 1989

Diploma in Electrical Engineering - 1981

Professional Database Training:

SQL Server 2008 Database Administrator Certified - MCTS/MCITP

Oracle9i Database Administration Fundamentals II (For Release 2)

Oracle Database Administration, Tuning, Backup and Recovery from Oracle

Corp

Cost Point Database Administration from DELTEK

CP (Cost Point) Reports Administrator from DELTEK

RS/6000 AIX operating system Administration

SAP Professional Training Details

. EP200 SAP NW Portal System Administration Portal 7.0

. ADM200 SAP Web AS JAVA Administration

. ADM100 MySAP Technology Administration

. BC505 Database Administration - Oracle (4.6)

. WNAINT Certified in SAP R/3 Business Integration

. SAPTEC MySAP Technology Solution Overview

. SAP BASIS Administration, ABAP/4 under SAP/R3 on NT

Present Employment: MS-Inc

Customer US Marshals

Duration Since October 2009

Industry Federal

Project Description Perform database capacity planning; create,

administer and maintain databases; install and patch server software;

upgrade all databases to current 11gR2version; implement disaster recovery

strategies; perform database backup/recovery and replication (Data Guard);

perform application and performance monitoring and tuning; identify and

resolve any database problems proactively

Production Oracle 11g DB and SQL Server 2005 and 2008 support and

Management

Role Sr. Oracle DBA/ SQL Server DBA / UNIX, LINUX Admin

Responsibilities / Deliverables

. Installation and Administration of the Oracle 11g RDBMS database on

SUN Solaris, RedHat Linux

. Oracle Critical Patch Update (CPU)

. Schema and capacity and space management

. Upgrade and patch to current Oracle database 11g Release 2 version for

multiple servers on multiple OS platforms

. Assist and developed disaster recovery and a continuity of operations

plan.

. Support in developing oracle database security baseline for all of

ITD/DCO database servers

. Create RMAN scripts to run in CRON jobs for all production database

server to backup all database servers

. Enterprise Manager Console and TOAD application for management of the

database.

. Established process and procedures to utilize active dataguard within

a test environment

. Executed active dataguard on production to coop site implementation

plan

. Convert outdated, unsupported Oracle application server and database

server to current Oracle Fusion Middleware application server and

latest Oracle 11g Release 2 database within 1 1/2 month turnaround

. Perform data management tasks like loading, update, delete and restore

data requested by the client.

. Created multiple databases for various USMS projects include delta

documenting any security vulnerabilities, hardening oracle database

servers, and managing oracle database servers

. Installation and support of SQL Server 2005 and 2008 databases.

Professional History: Oracle DBA And SAP Project Experience

USS Consultants June 2008 - Sept 2009.

Customer Oakland Consulting for Defense Logistics Agency

Duration March 2009 to July 2009.

Project Description Implement the BPM, CTS+, SMD, and E2E RCA.

Role Oracle DBA and SAP Solution Manager Application.

Responsibilities / Deliverables

. Installation and Administration of the Oracle RDBMS Database on HP UX-

IA64 for SAP Solution Manager System

. Oracle security patch upgrades timely

. Schema and space management and Capacity planning for the environment.

. Troubleshooting of the database using the TOAD.

. Developed or modified some Oracle backup and recovery scripts. Used

Oracle backup utility RMAN to implement Oracle backup and performed a

number of times of disaster recovery.

. Implemented database refresh with the hot backup using DUPLICATE or

full export. Used EXPORT/IMPORT using expdp/impdp utilities to do

table level and full database defragmentation.

. Performed database tuning using Explain Plan, hints,

utlbstat/utlestat, Toad, PowerExplain, and Enterprise Manager.

. Provided on-call production database support.

. Configuration of the BPM, Solutions Manager with CTS+ . (and CHARM,

Central System Monitoring, etc.)

. Installation and Configuration of the SMD on Managing and managed

systems

. Presentation of the One of the BPM process to the management as POC.

. Defining the systems in SMSY

. Defining and Configuring the Solutions and projects in DSWP

. Kernel 185 and SPS 17 Installation in Production.

Customer CSC for Home Land Security.

Duration June 2008 to Feb 2009

Project Description SAP Enterprise 4.7, CRM 4.0 with Oracle 10g

and DB2.

Role Database Administrator for DB2 and Oracle 10g.

Responsibilities / Deliverables

. Installation of the Oracle RDBMS 9i on IBM AIX

. Management of the Oracle RDBMS for SAP Applications.

. SAP R/3 Upgrade from 4.6D to 4.6D_EXT, including the Oracle DB to 10g.

. Installation of SP Stacks for the NW 2004 and 2005s SP 16 and ERP 2004

and 2005 ECC 6.0.

. Posts upgrade activities including Spool management kernel upgrade

applying support packs and add-ons.

. Configured Business Process monitoring E-Learning and Roadmaps in

Solution Manager.

. Performed daily administrative tasks such as Alert Monitoring

Scheduling periodic jobs Background

. Processing Buffer Monitoring Database Monitoring Short Dumps and

System logs

. Defined the RFC connection's for the SAP systems in the landscape.

. Maintained Roles (PFCG) Client administration.

. Monitoring the automated mail alerts generated by RZ20 and RZ21.

Environment: Oracle10g on Sun Solaris, DB2 on AIX, NETAPPs for SAP

Enterprise 4.7 and CRM 4.0.

CACI Dynamics

Customer US Navy

Duration May 2007 to June 2008.

Industry Department of Navy

Project Description SAP R/3 4.6C

Role Oracle DBA and SAP Basis Administration

Responsibilities / Deliverables

. Installation and Administration of of the Oracle RDBMS 9i on IBM AIX

for SAP R/3 Applicaton

. SAP R/3 Upgrade from 4.6D to 4.6D_EXT, including the Oracle DB to 10g.

. Administration and supporting of SAP R/3 4.6c Kernel 4.6D landscape

. Installtion of Best Practices of Defense services, Client Strategy and

Administration

. SAP System Refresh and Post-Processing steps to configure.

. In charge of the monthly SAP Data Reduction projection to reduce file

system growth. This involved performing the necessary PRD Archive and

Clean-up Jobs, performing reorganization of tables, and schedule the

archive jobs for the PRD system. For example; Archiving using SARA for

MWO, Notifications, QMEL, Running programs to eliminate and reduce the

data - RBDCPCLR

. Administration of Inbound and Outbound Queue SMQ1 and SMQ2

. Administration of the database including Performance & tuning

. Upgrade of SAP Kernel, support pack SPAM/SAINT, OSS notes SNOTE

. Assisting the functional and Development areas.

ADJOINED CONSULTING

Customer Estee Lauder Companies, Melville, NY

Duration April 2006 to May 2007.

Industry Cosmetics - Retail

Project Description Retail industry SAP system management.

Oracle 10g, and 9i for SAP Environment.

Role Oracle DBA for SAP applications.

Responsibilities / Deliverables

. Installation of the Oracle RDBMS 9i and 10g on HP UX Super-dome.

. Oracle Schema and User administration for SAP environment.

. Capacity planning and Configuration assitant for the Oracle RDBMS for

SAP Environment.

. Installation, configuration and Administration experince with SAP

Portal 6.0 SP Stack 16.. Applied Support Pack 19 to Portal, ECC 5.0

Unicode System, BW 3.5 & 3.1, XI 3.0,

. Installation, configuration. Middleware Monitoring and

Administration experince with CRM 4.0, SRM 5.0, SAP SCM 4.0

Satyam Technologies Inc (ST Inc) - Sr. Principal Consultant

Customer Northrop Grumman Mission System - GCSS-Army/AT

Duration 4+ Years July 2002 - Sep 2006

Industry Aerospace & Defense

Project Description SAP R/3 Enterprise 4.7 ext 2.00, ECC 6.00, NW 640,

Solution Manager 3.1, BW 3.5, Enterprise Portal 6.0

Role Sr. Oracle DBA and SAP Basis/Netweaver Administration

Responsibilities / Deliverables:

. Oracle DBA support in Installation and Management

. Backup and Restore Procedures for the Oracle Database using Legato

backup Strategy.

. Installation and Management of Oracle RDBMS for different applications

with SAP.

. Enterprise Manager Console and TOAD application for management of the

database.

. Installation of Solution Manager3.1 on Sun Solaris 9

. Configuration of Transport, Domain Controller, Importing Transport

STMS, STMS_IMPORT

. Administration of the database including Performance & tuning ST02,

ST04, ST06, and DB13

. Upgrade of SAP Kernel, support pack using SPAM/SAINT, OSS notes SNOTE

Sato Travel, Sterling, VA Sr. Data Warehouse DBA 1 Years

Duration: Aug 2000 - Jan 2002

Involved in production, development, and acceptance database instance to

Install, configure and maintain. Responsibilities include design,

installation, configuration, tuning, and administration of Oracle RDBMS

8/8i and its products to create and manage all database environments.

Manage user security over all applications and role privileges to the

development teams. Perform database upgrades/patches whenever necessary to

fit application requirements. Load data biweekly from the production OLTP

systems into a star schema data warehouse (500 GB). Maintain Oracle

production database audit system, as well as encrypted security accounts

for top secret, external customers. Perform day-to-day DBA duties, as well

as use Erwin Tool and Visio 2000 in designing the database and data models.

. Knowledge of Oracle Server 9i

. Export and Import of the Database. Cold and Hot Backup solution using

Syncsort Backup Express.

. Unix Shell scripting for the Management

. MicroStrategy7 OLAP/DSS Tools for Data Warehouse Report.

o MicroStrategy Administrator (with Enterprise Manager) 7.1.3 to

administer and maintain the Metadata.

o MicroStrategy Architect 7.1.3 to create the projects.

. Maintaining the Oracle RDBMS for the Metadata for the Warehouse.

. Creating, Maintaining Schema (User) and objects and assigning Security

to the Schema.

. Creating and maintaining Table spaces.

. Bitmap Index on global and local creation and management. Table / Data

Partitioning - ETL Data Loading.

. Creating Logical and Physical Data Models for the EDW using

ERWIN3.5.2, VISIO2000.

. Creating and Maintaining SQL, PL/SQL, and Triggers Scripts, and

Packages.

. Hands on Knowledge of Project2000.

Environment: SUN Solaris, Dell Windows NT4.0, HP Open View

Biospherics Incorporated, Beltsville, Maryland Sr. Oracle DBA /

Architect 5 Years

Duration: Sept 1996 - Mar 2001.

Environment: Compaq, DELL, SUN Solaris, HP-UX, SGA IRIX.

Mastech Systems Corporation, Pittsburgh, PA Database Administrator 1.5

Years

Duration: Oct 1994 - Sept 1996

Worked as DBA Consultant with Biospherics, Inc. Involved in the

Installation of Oracle RDBMS and its products to create and manage

databases. Administered the user security and authorizations to the

development team. Performed day-to-day DBA functions. Worked as DBA

Consultant to Biospherics Incorporated.

Environment: Windows NT 3.51, Oracle 7.3.4, Compaq, DELL, SUN Solaris, HP-

UX, SGA IRIX

Contact this candidate