Oracle Customer Service

Oracle / SQL Server DBA

>

Satish Shrikhande

*** ****** **

The Edison Apts

Memphis TN 38105

Home : 901-***-****

Work : 901-***-****

Cell : 901-***-****

Email : abpin4@r.postjobfree.com

abpin4@r.postjobfree.com

Summary:

Above 6 Years of extensive experience in Database Analysis and Design, Performance Tuning,

Database Management .

Database Analysis and Design (User requirements, database functionality, logical and

physical design, data modeling. )

Performance Tuning (Improving response time, eliminating bottlenecks, increasing scalability,

reducing hardware and software costs, working with developers to improve the performance of SQL and PL/SQL. )

Database Management(Database architecture and design, installations, enhancements, patches,

monitoring, database rebuilding, backup/recovery, replication, capacity planning, troubleshooting).

Extensive experience to provide reliable, scalable, high-performing Oracle with oracle tools

like Oracle Server Enterprise manager. Expertise in Oracle 7.3/8/8i, SQL Server 6.5/2000.

Used oracle tools like Oracle Designer 200,PL/SQL Developer, Visio 2000(to create ER diagram for

an existing database) Extensive development and implementation experience in finance, Banking

and healthcare industry. Excellent communication and interpersonal skills.

Education: B.E. (Mechanical Engineering), 1998 with 71%.Year Degree College/School Percentage University/Board

1994-1998 BE(Mech)Kavi Kulguru Tchnology & Sci, Ramtek 71% Nagpur University

1993-1994 HSSC New English High Scoll Mohpa, Nagpur 63% M.S.Board,Nagpur

19911992 SSC New English High Scoll Mohpa, Nagpur 73% M.S.Board,Nagpur

Technical Skills:

Languages: Visual Basic 6.0/5.0, SQL, ASP 2.5, VB Script, JavaScript, and PL/SQL

Other : Visual InterDev 5.0, ActiveX, ADO 2.5, COM/DCOM, HTML 4.0, MTS, IIS 4.0,

Crystal Report, PL/SQL Developer, Oracle Designer 2000, Oracle Discoverer,

ODBC, OLEDB, MS Excel,MS Word

Databases: Oracle 7.2/7.3 / 8 /8i, SQL Server 6.5, MS Access

O/S : Windows NT/95/98,XP

Professional Experience:Mar 03 Present VP buildings, Memphis, USA Database Admin

www.vp.com

Nov 02 Mar 03 Patni Computers, Bombay India Sr. Software Engg

www.isi-america.com

Contribution:

Contribution:

Creates and maintains all databases required for development, testing, and production usage.

Performs the capacity planning required to create and maintain the databases.

The DBA works closely with system administration staff because computers often have applications

or tools on them in addition to the Oracle Databases.

Performs ongoing tuning of the database instances.

Install new versions of the Oracle RDBMS and its tools.

Plans and implements backup and recovery of the Oracle database.

Controls migrations of programs, database changes, reference data changes and menu changes through the

development life cycle.

Implements and enforces security for all of the Oracle Databases.

Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.

Puts standards in place to ensure that all application design and code is produced with proper integrity,

security and performance.

Provides technical support to application development teams. This is usually in the form of a help desk.

The DBA is usually the point of contact for Oracle Corporation.

Enforces and maintains database constraints to ensure integrity of the database.

Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

Assists with impact analysis of any changes made to the database objects.

Troubleshoots with problems regarding the databases, applications and development tools.

Create new database users as required.

Manage sharing of resources amongst applications.

Database Consolidation

Proactive database maintenance

Constant database monitoring and alert notification with Database

Minimized database downtime

Responsible for RAID Level 5 Configuration, Clustering

Responsible for creating a Report server (A small data warehousing project to avoid load on production server

because of heavy reports during business hours)

Migration Oracle SQL Server

Responsible for the SQL Server Physical database design, T SQL and programs

Creating scripts for Reports, Web development, Tuning SQL and PL/SQL for Report.

Jul 01 Nov 02 Bay Systems Pvt Ltd, Pune Program AnalystJan 01 Jun 01 Integral Strategies Inc, USA Consultant

http://www.isi-america.com

Project: Ventive Enterprise 1.0 www.ventive.com

