SUMMARY

• 8 years of experience in Database Administration for very large and complex databases in SQL Server 2008R2 and SQL Server 2008/ 2005/ 2000/7.0.
• Extensive experience in maintaining Very large databases (VLDB) and highly transactive production servers in SQL Server 2008R 2/ 2008/2005/2000 /7.0 environments.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes and Unattended Installations.
• Good Knowledge on all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and testing.
• Implemented Side by Side Migration of MS SQL SERVER 2000/ .
• Good knowledge of Relational Database Management Systems (RDBMS).
• 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.
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication.
• Configured more than 2GB RAM for 32-bit and 64-bit systems using AWE switches.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, Mail Setup, Jobs, and Alerts, SQLCMD and Dedicated admin connection.
• Involved in Logical Data and Index Partitioning using SQL Server 2005.
• Experience in implementing new features of SQL Server 2008 like Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
• Extensively worked on Backup compression and data compression in SQL Server 2008.
• Managed stored procedures,jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Experience in configuring and working Microsoft SQL server 2005, Microsoft SQL Server 2008 on VMware Environment.
• Experience in using the DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Proficiency and expertise in Backup, Disaster recovery planning and Security Management.
• Expert in using Native tools like SQL server profiler, Database Tuning Advisor, Perfmon Counters.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities.
• Developed and created various complex SSIS dtsx packages and deployed in into File System Server and Microsoft SQL Server using manifest file.
• Expert in extracting and transforming data between homogenous and heterogeneous systems using DTS packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
• Experience in creating SSIS packages using Control Flow Tasks like Data Flow Task, For Each Loop Container, File System Task, Execute SQL Task, Transfer Database Task, and Transfer Login Task etc... And Data Flow Transformations like Multi Task, Conditional Split, Look up, Fuzzy Look up, Char in Microsoft SQL Server Business Intelligence Development Studio.
• Experience in creating complex drill down, matrix, drill through, cascading and parameterized reports using SQL Server Reporting Services 2008R . Configured and maintained reports using Report Manager and Report Server.
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using joins like merge, nested loops, hash join etc depends on scenarios.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for tuning and monitoring SQL Server performance.
• Expertness in trouble shooting database issues likespace issues, deadlocks, performance and blocking.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Proficiency and expertise in Backup and Restore databases, Disaster recovery planning and Security Management.
• Explicitly used third party tools like Idera, Litespeed, Redgate, Veritas net backup.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Experience in providing Production Support for 24x7.

TECHNICAL SKILLS

Operating Systems: Windows Vista/XP/2000/NT, Windows Server 2003, Exchange 2003, Linux, Unix.

Databases: MS SQL Server 2008R 2/ 2008/2005/2000 /7.0, MYSQL, Oracle, MS Office Access 97/2000/2003.

Microsoft Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Third Party Tools: Erwin, Red gate, Lite speed, fog lite.

Languages: T-SQL, C/C++, Java, java script, VB script, Visual Studio2005/2003, XML, HTML, ASP.NET and VB.Net.

Applications: Microsoft Office Suite, Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, Virginia

Senior SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2008R 2/ 2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and mentored other technical staff.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Provide and Monitor database "health" - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Setup Database Security and maintained accounts and access levels by creating suitable Logins, Roles and assigning object level permissions.
• Configured Database Mail for sending failure job notification email messages from Jobs and Procedures.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Monitored SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Maintained Production and Test Database Environment in SQL server 2008R 2/2008/2005.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Created documentation steps while upgrading From the SQL server 2000 to SQL server 2005/2008.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: MS SQL Server 2008R 2/ 2008/2005/2000, Windows server 2008/2003 Datacenter and Enterprise edition 32-bit and 64-bit, Transact-SQL, SQL LiteSpeed, ADO.net, VB.net, SSIS,SSRS, TFS(Team Foundation server).

Confidential, Atlanta, Georgia

Senior SQL Server DBA

Responsibilities:

