SUMMARY

• Around 7+ Years of IT experience in SQL Server Administration, Development, and Database Design using MS SQL Server 2016/2012/2008 R 2/2008/2005/2000 environments.
• Experience in installing MS SQL Server 2016/2014/2012/2008 R2/2008 and updating with hot fix and service packs.
• Expertise in installing and configuring SQL server 2012 Always - On availability groups on windows server 2008R2/2012.
• Hands on experience with High Availability & Disaster Recovery Solutions - Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot, Merge & Transactional) and Clustering (Active-Passive and Active - Active).
• Extensively worked on Active-Active and Active-Passive two node Clustering and three node clustering (Active-Active-passive).
• Implemented Side-by-Side and In - Place Migration of MS SQL SERVER 2000/ .Experience in migration of SQL server 2008 databases to SQL server 2012.
• Expert in Creating & Debugging Views, Functions, Stored Procedures, Triggers, Optimizing Code, and improving Efficiency.
• Good Experience and knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Excellent T-SQL developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• 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
• Expertise in using DBCC trace flags handling blocking and dead lock situations and handling the Isolation Levels and Concurrency Effects, detect CPU, I/O.
• Extensively used repositories like Team Foundation Server (TFS)
• Experience in configuring Data Quality Services, (DQS), and Master Data Services (MDS).
• Very Extensively used the native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, index tuning wizard, database tuning advisor for performance analysis
• Expertise in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.
• Implemented Change data capture(CDC)
• Handled Large Databases in Clustered environment using Physical Storage Configuration and SAN Optimization with different RAID Levels.
• Good at SQL Server 2008 new concepts like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE),
• Used Basic power shell scripts.
• Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
• Worked on data purging.
• Experience on installing and configuring SSRS on windows environment; also know the process of generating different types of reports.
• Hands on experience in working with System Center Operations Manager (SCOM) and Ignite Used third party tools like LITESPEED, Red gate, IDERA diagnostic manager, Veritas net backup, Fog light.
• Good Knowledge and experience in migrating database in the cloud.
• Ability to work independently as well as in a team.
• Experience in production support, 24 X 7 on call.

PROFESSIONAL EXPERIENCE

Confidential: Alpharetta GA

Responsibilities:

• Setup and configured Distributed availability group and created alerts in newly configured VM machine.
• Migrated database from 2014 SQL server to 2016 SQL server in Microsoft Windows Server 2016R2 enterprise edition.
• Involved in capacity planning for the newly migrated Database.
• Created store procedure, tables and jobs to analyze the performance of SQL server.
• Rebuilding and reorganizing indexes for the better performance.
• Installed and configured SQL server 2016 standalone installation in newly configured VM machine.
• Setup and configured always on availability group and HADR setup in 2016 SQL server enterprise edition.
• Setup and Configured SSIS, SSRS and SSAS in windows 2016 R2 enterprise edition.
• Worked on Query Store for the better performance of long running queries.
• Used Performance monitor to monitor the SQL server for the CPU and Memory issues.
• Applied SP1 with CU7 for the 2016 SQL server standalone server.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, Check DB and Update Statistics.
• Involved in trouble shooting for the long running queries for the better performance.
• Monitored the databases which are in Cloud/Azure.

Environment: Microsoft SQL Server 2016/20142012/2008 R2/2008/2005, Windows 2008R2, 2012 and 2016R2 Server, Foglight.

Confidential: Charlotte NC

Responsibilities:

• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Consideration
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Created store procedures, queries, triggers, views and cursors
• Managed and scheduled daily jobs relating to data backup and recovery.
• Managed transactions and errors.
• Installed and administered Three-Node Cluster Active/Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Created SSISPackages utilizing SSISDesigner for sending out heterogeneous information from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS bundles to SSISbundles and changed the bundles with new highlights of SQL SSIS.
• Designed and executed Parameterized and falling parameterized reports utilizing SSRS.
• Expert in Using DMVs, Performance dash board, Mirroring, Replication, database snapshots and tracking Performance Counters.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• 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.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• 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.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers)

Environment: Microsoft SQL Server 2016/20142012/2008 R2/2008/2005, Windows 2008R2/2012 Server, SCOM, IDERA.

Confidential: Richmond, VA

SQL Server DBA

Responsibilities:

• Installation and configuration/Maintenance of SQL Server R2 in newly configured standalone and Cluster Environments
• Configured SQL server 2012 Always on availability groups with one secondary replica on windows server 2008R2/2012, Worked on Always on proof of concept performed various failover test cases.
• Installed SQL server 2014 on test servers for testing purpose.
• Implemented and managed the clustering environment like Active/Passive.
• Worked on side by side migration, migrated SQL server 2008r2 databases and ETL packages to SQL server 2012 using team foundation server.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring
• Implemented and maintained Replication (Transactional, Snapshot).
• Worked on Team foundation server (TFS), created team projects and builds to deploy databases, ETL Packages, SQL jobs.
• Worked on rebuilding SQL server due to unexpected crash by Rebuilding Master Database in SQL Server as a part of recovery process and worked on moving system databases from existing drive to new drive as per the requirement.
• Configured Database Maintenance Plans for Backups, Re-indexing, and Reorganization of Indexes, Cleanup History, Check DB and Update Statistics.
• Scheduled weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.
• Created proxy accounts to lock down the permissions to the users were the SSIS packages runs under the proxy account
• Installed and configured master data services (MDS), SQL Server Data Quality Services (DQS) in SQL server 2012.
• Involved in Capacity Planning and adding new storage space as needed
• Worked on purge process as a part of database maintenance.
• Implemented CDC (Change data capture)
• Used native tools like SQL Server Profiler, Performance Monitor, Activity Monitor, index tuning wizard, database tuning advisor for performance analysis to optimize queries and enhance the performance of database servers.
• Worked on tuning SQL queries by adding the missing indexes
• Pro-actively monitoringand managingSQL Serverperformance like disk space issues, Log file full and backup failures.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Worked on tools like IDERA diagnostic manager.
• Worked on call 24/7 Support on weekly basis.

Environment: Microsoft SQL Server 2012/2008R2/2008/2005, Windows 2008R2/2012 Server, SCOM, IDERA.

Confidential

SQL Developer/DBA

Responsibilities:

• Installation and maintenance of SQL Server installations.
• Configuring and monitoring Log Shipping for few databases in the enterprise.
• Configuring and maintaining multiple replications for reporting.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Created DTS packages to export and import data from SQL Server to Access, text files and Excel files.
• Involved in creating Stored Procedures, views, tables, constrains.
• Involved in logical & physical design, development and testing of the system
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application
• Developed and coded applications in T-SQL. Debugged and fixed the bugs. Performed database and SQL tuning by using various tools and techniques, like Tuning Advisors
• Involved in logical & physical design, development and testing of the system
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Dropped and recreated the indexes on tables for performance improvements.
• Developed automated backup and DBCC scripts for databases and transaction logs.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, tables, and views, Developed complex T-SQL code for the application
• Developed and coded applications in T-SQL. Debugged and fixed the bugs. Performed database and SQL tuning by using various tools and techniques, like Tuning Advisors
• All regular SQL DBA tasks.

Environment: SQL Server 2000/2005/ Enterprise, Windows Enterprise Server 2003, Microsoft Visio 2003, Microsoft Reporting Service, Excel, SQL Enterprise Manager.