Contact Cell Phone: 203-***-****

Contact Home Phone: 203-***-****

Email: acpx8n@r.postjobfree.com

RAGHUNATH PARTHASARATHI

SUMMARY

An Oracle/MySQL Certified DBA With 20 Years Of Experience as an Oracle/MySQL/Talend/Spago BI

(ETL and Scheduling)/XSL/medical data formats (EDI 834,837), DBA/Architect/Developer On UNIX/NT

Platforms, A Database Professional With Excellent Analytical And Inter Personal Skills, SQL Expert, A

Proven Team Player, A Fast Learner And A True Believer In Knowledge Sharing Committed To The Pursuit

Of Excellence And Life Long Learning Ready To Analyze, Design And Implement Client/Server, Internet

Database Applications, Data Conversion And Migration From Unix To Windows, Oracle 10g RAC on

Vmware,Oracle 9i With HP UX Cluster Environment, exposure to HADOOP/HIVE installtion and work on

virtual machines in a test environment. Extensive Exposure To Manufacturing Applications With Industrial

Giants Like ALCOA, Singapore Airlines, Philippine Airlines, Supported these Companies With Design,

Development And Testing Of Software And Onsite Support In A Production/Live Environment. Exposure to

Medicaid Systems, Reinsurance Systems and Telemedicine.

EDUCATION

Jawaharlal Nehru University, India

1995 MCA

CERTIFICATIONS

Oracle Certified DBA

MySQL Certified DBA

MySQL High Availability Training

Brainbench Certified Programmer

Attended MySQL sessions in NYC.

Life Office Management Association

LOMA 280 Introduction to Life, Health, Annuities

LOMA 290 Insurance Company Operations

LOMA 301 Insurance Administration

EXPERIENCE

10/10 Teladoc Inc.

Company Involved in the business of telemedicine.

• Installation/Administration of MySQL Databases.

• Monitoring MySQL Database through Web based Monyog.

• Backup using Xtrabackup, autobackup and Linux lvcreate.

• mk tool kit to correct problems.

• Data Migration and MySQL Replication.

• ETL using Talend (minor changes involving Java code) and scheduling through

SpagoBI.

• Helped in Data Modelling through TOAD data modeler.

• Tuning MySQL quering and system parameters for MySQL.

• Support Adhoc programming in MySQL.

• Involved in implementation and design of data marts.

• HADOOP/HIVE installation and implementation on virtual machines on a test

environment.

• Datawarehouse Star schema Kimball keys modeling and implementation using Talend.

5/07 10/10 Alliant Co operative Data Solutions, LLC

Company Involved in the business of Market Research.

• Installation/Administration of Oracle 9i/Oracle 10g Databases.

• Monitoring Oracle 10g Database through Web based Enterprise Manager

• Installation/Administration of MySQL Databases(Innodb Myisam tables backup and

maintenance)

• Data Migration from Oracle to MySQL

• Offsite and onsite Backups of File systems and Databases and through Tivoli Storage

Manager

• Installation of Tivoli Storage Manager 5.4 and Integrated Server console

• Administration of TSM through Integrated Server console

• Management of Real Time Servers through Apache Tomcat

• Minor Java Code changes and deployment

• Load Balancer management through ipvsadm

• Version control through CVS

• Oracle 10g RAC installation on VMWARE software.

• ASM implemented using RAW disks on linux.

• Managing cluster through srvctl commands

• Implementing Failover and parallel instances.

• Tuning SQL and system parameters for Oracle and MySQL

• Use of Partitions/Sub Partitions, parallelism, hash joins on Oracle

• Support Adhoc programming in SQL.

• Support Adhoc programming using SyncSort.

• Maintenance of Trillium Software

• Some Minor tasks of mouting file systems, creating cache disk, tuning system

parameters in case any database need OS changes.

• Knowledge of MySQL NDB, Replication and DRBD.

• Use of MySQL query browser, MySQL administrator for schema details and

monitoring

• Use of MySQL tools such as Myisampack, Myisamchk for compression and index

building and repair

• Use of Master slave replication for MySQL innodb tables

• Use of LOAD DATA INFILE for loading flat files.

• Setup and configuration of multiple databases on same server using different ports.

• RealTime systems on MySQL configured with Apache Tomcat and load balancing

through IPVSADM(Internet Private Virtual Server) and High Availability(HA).

Environment: Oracle 9i/10g, PL/SQL.TOAD 9, AIX 5.2, Tivoli Server Manager 5.4

and Integrated Server Control, MySQL 5.0, Oracle SQL*Loader, Java 1.5, SyncSort

3.11, Trillium Version 7, AIX 5.2, Linux Fedora Cora 2.6 Kernel . SUSE Linux

