Ankit R.Shah

***, ***** ******, ***-***,

Honolulu, HI-96814

631-***-****

abgwxh@r.postjobfree.com

Profile

Extensive industry experience (4+ years) in MS SQL Server DBA,

Configuration, Installation, Management, Upgrading system Analysis with MS

SQL server 2008, 2005, 2000 in production environment. Additional

experience in SQL Business intelligence attributes to thorough

understanding of SQL framework.

Technical Summary

> Experience with SQL server 2008/2005/2000 Installation, Upgrade,

Migration, Configuration, SSIS, SSRS and Administration.

> Reliable in support and database management services for production

application

> Experience in supporting very large and highly transitive databases and

troubleshooting the performance bottle necks on different environment

(production, DEV, UAT, Test etc)

> Worked with Indexing, Statistics, Locking and Blocking on queries.

> Experience in database Backup, Recovery, and Disaster Recovery

procedures.

> Maintained Database Authentication and Authentication of database objects

creation of users, Configuring permissions and assigning Roles to Users.

> Experience with configuring database with high avaiblity techniques like

database mirroring, log shipping, Replication, Clustering

> Experience with database performance tuning, Query optimization,

client/server connectivity on network and other network issues, database

consistency checks using DBCC.

> Experience in investigating and applying necessary SQL server database

patches and installing server packs

> Experience in debugging and optimizing Triggers, Views, Functions, T- SQL

queries and stored procedures.

> Experience in using Dynamic Management Views (DMV) to improve server

performance.

> Proficient with data transformation services like SSIS, DTS, BCP and Bulk

Insert from heterogeneous.

> Good knowledge of RAID System, Capacity Planning, Data partioning,

indexing.

> Worked on 32 Bit and 63 Bit clustered and standard server environment.

> Good Experience with data warehouse development environment using SSIS,

SSRS, and SSAS.

Education

Diploma in Electronics & Communication from Technical Education Board -

Gujarat, India

Bachelor of Science - Electronics & Telecommunication from North

Maharashtra University, India

Technical Skills

Databases MS SQL Server 2000, 2005, 2008, 2008R2, MS Access.

Programming Languages TSQL, C, C++, Assembly Language.

DBA Database administration of MS SQL Server 2008R2,

2008, 2005, 2000.

Operating Windows 2008/2003/2000, XP, Vista, Win 7.

System/Servers

ETL Tools SSIS, DTS, Cognos.

Tools SSMS, SQL DB Access, Performance Monitor, SQL

Profiler, IDERA, SQL Diagnostic Manager, SCOM,

SSRS, SSAS, RML utilities, SQLIO, SQL BPA, MAP

tool Kit etc.

PROFESSIONAL EXPERIENCE

Kamehameha Schools, Honolulu, HI

March 2011 - Present.

SQL Server DBA

Responsibilities:

> Managing approximately 80 SQL Servers (2000, 2005, 2008, 2008R2) with

team of 4 DBAs.

> Monitoring and making recommendations for performance improvement in

hosted databases.

> This involved index creation, index removal, index modification, file

group modifications, code optimization and adding scheduled jobs to re-

index and update statistics in databases.

> Providing DB level support as well as SQL Server level support to the

users.

> Maintain the integrity, availability, and recoverability of all

production data systems. Planning for overall data deployment and

operational health.

> Responsible and Involved in SQL Server Performance Monitoring, Server and

Database optimization and Query tuning & used Windows Perform and various

3rd party tools to monitor SQL Server health and gauge the performance.

Used SQL Server Dynamic Management Views and functions to monitor &

optimize the performance.

> Worked with Business Analysts, Cognos Developer, SQL Developers, SSIS

Developers in Development of the Project

> Conducting Database Refresh once in every week from PROD to UAT, DEV, and

Test Environments.

> Monitoring SQL server Error logs, Disk Space growth, Clustering

Environment.

> Performed all SQL DBA functions for SQL Servers on various environments

like Production, UAT, and Development.

> Making plans to apply latest Service Packs to different versions of SQL

Server.

> Maintain the integrity, availability, and recoverability of all

production data systems. Planning for overall data deployment and

operational health.

> Worked on performance and tunning, identifying locking and blocking for

long running queries.

> Performing Backup and Restore operation from Production Server to UAT and

DEV.

> Monitoring clients' application and fixing bugs.

> Working on EDI and Promotional request to move database on production

servers.

> Working with 32bit and 64 bit clustered environment.

> Extensive ETL (Extract, Transform Load) work including SSIS subsystem to

provide daily data exports.

