Oracle Manager

Vikas Krishna K K Oracle DBA/OracleApps DBA

Mob: (201) 417 - 5060

201-***-**** x 110

Summary of Skills

. 6 years of experience in Oracle 8i/ 9i/ 10g/11g as a DBA

. 4 years of experience as Oracle Applications DBA( Ebusiness Suite

11i/R12)

. Oracle Certified Master in Oracle 10g (Please visit

http://www.oracle.com/technology/ocm/vkrishna.html to see my profile)

. Experience in Configuring Oracle 11g/10g Real Application Clusters(RAC)

and Automatic Storage Management(ASM)

. Good exposure of Apps DBA tasks like Installation, Patching, Cloning,

Upgradation of 11i to R12 on Oracle Ebusiness Suite (11i &R12)

. Experience in configuring standby databases using Oracle Data Guard.

. Experience in Backup & Recovery, Disaster Recovery options and Oracle

Recovery Manager (RMAN)

. Experience in working with Grid Control, OAM (Oracle Application Manager)

and Oracle Enterprise Manager(OEM).

. Experienced in maintenance of small to very large database, OLTP, DSS.

. Good experience in client and user interactions.

. Experience supporting operational 24 X 7 production databases.

TECHNICAL SKILLS

Operating System Sun SPARC, Sun Intel Solaris, AIX, Linux(x86 &x86-64),

TRU64, Windows, IBM Linux on Power, HP-UX IA64, IBM

system z, HP-UX PA-RISC, ITANIUM

Hardware/Platforms AIX 5.2/5.3,Enterprise Linux 4/5, HP-UX

11.23/11.31,Linux x86-64, OEL 4.0/5.0,RH 4.0/5.0, SLES

9/10,Solaris 5.9/5.10, Windows Server 2003

RDBMS Oracle 8i/9i/10g/11g (Administration)

ERP Oracle Ebusiness Suite 11i/R12

Languages PL/SQL

Tools SQL *Loader, Toad, SQL Developer, Data Pump Utilities

(expdp/ impdp), Import/Export, RMAN, OEM,TKPROF,

STATSPACK,EXPLAIN PLAN, Oracle Apex(HTMLDB), Autosys,

Informatica, Citirix Server, Control M,TOAD,SQL

Navigator

Application/Web Oracle AS

Servers

Terminal Emulation Telnet, FTP, Putty

Monitoring Tools Homegrown scripts using PL/SQL, UNIX shell scripts,

Perl scripts, BMC Patrol

TRAINING AND CERTIFICATIONS

> Oracle 10g Certified Master (OCM) for DBA

> Oracle 10g Certified Professional(OCP) for DBA

> Oracle 9i Certified Professional(OCP) for DBA

> Oracle Applications 11i Training By Oracle University

> Oracle Application Server by Oracle University

> Oracle 10g RAC training by Oracle University

EDUCATION

Bachelor Of Technology in Information Technology (First Class) from

Madras University, May 2004

PROFESSIONAL EXPERIENCE:

Oracle Corporation Dec' 06 to Jan'

10

Oracle Apps DBA/Oracle DBA

For three decades, Oracle has been the center of innovation for enterprise

software-birthplace of the first commercially available relational

database, the first suite of Internet-based applications, and the next-

generation enterprise-computing platform, Oracle Fusion and Oracle's 55,000

global employees

Project:

. Was part of Database Certification Team, which certifies Different

RDBMS versions, and Oracle Database Technologies with Oracle Ebusiness

Suite

. Was part of Oracle On Demand Team supporting midsize customer

Databases and Oracle Application instances

Responsibilities:

. Performed Installation/Patching/Cloning with Oracle Apps (Ebusiness

Suite Release R12 and 11i) in various Platforms and Operating System

. Installed Apps in RAC and DataGuard Environment

. Upgraded Oracle 11i Apps to R12 instance

. Upgraded Oracle 11i Apps Database from 9.2.0.6 to 10g and 11g

. Performed Oracle Apps/Database performance Tuning

. Experienced in Shell Scripting

. Experienced in Implementing Database Security using Oracle Database

Vault

. Integrating Oracle E-Business Suite (R12,11i) with Oracle Database

Vault 11g (For Database Security).

. Experienced in Implementing Transparent Data Encryption TDE with

Oracle Ebusiness Suite

. Performed Migration of Databases between platforms using Transportable

Database and Transportable Tablespace

. Performed EBIZ System Admin tasks like Creating and Assigning Roles

and Responsibilities.

. Managed an Oracle Application Express (APEX,HTMLDB) Instance and

creating and maintaining few applications.

. Configured Split Tier Configurations (Database Tier Only) and Multi

Node Installations

. Experienced in usage of AD Utilities

. Hands on experience of Oracle 10g Real Application Clusters (RAC) on

various platforms.

. Configured and Implemented Load Balancing and Concurrent Processing -

PCP

. Installing, configuring and up grading Oracle 9i/10g/11g RAC

DB/Application Server AS.

. Performed ongoing assessment of database performance and

identification of problem areas using ADDM with AWR.

. Installed and implemented Oracle Grid control and agents. Performed

reactive administration and tuning on basis of OEM alerts.

Environment: Oracle RAC 11g/10g/9i,Oracle Ebusiness Suite

(11i/R12),AIX,Linux,Solaris,Windows,HP-Unix,Linux

Company : Wipro Technologies

Client : Deutsche Asset Management July '05

to Dec '06

Database Administrator

Deutsche Asset Management (DeAM) is the global asset management business of

Deutsche Bank AG, DeAM is one of the world's leading investment management

organizations in terms of the quality and breadth of investment products,

asset management expertise and client service. The offshore team provides

all the database activities, Batch support, Production releases and support

to the development team.

Project:

. Was part of production support(24x7) Database team

Responsibilities:

. Performed Creation and Maintenance of Oracle Databases as per the

requirement

. Performed Table space sizing and Index Management

. Performed Creation of Schema with Quota maintenance.

. Experienced in Export / Import of Tables, Schemas, Table spaces and

Databases

. Performed Frequent analysis of objects or schemas

. Experienced in Tuning with Statspack

. Experienced in Patch up gradation and applying security patches

. Performed scheduling jobs in Autosys using JIL

. Monitored Jobs status using Autosys and various alert tools.

. Monitored Alert Log errors and making necessary actions to rectify

them

. Experienced in developing and configuring Shell scripts as per the

requirement and automation.

. Involved in scheduling a backup plan using RMAN

. Performed Recovery of Database depending on various scenarios

. Performed Database refreshes/Cloning from production to

test/development environment

. Maintained FTP file transfer by a mechanism called AM Central which is

driven by shell scripts.

. Performed 24x7 Support of production Databases

. Worked closely with Application Developers/Functional

Developers/Design Engineers to resolve issues and provide technical

expertise in the development and definition of existing database

solutions employing sound systems development practices.

. Diagnosed and troubleshoot database problems and failures.

. Modified the database structure, as necessary, from information given

by application developers.

. Checked for Patrol and Control M alerts and resolved issues

accordingly

. Maintained Data Warehouse Databases

. Maintained batch jobs

Environment: Oracle 9i, AIX and Windows 2000

Company : Wipro Technologies

Client : RR Donnelley & Sons Company June '04 to July

'05

Database Administrator

RR Donnelley is the world's premier full-service provider of print and

related services, including document-based business process outsourcing.

The Database team supports various Production and Development databases.

Project:

. Was part of production support Database team

Responsibilities:

. Monitored databases by means of alert tools

. Performed Database refreshes/Cloning from production to

test/development environment

. Experienced in User Management and Table space sizing Management

. Experienced in Installation of Oracle and creation of Databases

. Experienced in Taking Hot/Cold Backups according to the user's

requirement

. Experienced in Taking Export/Import at full database level, Schema

level and Table level.

. Ability to code PL/SQL packages, triggers, functions, and procedures.

Strong ability to quickly understand the existing code base and make

modifications as necessary.

. Configured and monitored database backups with maintenance plans.

. Maintained tablespaces, rollback segments, data files, control files,

log files.

. Experienced in performance optimization of queries and database.

. Handled OLTP and Data Warehouse Databased

Environment: Oracle 9i/8i, Solaris, UNIX, Windows 2000

[pic]

Contact this candidate