Muralidharan Govindan
6562536858 91374897
Blk#194, #08410, Kim Keat Avenue, Toa Payoh
Current Location: Chennai
Title: / Oracle DBA/ Oracle Apps DBA/ System AdministratorWork Experience: / 12 years
Skills: / Oracle 8i/9i/11i, Sun Solaris Admin/Business Objects/ Informatica/Cognos
Current Organization: / UBS
Previous Organization(s): / NorwichUnion Norwich, American Management Systems Ltd. London, TI Diamond Chains Ltd. Chennai, Arihant & Co. Chennai
Industry: / Banking/ Financial Services,Insurance
Highest Degree Held: / B.Sc (Other Science) ,Chennai University
Gender: / Male
Date of Birth: / 23rd July 1971
Detailed Resume:
CURRICULUM VITAE
Correspondence Address:
Govindan Muralidharan
Block #194,
#08-410, Kim Keat Avenue,
Singapore - 310 194.
Contact no.: +65-9137 4897
OBJECTIVE: To Pursue a Senior/medium position as Oracle APPS DBA, which
should give high degree of satisfaction and job challenge.
More than 12 years of experience in Information Technology.
Over 11 years experience as an ORACLE DBA.
Over 3 years of experience as Oracle Applications DBA
Over Eight Years experience as Unix (Sun Solaris) Administrator
Good experience in Production as well as Development Environment.
Experience in Creating Bournce Shell Scripting.
7. Oracle Application Administration (DBA Technical) on all the
platforms.
8. Maintaining Application servers, Upgrading the servers, Installing,
adding new products and Database Design
9. Extensively involved in Setting up Oracle 9i RAC environment on
Solaris / Linux
Having Experience in Advance Replication
Experience covers the entire System Development Life Cycle from requirement
specifications, system design, coding, testing which includes Data
Warehousing Designing and using Warehouse tools such as Informatica,
Business Objects.
At present working for a Swiss Bank, which consist of more than 4500
Instances
Strengths:
System Analysis
System and Database Design
Programming
Testing and Maintenance
Application Tuning
Capable of handling multiple tasks.
Good Communications skills with all management levels
Certified TCP-IP Administrator BY Brain Bench
Certified NT Administrator BY Brain Bench
Certified Data Modeller BY Brain Bench
Certified Oracle PL-SQL Developer BY Brain Bench
12. Certified Oracle 8i DBA By Skill Drill
13. Certified Solaris Administrator By Skill Drill
14. Certified Proxy Server Administrator By Skill Drill
15. Experience in handling Microwave connectivity between multiple sites,
Handled MS Exchange in 60 sites all over India from single location.
EDUCATION
1. Bachelor in Science, from University of Madras, Madras in 1991
2. PGDCP, from Datamation Computer Consultants, Madras, in 1992
3. SDACA, from C- LAN, Madras, in 1994,
SKILLS
Hardware IBM PC COMPATIBLE, COMPAQ PROLIENT SERVER.,
HP9000, RS/6000,SUN SPARC Enterprise Server E10000 Cluster
Server (16 Processors), E450, E250, SUN Netra T1 servers,
EMC Storage Devices, Veritas Volume Manager /Net Backup.
Cisco Switches, Hubs, Radio Modems,
O/S SUN Solaris, AIX, HP-UX, WINDOWS 95 / NT 4.0, TCP/IP,
NOVELL NETWARE, MAC OS
Languages SQL, PL/SQL, Cobol, C, PRO * C.
Utilities Oracle SQL Loader, Oracle Import/Export, GoldenGate
(3rd Party Replication Tool for Oracle)
Database ORACLE 7.x, ORACLE 8/8i, Oracle 9i, 10g,
PL/SQL, SQL*PLUS, SQL Server 7/2000, Toad, SQL Navigator
Application Software Oracle 9i,8i/8.0/7.x, MS-Access, Forms 4.5, Reports
2.5 (Developer 2000), Discoverer 4i Plus
Web Application
Software HTML, DHTML, IIS 4.0/5.0, Netscape Enterprise Server,
Oracle WebDB, Oracle 9i Application Server
Database Design Tool Erwin, Designer 2000
Scripting Languages Perl, Java script, VBScript, Shell Scripting
Data Warehouse
Reporting Tool Business Objects ,Cognos (Impromptu Admin/User,
PowerPlay, Visualizer)
ETL Tools Informatica (Power Center, Power Mart)
Professional Experience
Feb 2004 - Till DateCustomer : Perot Systems Ltd, Singapore.
Client : UBS, Switzerland (Bank)
Largest Bank in Europe
Project Type : Mixed Environment (Banking, Data Warehousing, Stock
Market, Wealth Management, etc).
Environment: This environment consists of more than 2000 Database ranging
from 10GB to 2 Tera Bytes. Sun Solaris 2.8, Sun SPARC Cluster Servers, Sun
Work Stations. From 8 processors to 32 processors using BAYDEL Disk
Arrays, Compaq Disk Arrays, EMC Storage, SANS, BMC Patrol, GoldenGate (3rd
Party Replication Tool),Business Objects, Informatica, Sybase, SQL Server,
Veritas Clusters, Veritas Netbackup, SQL Back Track, Oracle 8i, Oracle 9i,
9i Real Application Clusters (9i RAC), Oracle 10G, 10G Application Server &
Oracle 9iAS. Oracle Financials, Oracle CRM, Linux Advanced Server 2.1 on
DELL PowerEdge Servers, People Soft
Responsible for:
Installation and Configuration of Oracle Database on Sun Servers/ Cluster
Servers & Linux Servers.
Installation and configuration of Oracle 10g/10gAS.
Configuring RMAN / SQL Backtrack for backup and Recovery Purpose.
Cloning of Oracle CRM Database.
Applying Patches on Oracle CRM instance
Installation and Configuration of Discoverer 4i set of tools
Installation and Configuration of Oracle Inter Directory
Trouble Shooting Connectivity/Network issues related to Oracle
Installation and Configuration of Oracle 9i RAC on Solaris/Linux.
Troubleshooting of 9i RAC Database.
Administration of 9i RAC
Installation and Configuration of Oracle Database on Veritas Cluster Server
(VCS) running on Solaris.
Administration of Oracle Database on VCS
Schedule Backups on Crontab
Patching Oracle Applications
Installation and configuring Oracle 9iAS on Sun Servers
Installation of Oracle Workflow, Inter Media and JVM on Oracle 8i & 9i
Database
Experience in applying Security 68 Patches
Upgrade Database from 9.2.0.1 to 9.2.0.4 , 9.2.0.5 and , 9.2.0.6
Migrate Database from 8.x to 9.2.0.4 and 9.2.0.5
Setup Roles for Production & Development Database
Applying Database Patches (including Security patches)
Recover Oracle Database from Disaster like Disk Crash, Raid Array
Malfunction
Configured Oracle Data Guard extensively on production servers
Configured Standby Database on oracle 8i Database.
Trouble Shooting Data Guard and Standby Database
Trouble Shooting and Monitoring Production bottleneck problems
Scheduling statspack to analyze Database Performance.
Setup Replication between sites using GoldenGate (Replication consist of
one way as well as two way)
Nov 2003 - Jan 2004Customer : GE Plastics, Singapore
Project Type : Maintenance / Data Warehousing.
Environment : HP 9000 N-Class with MC Service Guard Cluster Nodes. GEMMS,
Business Objects, Oracle 8i
Role : Oracle DBA.
Responsible for:
Analysing the database tables.
Tuning the Application Design.
Tuning SQL.
Tuning the Data Storage.
Writing the new PL/SQL procedures for application performance.
Support for oracle 8i Database.
Backup & Recovery using Archive Log Files & RMAN
Monitoring Databases using Oracle Enterprise Manager & Shell Scripts
July 2002 - Oct 2003Customer : Oracle Corporation, USA
Project Type : Maintenance / Oracle Estudio project.
Environment : Sun Sparc 2.6 and 2.8, HP-UX11, Tru64 Unix 5.1, Windows NT
(Dell Machines), Oracle 8I, Oracle Application 11I (ERP & CRM)
Role : Oracle Apps DBA.
Responsible for:
Providing DBA Support for Oracle's eBusiness Studio Hosted environments to
ensure 24x7 DBA support.
Installing/Configuring oracle application on various platforms.
Monitoring, Maintaining and tuning multiple database and file system of
Oracle application hosted by Oracle Corporation, USA.
Upgrade oracle application from 10.7 and 11.0.3 to 11i(11.5.x.11.5.9)
releases.
Upgrade Oracle Application to current releases and current product-level
with applying maintenance packs and Minipacks.
6. Managing and Monitoring concurrent programs and requests
7. Tuning Concurrent Manager.
8. Creation and maintenance and customizing user accounts
9. Trouble-shooting of all oracle application problems.
10. Upgrading Apache Server for Oracle Applications
11. Configuring Multiple JVM to Load-Balance Oracle Applications
12. Setup Web Servers, Form Servers, Database and Listeners.
13. Copy/Clone of oracle application environment.
14. Used Oracle Application tools for maintaining database and
application like adpatch, adadmin, adctrl, adaimgr, adrelink,
adsplice etc.
15. Application AOL object setup (users, menus, responsibilities,
forms, reports, folders, request groups, request set etc) and
Purge AOL tables.
May 2001 - June 2002Client : Ubique Systems (UK) Ltd., Plaistow, Essex
Role : Administrator Unix/NT/OracleDatabase DBA
Environment : Oracle 8i, Oracle 9i, Oracle 9i Application Server & Sun
Solaris, Windows 2000, ERWIN, Developer 2000 (Forms 6I,
Reports 6I) Apache Web Server, Veritas Volume Manager,
Veritas NetBackup Professional, Informatica 5.1, Business
Objects 5.1, Apache Web Server, Perl
The Objective of this Oracle PL/SQL Optimization and SQL Tuning is to
increase the performance of the scripts used to process the raw data within
Oracle and achieve a greater than 50% Improvement and to create a new
development environment using Oracle 9i and Oracle 9i Application server.
In addition to that provide support for Oracle 8i Database environment and
Unix (Sun Solaris) administration support, Involvement in Data Warehousing
Project.
Responsible for:
Oracle 9i Development Database Installation/Configuration
Oracle 9i Application server Installation/Configuration
Installation and Configuration of Apache Web Server
Administration of Apache Web Server
Analysing the database tables.
Tuning the Application Design.
Tuning SQL.
Tuning the Data Storage.
Writing the new PL/SQL procedures for application performance.
Documenting the modules developed.
Support for oracle 8i Database.
Configuring Backup & Recovery using Recovery Manager (RMAN)
Backup & Recovery using Archive Log Files
Monitoring Databases using Oracle Enterprise Manager
Bournce Shell Scripting to Monitor Unix Server Activities.
Installation & configuration for Windows 2000 system
Business Objects 5.1
Creation of Universe with in schema (Business Objects)
Building quires on Universe.
Combining of Data from different data sources like RDBMS (i.e. Oracle),
Multidimensional servers (OLAP), Text files and Spread Sheets etc.
Exporting of Data from Business Objects to Text format, Spread Sheet. Etc.
Creation of Master Detail Report.
Informatica 5.1
Creation of Repository for Data Storage (Informatica)
Building the Data Mart (Informatica)
Working with Mapping Designer for Transformation of Data
Working with Server Manager for Loading Data from External Sources
Creation of Meta Data Elements
Creating the stored programs for data uploading from the database
Aug 2000 - Apr 2001Project : Wealth Management - eCRM (Norwich-Union)
Leading Insurance, Banking & Financial Institution in UK.
Client : Price Water house Coopers PLC, Norwich, Norfolk.
Software : Oracle 8i, Java, Protagona, Netscape Enterprise Server,
Erwin 3.5.2,TOAD, Informatica, Business Objects 5.1.1,
Crossworlds & Sun Solaris, Veritas Volume Manager
Hardware : Pentium, Sun SPARC E10000 Cluster Server (16 Processor),
EMC Storage Devices & Compaq Prolient Server
Project Profile:
This project is for insurance company, which started rendering services in
Wealth Management on Web, where every one can register. The Wealth
Management Program will launch a market leading e-venture that positions as
a trusted wealth Management partner.
This system is consisting of modules like Share Dealing, Supermarket of
Funds and Campaign Management. Campaign Management plays the key role in
the e-CRM project, which has to capture information of the customers,
different channels for communicating with Customer.
Role: Oracle Database Administrator/ Data Modeller
I held the position as data warehouse data Modeller at the eCRM proposition
of the WM project. I acquired the necessary skill set of a dimensional data
Modeller on site and applied those skills by using Computer Associates'
Erwin modeling tool when creating Logical and Physical data models.
I acquired the necessary skill set of creating the reports from database
using Business Objects 5.1.
Responsible for:
Analyzed the requirements of the eCRM work stream and incorporated those
into the eCRM model;
Adapted the various WM data warehouse and eCRM data models for the
Protagona campaign management tool;
Held a client facing position and worked closely together with consultants
of disparate technical skills;
Created the necessary sets of documentation that needed to accompany the
models created;
Initiated the data mapping initiatives between the off-line data stores and
the operational data model;
Database design: Used Erwin as modeling tool to maintain data base model.
Create, develop, and review the physical model created from the logical
model.
Analyses, tests, and implements physical database design supporting the
Data Warehouse (including base definition, structure, documentation, and
operational guidelines).
Primary responsibility for the definition, creation, and maintenance of
PL/SQL processes and procedures within Data Warehouse environment (Oracle).
RDBMS performance monitoring and tuning: Closely monitored performance;
identify problems and implement solutions; Monitor file system space.
Uploading the large data into CRM Database using utility SQL Loader.
Data backup, recovery, maintenance, data integrity, and space requirements
for physical database where required.
Commercial Experience in Business Objects
Creation of Universe with in schema
Building quires on Universe.
Combining of Data from different data sources like RDBMS (i.e. Oracle),
Multidimensional servers (OLAP), Text files and Spread Sheets etc.
Exporting of Data from Business Objects to Text format, Spread Sheet. Etc.
Creation of Master Detail Report.
Commercial Experience in Informatica as Developer
Creation of Repository for Data Storage
Building the Data Mart
Working with Mapping Designer for Transformation of Data
Working with Server Manager for Loading Data from External Sources
Creation of Meta Data Elements
Creating the stored programs for data uploading from the database
3 MonthsMay 2000 - Jul 2000
Client : AMERICAN MANAGEMENT SYSTEM,
Liverpool Street, London, U.K.
Role : Database/UNIX Administrator
Environment : Oracle 8/8i, Sun Solaris 2.7, Windows NT, Web
Objects,
Apache Web Server, Perl
Responsibility:
Installation of Oracle Software
Installation and configuration of Apache Web Server.
Tuning Unix Parameters.
Databases Creation on SUN NETRA T1 Servers.
Configuration for Advanced Database Replication
Database Triggers / Procedure /Packages Creation.
Shell Scripting.
Perl Scripting
Unix Admin on Solaris 2.7
Patch Installation
Performance Tuning
The above project is for Colt-Telecom, who is client for American
Management System. This project is mainly for Trouble Ticketing System.
Jun 1996 - May 2000 / 48 MonthsClient : TI DIAMOND CHAIN LTD., India
Manufacturing Automotive, Industrial & Agricultural
Chains in India.
Role : Oracle DBA/Unix Administrator/NT Administrator (Team
Leader)
Environment : Unix (Solaris), Oracle7.x, 8.0, 11.0.3,
Sybase, Windows NT 4.0 and MS Exchange 5.5, TCP/IP, Linux
(Lynux), Apache Web Server
Responsibility:
Maintaining and tuning multiple database and Oracle application, Performing
backup and Recovery and Trouble-shooting of all oracle application
problems.
SQL statement tuning.
Install and maintain Oracle Enterprise Manager.
Setup Sybase Server
Administration Of Sybase Server
User Management on Sybase
Space Management on Sybase
Dump and Load on Sybase
Setup Web Servers, Form Servers, Database and Listeners.
Copy/Clone database and application periodically.
Interaction with oracle team on support issues like TAR etc.
Used Oracle Application tools for maintaining database and application like
adpatch, adadmin, adctrl, adaimgr, adrelink etc.
Application AOL object setup (users, menus, responsibilities etc.) and
Purge AOL tables.
Installing Oracle software on different machines for different units.
Installation and configuration of Oracle WebDB Software
Installation & Configuration of Linux as Proxy Server
Oracle Data Modeling using Erwin
Creating the databases and monitoring them.
Developing triggers and stored procedures at the database level.
Taking backups of the different databases regularly.
Performing Database Recovery in case of any disk crash or loss of data
Managing the user privileges and access.
Educating the developers on the database related performance issues.
Carrying out performance tuning at the application and server level.
Developing an exhaustive set of server monitoring stored procedures, SQL
scripts to generate reports regarding the state of the data servers. These
were sending to the concerned people when a predefined error condition is
reached.
Diagnosing system problems and taking corrective action.
Performance Analysis on long running transactions and optimizing the same.
Installation of Sun Solaris Software & configuring Unix System
Enrolling Users in Unix system
Implementing Applications in Unix System
Bournce Shell Scripting to Monitor Unix Server Activities.
System Administration in Unix system
Installing Windows NT on different machines for different units
Installing MS-EXCHANGE on different machines for different units
SYSTEM ENVIRONMENT: DDE ORG SUPERMAX OS SVR 4, ORACLE 7.1. , COMPAQ
PROLIENT SERVER, WINDOWS NT, MS-EXCHANGE.
Leading a Team of 15 Members including Junior Administrators and Developers
NT Administration Details:
Installation of NT Server, NT-Workstation, Service Packs on different
servers.
Done NT installation on more than 15 servers and controlling them through
microwave connectivity from single location.
Trouble Shooting of NT
Controlling Access Rights
Creation & Maintenance of User Accounts
Regular Backup of NT File System
Recovery of NT Server
Interface connectivity with other OS
Installation and configuration of Microsoft Proxy Server
Installation & Configuration of Services like DHCP, DNS, FTP, RAS, TELNET,
etc
Installation and Administration of MS-Exchange messaging system on multiple
sites and controlled them from a single location.
Connectivity between Domains.
Administration of Multiple Domains in one Location
Experience in Handling Microwave connectivity between sites.
Sep 1992 - May 1996 / 44 MonthsClient : ARIHANT & CO.
Major share broker, Financial Services Provider in
Madras, India.
Role : Systems In charge
Environment : Unix, Oracle, FoxPro, Clipper, Novell
Netware 3.12
Responsibility:
Worked as member of Database Group, which was responsible for extending
expertise on the database area to develop projects. Responsibilities are as
follows:
Installing Novell Netware and applications.
Maintenance of users and privileges, Space in Network Environment.
Maintenance of Unix System, Users and privileges, Space.
Installing Applications in Unix System.
Analyzing the system before development.
Normalizing the data and Designing the system.
Developing Applications using FoxPro, Clipper and Oracle.
Creating the databases and monitoring them.