Oracle Manager

[pic]

[pic]

[pic]

[pic]

OBJECTIVE

To seek a challenging position as an Architect/ Lead DBA/SA. Managed all

aspects of database/System/Network architecture, Migration, Tuning,

Security/Compliance, Business Continuity & Disaster recovery using DB2,

Oracle, Sybase, Microsoft SQL, PostgreSQL and MySQL databases and managing

AIX, Solaris, Linux and Windows Environments. Extensive experience in OBI,

BOXI and Informatica Administration and Architecture.

. US Citizen with Active DOD TOP SECRET Clearance.

. Excels in developing and motivating highly focused teams

. Operational Leadership and Excellent Oral Communication Skills

. Extensive Knowledge of Business Continuity and Disaster Recovery

Planning.

. Configured Multiple environments with High Availability and Failover

capabilities.

CERTIFICATIONS and TRAININGS

. DB2 UDB OS/390, UNIX, Windows ER-Win Data Modeling

. Sybase 15 CISSP Trained

(Sch. 2014)

. MS SQL Server 2005 CCNA Certification Scheduled

in 2015.

. Oracle PMP

Trained

. Solaris Administration PostGresSQL 9.2 Training

. Oracle Database Administration Faculty @ Anna Arundel Community

College

TECHNOLOGY

System Administration/Hardware:

. AIX 6.1, Solaris 10, Vios 5.2

. Windows 2008,Centos, RHEV

. IBM Power 6 and Power 7, Data Power, Sun Sparc, 10K, E25K

. Cisco Catalyst 2900 Series Switches, 800,7200 Routers

. Clariion CX3-80, IBM DS4800

.

Databases (RDBMS)

. Oracle 11g, RAC 10g, 11g

. DB2 UDB 9.7

. Sybase 15

. MS SQL Server 2005,2008

. MySQL (2yrs)

. DB2 Z/OS, PostgreSQL 9.2

Data Modeling & DW Tools

. OBI EE 11g

. Informatica 9.5 (Power Center, Power eXchange) .

. BOXI R4, Microstrategy

. ER-Win, ER/Studio, InfoSphere

Application & Systems Support:

. IBM Web Sphere Suite, MQ

. IBM Content Manager, Documentum, Oracle Weblogic 10.3

. Rational Clear case, Clear Quest

. BMC Remedy,Jira,Puppet,Zenoss

. Munis and Nagios, VM Ware

. Oracle AS, OIM, OHS, OIM

. Solar Winds, Orion NCM

. HP Open View, Hobbit, Nessus

. Microsoft SharePoint

. Tomcat 6/7, Apache 2.2, IAS 7

Database & System Admin Tools

. Quest Central, Toad

. DB Artisan

. Tivoli, CA Products

EDUCATION

. Masters in Information Systems Stevens Institute of Technology, Hoboken,

NJ 2002

. Masters in Computer Science and Artificial Intelligence, 1995

. Bachelors in Electronics and Communications Engineering, 1993

Confidential/ Federal Clients, Fort Meade, MD& VA and DC Locations Jan-

2007 to Current

DBA Lead/Systems Engineer

. Installed multiple 10g/11g Oracle RAC with ASM at DOD and other

Clients.

. Administered and developed ETL Transformations in Informatica 9.5

. Supported BOXI in HA with Tomcat/Apache and Oracle RAC.

. Worked closely with DOD IA team to fix IAVA and Generated POA&M as

required.

. Supported DB2 DPF on 32 Node 50+TB Data warehouse.

. Designed and implemented Data warehouse environment (8 TB) on 4 node

RAC.

. Implemented Table Partitioning, Physical Data Guard for high

availability and disaster recovery in Oracle 11g.

. Installed and configures Oracle Web logic Portal Server 10.3 and SOA

suite.

. Involved in Hardware Refresh and installed Servers/SAN's, Security and

Firewalls.

. Supported 800+ Oracle/Sybase Prod Databases/200+ Servers in

Production.