Description: The product is developed for the consulting companies. This product consists of the following modules:

Timesheet module.

Expense module.

E-Mail module.

Time tracking module.

PDA module.

Consultant Database module.

HR Module

VConnect Module

HR XML Module

The main goal of this product is to allow the consultants to fill in the timesheets for a specified period.

Contribution:

Was responsible for the database design using Designer 2000.

Created database objects like Tables, Indexes, and Views, Synonym etc.

Wrote various complex PL/SQL programs Procedures, Functions, Triggers, and Packages.

Used various utilities of Oracle like JOBS, MAIL, Dynamic SQL, Backup And Recovery (EXPORT, and IMPORT)

INTERMEDIA to search for resume.

Was responsible for Network Administration, Performance and Tuning (Memory Tuning and SQL Tuning) used EXPLAIN PLAN,

TKPROF.

Developed various reports on client requirement, Used JavaScript for client side scripting and VB Script for server

side scripting.

Used PL/SQL Developer and TODD (Third Party Tool) for debugging the PL/SQL programs.

Environment: Oracle 8i Enterprise Edition, Designer 2000, Visual Basic 6.0, ASP, Visual Interdev, Java Script,

VB Script, COM, MTS, IIS, XML

May 00- Dec 00 Indus Software Pvt. Ltd., Pune, India

Project I: WEBCSM (Web Enable Customer Service Module) for Union Bank of Colombo, Sri Lanka

Description: The project dealt with the online application of loan from website. Various features are considered

like loan calculators, online applications, and forms downloading facility.

Contribution: Involved in analysis and designing of the database. Created the database objects like Tables, Index,

Views, Sequences, and Synonyms etc. Wrote complex PL/SQL programs. Wrote a Stored procedure, function, Triggers

and Packages. Used JavaScript for client side scripting and VB Script for server side scripting.

Developed components using Visual Basic 6.0 and registered it in MTS (Microsoft Transaction Server).

Was responsible for the onsite development and implementation. Documented and provided end user training.

Environment: Oracle 8i, Visual Basic 6.0, ASP, Visual Interdev, Java Script, VB Script, COM, MTS, IIS

Project II: LSI (Lending Solution) for Union Bank of Colombo, Sri Lanka

Description: The goal was to perform the activities like ICAPS, RMS, and Collection.

Contribution: Involved in the system study and designing of the database objects like Tablespace, Profiles,

Tables, Index, Views, Sequences, Synonyms etc. Coded complex PL/SQL programs. Wrote Stored procedures, functions,

Triggers and Packages. Used dbms_job for running the batch jobs. Wrote Dynamic SQL procedures. Used file

input/output features of Oracle to create customer reports. Worked on export/import utility for logical backup.

Used SQL*Loader for the data loading. Wrote test scripts and executed it successfully.

Environment: Oracle 8i,Oracle Discoverer, Visual Basic 6.0,COM, MTS, Windows 95, Windows NT

May98-Feb 00: Galaxy InfoTech Pvt. Ltd., Nagpur, India Software Engineer

Project I: Sales Order Processing System

Description: The package was developed to create huge opportunities to enhance services and to extend reach

to a National or Global market.

Contribution: Involved in designing of the database. Created the database objects like Tables, Index, Views,

Sequences, and Synonyms etc. Wrote complex PL/SQL programs. Wrote a Stored procedure, function, Triggers and

Packages. Other responsibilities included database administration activities like creating users, security,

roles etc.

Used JavaScript for client side scripting and VB Script for server side scripting.

Responsible for converting corporate data into business intelligence with Oracle Discoverer. Responsible for

designing Discoverer s end-user layer (EUL), the user interface.

Environment: Oracle 8, Visual Basic 6.0, ASP, Visual Interdev, ADO, JavaScript, VBScript, Windows 95/Windows NT

Project II: Material Management System

Description: The objective of this module is to computerize all internal and external operations of stores

and the purchase department.

Contribution: Designed and created database objects. Wrote PL/SQL blocks, stored procedure, functions,

Packages and Database triggers. Developed reports for the activities like purchase order, re-order level,

pending order, ABC analyses and economic order quantity (EOQ).

Environment: Oracle 8, Visual Basic 6.0, Windows 95/Windows NT

Contact this candidate