SUMMARY

• IT Professional with 8 years of Administration and Development experience on Data Design using SQL Server 2008R 2/ 2008/2005/2000 systems in OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Dexterity in implementing different types of High Availability & Disaster Recovery scenarios like Clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Implemented & managed Active - Active and Active-Passive Clustering, Failover and Load Balance technologies.
• Implemented Side-by-Side Migration of MS SQL SERVER 2000/ .
• Proficient in SQL Server 2008 new features like Merge Statement, Filtered Indexes, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE), Backup compression, Lock escalation and new data types.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot Isolation, Database Mirroring, Database Snapshot, DDL triggers, Try-Catch blocks, Online Indexing, Online Restoring, DMV’s, DMF’s, Mail Setup, Jobs and Alerts, Database Tuning Advisor.
• Configured more than 2GB RAM in 32 bit environment using AWE and /3GB switch.
• Expertise in Performance Tuning, Index Tuning Wizard, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, Database Maintenance Planning.
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Expertise in resolving locks deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• Data modeling Experience including Physical and logical data modeling using ERWIN & VISIO.
• Experience in implementing various RAID 1, 5 and 10 technologies.
• Create and manage OLAP Cubes on analysis servers and query cubes using MDX queries.
• Sound knowledge in writing complex SQL Queries, stored procedures, Normalization, creating Indexes, Indexed views, file group modifications, User Defined Functions (UDF), Triggers, Distributed Queries, Common Table Expressions and adding scheduled jobs to re-index and update statistics in databases.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Acquaintance in supporting Very Large databases (VLDB) 2TB and troubleshooting the problems in OLTP Environment.
• Extensively used repositories like Team Foundation Server (TFS), Visual source safe and Clear case for Data Archival.
• Expertise in extracting and transforming data using data transformation services like import/ export wizard, BCP, Bulk insert, attach/detach.
• Prowess in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions to them.
• Experience in developing and tuning SQL Server Integration Services (SSIS) packages, Analysis Services (SSAS) cubes and Reporting Services (SSRS) reports and models.
• Proficient in high level design of ETL, DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Aggregate, Data Conversion, Conditional Split, Bulk Insert Fuzzy Grouping, Fuzzy Lookup, OLEDB Command and Merge.
• Experience in creating deployment utility to Deploy SSIS Packages over Production and QA Systems.
• Experience in Creating Report Subscription, Data Driven Subscription, Report Snapshots and caching, linked, cascaded and parameterized reports, complex drill down reports using SQL Server reporting services.
• Configuring and maintaining Report Manager and Report Server.
• Expert in data warehouse modeling (designing Star Schema, snowflake schemas with identifying Facts and Dimensions).
• Created Linked Servers between SQL Server & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Handled numerous Change Management requests on production servers.
• Good experience in configuring IIS and XML.
• Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
• 24 X 7 Production Database on Call Support.
• Flexible, Enthusiastic and project oriented team player with excellent communication skills and analytical skills to develop creative solution for challenging client needs.

PROFESSIONAL EXPERIENCE

Confidential, LONGMONT, CO

Senior SQL Server DBA

Responsibilities:

• Database Administrator, Database Administration;
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• DB2 database support system during the system, application and database upgrades.
• Involved in Index Analysis and Performance Tuning.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• 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.
• Fixing Missing Indexes and Excess indexes
• Performance testing on stored procedures, indexes, and triggers.
• Managing the DB2 database backups.
• Rebuilding the indexes at regular intervals for better performance
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Monitoring, tuning, recovery and backup of DB2 databases.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Improve theperformanceof SQL Queries and stored procedures using SQL Profiler,
• Configuring TEMP DB on files and file groups.
• Supported 24 X 7 Production environment

Environment: SQL Server 2005, SQL Server 2000, DB2, Windows 2003/2000 Server, SQL LiteSpeed 4.5, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, Atlanta, GA

Senior SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databases.
• Optimizing and tuning of DB2 database.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredLog shipping/ Transactional Replicationand trouble shooting of errors.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Rebuilding the indexes on regular intervals and placing the huge table/non-clustered indexon theseparate file group to improve the performance.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Handled numerous change management requests on production servers
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• UsedOnline Indexingandonline RestoringinSQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Supported24 X 7 Production environment

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server)

Confidential, Fairfax, VA

Database Administrator

Responsibilities:

• Database Administrator, Database Administration;
• Converting DTS packages into SQL Server 2005 Integration Services.
• Recovering the databases from backup in disasters
• 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
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Managing the San backups.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non production database code as well as T-SQL code from developers.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, Hartford, CT

SQL Server DBA

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.
• Worked in active/active and active/passive cluster environment
• 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.
• Developing Crystal Reports used 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.
• ETL experience with SSAS and SSIS.
• Designed the reporting databases using ERWIN.
• 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.

Environment: MS SQL 2000/2005, Windows NT/2000/XP, SSIS, SSRS, SSAS, MS Access, MS Excel, VB.NET, C#, OLAP.

Confidential

SQL Server Developer

Responsibilities:

• Converted logical Database Design into Physical schema using the balanced normalization in 2ndand 3rdNormal form for highest performance.
• WroteStored Proceduresto implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Improve theperformanceof SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transfer data from flat files, Excel spreadsheets to and from SQL Server usingDTS, BCP and Bulk Insert.
• Created and managed users, roles and groups and handled database security.
• Managed test data and their updates between development and production databases.
• Regularly monitor the system for bottlenecks(CPU,RAM, Disk IO)
• Use XMLdocuments to pass multiple parameters for Stored Procedures to read and write database table. Alsogenerate XML documents from tables.
• Handle development and production support, document reviews, test plans, integration of the system.
• Document all process and Data Flow involved in the database for future reference.

Environment: SQL Server 2000, T-SQL, Access, Excel, Crystal reports, Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT.