Manager Oracle

PRABHAT PANDEY

C/o V B Jantre, Bld No **,**,Shanti Nath Tower, Near Happy Home Complex,

Mira Road, Mumbai, INDIA

Cell: +91-982*******

Email:***********@**********.***

Professional Summary:

. 5+ years of total experience, encompassing a wide range of skill set,

roles and industry verticals.

. Experience of Client-Interaction on both off-shore and onsite

. Ability to quickly master new concepts, applications, strong

communication, creative and interpersonal skills.

. Proficient and strong database skills.

. Key Skills: ORACLE 9i,10g,SYBASE Unix [Sun Solaris, HP AIX]

ACADEMIC QUALIFICATIONS

. Master in computer Application (MCA) from IGNOU

. .P.G. Diploma in Computer Applications from IGNOU New Delhi.

. Advance Diploma In Computer Appliction.

. P.G. Diploma in Bioinformatics From Mysore University.

. Certified course in Computing.

. Bachelor in science from Purvanchal university jaunpur UP India

Languages : C, C++,Perl. VC++,PL/sql..

Database : Oracle8i,9i,10g,11g MYSQL,SYBASE

Operating System : Windows, Win NT, and UNIX Sun Solaris

(2.5/2.6/2.7/2.8), HP-UX v10.x/11.0, AIX 4.x,

Digital, 4.x/3.x), Linux Mandrake 7.x, SCO Unix

,WIPRO Winix

..

Client Side : Java Script, VB Script.

Scripting

DBA TOOL PL/SQL, SQL, PRO*C, SVRMGR, SQL*DBA, Import/Export,

SQL* loader, Oracle Enterprise manager(OEM), DBA

Studio, Unix Shell Scripts,, Unify 4.0,Forms,

Report Writer, Unix Shell Scripts, RMAN, UTLSTAT,

Explain plan & TKPROF, DB Artisan, Rapid SQL,

ERWin, Quest I watch, Quest SQLab Vision, Quest

SpotLight, T.O.A.D., DBVERIFY, SQL*Net V2,

Net8

Experience:

Wipro Technology Services Ltd (WTS),Mumbai

[Previously Citi Technology Services [CTS], Mumbai]

Senior Oracle Database Administrator

Jan 2009 - Till Date

Project: GDMG (Global database Management Group)

Client: GDMG provides single view to manage multi-legged banking

services over the structured products and applications which are

booked across various core systems for Citigroup Corporate Investment

Banking Technology, Citigroup Inc., the leader in investment banking

in USA. GDMG supports about 2570 PROD/CNTG/UAT/DEV servers and a

whopping over 25000 databases altogether located at 21 datacenters

globally. GDMG provides 24*7 support to all these servers.

We at GDMG provide level I and II support/ from our 24-7 Group line

and email. We not only support production servers but also support

CNTG, UAT and DEV servers with SLA achievement.

Role: Providing support in a highly critical enviournment . Support

for PROD/CNTG/UAT/DEV server. Successfully engaged in extensive

interaction with clients business users and Data Modular's frequently

to resolve database issues.. Rewarding experience of working in large

team environment, supporting databases on off-shore/ on-site client

delivery model. Responsible for handling shift as Shift lead. Involved

in providing to the point solution and support to the business

requirement using Oracle technology. Providing knowledge transfer to

new level I joiners. Making them familiar with work process and

enviournment. Support for COB/DR testing, DB migration,DB upgradation

etc.

Technology: Oracle 9i/10g, Unix, IBM Tivoli, Autosys, Putty Release

0.54,BMC Patrol, Shareplex.

Domain: Corporate and Investment Banking

Citi Technology Services [Offshore IT support for Citigroup Inc], Mumbai

Senior Technical Specialist [Oracle]

Jun 2007 - Jan 2009

Project: GDMG (Global database Management Group)

Client: Citigroup Corporate Investment Banking Technology.

. Role: Responsible for handling user requests and database

monitoring. Troubleshooting production job failures which

are scheduled on AUTOSYS,UNIX-cron. Database backup using

different backup policies,DDL Deployments and VTM patch

application on Oracle databases.

Technology: Oracle 9i/10g, Unix, IBM Tivoli, Autosys, Putty Release

0.54,BMC Patrol, Shareplex.

Domain: Corporate and Investment Banking

Four-Soft India Pvt Ltd, Hyderabad

Oracle Database Administrator

Aug 2005 - Jun 2007

Four Soft specializes in delivering world-class products and services for

the supply chain industry. Four Soft uses the power of leading edge

internet technology so companies can quickly and affordably realize the

full power and potential of the operations. With over 400 customers across

120 countries and 50,000 plus users, Four Soft is one of the top solution

providers in the supply chain domain

Project

Titile :e-Trans

Client : DHL

Role : Database Administartor

4S e-Trans: Multi-modal Freight Management System e-Trans meets all the

information

requirements of freight service providers in moving their customers'

shipments across various

geographical locations. It is a complete B2B enterprise application (ERP)

and handles all

operational, customer relations, financial, marketing and sales information

needs of Air, Ocean

Duration : Aug 2005 Jun 2007

Environment : Oracle 10G

Role:

> Installation and configuration of Oracle 10g (10.1.0.2.0) on Linux and

Windows NT server / 2000 server.

