Sql Server Manager

Jigar Merchant

Tele. : 973-***-****

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

SQL SER VE R D BA

PROFESSIONAL SUMMARY

Over five plus years of IT experience include four plus years of experience in SQL Database

Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005,

2000 and 7.0 in Production, QA, Reporting Services, Development environments &

Replication and Cluster Server Environments.

Extensive experience in installation and configuration of MS SQL Server 2005/2000/7.0/6.5

versions.

Experience in working with Windows server 2003, Windows 2000 Advance Server and

Windows NT Server Installation and Administration.

Expertise in planning and implementing MS SQL server security and database permissions.

Successfully tested and implemented Log Shipping Technique used for warm backup solution

for MS SQL Server 2000/2005 databases.

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Hands on experience in trouble shooting database issues.

Experience in writing and debugging Stored Procedures and Triggers.

Extensive knowledge of Relational Database Management Systems.

Experience in implementing different types of Replication models like Snapshot, Merge and

Transactional.

Maintained Database authentication modes, creation of users, configuring permissions and

assigning roles to users.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP)

and Data Transformation Services (DTS).

Migrate from Oracle to SQL Server through DTS Packages

Upgrade DTS packages to SQL Server Integration Services (SSIS).

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database

consistency checks using DBCC Utilities.

Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.

Expertise with Table Design, Index Design and Performance Tuning.

Involved in optimizing code and improving efficiency in databases including re-indexing,

updating statistics, recompiling stored procedures and performing other maintenance tasks.

Experience in implementing business logic using Triggers, Views and Stored procedures.

TECHNICAL SKILLS

Operating Systems: RDBMS:

Windows Server 2000/2003, Windows NT 4.0 MS SQL Server 2005, 2000, and 7.0

Windows XP/98/95, MS DOS, Linux, UNIX. Oracle, Microsoft Access

Languages: OLAP Tools:

C #, T-SQL, SQL plus, OSQL, VB MS OLAP Services Manager

Scripts, ADO.Net

SQL Server Tools and Others:

Export & Import (DTS), SSIS, Replication

Enterprise Manager, Profiler, Query Analyzer,

ERWin

1

PROFESSIONAL EXPERIENCE

AIG Personal Auto Group Wilmington, DE

Database Administrator August 2008 – February 2009

RESPONSIBILITIES:

Installing SQL Server 2005 Instance on Window 2003 Servers.

Migrate databases from SQL Server 2000 to SQL Server 2000/2005 & Oracle.

Create and modify Jobs, Alerts, tables, maintenance plans, DTS and SSIS packages based on

the requirements.

Give user risks to perform user activity based on the applications and requirements.

Maintain and manage & monitoring SQL Server Databases

Monitoring the user activities

Manage and monitoring disk space for backup and restore.

Responsible for providing and manage data on 24/7 applications.

Provide On-call support for other application on remote side.

Maintain and create/modify SSIS and DTS packages for migrate the data from SQL Server to

data warehouse.

Performance tuning of SQL Query and database

Maintain and manage database mirroring and replication.

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, ADO.Net, Oracle 10g/11I, SQL

Plus, SQL Loader, TOAD

University Of Michigan Ann Arbor, MI

Database Administrator December 2007 – July 2008

RESPONSIBILITIES:

Migration of SQL Server 2000 DTS Packages in to SQL Server 2005 SSIS.

Recompile SQL Query to pull out the data and make some changes.

Create BCP scripts to load and unload SQL Tables.

Documentation of SSIS Packages and Database Model.

Performance Monitor with SQL Profiler and Windows Performance Monitor.

Create SSIS Package to insert the data with SQL Queries on SQL Database to Oracle

Data warehouse.

Change the Physical model of SQL table based on the requirement and Data Warehouse.

Create new user as per requirement and assign proper rights to the Developer User.

Work with developers to re-write the code in Visual Studio & ADO.Net and deploy on test

servers.

Involved in oracle to setting up the custom database schema and design on it.

Configuring Oracle ODBC driver for SQL Provider.

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, ADO.Net, Visual Studio 6, Oracle

10g, SQL Plus.

Future Technology Associate Brooklyn, NY

Database Administrator March 2007 – Nov. 2007

RESPONSIBILITIES:

Performed Data Migration from SQL Server 2000 to 2005.

Creating tables, views, indexes, stored procedures, triggers, cursors.

2

Performance Tuning: Analyze, tuning and optimizing and using performance monitor.

Migrating SQL Server 2000 DTS Packages to SQL Server 2005.

Scheduled the backups and recover when needed.

Configured SQL Server clients and support for test and development servers.

Created User Database, tables and gives user rights.

Imported data from text files and excel spread sheets into SQL Server 2005 databases using

SSIS packages.

Created Reports in SSRS.

Performed DBCC Utilities to checks and fixing data

Enabling Service Broker with WMI Provider for Server Events.

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, ADO.Net, ERWin

Reliadat Ahmedabad, India

SQL Server DBA Jan. 2006 – Feb. 2007

RESPONSIBILITIES:

Installation, configuration the MS SQL Server 6.5 and maintenance of servers in various

environments.

Performance and tuning of SQL servers and application issues related to migration.

Data Transfers between various servers using BCP and Managing Disk space on NT systems

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and

weekly basis.

Complete automating on NT so that the tasks are run with out user monitoring.

Develop and maintain in-house utilities to automate problem determination, change

implementation and monitoring activities.

Administrative and Production support for various applications in all environments.

Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and

Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000/2005, Query Analyzer, Windows 2000 Server, Import/Export Data, Visual

Studio.

Hi-Tech Solutions Ahmedabad, India

SQL Server DBA/Analyst Feb. 2004 – Dec. 2005

RESPONSIBILITIES:

Developing and implementing plan for Disaster Recovery.

Requirement gathering and analyzing data sources

Assisted in design and implementation of the Database

Installation and configuration of SQL Server 7.0 and 2000

Design and implementation of Backup policies and Recovery procedures

Created stored procedures and triggers

Transfer of data from non SQL Server sources

Used BCP for data transfer

Environment: SQL Server 2000, Windows 2000 & Windows NT 4.0

EDUCATIONAL QUALIFICATIONS

Bachelor of Commerce with Computer Science, Ahmedabad, India.

3

Contact this candidate