Sql Server Manager

KANCHAN KAVIMANDAN

CONTACT DETAILS

* ******** ****

Hopkinton MA 01748

Cell Phone: 508-***-****

Email: ******@*****.***

WORK EXPERIENCE

Liaison International, MA (Sept' 2010 till date)

. Lead Production DBA responsible for supporting more than 35 servers

including production, test and development SQL servers at Liaison

International and providing on-call support.

. Worked along with higher Management for setting up company-wide

processes for various IT operations such as setting up database

environments, Backup Management, Release Management etc.

. Experience in creating detailed documentation to install SQL Server

2005 including applying of service pack and security fix. Documenting

backup procedures, standards for production deployment and fail-back

strategies.

. Experience in capacity planning for production databases, advising the

System Administrator for procuring proper hardware.

. Guiding SQL developers to optimize the SQL queries and stored

procedures.

. Experience in improving server performance after analyzing CPU, memory

and hard disk I/O using the performance monitor and SQL Profiler.

. Extensive experience in upgrading from SQL Server 2000 to SQL Server

2005 using in place upgrade methods.

. Experience in creating the SSIS packages to export production data to

staging, area that was later picked up by third party ETL processes.

. Involved in setting up transactional replication for reporting

purposes for all the production servers.

. Experience in installing MS SQL 2008 in test environment and initial

analysis for next upgrade. Securing SQL Server, user administration

and assign the permission.

. Implementing methods for data refresh between production and test

environments.

. Experience in creating the backup strategy for production, test and

development servers, implemented it for all the servers using the

maintenance plans and Redgate backup tools.

. Monitoring SQL Servers for schedule job failures, error messages and

log space usage.

Department of Corrections, PA (Oct'2006 to Apr'2009)

. Production and development support DBA, for 60 servers including

production, test and development servers.

. Worked in the capacity of a Consultant for upgrading DOC's SQL servers

from 2000 to 2005 using side by side as well as in place upgrade

methods. Was also responsible for mentoring three database analysts.

. Installing MS SQL 2000/2005 fail over clustering for projects with

three node Active/Active configuration and Active/Passive

configuration.

. Experience with installing and configuration of MS Report server.

. Creating the SSIS packages to export/import data to from different

data sources like Oracle, access and text files. Experience in

converting DTS packages to SSIS packages.

. Involved in setting up transactional replication as fail back strategy

for production servers.

. Worked with setting up the link server and run the reports from

different servers.

P&O Nedlloyd IT Services, India (Jul' 2003 to Oct' 2005)

1. Responsible for approximately 194 databases holding more than 80

terabytes of data across production, QA, Client Acceptance Testing and

development.

2. Installing, configuring and maintaining fail over MS SQL clusters for

production environments.

3. Provided 24*7 production support for production servers, involved in on

call DBA rotation schedule and was responsible for resolving customer

issues within the client specified SLA's

4. Involved in putting change control and work requests using the remedy

software to keep track of all the changes to production, test and

development servers.

5. Monitoring SQL Servers for schedule job failures, error messages and log

space usage.

6. Performing data refresh request between production to test and

development environments.

7. Creating logical and physical database design for development projects.

8. Involved in setting up transactional and snapshot replication and

maintained them in production servers.

9. Implemented the log shipping as high availability option for less

critical applications.

10. Creating backup and restore strategy and setting up the backup

maintenance plans for production, test and development servers.

11. Involved in recovering SQL Server in disaster recovery solutions and

created the document for disaster recovery procedures.

12. Experience in creating the DTS packages to import the data from

different data sources like Oracle, access and text files.

13. Setting up SQL Security features and maintained the user

administration.

14. Created check-lists to install SQL Server, SQL Cluster, service packs

installation on stand alone and cluster servers and hot fix.

P&O Nedlloyd IT Services, India (Jun' 2002 to Jun' 2003)

. Provide 24x7 Oracle database support to more than 200 remote production

and test bases.

. Creating databases and creating/sizing primary database objects.

. Backup Management and restoration (both physical using RMAN and logical

using Export & Import utility).

. User Management.

. Manage standby databases.

. Space management.

. Applying releases and patches in test and production bases after QA.

. Troubleshooting backup and recovery and other database issues.

. Testing backup strategies & plan by recovering the data on test servers.

EDUCATION

Degree Institute and Country

Master's in Computer Science Pune University, India

(2002)

Bachelor's in Computer Pune University, India

Science (2000)

CERTIFICATIONS

Certifications

Microsoft Certified Professional (MCP) in SQL Server 2000 Administration

Oracle Certified Professional (OCP) 9i DBA track

TECHNOLOGY EXPERIENCE

Hardware: IBM X Series Servers (3950 Model/ 346 Model 445 Model),

Compaq ML and DL Series DL360 G2, G3, DL380 G2, G3,

DL580, DL760, DELL 6400

Operating Systems: Windows 2000, 2003(32 and 64 bit), NT 4.0, NT 3.5,

Windows 98/95, AIX and UNIX

RBDMS: MS SQL Server 7.0/ 2000/2005/2008, Oracle 8i and 9i,

ACCESS 2000

Tools Cluster Administrator, NetIQ, Erwin, SQL Management

Studio, SQL Server Business Intelligence Development

Studio, SQL Server Configuration Manager, SQL Server

Surface Area Configuration Manager, Shell scripts,

Remedy, Performance monitor, SQL Profiler, SQL Query

Analyzer, ISQL, OSQL, PL/SQL, Red Gate SQL Tool belt,

Quest Litespeed, Lumigent Log Explorer (4.0.2)

Software Languages: Visual Basic, C, C++

WORK AUTHORIZATION

Permanent Resident. Authorized to work for any employer in the United

States.

Contact this candidate