SUMMARY:

• 8 +years of experience with the 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Stand alone Server Environment.
• Experience installing MS SQL SERVER 2000,2005,2008,2008 R2; updating with hot fix and service packs
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing High availability solutions like different Replication models (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Strong experience in mentoring with team members, documentation and 24/7 on call production support.
• Implemented Side by Side Migration of MS SQL SERVER 2000/ .
• Experience with Microsoft SQL Server Integration Services or any comparable ETL tool and Reporting tool with SQL Server Reporting Services using Business Intelligence Development Studio (BIDS)
• Expert in developing T-SQL (DDL, DML, DCL) statements.
• Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
• Expert in creating Views.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Configured the AWE and /3 GB switch for the 32 bit 2005 server
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server.
• Experience in SQL Upgrades SQL and Building SQL Clustering.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
• Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Explicitly used third party tools like Lite Speed, Fog light and Red gate.
• Auditing of database for users transaction, login and database action and removing orphan users
• Worked with a team of business analysts, data architects, application developers, ETL developers and testers. My objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Expert in creating SQL Server Reports using SSRS 2005 and 2008.
• Expert in using Version Control Software like Visual SourceSafe (VSS).
• Strong ability in Scheduling and deploying reports on Report manger.
• Expert in using Ms Office suite 2007 including Ms Access.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows 95/2000/2003/2008/ XP/VISTA/7, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2008/2005/2000

ETL Tools: Data Transformation Services(DTS), SQL Server Integration Services (SSIS)

Scripting: Shell Scripting

Reporting Tools: SSRS, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Data Modeling Tools: Erwin, Red gate, Lite Speed

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

SQL Server DBA

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, XML.

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Confidential, Reno, NV

Sr.SQL Server DBA

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• Upgrading SQL Server 2000 to SQL Server 2005.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL 2005.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS.
• Helping the front-end application developers with their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles
• Performed Database backups with tools like litespeed.
• Used SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
• Suggest Replication techniques to meet business needs.
• Setting MAX DOP (Max degree of parallelism) to 8 for 28 GB memory.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes
• Generated script files when changes applied to stored procedures and functions.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Confidential, Albany, NY

Sr. SQL Server DBA/Developer

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• SQL Server 2000 contains 2 TB of Data and SAN infrastructure of 60 Server. 2 NODE cluster Active / Active and Active passive for different environment.
• Installation & configuration 2005 enterprise Edition.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Converting DTS packages to SSIS packages.
• Designed the reporting databases by using Erwin.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Migrate databases easily from SQL Server 2000 to SQL Server 2005 by using redgate.
• ETL experience with SSAS and SSIS.
• Install and upgrade packaged databases remotely by using red gate.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
• Suggest replication techniques to meet business needs.
• Maintain transactional replication on production SQL Servers.
• Set up transactional, snapshot replication and maintain the active replication(s).
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Performance tuning and optimization of Query of SQL server.
• Supporting programmers for moving objects to different environments.
• Creating and maintaining user’s logins and Roles.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Estimated space requirements for a database.
• Converted and imported data from an Oracle Database to a SQL Server Database.
• Worked in tune with strategic planning for improving the mapping and data migration.

Confidential, Atlanta, GA

Sr. SQL Server DBA

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, T-SQL, Microsoft Reporting Service.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Tuned aggressively stored procedures in order increase the performance with no cost effective.
• Worked as a team following Agile/SCRUM methodology for iterative and incremental development.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• 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
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Extensively working on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Configured up to 32 GB of memory.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Huge data of Insurance policies and customer information in XML, Flat file data transforming using SSIS Packages.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.

Confidential

SQL Developer

Environment: SQL Server 2000, Windows NT server, SQL Profiler.

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.