Radha Muthaiah ***** Royal Poinciana Dr Weston FL 786-***-****

ASenior SQL Server DBA

Summary

• Over 15 years of IT experience and 12 years in SQL Database Administration, System

Analysis, Design, Development & Support of MS SQL Servers 2008r2, 2008, 2005, 2000

and 7.0 Reporting Services, SQL Server Integration Services and Analysis Services

• Configuration, upgrades, capacity planning, performance tuning, backup and recovery,

clustering, index maintenance in a very large, high-transaction volume, fast-paced

environment.

• Maintenance and tuning of the databases and replication

• Experience with partitioned schemas,tables,indexes,Filegroups,online indexing and

recovery features

• Experience with setup and administration of SQL Server Database Security environments

using database Privileges and Roles

• Implement DR solution, High Availability of database servers using Database mirroring,

replication and Log Shipping

• Experience in troubleshooting and problem solving of MS SQL database Servers using

various tools like Profiler,Perfmon, Idera

Education

Bachelors in Electronics and Computer Science Engineering.

Technical Skills

Business Domains: Pharmaceutical, Healthcare, Entertainment, Manufacturing,

Insurance

Databases: SQL Server 2000(Administration, Replication, Development), SQL

Server 2005, 2008,Oracle, Sybase

Data Modeling Tools: ER-Win, Visio

Radha Muthaiah 16810 Royal Poinciana Dr Weston FL 786-***-****

Database SQL Compare, Speed Coefficient, SQL DBArtisan, Idera Diagnostic

Administration Tools: Manager, Litespeed, Embarcadero Change Manager

Reporting Tools: Crystal Enterprise, MS Reporting Service

Languages/IDE: TSQL, PL/SQL, ASP.NET, VB.NET, JavaScript, HTML/DHTML, XML,

Visual Studio

Experience

Currently specializes as the Senior SQL Server DBA for Insurance Company. Has hands-on

database administration of managing over 1000 corporate SQL Server databases. Specialize in

advance database management tasks such as logical & physical modeling, ETL, replication,

disaster recovery, clustering, maintenance plans and performance tuning.

August 2007 to Present: Miami, FL

Senior SQL Server Database Engineer

• Design infrastructure and develop standards to transition data from DB2 using SQL

server 2008 Integration Services (SSIS) as the Enterprise ETL tool to populate a 4.5

billion revenue generating system

• Responsible for creating and supporting SQL Server 2000 and 2005, 2008r2 high

availability (Microsoft clustering, log shipping, database mirroring, and etc.) database

servers. Set up backup and recovery plans and monitor system performance.

• SQL server Reporting Services 2005 and 2008 reporting application platform architecture,

implementation and administration.

• Work closely with w/Microsoft Premier Services to resolve issues, request enhancements

and recommendations to minimize issues on company wide SQL servers.

• Implement transactional replication,mirroring and Log shipping using SQL server and

Litespeed for Disaster Recovery

• Provide performance tuning guidance for developers using various tools like database

tuning advisors, execution plans, update statistics, rebuild indexes

• Set up backup and recovery plans, supported database replication, and monitor system

performance.

August 2005 to August 2007 Vitas Hospice care Miami, FL

Senior SQL Server DBA

• Architect ETL solutions to migrate data from Sybase to SQL Server 2005

Radha Muthaiah 16810 Royal Poinciana Dr Weston FL 786-***-****

• Architect newer technology solutions in SQL Server

• Create Monitor and improve data flows using Replication, DTS and SSIS

• Performance Tuning, analyze and optimize costly queries to reduce logical disk I/O for

effective performance

• Monitor of server performance using Profiler, Perfmon during peak periods of server

utilization

• Performance tuning to ensure that the databases run efficiently though server

configuration, changes to database structure, indexes, stored procedures

• Scripting stored procedures and creating DTS packages for varied purposes as and

when required in the project

•

January 1999 to August 2005 Cephalon Inc Philadelphia, PA

Technical Architect, SQL Server DBA