11,Apache Tomcat 5.5/5.6

8/05 5/07 Swiss Re Life and Health America Holding, Inc

BOF (Business of Future) system. The system replaces the existing system REALIS

running in Informix. BOF is web based system handling policy data, Treaty data, UnderWriting, Claims,

Technical Accounting, Message Management Migration and various other sub systems required for the

Reinsurance Administration.

• Install/Manage patches for ORACLE 9i databases on Sun OS hosts for all databases

required for development, testing, and production usage.

• Design and implement physical databases; On going monitoring and performance

tuning.

• Created DDL scripts for implementing data modeling changes

• Worked with Applications team in developing ETL logic using Sql*Loader, PL/Sql,

Control files, Stored Procedures and Shell Scripts used to populate the database.

• Helping the Applications team in tuning SQL statements to improve the response

times by analyzing the objects and evaluating the execution plans.

• Backup and Recovery using RMAN and scheduling Cronjobs in UNIX.

• Regular tablespace checks and viewing and calculation of statistics.

• User creation and checking connectivity to oracle for users.

• Back end Oracle Triggers and procedures to load data into Data warehouse are also

created.

• The workflow steps for each subsystem(Policy,Treaty,UnderWriting and others) are

monitored

• UNIX shell scripts to automate certain SQL scripts and SQL Loader scripts

Environment:Oracle 9i,PL/SQL.TOAD 7.5, Windows 2000,SUN OS 5.8,

Power Center 6.2.1, Data Junction(7.5.5),Oracle SQL*Loader

8/02 Client Network Services, Inc

8/05

Contact Cell Phone: 203-***-****

Contact Home Phone: 203-***-****

Email: acpx8n@r.postjobfree.com

MECMS (Maine Claims Management System) Conversion from legacy system for

the State of Maine to a Web based system. Duties and Responsibilities: Support for Oracle Data Conversion

of MECMS (Maine Claims Management System) from legacy system for the State of Maine.

Responsible for data conversion of various sub systems, some of which includes:

• Reference, Provider, Prior Authorization and Claims.

• Involved in documentation, design, analysis and coding of programs to load data from

flat files to staging area using Oracle PL/SQL(UTL FILE usage).

• Involved in data setup(Creation of Master data) required for target loading using

Oracle SQL scripts.

• Involved in data setup required for staging loading and target loading.

• Involved in Provider Conversion meetings and in the resolution of various conversion

issues.

Above work involve extensive use of PL/SQL, UNIX shell scripts, fine tuning

oracle SQL queries.

•

Involved Database Administration.

•

Supported Provider,Reference and Prior authorization subsystems involving

conversion and other issues.

• HP Service Guard –OS level cluster.

• Shutdown and startup HP cluster.

• Supporting DBA with exposure to Cluster 9i database and backup using RMAN and

omni backup utility.

• Creation of media pools in omni backup.

• Scheduling offline backup jobs to different media pools.

• Scheduling RMAN online backup using omni backup utility.

• Scheduling Cronjobs in UNIX.

• Involved in data conversion from MS Access to oracle for small databases through

odbc facility.

• Regular tablespace checks and viewing and calculation of statistics.

• UNIX shell scripts to start,stop and log errors of various conversion processes.

• Successful loading data of into target. System for Provider, PA and Reference sub

systems.

Environment: Oracle 9, PL/SQL.TOAD, Erwin, Windows 2000, UNIX, MSVSS,

HP Omni backup, MS Access

6/01 NorthBound LLC

7/02

Production Support for Oracle databases for Asset Maintenance Applications and

Timeseries Applications. Duties and Responsibilities:

• Install/Upgrade/Migrate/Manage ORACLE 8/8i Enterprise Edition databases on Sun

Solaris hosts for all databases required for development, testing, and production usage.

Perform the following DBA tasks: Install, configure and upgrade ORACLE software;

Interface with ORACLE technical support; Design and implement physical databases;

Maintain backup and recovery plans; On going monitoring and performance tuning.

• Design and implementation of a database system. Erwin for data modeling and for

ERD. Created DDL scripts for implementing data modeling changes

• Worked with Applications team in developing ETL logic using Sql*Loader, PL/Sql,

Control files, Stored Procedures and Shell Scripts used to populate the database.

• Helping the Applications team in tuning SQL statements to improve the response

times by analyzing the objects and evaluating the execution plans using Precise/In

depth tool.

• Development of forms and reports using Developer 6i.

• Deployment of forms and reports on OAS 4 and 9iAS.

• Install, Configure, maintain Oracle Application Server (OAS, 9iAS) to integrate

several web based products, tools.

• Auditing the Database usage to determine the better physical layout and load