. Designed and administered OBI EE 11g and Informatica Power Center.

. Administered Windows 2003/2008 Servers with LDAP.

. Managed Several AIX and Solaris servers and written Shell and Perl

Scripting.

. Implemented HA /Active Standby and migrate Oracle RAC to Postgres 9.3.

. Maintained and supported Informatica 5, OBIEE and Business Objects

with Jboss/Apache/Tomcat Setup.

. Involved in Security Scanning, Business Continuity Planning and

Network Security.

. Managed a group of SA/DBA/Network Admins.

CMS, DHHS Baltimore,MD MD Dec 2004 ~ Dec 2006

Sr. Database Admin. /Systems Admin

. Managed IBM Content Manager, TSM Server

. SQL performance tuning on DB2, Sybase and Oracle.

. Supported OBIEE and Web sphere Application Suites.

. Managed Several Solaris/AIX/Windows 2003 Systems.

. Involved in Capacity Planning and DR Planning.

Sprint / IBM. Overland Park, Kansas Dec

2004 ~ May 2006

DBA Lead

Managed a Group of 5 DBA's

Managed 200+TB database with 48 Partitions

Oracle Performance Monitoring and Recovery.

. Mentoring and knowledge transfer to other DBAs

. Set up and monitored Q Based Replication.

. Designed and Managed HACMP Cluster for Current Production Environment

with Mutual Takeover and Idle Standby Configurations.

. Installed and Troubleshooting of HACMP in AIX 5.3 and HMC

Freddie Mac, McLean, Virginia December

2003 ~ December 2004

Sr. Database Admin

. Provided operational and on call support for multi-terabyte (30TB+) DB2

EEE Data Warehouse (16 Nodes), Disaster Recovery using IBM PPRC.

. Involved with Database design using ER-Studio.

. Created Multiple Environments for Different Teams.

. Suggested and trained application developers about EEE and Broadcasting.

. Trained Programmers and testers on SQL Coding

. Supported Multiple Sybase and SQL Server Databases

Salomon Smith Barney / CitiGroup New York, NY May 1998-Dec2002

Lead DBA/DBA

Managed Central Database Admin's (DB2, SQL Server, Sybase and Oracle)

Promote dissemination of knowledge by having DBA's give presentations

Structured DBA support staff to reduce response time

Created internal DBA web site framework and templates that holds all DBA

related information thereby promoting dissemination of knowledge

Managed Offsite DBA's who would do Production Support and scripting, there

by effectively cutting the cost down and increasing the availability.

Migrated servers from Sybase 11.0.3 to 11.5 and 11.9.2

. Involved in SRDF Design using EMC Storage and Sun systems.

. Provided production DBA support for high profile financial apps.

. Installing, configuring and maintain DB2 UDB (EEE) on E10K.

Prudential Insurance Roseland, NJ

May 1997-May 1998

Database Admin

IBM Southbury, CT May 1996-

May 1997

DBA/PL/1 Programmer

Bank of Tokyo Mitsubishi/Singapore Network Services Aug1995-

May 1996

DBA/Cobol Programmer

State Department of Oregon Portland, OR Dec 1994-Aug1995

DBA/Performance Tuning Specialist

Keywords: DB2 UDB 9.5 Performance Specialist, EEE, DPF, Sybase 15,

Replication, MS SQL Server 2005, 2008, SSIS, BCP, SSMS, DHS Clearance,

HADR, HACMP, Oracle 10g, Federal/DHS, DoD TS/SCI Clearable, DHS Top Secret

Clearable, Unix, AIX, IBM, Z/OS, OS/390, DTS, EEE, Korn Shell, Perl, SQL

Tuning, MySQL, My SQL, Architect, ER-Win, RAC, Oracle 11g, Oracle ASM,

RMAN,CISSP, CCNA, Solaris, Solstice, VERITAS VM, VIOS, Power 6, Network,

OBI, Windows 2003

Kiran P. Gunnam

571-295-5DBA(M) ************@*****.***

Contact this candidate