Sql Server Data

Deepak

Phone No: 216-***-****

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

Summary:

. Extensive Experience in Installation, Configuration and Maintenance of

SQL Server Database.

. 7+ years of IT experience in Database Administration, SQL Server DEV

(SSIS/SSRS Design, Development, Security and Support of MS SQL Server

2008, 2005, 2000, 7.0 in Production, Test, Development, Replication &

Cluster Server Environments.

. Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server

2008.

. Have Experience working with Data Compression techniques like Row Level

and Page Level Compression and Database backup Compression in SQL 2005

and 2008.

. Rich Experience in automating database monitoring and administration

tasks using scripts, implementing changes and capacity planning.

. Good Knowledge of all phases of Software Development Life Cycle (SDLC)

involving Systems Analysis, Design, Development and Implementation and

testing.

. Good knowledge of Relational Database Management Systems (RDBMS).

. Experience in N-tier, DNA and Client Server Architecture.

. Extensive Knowledge of RAID, SAN (EMC) technologies.

. Expertise in implementing efficient Disaster Recovery Strategies and High

availability like Replication, Log shipping, clustering (Active/Passive)

and Database Mirroring.

. Worked on 32 bit and 64 bit SQL Server and MSCS Configurations.

. Expertise and Interest include Administration, Database Design,

Performance Analysis, and Production Support for Large (VLDB) and Complex

Databases.

. Specific hands on experience include administering large and complex

Databases, Database Design, Normalization, Replication, Log Shipping,

Full-text indexing, and Database Application Development using varied

development tools. Extensive use of DTS in SQL Server, Performance Tuning

& Application Design, Hot and Cold Backups, Disaster Recovery Planning,

Security Management, Managing server and clients

. Extensively worked on 32bit, X64 bit and i64 clustered and standalone

server environment.

. Expert in extracting and transforming data between homogenous and

heterogeneous systems using DTS packages, IMPORT/EXPORT, BULK Insert, BCP

and XML Technologies.

. In-depth knowledge of T-SQL (DDL, DML)

. T-SQL, Stored Procedures, Functions, Cursors, Table variable, temp

tables, CTE and Triggers.

. Creating XML Indexes, modifying XML data, Retrieving XML data using SQL

Server.

. Experience in Database administration activities for DB Security

(creating users, roles, and assigning permission to them).

. Experience in Performance Tuning, Query Optimization, Client/Server

Connectivity, Database consistency checks using DBCC utilities.

. Experience in Database Backup, Recovery, Replication and Disaster

Recovery (Log Shipping) procedures.

. Intensive experience in monitoring and tuning SQL Server and database

performance using SQL Profiler, Index Tuning Wizard and Windows

Performance Monitor.

. Experience of installing, configuring, deploying, Integrating SQL Server

Reporting services, Analysis Services on SQL Server 2008, 2008.

. Experience and Implemented New Features of SQL Server 2008 like Policy

management, Resource governor, Data collection, backup compression.

. Performed daily tasks including backup and restore by using SQL Server

2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL

Server Agent, and Database Engine Tuning Advisor

. Used Data Partitioning, Database Snapshot, Database mirroring in SQL

Server 2005.

. Worked with Offshore teams and Developers and developed Proper

Infrastructure Support model

. Experience in providing Production Support for 24x7.

Technical Skills:

RDBMS/DBMS: MS SQL Server 2008,2005,2000, 7.0, MS-Access,

Oracle10.i/9.i/8.i

Database Technologies/Tools: SQL Server Enterprise Manager, Query Analyzer,

SQL Profiler, T-SQL, PL/SQL, DTS, SSIS, OLTP,

ADO, SQL OLEDB, DBCC,, SSRS,SSAS, VERITAS

Netback up 6.0, Light Speed, ERWIN 3.5/4.0,ER

Studio 7.0, Visio 2002, Visual Source safe,

TFS.

Operating System: Windows 2008/2003/2000/NT/Vista Datacenter and

Advanced Server -32bit/64bit. Windows

2000/2003 Advanced Server, Windows Exchange

Server 2003/2008,Windows NT 4.0/3.5,

Windows9.x, Windows XP

Programming Languages: C/C++, Java, HTML, JavaScript, C#, .NET,

T-SQL, PL/SQL.

Others: MS Office 2000/2003/2007,OutLook etc.

Professional Experience:

Client: Ironshore services Inc, one state street, NY

Nov '10 - Till Date

SQL Server DBA/ Operational Specialist

Responsibilities:

. Administration and Maintenance of SQL Server 2008/2005/2000 databases in

Production, Staging, QA and development environments.

. Responsibilities include the Production and Application Support for the

Database and Application Servers.

. Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 (64

bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.

. Designed the Database Recovery plan and implemented the Database

Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery

Drill processes.

. Provide and Monitor database "health" - availability, reliability,

performance and capacity planning using SQL Profiler, Database Tuning

Wizards.

. Provide Reliability using Transactional Replication.

. Troubleshooting blocking issues, deadlocks using blocker scripts, trace

flags and activity monitor.

. Resolving performance issues using DMVs (Dynamic Management Views).

. Performance Tuned Stored procedures using Index Tuning Wizard, Estimated

Execution plan, Profiler and PerfMon.

. Used the DMV's to find the missing indexes on the tables for most

appropriate used and missing indexes.

. DTS, SQL Server Integration Services Package (SSIS) and Transact SQL

Scripts.

. Database Design; Creation of tables ( > 150), views, triggers, stored

procedures and functions using SQL (Structured Query Language) and T-SQL

(Transact-SQL).

. Designed application database model using MS Visio for Enterprise

Architecture.

. Setup, Installation and Configuration of SQL Server RDBMS. Evaluating and

installing patches/Service Packs.

. Optimization, performance tuning of SQL Server Systems and databases.

. Setup Database Security and maintain accounts and access levels by

creating suitable Logins, Roles and assigning object level permissions.

. Monitoring database access users and roles.

. Analysis, development and maintenance of Backup Plan, Disaster Recovery

Plan, Procedures and Strategies using Maintenance Plans.

. Created Auditing procedure related Data using DDL/DMLTriggers to keep

track all the changes to database and data in tables.

. 24x7 Production support on rotation bases and experience of MTM incident

ticket management, for resolving CMR.

. Configure Database Mail for sending failure job notification email

messages from Jobs and Procedures.

. Used CDC (Change data capture), Table valued parameters and other new

features in new applications.

. Adhoc data query and analysis for different SQL Server based Business

applications for information and audit purpose as required by Business

Users.

. Working with testing team for testing of applications, Reports and other

batch job processes as required. Generating test data as well as

confirmation of testing operations from backend.

. Documentation of SQL Server system and database operations, technical

specifications, functional specifications, best practices, policies and

procedures.

. Implemented the Reporting Services in SQL Server 2008 and integrate the

Microsoft Share Point portal with Reporting services.

. Design, Development, Configuration and deployment of custom build

business reports using MS Reporting Services - SSRS.

. Perform after hours and weekend on-site or on-call support as needed.

Environment: MS SQL Server 2008/ 2005/ 2000, Windows server 2008/ 2003

Datacenter and Enterprise edition 32 bit/64 bit, Transact-SQL, SQL

LiteSpeed, MS Visio for Enterprise Architect, ADO.net, VB.net, SSIS,SSRS,,

TFS(Team Foundation server).

Client: Office of Payroll Administration, City of New York, NY

April '2010 to Oct '2010

SQL Server DBA

Responsibilities:

. Administering and maintaining large SQL Server 2008, 2005 and 2000

databases with more than 100 million records in individual tables.

. Table Partitioning for existing and new application databases.

. Developing Reports using SQL Reporting Services.

. Data Analysis and BI Reports against OLAP/MDX Data cubes using SSRS.

. Disaster Recovery planning and implementation - Database mirroring, Log

shipping, Active Passive clustering

. Involved in installations, releases, change control systems.

. Creating SQL agent maintenance jobs for purging data, maintaining

indexes, archival operations

. Creating SSIS package based jobs for bulk data loading, updating and

exporting.

. Supporting production issues during work and after hours as required.

. Monitoring SQL Services using MOM, SQL Sentry.

. Backups and Restore using Litespeed for SQL Server

. Using new features of SQL Server 2008 like Log compression, transparent

data encryption TDE, Policies, Performance data collector, Auditing.

. Performance tuning, trouble shooting and monitoring using Performance

Dashboard reports, Database Tuning Advisor, SQL Profiler, Dynamic

Management views (DMV)

. Database Design and maintenance for trading data services and

collaboration services for users of financial community (traders, bankers,

hedge fund managers)

. Creation of tables, views, triggers, stored procedures and functions

using SQL (Structured Query Language) and T-SQL (Transact-SQL).

. Using SQL Server Service Broker to create async. message based database

update services.

. Maintaining database security and application security framework using

security matrix, windows based group memberships and database roles.

. Extensively using XML for input and export operations.

. Using TFS for version control of Database code.

. Implemented Database Replication (Merge and Transactional) for Call

Center Database on SQL Server 2005.

. Upgraded DTS to SSIS Packages, deployed SSIS packages from Dev to Prod,

Created Deployment utilities,created Configuration files(XML),Created

Completed Complex SSIS packages for Data extraction and transformation

using various new features like fuzzy lookup, fuzzy grouping, Sequence

container, for loop container,Merge troubleshooting package related

issues and errors.

. Created and Implemented SSIS Packages for importing and exporting data to

other data storage like PostgreSQL, FoxPro, and DB2.

Environment: SQL Server 2008, SQL Server 2005, Windows server 2008, Windows

server 2003, Transact-SQL, SQL Server Reporting Services, SQL Sentry,

VMWare

Client: KPMG, Montvale, NJ

June'09 -March '2010

SQL Server DBA operation Specialist

Description: Worked on Sentinel project.

Responsibilities:

. Complete administration and Maintenance of MS SQL 2000/2005/2008 servers.

. Capacity planning, design and implementation of database solutions.

. Experience working on Active/Passive Failover Clustering solution into HP

EVA 3000 SAN environment for SQL Server Consolidation.

. Installation, Configuration and Tuning of SQL Server 2005 and applying

SQL Server Service Packs and cumulative hotfixes.

. Apply hot fixes, Patches and Service Packs and create script for

Unattended Installation.

. Database Tuning and Performance Optimization using SQL Profiler,

SHOWPLAN, Index Tuning wizard.

. Development of Stored procedure, Trigger, Index, Jobs, Alerts, SQL Mail

Notification using Enterprise Manager and Query Analyzer.

. Used FOR XML clause of SELECT statement of SQL Server for sourcing

database results directly into the .NET Web Controls at run time and web

based reports.

. Utilization of Excel Pivot table, database queries for Excel based data

analysis

. Debugging various access and performance related SQL server issues.

Analyzing the profiler data from production for blocking/deadlocking

happening on the server, to find out long running, I/O expensive,CPU

expensive and read/write expensive queries

. Installing, configuring, and maintaining BMC Patrol on Database Servers

for extensive monitoring, alerting and auditing the application, OS

related errors.

. Worked with SA on SAN issues, DNS aliasing.

. Worked with SA on Disk failures, RAID problems.

. Setting up and handling troubleshooting issuesin high availability and

disaster recovery solutions like log shipping, clustering, mirroring,

replication etc.

. Configured and supported log shipping from Amsterdam to Singapore

. 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.

. Transferred data (ETL) to Data ware house Environment using SSIS

. Used Connection managers like Flat File, File. OLEDB, ODBC, SMTP, HTTP

and many others in SSIS.

. Experienced with the Objects in SSIS like Task, Maintenance plan tasks,

Data Flow Tasks and Containers.

. Used Containers like For Loop, Sequence and For Each Containers in SSIS.

. Designed packages in Package Designer using Dataflow Sources,

Transformations and Destinations.

. Implemented and maintained database security, policies and procedures.

. Developed standards and guidelines to maintain and develop and administer

the SQL Server database.

. Provided 24/7 Support for Production, Development & Test Servers of MS

SQL Servers.

. Implemented and maintained database backup policies using third party

tool Quest LiteSpeed 4.7.

. Extensively documented all the databases, database objects, jobs and the

changes made to the database using Visual source safe (VSS) tool.

. Extensively involved in change control documentation, issue tracking

documentation.

Environment: MS Windows 2003/2008 MS SQL Server 7 /2000/2005/2008, SQL, T-

SQL, SQL Query Analyzer, Profiler,.NET. Litespeed, VSS, SSIS

Client: Unifocus, Texas

Oct '07 -

May '09

SQL Server Development Database Administrator

UniFocus, a performance-management firm in the hospitality industry,

acquired Telman Software to enhance UniFocus real-time, dynamic information

systems. UniFocus integrated Telman's financial expertise and Focused

Scorecard database into its own systems.

Responsibilities:

. Worked in Sql Server 2000/2005 with 2 TB of Data and SAN infrastructure

of 60 Server 2 NODE cluster Active / Active and Active/ passive on

Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN

environment

. Migrated DTS packages from Sql Server 2000 to SSIS SQL server 2005.

. Created Documentation for steps need to be taken while upgrading the SQL

server 2000 to SQL server 2005.

. Performed BCP extracting the zip file and used the xp_cmdshell for the

bulk operation.

. Utilized foglight, profiler, Perfmon for monitoring the deadlocks,

blockings and windows level performance also.

. Conducted Consistency Checks on the database and analyzed the

fragmentation on the indexes.

. Worked with Transactional Replication to achieve Load balancing.

. Created several stored procedures, triggers, views.

. Created ADHOC reports using SSRS in BIDS.

. Reviewed Store Procedures and Queries fine tuned the Slow Running

Queries.

. Implemented Maintenance Plan tasks like History Clean Up and Rebuilding

the Indexes in SSIS.

. Detected and Resolved locks and Deadlocks using the Trace Flags and

Native tools like Profiler and the Activity Monitor.

. Creating Logins and Mapping the User to Roles by Assigning Permissions.

. Development and Atomized Administration and Maintenance Plan for SQL

Server 2005.

. Troubleshooted SSIS packages which failed to execute in the Scheduled

Jobs.

. Developed CLR Functions to replace earlier application modules and

integrate assembly using Service Broker Feature Available in SQL Server

2005.

. Creating Stored Procedures to convert database tables into XML format and

display via web.

. Collected business requirements, designed data maps and data models.

Created Internal and External Design Documents and Transaction Definition

Documents.

. Used DTS Xchange tool for Migrating DTS packages to SSIS.

. Development of DTS Packages using DTS Designer for Extraction,

Transformation and Loading (ETL) for extraction, transfer and load (ETL)

of existing data into SQL Server

. High Level Design of ETL DTS Package in SQL server 2005 for integrating

data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text

Format Data).

. Used Notification Services Available in SQL Server 2005 to create alerts

and email notification.

. Worked on Veritas Netbackup 6.0 for Database backup and recovery

solution.

. Involved in change management process like releasing the report into the

production Report server by deploying the code using the TFS.

. Configured the Protection levels for the SSIS packages while moving from

Staging to Production

. Involved in 24/7 production support.

Environment: TSQL, MS SQL SERVER 2000/2005,SSRS, VISUAL STUDIO 2005,

VB.NET,C#, ADO.Net, XML,MS WINOWS SERVER Enterprise Server

2008/2003/2000,IIS 6.0,SSIS

Client: Freddie Mac, Mclean, VA

Nov'06 - Sep '07

SQL Server Development DBA

Resposibilities:

. Created and maintained various databases for Production, Development and

Testing environments using SQL Server 2000.

. Creation of new database, planning the location of data, index, and

transaction log files on the disks.

. Perform Data Modeling for New Database using Erwin 3.5.2.

. Created and redesign stored procedures, functions, and triggers.

. Used Database Consistency Checks - DBCC commands for database

maintenance.

. Installed and Configured SQL server 2000 on windows 2000 data Center

server system.

. Performed daily backups and developed recovery procedures.

. Created Alerts and Notifications for system errors, insufficient

resources, fatal database errors, hardware errors, security breach, etc.

. Implement triggers to audit some of the production tables and raising

customized error messages and sending the emails to the concerned team.

. Performed Database creation; database tuning, performance planning.

. Involved in Proactive and Reactive tuning of databases in every stage of

the project.

. Capacity planning in estimating and sizing of tables.

. Created Tables, Views and Indexes.Wrote Triggers and Stored Procedures.

. Actively involved in Normalization (3NF) & De-normalization of database.

. Created database roles and alerts for Databases.

. Created DTS Packages for data import / export data from SQL Server to

Access, text and EXCEL files

. Experienced in performance tuning using perfmon and SQL profiler of SQL

server.

. Setting up backup plans, maintenance plans for the databases.

. Provided support to the application developers on the application

databases.

. Handled the database components of application releases.

. Worked on Linked Servers to run distributed queries between SQL server

and other data sources like excel using ODBC, OLE DB Drivers.

Environment: Windows 2000 Advance/Data Center, Windows XP, MS SQL Server

2000/7.0, Erwin 3.5.2, MS Excel, IBM p series, Dell/EMC CX3/CX Series SAN

Arrays

Client: LIC Insurance, INDIA

Jan'04

- Oct '06

SQL Developer

Spread Life Insurance widely and in particular to the rural areas and to

the socially and economically backward classes with a view to reaching all

insurable persons in the country and providing them adequate financial

cover against death at a reasonable cost.

Responsbilites:

. Sound knowledge Stored Procedures, Indexed views, User Defined

Functions (UDL), Triggers Distributed Queries and Common Table

Expressions.

. Understanding the environment and tables and business logic.

. Understanding the user requirements and creating the logics and

scripts

. Implementing the database objects like stored procedures, Functions

and Triggers.

. Debugging and fixing the bugs.

. Worked to create Software Requirement Specification (SRS) document.

. Developed and coded applications in T-SQL.

. Designing the Logical and Physical databases and development of SQL

Server Database.

. Created the DTS packages to load the data file excel files into SQL

table.

. Designing the scenarios and process flow using UML.

. Preparation of Entity Relationship diagrams and data flow diagrams.

Environment: TSQL, MS SQL SERVER 2000, ENTERPRISE MANGER, VB.NET, WINOWS

SERVER 2003.

Contact this candidate