Title:Scott Burgin

abpzk7@r.postjobfree.com

Document

Source below

NAME: murugaiah, suresh

ADDRESS: ***** ******* ** ***** *** f207

ADDRESS2:

CITY: farmington hills

STATE: MI

ZIP: 48334

CANDIDATE ID: 2327432

US

CITIZENSHIP: Permit

EDUCATION: Bachelor Degree

EXPERIENCE: 9

WILL RELOCATE: Open -

JOB WANTED: Any

RATE NEEDED: 75000+/Annum

TELEPHONE: 248-***-****

EMAIL: abpzk7@r.postjobfree.com

HOMEPAGE:

COMMENTS:

HOTTEST SKILLS: ORACLE DBA

REVISION: 18-JAN-02

YOE: 9

RESUME:

SURESH MURUGAIAH

abpzk7@r.postjobfree.com

cell : 248-***-****

SUMMARY

Over Nine (9) years of experience in Software design, development,

installation, implementation and database administration.

Certified Oracle DBA

Strong skills in Oracle 9i/8i/8.x/7.x DBA (Oracle Parallel Server,

Multi-Threaded Server)

installation, configuration, tuning, optimisation, backup and recovery

strategies

Good experience in Silver Stream Installation, Database Connectivity

Extensively used Oracle tools like Oracle Server Manager, Oracle

Enterprise

Manager, SQL*Loader, Net8, Import and Export

Excellent experience in Designer 2000, PL/SQL, Pro*C, Developer 2000

(Forms

5.0/4.5/3.0, Reports 3.0/2.5/1.2), SQL, PL/SQL, Pro*C, SQL*Load, SQL*Menu 5.0,

Oracle 8.x/7.x.

Excellent experience in Unix, Unix Shell Scripting, Sun Solaris OS 5.4,

HP-UX,

Windows NT, Windows 98/95

EDUCATION

B. Sc

. (Computer Science)

Higher Diploma

in Software Engineering

CERTIFICATIONS

Oracle Database Administration 8.0 certification from Brain Bench, USA (2000)

Completed Oracle 8.0 Database Administration exam for OCP Certification

Oracle Database Administration 7.x certification from Tekmetric Inc, USA (1999)

Certificate Course on Oracle 8.0 DBA (Grade B), Radiant Software Ltd, India

(1998

)

Certificate Course on Oracle Database Administration (Grade A), Software

Solution Integrated (1998)

Certificate Course in Developer 2000 & Power Builder, Software Technology Group

Int. Ltd

(1996)

TECHNICAL PROFILE

RDBMS : Oracle 9i/8i/8.0/7.x.

GUI : Developer 2000 (Forms 5.0/4.5/3.0, Reports

3.0/2.5/1.2), PowerBuilder

4.0

Data Modeling : Designer 2000,

Hardware : IBM Compatibles, IBM Netfinity, Gateway 2000

Server, HP 9000 Server

Operating Systems : Solaris Sun OS 5.4, MS Windows NT/98/95, Windows 3.1x,

HP-UX, SCO Unix, Novell Netware 3.12, MS DOS 6.22

Languages : JDBC, MYSQL, PL/SQL, C, COBOL, FORTRAN, Pascal and

BASIC

Others : FoxPro, Foxbase, Dbase, Lotus, Wordstar,

MS-Mail, Silver Stream.

PROFESSIONAL EXPERIENCE

CISCO SYSTEMS,US Sep '01 Till Date

Cisco systems is a manufacturing company for cisco routers,networking products

and lot more.

Projects involved : Sales Forecasting serialization, population and Dynamic

sparing.

As a Oracle Database Administrator responsibilities included :

Define, enforce, document & track standards for managing databases in

terms of

capacity, integrity, security, performance and version control.

Define, test, document & implement the backup and recovery strategy of

all the

databases and develop scripts for seamless integration with OS backup.

Perform capacity planning for databases and regular review the capacity

usage.

Automate database administrative process including job scheduling, logs,

events & alerts.

Proactively monitor, pre-empt, diagnose, and rectify database relation

problems.

Manage database migration to new platform.

Develop and implement effective disaster recovery for all mission

critical

databases and periodically test the disaster recovery strategy for all

databases.

Evaluate new releases of oracle and associated tools

Planning, design & performance tuning of OLTP & OLAP databases.

Coordinating with development teams for better application design &

performance.

Providing training to other junior DBAs.

Interacting with Oracle Worldwide Gold Customer Support Teams for

problem

analysis and troubleshooting.

ENVIRONMENT : Oracle 8i,9i,SQL/PL-SQL,SQLJ,Windows NT 4.0 Workstation/2000,

Sun Solaris OS 5.6,HP-UNIX,TerraData(DW),ERWIN3.0

IBM Global Consultants for Lucent Technology/Agere Systems, PA

Dec '00 Till

Date

Lucent Technology/Agere Systems

Agere Systems is a manufacturing company for Lucent modems, Integrated circuits

and specialized in

Opto-electronics and Use Oracle as their core database.

As a Oracle Database Administrator responsibilities included:

Installation of Oracle databases version 8i(8.1.6)/7.3.4

Database backups through BMC SQL backtrack and HOMEGROWN software.

Memory tuning.

SQL Tuning for applications. Optimization techniques both cost based

and rule

based

(eg. Explain plan utility, tkproof).

Auditing the database, tables, users, sessions through audit utility of

Oracle.

Creation of user accounts, security aspects, access controls and profile

handling.

Installation and capacity planning.

Shell scripts to monitor the database and schedule them.

BMC PATROL monitoring.