• As a Corporate SQL Server DBA, managed over 50 SQL server databases. Some of

the responsibilities include but not limited to:

• Installing and configuring multiple SQL Server

• Developing Logical and Physical Models

• Performance tuning of application data interface layers and databases using profiler,

Imceda Co-efficient tools

• Managing replication of over 25 Clinical Study databases to manage various Clinical

trail studies throughout the world. These clinical study data is critical part of the FDA

submission and approval process. Implement various snapshot and transactional

replication publications to support offsite clinical studies depending on the nature of

the Clinical Study and criticality of the data

• Ensuring the 24*7 availability of the databases including company intranet, extranet,

internet web applications databases, and other application databases such as

Platinum, Work Flow Extender, Electronic Data Capture system, Net G, Evaluator

and Sales Force Training.

• Automating various DBA tasks such as index rebuild and notifications

• Implementing a robust code promotion scheme from development/test/production

system using SQL Compare.

Radha Muthaiah 16810 Royal Poinciana Dr Weston FL 786-***-****

• Designing comprehensive user security

• Creating data import/export interface using DTS between various external databases

such as IMS, NDC, IMPACT, SAS, Oracle and SQL Server

• Managing Backup and Restore processes using log shipping, full, incremental,

transactional backups depending upon the nature of the databases

• Enforce various database standards including coding, code promotion, best practices

and Backup/Restore.

• Evaluating various SQL Server tools including SQL 2005

• Participating in FDA 21 CFR Part 11 and Sarbanes-Oxley (SOX) validation of SQL

Server databases including creating IQs, SOPs for SQL Server installation, service

pack upgrades.

• As a SQL Server Developer

• Developed application data layer to include stored procedures, views, triggers, user

defined functions

• Created a SQL Server reporting service solution to support transactional report

requirements

• As an Architect

• Evaluated various Microsoft technology products such as SQL Server, .NET,

Exchange Server and instrumental in bringing in those technologies from other

platforms

• Evaluated and implemented various tools and technologies such as SQL Server

Reporting Solution, Cizer Quick Query, Report Builder, DBArtisian SQL Compare and

Imceda Coefficient

• As a Manager

• Managed a team of developers and validation consultants

• Managed business requirement gathering and responsible for creating technical

specifications.

• Participated in vendor evaluation for NetG, Evaluator, Generation21 and Sales &

Marketing Travel Planner applications.

• As a Business Objects developer

• Created Business Objects Universe to support the Sales & Marketing DSS system

Radha Muthaiah 16810 Royal Poinciana Dr Weston FL 786-***-****

• Managed security of Business Objects users

• Managed a consultant responsible for developing WEBI and BOFC reports

• Created Microsoft Analysis Server OLAP Cubes and integrated with Business

Objects DSS system

June 98 to Dec 98: Philadelphia Museum Of Art Philadelphia, PA

Application Developer

• As a consultant, worked with the Museums staff in developing an Art Museum Image

Consortium (AMICO) application using Visual Basic and SQL Server. This application

to track inventory of various artifacts in the Museum.

• Developed TSQL Interface to import external data from other museums into the

centralized database

• Involved in centralization and migrating various Microsoft Access databases into SQL

Server database.

• As a consultant, designed and developed FRIENDS application used by the

Curatorial Assistant and Gallery Staff to track contributions to the Gallery using

Visual Basic and SQL Server

• Responsible for evaluating of various web applications IDEs such as Borland, Visual

Interdev and PowerBuilder

September 1998 to December 19 98: Moore College Of Art Philadelphia,PA

Application Developer:

• As a consultant, designed and developed FRIENDS application used by the

Curatorial Assistant and Gallery Staff to track contributions to the Gallery using

Visual Basic and SQL Server

• Responsible for evaluating of various web applications IDEs such as Borland, Visual

Interdev and PowerBuilder

Radha Muthaiah 16810 Royal Poinciana Dr Weston FL 786-***-****

References available upon request

Contact this candidate