Title:Senior DBA

abpb3d@r.postjobfree.com

Document

Source below

NAME: Saiprasad V

ADDRESS:

CITY: Edison

STATE/PROVINCE: ON

ZIP/POSTAL CODE:

COUNTRY: USA

EMAIL: abpb3d@r.postjobfree.com

PHONE: 732-***-****

CANDIDATE ID: 196622

CITIZENSHIP: US

Citizen

EDUCATION: Technical Institute

EXPERIENCE: 2

WILL RELOCATE: Open

RELOCATION INFO: Any

JOB WANTED

: Any

RATE NEEDED:

HOMEPAGE:

HOTSKILLS: ORACLE AND OTHER

ESUME

V. SAIPRASAD

732-***-****

abpb3d@r.postjobfree.com

SUMMARY

Has over Eleven years of experience in Database installation, administration,

design and development in the Oracle (7.0,7.3,8.0 & 8i versions), Oracle

Financials 10.7, 11i on Unix and Win NT Platforms, primarily in the Business

Applications area. Have maintained databases with size over Terabytes.

Expertise on various software and hardware platforms including Windows 95, HP

Unix, Sun OS 5.7 (Solaris 7) & 5.8, SCO Unix and on Xeon processors. Has in-

depth knowledge of Oracle 7.3.3, 8.0 & 8i, Oracle Financials 10.7, 11i with

Developer / 2000, Erwin 3.5.2, Advanced Replication, Partitioning and Oracle

Certified Database Administrator for Oracle 7.3, Oracle 8.0 & Oracle 8i. Has

sound knowledge on Data warehousing. Has done SQL Server Replication with

(Merge & Snapshot).

TECHNICAL SKILLS

RDBMS: Oracle 7.0,7.3, 8.0.5, 8i, SQL Server 2000

O.S.: Sun OS 5.7, 5.8, Win NT 4.0, HP UNIX 10.2, Windows 95,

Novell NetWare

Languages: C, SQL, PL/SQL, Pro*C, VC++

Hardware: Ultra 10, Sun E250, PCs, Unix Workstations.

App. Server: Oracle Application Server 4.0.7, Oracle Web server 2.1, IIS

3.0, Apache 1.3.19, Weblogic Server 5.1

GUI: Oracle Developer/2000 (Oracle Forms 5.0, Oracle Forms 6.0/6I,

Oracle reports 3.0), Forms 3.0, Visual Basic 4.0

Tools: Erwin 3.5.2, Oracle Diagnostic pack, Oracle Tuning pack, Toad

(Quest Software), DB Artisian 5.3, BMC Patrol, Citrix, MetaFrame, SQL Backtrack

EDUCATION / TECHNICAL BACKGROUND

Bachelor of Engineering

(Computer Science) from Madurai Kamaraj

University in 1991

.

Attended Sun Solaris Administration training programme conducted by SUN

Microsystems

Attended training programmes conducted by S.S.I. ltd, Madras and STG,

Madras in Oracle 8.0.

Oracle 7.1 & Developer / 2000 conducted by Aptech, Madras and Java 1.1

& HTML conducted by Maxworth information technology ltd, Madras.

VC++ & MFC conducted by STG, Madras.

EXPERIENCE

Mpower Communications, Las Vegas, NV

Senior DBA

(June 2001

Nov 2001)

The system is developed using the ADC software for billing and the customer

care. The billing system is complex in nature due to many criteria like the

taxation which differs for every state and contract nature, timing duration

etc. They provide DSL service for the business firms.

Environment:

Oracle Financials 11i, Oracle 8.1.7, DB Artisian 5.3, Perl, Citrix MetaFrame,

Tuxedo, MF Cobol, ADC, Apache 1.3.19, Win NT 4.0, Sun Solaris 7 /8, Sun Cluster

2.2

Responsibilities:

Responsible for setup of Oracle database on Sun Solaris.

Tuning and monitoring the database using DB Artisian and also scripts

Applying the patches for the ADC & ICM environment

Setup of Nameserver

Providing an on-call support

Writing shell scripts to monitor the health of the database

Performing day today monitoring & database admin activities

Using Replication manager configured the multi-master site and the

updateable snapshot site

Using Enterprise manager configured the master site and the snapshot

site

Installation of Oracle on Windows 2000 Server

Resolved the conflict resolution based on the business logic, timestamp

& site priority

Written a database business integrity check procedure to verify the

data intact.

LIMITrader Securities Inc

., NY

Senior DBA & Project Leader

Jan 1999

- May 2001