distribution.

Partitioning the larger tables for ease of maintenance and for better performance.

Created HTML help files for the forms developed.

Accomplishments:

• Successful implementation and maintenance of Asset management systems.

Environment: Sun Solaris2.8 On SunE10000, Sun6000, Sun 5000, Oracle,

8.0.6,8.1.7(8i),OAS 4.8,9iAS, SVRMGR, Oracle Enterprise Manager, SQL Loader, SQL*plus, Pl/Sql,

Designer/Developer 6i, Oracle Application Server 4.0, 9iAS, Precise/Indepth, Toad, VSS Version control,

Number of People Managed 3

3/00 Compunnel S/W grp Inc Location Iselin, NJ

5/01

Lot Trace system, Time and Attendance System, Labor Control systems

Responsibilities include:

• Oracle 8 Database Administration (Oracle 7/8): Install/upgrade database back end

(Unix/NT), migrate oracle 7.3 to 8/8i,plan/allocate storage requirements,

initialize/populate databases, create/alter structures/schemas as needed,

create/alter/control user profiles/roles/privileges as needed, monitor and optimize the

performance of the database, plan/implement backup and recovery of database.

• Built space management SQL scripts to prevent failure from rapid data volume

growth, table and Index rebuilds for defragmentation and row chain repairs after

major loads.

• Helped troubleshoot database problems to maintain 7 x24 uptime for high throughput

OLTP systems.

• Perform database tuning using Explain Plan, utlbstat/utlestat, tkprof & other home

grown utilities to reduce reloads, enhance Cache Hit Ratios and fine tune the database.

• Using export/import for application backup.

Analyzing customer database needs requirements and problem resolution.

Design and implementation of a database system. Erwin was used for functional

decomposition, process modeling, data modeling and for ERD.

Created DDL scripts for implementing data modeling changes.

Accomplishments:

• Successful maintenance of the above mentioned systems. Received appreciation letter

from Manager.

Environment: Vax/Vms, Solaris 2.6, Oracle 7.3.4, 8.0.5, SVRMGR, SQL Loader,

SQL*plus, Developer/2000, PL/SQL, Oracle, Enterprise Manager, TOAD Soft

2/98 Kumaran S/W Inc, Location Rockville, MD

1/00

Conversion of character based systems to client server GUI based systems and web

based systems for big clients like FORD, STROH brewery etc

Duties and Responsibilities:

• Interacted with customer for obtaining specifications for GUI design.

• Planned conversion for GUI interface using GUI*Converter.

• Demonstrated functionality and use of GUI*Converter.

• Upgraded Forms 3.0 to Forms 5.0.

• Upgraded Reports from Reports 1.1 and RPT to Reports 3.0.

• Installed Developer 2000 Server on Windows NT

• Created Batch script for invocation of Forms listener.

• Created script for Java initiator for clients.

• Installed Reports 3.0 server as a service for sending reports to queue.

• Created virtual directories using Windows NT work pack version 4.0.

• Data loading using Export/Import.

Environment: Oracle 8.0 Migration from Unix HP UX to Windows NT 4.0

Accomplishments:

• Successful implementation of GUI/web based systems for a lot of clients and won

their appreciation.

Environment: Oracle 7.x/8.0, Developer/2000 Forms 5.0, Reports 3, IIS, Window

NT, UNIX.GUI Converter, Number of People Managed: 10

8/95 CRI, India

12/97

AIRMAN is a product designed by Cambridge Online Systems. This is a

system applicable to complete aircraft maintenance comprising of purchasing,

job control and works order maintenance, labor resource management, master data maintenance,

inventory and security.

Duties and Responsibilities:

Contact Cell Phone: 203-***-****

Contact Home Phone: 203-***-****

Email: acpx8n@r.postjobfree.com

• Involved in development of application in Forms3/ 4.5 with inclusion of GUI features.

• Common procedures are clubbed to create libraries.

• Various types of reports such a tabular, master detail, matrix are created for the

system in Pro*C/Reports 2.5.

• Involved in creation of database procedures using DBMS packages, and triggers.

• Data loading for help using SQL*Loader.

• AIRMAN – MEMIS (Material Management System) interface using Pro*C.

• AIRMAN – AMPS (Aircraft Maintenance Planning System) using Pro*C.

• Involved in ER diagrams.

• Monitoring CPU, I/O, Memory.

• Involved in installation of oracle.

• Involved in creation and maintenance of database.

Accomplishments:

• On site support for Singapore and Philippine Airlines for the AIRMAN systems

Environment: Oracle 3.0/4.5, Oracle 7.1, UNIX (AIX), Reports 1.1, Pro*C, Number of

People Managed: 5

Contact this candidate