Sql Server Data

Kamal Chauhan [pic]

**********@*****.***

***- ***-****

PROFESSIONAL SUMMARY

. Over 7+ years of extensive experience in Database Design, development

and administration of database systems using MS-SQL 2008/2005/2000

for both OLTP/OLAP enterprise applications

. Expertise in installation, up gradation and configuration for SQL

Server including applying Service Packs

and Hot Fixes on 32-bit (x86) and 64-bit (x64) environments

. Created & Deployed SSIS (SQL Server Integration Services) Projects,

Schemas and Configured Report Server to generate reports in SSRS.

Hands on experience on Migration of DTS packages from SQL 2000 to

2005.

. Experience in Importing/Exporting Data from various data sources like

Excel, Oracle and Flat file using BCP, Bulk Insert & DTS utility and

transformation of data between source and destination databases

. Involved in transformation of OLTP data to the Data Warehouse using

DTS and SQL commands.

. Supported Installation, Configuration and Maintenance of SQL

Active/Passive Clustering for high availability

. Successfully tested and implemented Log shipping as a Disaster

Recovery and Warm Backup solution for

MS SQL 2000 and MS SQL 2005 Servers

. Experience in MS SQL Server configuration, performance tuning,

client/server connectivity, query optimization, back-up/recovery,

running Database Consistency Checks using DBCC.

. Expertise in index tuning, stored procedures, functions, triggers,

cursors and complex T-SQL queries

. Solid command over daily database administration activities like

Backup & Restore, Running & Scheduling Jobs, Monitoring Event Viewer

and SQL Server Error Logs

. Good experience in Automation Configuration by Creating Jobs, Alerts

and Operators and Database Mail.

. Participated in Disaster Recovery and Capacity planning exercises to

ensure smooth operations

. Sound knowledge on SQL Server and Database Monitoring & Tuning for

better performance using different tools like Database Tuning

Advisor/Index tuning wizard, Performance Monitor, SQL Profiler

. Expert in designing Enterprise reports using SQL Server Reporting

Services (SSRS 2005/2008), use of multiple value selection in

parameters pick list, matrix reports using Report Designer and managed

report security

. Used Erwin Data modeling tool and Microsoft Visio for designing the

logical and physical data models

. Worked with Dynamic Management Views (DMV) for improving query

performance.

. Analyzed the existing application programs and tuned SQL queries using

Execution plan, Query Analyzer,

SQL Profiler and database Engine tuning Advisor

. Experience in monitoring different types of Replications like Snapshot

and Transaction Replication.

. Provided 24x7 Production Support for mission critical applications on

call rotation basis.

TECHNICAL SKILLS

Databases SQL Server 2008,SQL Server 2005/2000,MS-Access, MySQL,

Oracle

Database Tools SQL Server Management Studio, SQL Profiler, SSIS, SSAS,

SSRS, DTS, Business Intelligence Development Studio

(BIDS), TOAD, ERWin, SQL Compare

Programming T-SQL, C,C++, SQL, PL/SQL

Languages

Tools and MS-Visio, Visual Source Safe (VSS), MS-Excel, Quest

Utilities Foglight, SQL Litespeed

Operating System Windows Server 2003/2000, Windows XP, Vista, Linux

PROFESSIONAL EXPERIENCE

Visa International, foster city, CA

August 2007 - Present

SQL Server Developer/DBA

Visa is a global payments technology company that connects consumers,

businesses, banks and governments in more than 200 countries and

territories, enabling them to use digital currency instead of cash and

checks.

Responsibilities:

. Installation of SQL server 2005/2008 on development, test and

production servers in Win 2003 environment and ensured all servers

were up-to-date with latest Service Packs, hot fixes and updates

. Administering production server and ensuring 24/7 availability for all

enterprise applications

. Responsible for performance tuning of the databases, running databases

tuning advisor, updating statistics, index fragmentation and

troubleshooting application issues

. Database normalization, query optimization and database consistency

checks using DBCC utilities.

. Perform database integrity checks, update statistics and used DBCC

DBREINDEX for improving performance.

. Create objects such as table, views, stored procedures, DDL/DML

triggers and more using T-SQL scripts.

. Perform data migration from excel and other flat file using ETL tool

like SSIS and BCP command.

. Analyze query plans, use extended stored procedures and manage indexes

and locks

. Transform business logic into database design and maintain it by using

SQL tools such as stored procedures, user defined functions, views and

triggers for enterprise applications

. Database cleaning/Shrinking up, DBCC, Update Stats and maintaining the

database integrity.

. Created SSIS packages for ETL operations and to transfer data from SQL

Server to Access, Excel and flat files

. Extracted data from SQL Server for reporting disk space statistics,

row counts and job history in sysjobs

. Creating Ad Hoc and Parameterized various Reports using SQL server

