Candidate Name: Vasanth

For Rate contact Bharathi @ 317-***-**** OR Jim @ 317-***-**** OR Email:

acebwa@r.postjobfree.com

_

SUMMARY:

. 7 years of experience as a Certified SQL Server Database Administrator.

My expertise includes MSBI tools (SSRS, SSIS, SSAS), Installation, Up-

gradation of SQL Server, High Availability clusters, DB Mirroring, Server

Configurations, Security management.

. Production Database Support & Troubleshooting (24*7*365) All Versions of

SQL Server

. Database Administration (DBA) for Microsoft SQL Server 2000,2005 and 2008

Environment

. Experience in installation and configuration of MS SQL Server

2005/2008/2008R2/2012 versions.

. Experience in the upgrade of SQL Server 2000/2005/2008R2 databases to

later versions.

. Experience in applying necessary SQL Server service packs and CUs /Hot

fixes.

. Design and Implement Database Backup Restore & Disaster Recovery Strategy

. Hardware sizing, Setting up Base lining and Capacity Planning

. Auditing SQL Server Security

. Plan, Design and Scheduled Database Maintenance & Administrative Tasks

. Expertise in Disaster Recovery planning based on customer requirements

(Replication / Mirroring / Clustering / log shipping).

. Installing and configuring SSRS, SSAS and SSIS.

. Extensive experience in eG, Ignite and NetiQ monitoring tools and

enhancements in Monitoring tool based on the business requirements.

. Adhered to Change Control Procedures.

. Ability to work independently and as a team player and effectively meet

project deliverables on time.

. Good analytical, problem-solving and communication skills. Ability to

adopt new technologies.

. Experience in SharePoint Administration - Installation and configuration

of Central admin

TECHNICAL OVERVIEW:

: C/C++, Java

Programming Languages

Database : SQL Server 2000/2005/2008/2008 R2 and 2012

Web Technologies : HTML, XML

Script Languages : JavaScript, VB Script

Office Applications : Ms-Office, Share Point Designer

Reporting Tool : SQL Server Reporting Services (SSRS).

Other Applications : eG Monitoring Tool, Ignite, Spotlight, MSBI

EDUCATIONAL OVERVIEW:

. Master of Computer Applications (M.C.A) from Osmania University -

2006.

. Bachelor of Computer Applications (B.C.A) from Osmania University -

2003.

WORK & PROJECTS OVERVIEW:

Company : CIIT 2014 Jan -

Present

Client : Angie's List

Project Name : Angie's List

Software : .Net, Microsoft SQL Server

Role : SQL Server Database Administrator

Responsibilities:

> Production Support [24*7*365], & ON Call SQL DBA

> SQL Server Failover cluster Installation

> Capacity Planning, Load Balancing & Scaling out SQL Services

> Monitor Database Backup Restore & Disaster Recovery

> Hardware sizing, Setting up Base lining and Capacity Planning

> Auditing SQL Server Security

> Plan, Design and Scheduled Database Maintenance & Administrative Tasks

> Implementing and Maintaining Replication Clustering Mirroring

> SQL Server Database Monitoring with DDL Triggers SQL Server Profiler

Event Notifications

> Schedule SQL Jobs SQL Server across multiple Servers

> Performance Tuning, Execution plan, Profiler, Perfmon and Extended

Events

> Resolving Tempdb issues

Description:

Angie's List relies on its members' experiences, reviews aren't

submitted anonymously. Members' information is kept confidential on Angie's

List, but reviews are made available to the companies who have been

reviewed. Since there are always two sides to every story, companies can

respond to reviews, helping make sure that members get all the information

they need to make a hiring decision. To Monitor the application and

database we use Spotlight and Ignite - Confio.

Company : Tata Consultancy services

2012 May - 2013 Nov

Client : Nuance

Project Name : Quantim

Software : Java/J2EE, T-SQL, Eclipse, Perforce, Test Track,

Microsoft SQL Server

Role : Database Administrator

Responsibilities:

> Production Support [24*7*365], & ON Call SQL DBA