> Involved with the team to run different MS SQL Server tools like MAP tool

kit, SQLIO.

Best practice analyzer (BPA), RML utilities for SQL Server health check.

> Supports Production, UAT, and Development Environment.

> Monitoring all Production servers using third party tool IDERA

> Created SQL Server logins and assigning roles and Authentication models

as a part of Security.

Environment: SQL Server 2000/2005/2008/2008 R2, Microsoft Business

Intelligence, Visual Studio for SSIS, SSRS, SSAS, MS Office Access, Windows

Server 2003/2008.

Rume Corp, Farmingdale, NY

Nov 2008 - Feb 2011.

IT Technician/SQL Server DBA

Responsibilities:

> Installed SQL Enterprise Server 2005 / 2008 64 bit version on windows

2003 Servers.

> Designed and Implemented SSIS packages to load data from heterogeneous

data source.

> Performed different kind of DB backup and restore on regular basis.

> Migration of database from SQL Server 2000 to 2005 / 2008.

> Experience with implementing different type of Replication models like

snapshot and transactional.

> Developed, deployed and monitored SSIS packages including upgrading DTS

to SSIS.

> Worked and generated reports using SQL Server 2005 reporting services

(SSRS).

> Implementation of SQL logins, Roles and Authentication modes as a part of

security policies for various categories of user.

> Involved in implementation of log shipping for synchronization of

databases

> Scheduled Jobs and Alerts using SQL Server Agent.

> Designed and configured DB Mirroring in SQL Server 2005.

> Designed and implemented comprehensive Backup plan and disaster recovery

strategies implemented

> Performed and applied SQL service pack and windows service pack to

upgrade.

> Performance testing on stored procedures, indexing and Triggers.

> Involved in trouble shooting and fine tuning of database for its

performance and concurrency.

> Proficient with SSAS

> Experience in using DMV to improve Server performance.

> Responsible to check and repair various Sensormatics Antitheft IT

Equipment's

> Repaired IT based equipment Ultra Post, M4K and M2K power pack used for

Euro max and Euro Promax pedestals used as loss prevention system

> Able to check door max, digital promax pedestals with AMD 216 and AMS

9030, AMS 9040 power pack.

Environment: SQL Server 2005 / 2008, Microsoft Business Intelligence,

Visual Studio for SSIS, SSRS, SSAS, Microsoft .Net, MS Office Access,

Windows Server 2008.

DNS Software Technologies Pvt. Ltd, Pune, India

Oct 2007 - Sept 2008.

SQL Server DBA

Responsibilities:

> Involved in System Study and database Maintenance.

> Successfully installed and configure SQL Server 2005

> Migration of MS SQL Server from 2000 to 2005

> Monitored Log shipping as high arability solution.

> Configured Server memory for maximum performance and effective

utilization.

> Integrated Performance Monitor and SQL Traces to have better graphical

analysis to find system bottlenecks.

> Extensively used filtered Indexes to improve query performance and

lower storage and maintenance cost.

> Created, Modified and monitored Replication on all Production

databases.

> Designed and Implemented comprehensive Backup plans and disaster

Recovery strategies.

> Involved in Migration of DTS package to SSIS package.

> Worked and generated basic reports using SQL Server 2005 Reporting

services (SSRS).

> Created SQL Server logins and assigning roles and Authentication

models as a part of Security Policies for various categories of user

support.

> Created, Scheduled and monitored SQL Server Jobs making sure job run

successfully every night.

> Extensively worked in UAT and Production support and involved in

trouble shooting SQL Server in various level.

Environment: SQL Server 2000/2005, Windows Server 2000/2003, Microsoft

Business Intelligence Visual Studio for SSIS, SSRS, Microsoft .NET, MS

Office access.

DOT INFO TECHNOLOGIES, Pune, India

July 2006 - Sep 2007.

SQL DBA.

Responsibilities :

> Undergone through formal training for SQL Server 2000 and 2005.

> Involved in System Environment (DEV Environment) and database

Maintaining.

> Involved with team for Installation and Configuration of the MS SQL 2005.

> Involved in upgrading database MS SQL Server 2000 to 2005

> Used tools like SQL Server Management Studio, SQL Server Profiler, SQL

Server Agent and Database Engine Tuning Advisor.

> Good in high Availability database Mirroring and Merger Replication

> Conducted in performance tuning, Backup and disaster Recovery Process and

tools.

> Created logins and Maintained user permissions appropriately.

Environment : MS SQL server 2000/2005, MS Office access, MS Visual Studio,

Windows Server 2003.

Contact this candidate