2005 Reporting Services (SSRS)

. Identified Tested and resolved database performance issues (monitoring

and tuning) to ensure database optimization by using Index Tuning

Wizard, SQL Profiler and Query Analyzer and system monitor

. Created Users and Roles and managed security and permission of

database.

. Implementation of Point in time Backup and recovery plans of all

databases and maintain documentation.

. Created stored procedures for Automatic Scripting to back transaction

logs, log files, maintain archives

. Created maintenance plans and scheduled jobs to perform nightly data

loading operations

. Created test cases at the back end for various scenarios and executed

SPs and recorded durations

. Created database diagram in MS Visio and SQL Management Studio to

maintain schema diagrams

. Responsible for configuring replication methods like snapshot,

transactional and merge replication

. Setting up database backup and recovery procedure for production, QA

and development servers.

. Responsible for fine tuning of the database, trouble shooting, user

administration, memory management

and running DBCC commands

. Created many SSIS packages using Import/Export Wizard. Designed many

Packages using SSIS Designer by using Control Flow and Data Flow Tasks

with ETL Tool

. Performed QA tests for migration of database objects from SQL Server

2005 to SQL Server 2008

. Implemented security to restrict the access to users and to allow them

to use only certain reports

. Provided Database Administrative Support through 24X7 for all users

Environment: Windows 2003 R2, MS SQL Server 2008/2005, SQL Profiler,

Perfmon, Erwin, SSRS, SSIS, MS-Access

Hilton Group, Nashville

June 2006

- Aug 2007

SSIS /SSRS Developer

Hilton Group is one of the premier organizations in hotel industry. The

corporate office has a centralized administration system. The system

maintains the customer relation activities like acquire, serve, retain and

grow relationships with their customers.

Responsibilities:

. Involved in Designing, Developing and Testing of the ETL (Extract,

Transformation and Load) strategy to populate the data from various

source systems feeds using SSIS.

. Designed ETL packages dealing with different data sources (SQL Server,

Flat Files) and loaded the data into target data sources by performing

different kinds of transformations using Integration Services (SSIS)

. Involved in building and maintaining SSIS Packages to import and

export the data from various data sources using BIDS based on the

design data models

. Worked on various tasks and transformations like Execute Sql Task,

Execute Package Task, Conditional split, Script Component, Merge and

Lookup while loading the data into Destination.

. Created stored procedures, Triggers, User-defined Functions, Views for

both Online and Batch requests handling business logic and

functionality of various modules.

. Responsible to support SQL Servers with ever-changing workloads, and

achieving some level of predictable performance (or minimizing

variance in plans and performance).

. Responsible for Database and Log Backups & Restoration, Backup

Strategies and Scheduling Backups

. Created Packages, Jobs and Sending Alerts using SQL Mail, database

Backup, Recovery and Disaster Recovery procedures. Planned the

complete Back-up of various Databases for Disaster recovery scenarios

. Administering the MS SQL Server by creating user logins with

appropriate roles, dropping and locking the logins, monitoring the

user accounts, creation of groups, granting the privileges to users

and groups

. Created various ad-hoc SQL queries for customer reports, executive

management reports and types of report types like tables, matrix, sub

reports

. Responsible for installation of SQL Server, database design and

created schema objects like tables, views

. Create functional and technical specifications for projects

. Used DDL and DML for writing triggers, stored procedures, and data

manipulation.

. Involved in configuring and maintaining Report Manager and Report

Server for SSRS.

. Created tabular Reports, Matrix Reports, drill down reports, Sub

Reports

. Created Report Models to simplify the process of building the

customizable Reports by the users themselves.

Environment: SQL Server 2005 Windows 2003 Server, SSIS, Erwin, SQL

Profiler, SSRS, SSMS, IIS 6.0

Lincoln Financials, Buffalo, NY

Sep 2005 - June 2006

SQL Server DBA\Developer

Lincoln Financial Group sells a wide variety of financial products and

solutions through financial advisors.

I was involved in setting up DTS packages for data coming from data sources

and migrating the data from supporting data sources into SQL Server

Responsibilities:

. Identified the necessary steps to enhance user response time by

checking fragmentation and reindex tables for efficient application

access methods.

. Rebuild Indexes on Various tables using DBCC DBREINDEX and also

defragments with DBCC INDEXDEFRAG

. Scheduling activities for Maintaining Databases and installed MS SQL

Servers 2000.

. Design DTS package to export SQL Server data to Access Database

. Responsible for Database and Log Backups & Restoration, Backup

Strategies and Scheduling Backups

. Created Packages, Jobs and Sending Alerts using SQL Mail, database

Backup, Recovery and Disaster Recovery procedures. Planned the

complete Back-up of various Databases for Disaster recovery scenarios