> Installation, Version Upgrade and Setup

> SQL Server Hardening & Best Practice Implementation

> Capacity Planning, Load Balancing & Scaling out SQL Services

> Design and Implement Database Backup Restore & Disaster Recovery

Strategy

> Hardware sizing, Setting up Base lining and Capacity Planning

> Auditing SQL Server Security

> Plan, Design and Scheduled Database Maintenance & Administrative Tasks

> Implementing and Maintaining Replication Mirroring

> SQL Server Database Monitoring with DDL Triggers SQL Server Profiler

Event Notifications

> Schedule SQL Jobs SQL Server across multiple Servers

> Performance Tuning, Execution plan, Profiler, Perfmon and Extended

Events

> Leading the team of 8 members

> Creating Database Builds and delivering it to Release Management

OLAP

> Installing & Configure Analysis Services

> Cube Deployment

> Logging and Monitoring Analysis Services Solution

> Backing Up and Restoring an OLAP Database

SSRS

> Installing & Configuring Reporting Services on Clustered Environment

for High Availability

> Publishing / Deploying Report on multiple Report Servers

> Managing Shared Data sources and permissions

> Configured Reports Snapshots, Report Caching for reporting performance

> Created and managed subscriptions for Reports and assigning report

level permissions

> upgraded / Migrated reporting services

> Configure Backups

SSIS

> Installing and Configuring Integration Services on Clustered

Environment for High Availability

> Troubleshooting and Optimizing SSIS package performance

> Deployed and Scheduled DTS SSIS Packages

Description:

Nuance is the industry leader in developing information technology

solutions enabling health care organizations to leverage quality care into

positive financial outcomes. From clinical management to patient

information management, from revenue cycle management to health information

management, Nuance solutions increase transparency, profitability, quality,

and safety in today's care delivery process. As the broadest set of HIM

(Health Information Management) products in the industry, Nuance HIM

solutions provide a powerful link between access, care and patient revenue.

With patient information a key element of quality care, our HIM

solutions enable healthcare organizations to efficiently manage information

critical to all processes within their facility. Quantum is one HIM

products that integrate across the full suite of Care-Based Revenue Cycle

solutions to automatically capture and collect information required for

each step. These solutions are designed by HIM professionals to ensure they

positively impact on all key success metrics.

Company : Tata Consultancy services 2011

May - 2012 May

Client : J P Morgan Chase

Project Name : COE Monitoring

Software : Java, JSF, XHTML, JSP, Servlets, Hibernate, RTC, RTM,

WebServices,

MS SQL Server, BIRT, Nagios

Role : Administrator /Technical Lead

Responsibilities:

> Installation of SQL Server 2005/2008

> Implemented the Nagios Monitoring tool for infrastructure and Database

monitoring

> Release to the production

> Bug fixing

SSRS

> Installing & Configuring Reporting Services on Clustered Environment

for High Availability

> Publishing / Deploying Report on multiple Report Servers

> Managing Shared Data sources and permissions

> Configured Reports Snapshots, Report Caching for reporting performance

> Created and managed subscriptions for Reports

> Assigning report level permissions to Secure business information

> upgraded / Migrated reporting services

> Configure Backups

Description:

The COE has been established to assist the top management in

monitoring Applications, Infrastructure, Business Flows and Operations. The

current activities include Implementing Strategic Monitoring Solutions for

different monitoring requirements.

This includes Tools Identification and Evaluation, Technical POCs

followed by Analysis. The tools evaluated so far are CA-Wily, IBM Tivoli,

eG, Nagios, Foglight and BIRT Reporting tool.

Design and Develop Web and Middleware applications that collect and

collate Monitoring application parameters and store them in a datastore for

analysis, these application and set of applications also send real time

alerts. The applications are being designed with Java, Spring, Hibernate,

WebServices and HTML5

Company : Allscripts Corporation 2007 Apr

- 2011 May

Client : Allscripts Corporation

Project Name : Sunrise clinical manager (SCM)

Software : Dot Net, C#, ASP.Net, MS SQL Server, WebServices, eG