SQL NAVIGATOR/TOAD tool for monitoring the databases.

Monitoring the replication database with the use of snapshots.

Database Cloning

Environment : Oracle 7.3.4/ 8.1.6, SQL/PL/SQL, Windows NT 4.0 Workstation, Sun

Solaris 5.6

MSAS Global Logistics, Bracknell, United Kingdom Dec '99 -

Nov '00

MSAS Global logistics deals with freight forwarding. It was ranked second in the

world in freight forwarding.

As a Oracle DBA responsibilities included:

Installation of Oracle 8i/8.0.5, Oracle Parallel Server and Silver

Stream (web

based application).

Database connectivity between servers and client.

Performance tuning for memory and SQL.

Automating on-line and off-line backups (table space, datafile, log

files and

control files), Cold backups (OS level) using export, import.

Recovery procedures for the database running under both archive and

non-archive log mode.

Optimization techniques both cost based and rule based (eg. Explain plan

utility, tkproof).

Auditing the database, tables, users, sessions through audit utility of

Oracle.

Creation of user accounts, security aspects, access controls and profile

handling.

Installation and capacity planning.

Monitoring the database for Nil Down time.

Environment: Oracle 8i/8.0.5,7.x,SQL/PL-SQL, Silver Stream, JDBC, Designer 2000,

Windows NT,Sun Solaris OS5.6

HTC Software Development Center (P) Ltd, India

Mar '99 - Dec '99

HTC is in a business of software development and maintenance for their clients

in US and India.

As a Oracle DBA responsibilities included:

Installation of Oracle RDBMS repositary for Designer 2000.

Handling the database for performance in memory and SQL.

On-line and off-line backups (Table space, datafile, log files and

control

files). Cold backup (OS level) using export, import and tar of UNIX.

Handling recovery procedures for the database running under both

archive and

non archive log mode.

Optimization techniques both cost based and rule based

(eg. Explain plan utility, tkproof).

Auditing the database, tables, users, sessions through audit utility of

Oracle.

Creation of user accounts, security aspects, access controls and profile

handling.

Installation and capacity planning.

Environment: Oracle 8.0.5, SQL, PL/SQL, Designer 2000, HP-UX, Windows NT 4.0

Vaasum Institute of Technical Studies (VITS), India

Feb '98 - Feb '99

VITS is a Software Development Company which deals with software development,

maintenance and

education.

As a Oracle DBA responsibilities included:

Planning and designing the Database.

Creating and modifying database storage structures.

Space and user management.

SQL*Net Administration.

Evolving Database backup strategies and automating them.

Performance Tuning and Monitoring statistics.

Database Size estimation.

Writing Stored Procedures.

Installation of Oracle 7.x server.

Creating users and assign user profiles and responsibilities to users.

Create dblink, Ran the Oracle Concurrent interface programs.

Customize tables, views and database triggers.

Environment: Oracle 7.x, SQL/PL-SQL, Developer 2000 (Forms 5.0/4.5, Reports

3.0/2.5),

Windows NT 4.0

Blue Dart Express Ltd

., Chennai, India

Oct '94

- Jan '98

Blue Dart Express is a freight forwarding and courier company, which is a Global

service participant of

Federal Express.

Responsible for DBA and Development activities as follows:

Oracle DBA responsibilities included:

Installation of the Oracle RDBMS and Application packages on the Unix /

DOS

platforms.

Planning and estimation of the size of the database and configuring the

database.

Creation of the database, including database objects like redolog file,

data

files, control files and rollback segments.

Tuning and optimization of the database for better performance.

Developed and implemented proper backup and recovery strategies.

Periodic production of database audits to validate operational

integrity.

Database security administration.

User creation, access control and profile handling.

Involved in the following development projects for Blue Dart Express:

Customer Audit System

CAS (Jan '97 - Mar '97)

Involved in design and development of the integrated package Customer Audit

System which gives the statistical information of the on credit customer. This

module generates reports on total Sales variance, projection by each on credit

customers for the past three months and the discounts to be given accordingly.

Sales Vs Target Module STM

(Sep '96 - Nov '96)

Involved in the design and development of the integrated package Salves Vs

Target Module, which consists of Sales Analysis. This module gives clear

reports on the Budgets to be handed to the Sales Persons, achievements and

projections.

All India On-line Query System/Tracking System

(Feb '96 - Jul '96)

All India on line Query System / Tracking System helps to track customers

consignments. Involved in gathering customer needs, design accordingly and

development.

Revenue Audit System RAS

(Apr '95 to Dec '95)

Involved in auditing, design and development of Revenue Audit System. This

system consists of 40 modules. The Report generated through the module gives

the cause for the revenue leakage. This module is used by all India Audit

department of Blue Dart Express Ltd.

Environment: Oracle 7.x, SQL/PL-SQL, Developer 2000 (Forms 4.5/3.0, Reports

2.5/1.2), Pro*C

Sun Solaris OS 5.4, Novell NetWare 3.x

School Management System

Nov '93

to Sep 94Yuvas Systech, India

Developed the School Management System for Sethubaskara Matriculation School,

Pudur, Chennai. Involved in the Student Admission, Students Mark list

preparation, preparation of Students profile, Progress report maintenance,

day-to-day activities and Library Management.

Environment: Foxpro 2.5 on DOS

Hospital Management System

Jun '92

- Nov '93Baron Associates, India

Developed the Hospital Management System for Vasantha Nursing Home, Chennai.

Involved in the development of in/out patient billing, income/expense

maintenance, Doctors Availability and Appointment Booking.

Environment: Foxpro 2.5 on DOS

Contact this candidate