Electronic Bond online Trading System - This system was developed for

LIMITrader Securities Inc (Wall Street Firm). It is an online bond trading

system; the bidder and the offerer can negotiate and trade the bonds online.

If the business criteria are matched then auto trade is done automatically.

They can put the offers or bids as firm or subject to trade with contras. Once

the trade is executed, then socket messages are send up using third party

software Smart Sockets. The buyers and the sellers can do an online

negotiation in the system. They need not reveal their identity and the desk can

monitor the ongoing negotiation and they can intervene in the negotiation

process. The desk can either lower the spread or increase the spread and make

the trade happen which is transparent to the end client.

Environment - Oracle (8i, 8.0.5), DB Artisian 5.3, Informatica Power Mart 4.7,

Power Center 1.7, Cognos Impromptu 5.0, Developer /2000 (Forms 5.0, Forms 6.0,

Forms 6i,Reports 3.0), Pro *C, Oracle Web Server 2.1, Oracle Application Server

4.0.7, Apache 1.3.19, Smart Sockets 5.0 in Microsoft Cluster 1.0 with Oracle

Fail Safe 2.1 in Virtual Private Network (Aventail Extranet Server), WIN

NT4.0., Strong Hold 3.0, Perl 5.005, Sun Solaris 7 / 8.

Responsibilities:

Installation of Oracle on Sun Solaris 7/8 & Win NT 4.0

Installation of Oracle Fail Safe

Set up of Oracle Application Server, Forms & Reports Server

Creation of Database on Sun Solaris 7 / 8 & Win NT 4.0

Written Perl programs

Using Replication manager configured the Multimaster site.

Requesting for the Verisign Digital Cert and configuring the VPN server

to apply Digital Cert.

Writing Database Procedures & Functions

Performance tuning of Database using DB Artisian

SQL Tuning in Forms & Reports

Fine tuning of Apache 1.3.19

Installation of Solaris 7 / 8 and configuration of Apache & mod_perl

Performance monitoring, system tuning & kernel configuration of Sun

Solaris

Trouble shooting for Sun Solaris 7 / 8

Solaris Patch Installation

Set up of NFS file system on Sun Solaris 7/ 8

Application Design and Project Leader for Medium Term Notes (MTN)

Used Erwin to design database.

Tracking the Project Status.

Creation of Application Installation Disks for end clients using

Install Shield

DOW JONES, Princeton, NJ

DBA

July 1998 - Dec 1998

Wsjie - Billing System - This system was developed for Dow Jones for billing of

wall street journal interactive edition on web. The system was developed in

Oracle 8.0.5 database running on Sun OS 5.7 machines and Perl as the front-end

tool for accessing the data. This system is basically for subscribers

subscription, changing the existing payment plan, transferring a customer to

another existing group, corporate users and getting an initial free period at

the start of the subscription. Depending upon the plan billing is sending to

the subscribers monthly or yearly.

Environment - Oracle 8.0.5, Perl, Sun OS 5.7, SQL, Oracle Replication Manager,

Netscape Publishing system.

Responsibilities:

Installation of Oracle 8.0.5 on Sun OS 5.7

Used Oracle Replication Manager and done Hybrid replication

Wrote the online & full backup scripts

Tuned the I/O by stripping the tables.

Daily monitoring & performance checking

Writing of shell scripts to do batch jobs

Performance tuning of Database Triggers

Tuning Batch programs

SQL statement Tuning

Suggesting the various methods to be followed in the procedure /

function writing to improve database performance

Wrote shell scripts to run the batch process depending upon the day and CPU

load. If the process is already running it wont run and if the load on CPU is

high then the schedule job is delayed and if it is holiday it is run only once

else every hour etc.

DSQ SOFTWARE LTD

DBA and System Analyst

March 1997

- June 1998

NSW, Japan

Team Leader / DBA

Feb.98

- June.98

Swanz - Phase II & Phase III - This system was developed for Fujikura Co. Ltd.

(SWANZ) Fiber Optical Cable Manufacturer. The system was developed in Oracle

7.3 database running on Windows NT machine and Developer 2000 as the front-end

tool for accessing the data. This phase involves the development for dispatch

module. This module achieves functionality of reserving the goods for the

customer and storing them in the yard. After confirmation the goods are sent to

the customer and if the customer is another unit of the same factory then the

database of that factory is updated with the information.

Environment - Oracle 7.3, Dev/2000, PL/SQL 2.3 on Windows NT 4.0

Responsibilities:

Performed Database Administrator functions and kept track of Development,