. Set up, configure and administer Snapshot and Transactional

Replication on MS SQL Server 2005.

. Administered Backup and recovery and administered Disk and Database

Space.

. Administered the MS SQL Server by creating user logins with

appropriate roles, monitoring the user accounts, granting the

privileges to users and groups.

. Assign users to particular roles and scheduled the job for Database

Backup, Transaction Log Backup.

. Ran various DBCC commands like checkdb/checktable, showcontig,

showstatistics etc. for checking database/table consistency and system

performance.

. To ensure all scheduled administrative jobs are running/completed for

Microsoft SQL Servers.

. Tested SQL Server 2005 in Development Environment and deployed in

production later on.

. Involved in installing SQL Clustering for production environments.

. Worked with various business groups while developing their

applications, assisting in database design, phasing from development

to QA and to Production environment.

Environment: MS SQL Server 2000, Windows 2000 Server, Enterprise Manager

Acxiom, Conway, Arkansas

July 2004 - Sep 2005

SQL SERVER DBA /DEVELOPER

Served as SQL Server Database Developer/Administrator for Financial

Accounting System for the finance/IT group

Responsibilities:

1. Interacted with users and troubleshooting the problems involved with

development of stored

2. Involved in writing T-SQL Programming for implement stored procedures

and Functions for different tasks.

3. Creating and managing schema objects such as tables, views, cursors,

indexes, procedures

for any tables, triggers and maintained Referential Integrity across

parent and child tables

4. Wrote stored procedures using Dynamic SQL and cursors to implement

iterative business logic for apps

5. Created views to develop new user-friendly web pages and restrict data

access to users.

6. Used joins and other complex queries to view the results that meet the

business decision.

7. Query optimization and performance tuning of SQL Stored Procedures using

query plans and SQL profiler

8. Using profiler to find badly performing queries and deadlocks and

resolved them using locking hints like nolock

9. Tuned SQL queries using Show Plans and Execution Plans for better

performance and tracked durations

Extraction, transformation and Loading [ETL] of Data using DTS Packages

from source to destination

Exported and imported data from text files and Excel to SQL Server database

using BCP utility

Backing up, restoring systems & other database as per requirements and also

scheduled those backups.

13. Involved in fixing constraints to all database objects line rebuilding

the indexes and updating the statistics.

14. Involved in checking database consistency, data integrity and data

redundancy.

15. Involved in snapshot replication of the tables in the production

servers

16. Scheduled database maintenance tasks, alerts to the operator by means

of email in case of success/failure of job and to solve emergency

scenarios like server shutdown, when the database is in suspect/shutdown

mode.

17. Responsible for scheduled backups, taking tape backups and disaster

recovery

Environment: SQL Server 2000, SQL Server 7.0 Windows 2000 Server, DTS,

Erwin

ENGELHARD CORPORATION (Iselin, NJ)

Feb 2003 - July 2004

SQL Server DBA

Engelhard Corporation is a fast growing company in New Jersey that

manipulates basic materials - typically minerals, mechanically and

chemically, altering their size, shape, porosity and chemical

characteristics to produce a wide range of functionality with important

business uses. This project included creating production and marketing

system, which included all customer information and all business

transactions..

Responsibilities:

Database Administrator, Database Programming.

. Relocation of Databases from one server to another server using attach

and detach databases.

. Implementation of SQL Logins, Roles as a part of Security Policies for

various categories of users

. Rebuilding the indexes at regular intervals for better performance.

. Designed and implemented comprehensive Backup plan and disaster

recovery strategies.

. Involved in Weekly Change Management for all T-SQL scripts run on

production servers

. Implemented log shipping between two instances of servers using

Database Maintenance Plan

. Involved in trouble shooting and fine-tuning of databases for its

performance and concurrency.

. Monitored and modified Performance using execution plans and Index

tuning.

. Maintaining the database consistency with DBCC at regular intervals.

. Used DTS packages to move logins and jobs from one server to another

server.

. Monitoring SQL server performance using profiler to find performance

and deadlocks.

. Maximum performance and uptime in production environment.

. To analyze long running slow queries and tune the same to optimize

application and system performance.

. Handled up to half TB Size databases with clustered and replication

environment.

. To set up SQL Server configuration settings to resolve various

resource allocation & memory issues for SQL Server databases and to

setup ideal memory, min/max server options.

. To perform installations & performance tuning, manage capacity

planning & user accounts, and implement DB security for multiple

instances of development, QA, and production SQL Servers databases.

. Develop data models and perform forward and reverse engineering using

data modeling tools like ERWIN

Environment: SQL Server 2000, Windows 2000/2003, Enterprise Manager, DTS

Import/Export, Profiler

EDUCATION

Bachelor of Engineering, Sardar Patel University, India

REFERENCES

Available upon request

Contact this candidate