Monitoring Tool, Clarify

Role : Database Administrator/ eG Monitoring Tool

Administrator

Responsibilities:

> Installation of SQL Server 2005/2008

> Creating SQL Objects like Table, View, Joins

> Writing T-SQL Statements

> Database Backup and Restore

> Creating user Roles and assigning permissions

> Monitoring SQL Servers and SQL Executive error logs

> Monitoring DBCC logs

> Monitoring database space availability

> Creating and monitoring Replication Agents

> Creating and monitoring Mirroring

> Creating Custom reports using SSRS

> Installing eG manager and agents on clients environments and

configuring the applications

> Writing Basic Java class file to monitor some special applications

through eG.

> Configuring HL 7 interfaces

> Monitor HL 7 Interfaces and connections between different interfaces

> Working on clarify/CRM on Demand

> Log all reported problems and requests by RSA customers in Clarify

> Logging and updating cases for any issues that has been detected

> Updating all cases that are opened by customers

> Create sub case for escalated cases

> Work with Level Three Specialist through the problem resolution.

Update Clarify with appropriate information while working with Level

Three

> Closing all cases that have been resolved

> Notify customers of any potential issues

> Escalating calls according to severity level index. Increase priority

where appropriated base on the needs of the customer and severity

level

> Monitor RSA queue and assign cases to the appropriate site owners

(Group Leader)

> Monthly application status reports

Description:

To provide customers of Allscripts Corporation with a single point of

contact for SCM remote system administration and database administration

services which include Application or database problem triage and

resolution, application and database administration tasks, requests for

service and information dissemination.

Allscripts Product Support Services has standardized on Clarify as the

RSA and DBA software of choice. A standard data model has been developed

that is to be used by the RSA technical group. The use of the standard data

model will accommodate gathering of standard data from account to account

and standardized reports from SSRS. This information will be analyzed for

opportunities to implement changes to monitoring scripts to reduce customer

problems and improve customer service.

ACHIEVEMENTS

* Microsoft SQL Server 2008, Implementation and Maintenance

Certification

* Microsoft SQL Server 2008, Database Development Certification

* AHM - 250 Certification

beginner - training only, limited practical use

intermediate - used on the job, may need minimal support or assistance

advanced - used extensively, can perform work independently

expert - can perform in the role of a lead developer / supporter

Technology Skill Level Experienc Year

e Last

(Years) Used

Operating Systems

Linux

SCO UNIX

Windows NT / 2000 / XP / 7 intermediate 6.6 2013

Windows Server 2003 / 2008 intermediate 4 2014

Languages / Development Tools

ADO.NET

AJAX

ASP.NET

Borland Delphi, Object Pascal

C / C++

C#

COM / DCOM

Entity Framework

Foxpro, Visual Foxpro

HTML, XHTML, CSS

Java intermediate 2 2013

JavaScript

jQuery

LINQ to SQL beginner 2013

Microsoft .NET Framework 1.0 / 2.0 / 3.0

/ 3.5 / 4.0

Microsoft MVC

Microsoft Visual Studio .NET 2003 / 2005

/ 2008 / 2010

Silverlight

Visual Basic, Visual Basic .NET

WCF

web services

Windows Forms Applications

WPF

XML, XML Schema, XPath, XSL, XSLT, DTD

Databases / Database Tools

Access 97 / 2000 advanced 1 2008

Oracle 7.3 / 8.0 / 11g and PL/SQL

SQL Server 2000 / 2005 / 2008 and T-SQL expert 7 2014

Design Methodologies

Agile / Scrum advanced 2 2013

GOF Design Patterns

OOA / OOD / OOP

Rapid Application Development (RAD)

UML

Use Cases

Other

Dreamweaver MX

ERwin 3.5.2

Excel 2000 / 2003 / 2010 advanced 7 2014

Firefox and Firebug

IIS intermediate 1 2007

Internet Explorer advanced 7 2014

PowerPoint 2000 advanced 7 2014

Visio 5.0

Word 97 / 2000 / 2003 / 2010 advanced 7 2014

Contact this candidate