Engineer Oracle

Title:Signals Intelligence Specialist Operator/LinguistRussian Linguist

************@***.***

Document

Source below

NAME:,

ADDRESS:

ADDRESS2:

CITY:

STATE: MA

ZIP:

CANDIDATE ID: 2918527

US CITIZENSHIP:

EDUCATION:

EXPERIENCE: 0

WILL RELOCATE: No -

JOB WANTED:

RATE NEEDED:

TELEPHONE: 781-***-****

EMAIL: ************@***.***

HOMEPAGE:

HOTTEST SKILLS: oracle, database, sql, unix, engineer, solaris, financial, software

engineer, sparc, product, client server, computer science, data modeling, nt4, programmer,

communication, market, sale, accounting, finance

REVISION: 08-SEP-02

RESUME:

NAME:

ADDRESS:

CITY: Malden

STATE/PROVINCE: Massachusetts

ZIP/POSTAL CODE: 02148

COUNTRY: US

EMAIL: Home: ************@***.***

PHONE: Home: 781-***-****

CANDIDATE ID:

CITIZENSHIP: United States

Citizen or National

EDUCATION: Bachelor Degree

EXPERIENCE: 3 Years

WILL RELOCATE: Maybe --

RELOCATION INFO:

JOB WANTED: Any

RATE NEEDED: Experience:

HOMEPAGE:

COMMENTS:

HOTSKILLS:

GAURAV SHARMA

181 Kennedy Drive #804

Malden MA 02148

Phone: 781-***-****

email:************@***.***

PROFESSIONAL SUMMARY:

5 years experience working as an

ORACLE DBA in Client Server Architecture

using

Oracle (8, 7.x), PL/SQL 2.0, ReportWriter 2.5, Forms 3.0,Forms 4.5, and

Pro*C

Experience in Data Modeling, Database design, Capacity Planning, Space

Management, Performance Tuning, Backup & Recovery and datawarehousing, VLDB

TECHNICAL SKILLS

Hardware : Sun Sparc2000,Sun Ultra 4000, Sun Ultra

6000, HP9000

Relational Database : ORACLE(7.3, 7.1, 7.0 & 6.0)

Oracle Products : SQL*Plus, SQL*Forms(4.5, 3.0, 2.3),

SQL*Report Writer(2.0),SQL*Menu(5.0), PRO*C(2.0), PL/SQL(2.0)

Operating Systems : MS-DOS, UNIX SVR 4.0, Solaris, Windows

NT,

AIX, SunOs

Parellel Architecture : Oracle Parallel Server 7.3 on Sun Sparc

Ultra6000 Cluster for Oracle Parallel databases

EDUCATION

BS

computer Science from Punjab Engineering College, Chandigarh India

MAJOR ASSIGNMENTS

May98

-Present

Company : CapGemini America, Cambridge MA

Position : Senior Consultant

Projects : Worked on the following two projects:

Nov, 98

- Feb, 99

Client : Proctor&Gamble

Role : ORACLE DBA

Environment : Oracle 8.0.4 on Solaris2.5

Hardware : Sun Ultra 2000, 4000

Part of a team of nearly 50 people working to implement a Common Data

Warehouse(CDW). The CDW has data from Market Measurements, Sales and Finance.

My

role was to provide various databases for Software development environment and

Schema design.

Responsibilities included:

Oracle Installation and Configuration

Common Database design for different areas of business

Generation of logical Raw volumes on shared disk Array

Disk Striping and Mirroring plans for database

Backup and Recovery plans implementation

Schema Management

Performance tuning of the database

July, 98

- Sep 98

Client : Proctor&Gamble, Scranton PA

Role : ORACLE DBA

Environment : Oracle 7.3.4 on WindowsNT4.0

Hardware : Compaq Prosignia

The project is to intall Oralce and set up Databases on Windows NT. These

databases are to be used for implementing Machine Vibration Analysis Software.

Responsibilities include:

Oracle Installation and Configuration

Creating the database setting privileges, user logins, passwords(security)

Backup plans and scripts

Performance tuning of the database

Capacity planning

May96

-May98:

Company : Netguru Systems, Waltham MA

Position : Software Engineer

Projects : Worked on the following two projects:

Feb, 97

- May98

Client : Fidelity Investments, Marlboro

Role : ORACLE DBA

Environment : Oracle7.3.2 with Parallel Server Solaris 2.5

Hardware : Sun Ultra 6000 Cluster, Ultra 4000

Part of a team of nearly 100 people working on a major migration project from

Legacy system to Oracle. My role was to provide software development

environment

and Certification environment. Oracle Parallel server Architecture is used on

Sun Ultra 6000 Cluster environment. The system has gone into Production with

150GB of database for OLTP and 300GB database for Warehouse.

Responsibilities included

Database design for OLTP and Warehouse system working in sync

Generation of logical Raw volumes on shared disk Array

Backup and Recovery plans implementation

Creating the database, setting privileges, user logins,

passwords(security)

Import and export procedure

June, 96

- Jan97

Client : Eastman Kodak, Rochester NY

Role : ORACLE DBA

Environment : Oracle 7.x on HP-unix

Hardware : HP9000

Responsibilities included

Oracle Installation and Configuration

Deciding the backup criteria

Implementing OFA(Optimal Flexible Architecture) for every database

Creating the database, tables, tablespaces, data objects, setting privileges,

indexes, user logins, passwords(security).

Defining users and assigning access rights

Backup scripts

Performance tuning of the database

Review of most SQL queries to the server from all the modules for performance

enhancement

Day Pager support

Jan 94

- May 96

Company : Punjab Communications Ltd, Chandigardh, India

Position : Software Engineer

Projects : Worked on the following two projects:

April 95

- May 96

Client : Punjab Financial Corporation, Chandigarh(INDIA)

Role : ORACLE DBA

Software : Oracle7.1, Forms 3.0, Pro*C, Unix

Responsibilities included

Installation and Configuration of ORACLE

Physical database design

Backup scripts

Creating the database, tables, tablespaces, database objects, setting

privileges, indexes, user logins, passwords(security).

Defining users and assigning access rights

Writing scripts for backup and recovery

Import and export procedure.

Working with development team for optimizing the table and index storage

parameters.

Backup scripts

Jan 94

- March 95

Client : Punjab Financial Corporation, Chandigarh(INDIA)

Project : Management Information System

Role : Programmer/Analyst

Software : Oracle7.0, Forms 3.0, Pro*C, ReportWriter 1.1, sql*menu

Hardware : HP9000

The Project involved the development of totally computerized Management System

for the functioning of Financial Institution. The scope of the project

included

design and development of Loan approval, disbursement, recovery along with the

integration of general accounting.

Responsibilities included

Development of Loan disbursement and recovery module.

Development of reports using Pro*C and ReportWriter 1.1

Loading the data from flat files using loader.

Unix Shell Scripts csh for cron jobs etc.

Contact this candidate