> Creating the Database Tablespaces, Redolog files, Database triggers

and indexes.

> Performing database backups on disks.

> Recovery of database when needed.

> Tuning SQL queries for optimal performance and tuning memory

structures.

> Applying patches and upgrades.

> Migrating from lower versions of oracle to upper versions.

> Managing the on-line redo log files. Creation of redolog members and

groups.

> Performance tuning of the database.

> Oracle client installation, SQL *NET connectivity issues.

> Resolution of day-to-day related issues, Documentation of Oracle DBA

routine tasks.

Project#2

Title : Esupply

Client : WT, Century

Role : DBA(Oracle performance Tuning )

Duration : Aug 2005 Jun 2007

These products used for maintaining and optimizing inventory for multi-

user, multi location Warehouses,useful in optimizing inventory, and

managing the vendors (VRM) and customers (CRM) of a Warehouse along with

regular Warehouse operations and will be very useful in cutting the

manpower costs and as well a useful in giving the whole picture of

inventory at any point of time. CRM (Customer Relationship Management)

gives the flexibility of raising the orders online by a customer and VRM

(Vendor Relationship Management) makes the order tracking easy for Vendors

so that to optimize the inventory and to cut the huge operational costs

involved in maintaining the inventory

Role

Data Guard Configured

> Configured Primary Database.

> Created physical Standby.

> Created logical standby

> Manage Data Guard configuration with Enterprise Manager Grid Control

> Back up the primary database with a physical standby database

> Back up a logical standby database.

> Switchover

> Failover

> Flashback Database after a failover

Celestial Labs Ltd Hyderabad.

May 2003 - Aug 2007

Project Requirement Analyst and Database Specialist

Celestial Labs Limited, a leading hyderabad based bio informatics company,

is all set to tap the capital markets with an IPO

Project: Sanjivani.biz.

Software: Windows NT,JSP .

Duration: Jan 2006 - Aug 2007 .

Synopsis:

Sanjivani.Biz aims to demonstrate the use of Information and communication

Technology and multimedia in the herbal industry. Through the information

that it provides hope to create a knowledge community on the herbal

industry, thus creating awareness into the industry. Also it would be used

to co-ordinate the industry in terms of providing information about R&D and

any scientific and non scientific information.. Sanjivani.Biz is a

dedicated web site portal solely on providing information and inputs on

herbs and herbal products with scientific data, market & trade data,

monographs, policy, conservation etc.

Major Functions involved are:

> Developed schema for the project.

> Logical & Physical Database Designing.

> Tuning applications using:

> Explain-plan/SQL-trace/TKPROF.

> Installed Oracle server-clients for the project.

> SQL tuning and database tuning was performed.

> Planned and implemented backup strategy of data in both archive and

non-archive mode.

> Managing Schema Objects - Tables, Views, Sequences, Synonyms, Indexes.

> Tuning databases involving Application, Memory tuning and CPU

utilization. Extensively

> used Explain Plan.reating indexes, rebuilding the indexes to improve

the performance.

> Developed various packages, database procedures, functions and

database triggers for backing up important tables.

Skills:

OS: Windows XP/2000, Unix/AIX

Database: Oracle

Tools: TOAD, Oracle Enterprise Manager, Putty, SSH Tectia

Specialization Domain

> Oracle 9i Database Administration on different UNIX flavors [Solaris,

HP AIX]

> Manage and support Production, 9i/10g.

> Administration and managing the Oracle Instance using custom scripts

and 10g Oracle Enterprise Manager (OEM) database control.

> Managing Logical Database Structure: Managing tablespaces, datafiles,

redo logs, tables and its segments.

> Maintaining data integrity also managing profiles, resources and

password security also Managing Users, Privileges and Roles.

> Initiate and interpret user and system session traces using TKPROF.

> Loading Data into Oracle Database: Export and Import.

> Performing backup and recovery using user managed backup such as

automated or manual cold backup and hot backup procedures.

> Performing Oracle 10g Data Pump Import and export utility.

> Usage of performance views and performance utilities using Explain

Plan and Statspack.

> Perform interrogation of system events, wait stats, lock and latch

activities and take corrective action based on analysis of these

activities.

> Determined possible backup and recovery strategies that would be

applicable for 24x7 situations protecting data loss.

> Utilize, managing and monitoring hot standby database using (Data

Guard) as well as monitoring primary database.

> Upgrading the Database from lower version to higher version and

Installation Patch and fix bugs.

> Performed Partition Maintenance activity.

> Performing REORG activity for tablespaces space management on

Production/UAT/Dev servers.

> Performed cloning of database.

> Responsible for fine-tuning production servers.

> Pinning of Packages, procedures and functions in SGA Use of recovery

strategy when required.

> Working Knowledge of load testing tool like web load, loadrunner,

opensta etc.

> knowledge of Oracle application Server 10g

> Working knowledge of Jboss 4.0 Server.

> Deployment of java application in different Application Server like

oracle Application Server 10g,jboss4.0,Apache etc.

Trainings:

ORACLE India Private Limited, Mumbai

1. Oracle 10g Grid Control

2. Oracle 9i Performance and Tuning.

3. Oracle Goldan Gat

4. IntroDuction TO Syabse Fundamental From Sybase

[pic]

Contact this candidate