Program specification, test plans

As the Oracle database administrator was responsible for the installation,

database administration, tuning and technical support of Oracle 7.3 databases

on WinNT 4.0.

Specific DBA responsibilities included:

Definition of tablespace, allocation of tablespace, user security

design and implementation

DB, RBS and Log File allocation for reducing disk contention.

Allocation of optimal rollback segments

SGA tuning

IPF (Initialisation Parameters File) tuning

Implementation of backup procedures

Reallocation of datafiles based on utilization

Database activity monitoring using Oracle utilities such as SQLDBA and

Oracle Server manager

Tuning Disk I/O.

Tuning CPU for optimal performance.

Implementing Optimal Flexible Architecture.(OFA)

SQL Tuning

Oracle Database Installation on Windows NT 4.0

Responsible for Oracle on WIN NT application

Responsible for installation of Oracle V7.3

Monitor DB activity utilizing tools such as Oracle enterprise manager,

Oracle Instance Manager.

Generated reports for the administration purpose such as

User Roles and Privileges, Database occupancy of the user, Database Occupancy

and Security, Tablespace balance report, Optimization of the Sql statements,

Execution of SQL Statements and Optimization of indexes.

NSW, Japan

DBA and Team Leader

Nov.97

- Jan.98

Alice - The power supply control system project named as Alice caters the

automation needs of NTT power supply system, Japan. It helps to collect the

information like power supply transmission, breakdown period, frequency etc.

The system gets the input from QINH machines, which will be stored and

manipulated in the Oracle database. This system was developed for NSW Japan.

This involves development of testing drives using Pro* C creating program

checklist and integration unit testing of remote packages (PL/SQL) and local

procedures (Pro* C).

Environment - Oracle 7.3, PL/SQL 2.3, Pro* C 2.2 using Win NT 4.0.

Responsibility -

Was the Database administrator and additionally kept track of Project schedule,

Deliverables, quality standards and testing reviews.

As the Oracle Database Administrator created database, performance tuning

Was also responsible for the following as the DBA :

Creation of tablespace, allocation of tablespace

Allocation of optimal rollback segments

SGA tuning

IPF (Initialisation Parameters File) tuning

Reallocation of datafiles based on utilization

Database activity monitoring using Oracle utilities such as SQLDBA and

Oracle Server manager

Implementing Optimal Flexible Architecture. (OFA)

Oracle Database Installation on WIN NT 4.0

Responsible for Oracle on WIN NT application

Responsible for installation of Oracle V7.3

Monitor DB activity utilizing tools such as Oracle enterprise manager,

Oracle Instance Manager.

MOL, Singapore

Team Member

April.97

- Oct.97

Industrial Health System - This project involves in the development of

the Industrial Health System for ministry of labor, Singapore. The system

keeps track of the industrial workers health conditions and generates various

statistical reports regarding the industrial workers who are exposed to

hazardous chemicals. Using Reports 2.5 generated various reports by extracted

data from Oracle 7.3 and CA DATACOM. Using Forms 4.5 done data conversion to

transfer data from Access and text file into Oracle database.

Environment - Oracle 7.3, SQL* Plus 3.1, PL/SQL 2.1 Forms 4.5, Reports 2.5, HP

UNIX 10.20

Responsibilities -

Involved in the development of Forms, Reports, Packages, Stored procedure and

database triggers. Using SQL * Loader populated the Oracle database.

SQL Tuning

Optimising Report

Developer / 2000 Connectivity via SQL * Net V2.2

Installation of Developer / 2000 (Forms 4.5 & Reports 2.5)

Creation of dynamic views from Reports 2.5

SFI SOFTWARE LTD

Chennai

System Analyst

July.96

- March.97

Telecom Customer Service System - The project aim to cater the needs of a

typical telecom basic service provider. The system takes care of registration

of the various customer request, wait list queue management, resource

allocation, work order generation, work order assignment and work order

execution. This system has identified to be developed by SFI Software ltd,

Chennai. This involves development of forms & Reports in Oracle 7.1.

Environment - Oracle 7.1, SQL* Plus 3.1, Forms 4.5, Reports 2.5, PL/SQL 2.1 on

Unix

Responsibilities -

Involved in system analysis, design, and development. Wrote Packages, stored

procedures & database Triggers for wait list queue generation and work order

generation.

Specific DBA responsibilities included :

Definition of tablespace, allocation of tablespace, user security

design and implementation

DB, RBS and Log File allocation for reducing disk contention.

Allocation of optimal rollback segments

SGA tuning

