Manager Maintenance
Resume:
Contact Cell Phone: 203-***-****
Contact Home Phone: 203-***-****
Email: ****************@*****.***
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: ****************@*****.***
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: ****************@*****.***
• 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