• Highly worked on Administration, Database Design and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2008R2/2008/2005 on new servers with service packs.
• Experience working on Active/Passive Failover Clustering solution into HP EVA 3000 SAN environment for SQL Server Consolidation.
• Implemented the disaster recovery models like Clustering, Database Mirroring & Log shipping.
• Monitored Log shipping/ Transactional Replication for trouble shooting of errors.
• Created Logins at Server level and Users at Database level and mapped Roles by assigning permissions.
• Used Performance monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.
• Extensively worked on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
• Successfully implemented the Capacity planning for different servers.
• 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
• RoutineDBAjobs likemonitoring the data loading jobs, Backups (Full, Differential &Transactional), disk space, database status, handling the maintenance jobs and checking the error logs.
• Expert in using and implementing DMV’s, DMF’s, data partitioning and Indexing.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, update statistics and backups.
• Applied hot fixes, Patches and Service Packs and create script for Unattended Installation.
• Implemented and maintained database security, policies and procedures
• Transferred data (ETL) to Data ware house Environment using SQL Server Integration Services.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Experience in creating drill down, parameterized and cascading reports using SQL Server Reporting Services 2008R 2/2008/2005.
• Experience in generating Adhoc reports using SSRS.
• Performed all basic Database activities like moving databases between servers, copy databases etc…
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: Microsoft Windows Server 2008/2003 MS SQL Server 2008R 2/2008/2005/200/7.0, T-SQL, SQL Query Analyzer, SQL Server Profiler,.NET, Litespeed, VSS, SSIS 2008R2/2005/2008

Confidential, Birmingham, Alabama

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabyte.
• Migrated DTS packages from SQL Server 2000 to SQL server 2005 using DTSXchange tool.
• Created Documentation for steps need to be taken while upgrading the SQL Server 2000 to SQL Server 2005.
• Successfully Configured Transactional replication on migrated server.
• Setting up and Monitored Transactional Replication, Database mirroring on Production, QA and Development servers.
• Created and Redesigned stored procedures, functions, and triggers.
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Used Database Consistency Checks - DBCC commands for database maintenance.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance.
• Reviewed Store Procedures and Queries for fine tune of Slow Running Queries.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Handled Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows bit environment.
• Troubleshooted SSIS packages which failed to execute in the Scheduled Jobs.
• Expertise in Extraction, Transformation and Loading of data using SSIS from various sources like Excel Source, Flat File Source, OLEDB Source to the Excel Destination, Flat File Destination and OLEDB Destination.
• Debugged and Deployed SSIS dtsx packages in to File System
• Created Documentation steps after upgrading from SQL Server 2000 to SQL Server 2005.
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2005/2000 Enterprise Edition, Windows Enterprise Server 2003, SQL Server Business Intelligence Development Studio 2005, Red gate.

Confidential, Bethesda, Maryland

Technical SQL Server DBA

Responsibilities:

• Tuned aggressively stored procedures in order increase the performance with no cost effective.
• Index tuning for almost 46 databases associated with production and non-production databases.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• SQL 2000, 2005 - Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
• Installed couple of SQL Server 2005 on cluster environment.
• Configured the new servers using failover clustering and SAN technology.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Expertise in setting up and troubleshooting Database mirroring.
• Using log shipping for synchronization of database.
• Expertise in working with Transactional Replication Environment and handled the publication conflicts manually depending on last changed date.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• To provide 24x7 production support for SQL Server databases on Clustered Servers.

Environment: SQL Server 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater, Erwin.

Confidential

SQL Server Developer/ SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2000.
• Involved in Database designing, Logical and Physical Data modeling using Erwin.
• Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Performed query tuning and reduced response time by 60%
• Managed Disk space, memory and User connections.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Monitored SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Experience on Import / Export using DTS and BCP utility.

Environment: MS SQL server 2000, Windows Server 2000, VB .Net, Enterprise manager, Query Analyzer, SQL profiler.