IPF (Initialisation Parameters File) tuning

Implementation of backup procedures

Database activity monitoring using Oracle utilities such as SQLDBA and

Oracle Server manager

Tuning Disk I/O.

Tuning CPU for optimal performance.

SQL Tuning

Responsible for installation of Oracle V7.1

Competent Software

Madurai

Senior Programmer

May.91

- May.96Embudu Village, Veligandu Island Resort,

Maldives

Feb.95

- May.96Resort Manager

- This project aims to cater the needs of a Resort. The system

takes care of reservation of the various Tour Operators, Registration and

Billing of the clients. Registration module consists of check-in, checkout,

Room Transfers, Occupancy at any point of time etc. The billing module consists

of credit status details, running bill detail, Cash collection report, Daily

sales etc. The stock of the individual outlet is also taken care of. The

monthly sales and daily sales of each outlet, as well as put together can be

taken at any point of time.

Environment - Oracle 7.0, Forms 3.0 SQL *Menu 5.0, SQL Report Writer 1.1 on

Unix

Responsibilities -

Involved in system design and development of Forms, stored procedure and

database triggers for transfer of bills from various outlets into their

respective room bills. Developed forms for reservation, registration and

individual outlets. Developed around 10 reports.

Implemented the application across client sites and fine tuned application.

Specific DBA responsibilities included:

DB, RBS and Log File allocation for reducing disk contention.

Allocation of optimal rollback segments

SGA tuning

IPF (Initialisation Parameters File) tuning

Implementation of backup procedures

Reallocation of datafiles based on utilization

Database activity monitoring using Oracle utilities such as Oracle

Server manager

Tuning Disk I/O.

Tuning CPU for optimal performance.

SQL Tuning

Journey World,

Maldives

Senior Programmer

April.94

- Jan.95

Human Resource Management System (HRMS) - This project involves in the

development of the HRMS for Journey World Trade & Travel, Maldives.

Recruitment

Work permit/visa processing

Appraisals

Training

Payroll, Payslips, Memos, Employee Records, Leave Details, Appraisals, Training

activities undergone, Bonus and Overtime Calculation.

Environment - Oracle 7.0 with Forms 3.0 SQL *Menu 5.0, SQL Report Writer 1.1

on Unix

Responsibilities -

Responsible for development of 10 Forms database Triggers and Stored Procedures

for bonus/overtime calculations. Reports for payslips, payroll and Memos and On-

site implementation.

Volvo Centre,

Membrane and Happy Market Trading Company,

Maldives

Senior Programmer

Dec.92

- March.94

Inventory Management System - Executed for Competent Software, this project is

developed for Volvo Centre, Membrane and Happy Market Trading Company in

Maldives. This project consist of Purchases, Sales (Monthly/Daily/Quarterly/Any

period sales report), Stock Valuation, MIS reports (Bin Card, Reorder report,

Daily sales, Creditors and Debtors outstanding, Ageing analysis, Profit & Loss

statement, Bin Card etc.)

Environment - 486 with Novel NetWare, Clipper 5

.01

Responsibilities -

Responsible for development of purchase and sales module forms. Reports for

sales & MIS (Ageing analysis, creditors & Debtors outstanding, daily sales

reorder report, bin card etc.) Installed application and fine tuned performance

Akari Enterprise,

Maldives

Senior Programmer

Jan.92

- Nov92

Accounts Manager System - The system maintains the accounts in multi currency.

The debtors would be US$ and the other transactions are in MRF (Maldivian

Rufiyaa). At the end of each month the difference in exchange rate is posted

into an account called Exchange Rate Gain and the posting is done at batch. The

system generates accounts ledger, day book, cash and bank books, trial balance,

balance sheet, profit & Loss statement in both US$ and MRF.

Environment - 486 with Novel NetWare, FoxPro

Responsibilities -

Responsible for development of screens for debtors, creditors, cash and bank

transactions Report for account ledger, daybook, cashbook, bankbook, trial

balance and ageing analysis. Installed and maintained the developed application

at various sites.

Trimurthy Industries

Senior Programmer

May.91

- Dec.91

Machine Maintenance System - Machine History, Machine scheduling services

(Machine servicing schedules, service details), Spare parts (Spare parts stock,

spare parts cost), MIS reports (Total expenditure for a given period, labour

cost etc.)

Environment - 486 with Novel NetWare, FoxPro

Responsibilities -

Responsible for development of screen for machine history, machine servicing

scheduling and spare part stock. Report for machine history and MIS reports.

Contact this candidate