PROFESSIONAL SUMMARY:

• IT Professional with 9+ years of Administration Experience on MS SQL Server 2016/ 2014/2012/2008 R 2/ 2008/2005/2000 systems in OLTP and OLAP environments.
• Expertise in installing MS SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Implemented SQL Server Always ON Feature in SQL Server 2012/2014and also configured Always ON Availability Groups.
• Acquaintance in supporting Very Large databases (VLDB) up to 3TB and troubleshooting the problems in OLTP Environment.
• 24 X 7Production Database on Call Support.
• Implemented different types of High Availability & Disaster Recovery models like Clustering, Database Mirroring, Transactional Replication and Log Shipping.
• Implemented & managed Active - Active and Active-Passive Clustering, Failover and Load Balance technologies.
• Expertise in Side-by-Side Migrations of MSSQLSERVER 2000/20 /2008/2008 R 2/2012/2014/2016.
• Worked in an environment with more than 1000+ databases to handle.
• Proficient in SQL Server 2014/2012/2008 R2 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.
• Worked on Linux Cluster and supported Network team in installation.
• Expertise in resolving locks, deadlocks, handling Isolation level and concurrency effects, detect CPU, I/O, Memory bottlenecks.
• 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, Linked Servers, Database Maintenance Planning.
• Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
• Sound knowledge in writing complex SQL Queries, stored procedures, 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.
• 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 (SSRS) packages and also Configuring and maintaining Report Manager and Report Server.
• 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.
• Expertise in using Temporary Tables, Table Variables, CTEs and Data Dictionary.
• Knowledge 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.
• Knowledge in designing, creating, processing ofCubesusingSSASand using MDX Queries.
• Knowledge in data warehouse modeling (designingStar Schema, snowflakeschemas with identifyingFacts and Dimensions).
• CreatedLinked ServersbetweenSQL Server & Oracle 9i and 10g. Also createdDTS packagefordata transfer between the two environments.
• Handled numerous Change Management requests on production servers.
• Flexible, Enthusiastic and project oriented team player withexcellent communication skills and analytical skills to develop creative solution for challenging client needs.
• Involved in all phases of the SDLC (Software Development Life Cycle).

TECHNICAL SKILLS:

Project Domain: Application Development, Administration of MS SQL Server 2014/2012/2008 R2/2005/2000, Oracle, Sybase.

Programming Languages: Transact-SQL, SQL, C/C++, Java and Visual Basic

RDBMS: MSSQLServer 2000/ 2005/2008/2008 R2/2012/2014, MySQL, PostGreSQL9.2.10, Oracle, MS Access.

Operating Systems: Windows Server 2000/20 R2/2012, Windows XP, 7 Pro, Linux, Unix.

Database Tools: SSMS, SQL Server Business Intelligence Studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Log Viewer, Database Tuning Advisor, and Upgrade Advisor.

ETL Tools: SSIS 2005/2008/2008 R2/2012, DTS

OLAP Tools: SSAS 2005/2008/2008 R2/2012

Web Server: IIS

Reporting Tools: SSRS 2005/2008/2012, Crystal Reports, MS-Excel

Tools: Active X, IIS, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, Idera, Lite Speed, Spotlight, Fog light, SharePoint Designer 2007, Erwin 4.x/7.x.

PROFESSIONAL EXPERIENCE:

Sr. SQL SERVER DBA

Confidential

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008 R 2/2012/2014/2016 on Production, Development and Test Environments along with configuring the drives according to the standards and policies.
• Capacity planning of databases according to client requirements.
• Supported24 X 7 Production environments and solved many incident Tickets.
• Set up Always on Availability Groups as a high availability for group of databases in SQL 2014 instance.
• Worked on very large and complex databases and in a highly transactional environment.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Implemented in memory OLTP feature in SQL Server 2014.
• Migrated databases from SQL Server 2005/2008R2 to SQL Server 2008 R2/2012/2014
• Migrated SQL servers from physical to VMware virtual environment.
• Installation of SQL Server 2014/2 and service packs on Windows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2/2012.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance using Database tuning advisor and SQL server profiler. Identifying and recommending the resolutions for the failed jobs in all the production servers.
• Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Worked on Foglight for monitoring servers.
• Supported Very Large databases (VLDB) up to 3TB and troubleshooting the problems in OLTP Environment.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Rebuilding indexes with different fill factors and update statistics manually.
• Good hands on experience in Change Management, Incident and Problem management.
• Involved in capacity planning, sizing and database growth projects.
• 24*7 On Call production support.

Environment: TSQL, MS SQL SERVER 2000/2005/2008 R2/2012/2014, SSRS, QUERY ANALYSER, VISUAL STUDIO 2008/2012, VB.NET, C#, WINOWS SERVER 2000/2003/2008 R2/2012, IIS.

Sr. SQL SERVER DBA

Confidential, Atlanta, GA

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008 R 2/2012/2014/2016 on Production, Development and Test Environments along with configuring the drives according to the standards and policies.
• Capacity planning of databases according to client requirements.
• Supported24 X 7 Production environments and solved many incident Tickets.
• Set up Always on Availability Groups as a high availability for group of databases in SQL 2014 instance.
• Worked on very large and complex databases and in a highly transactional environment.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Implemented in memory OLTP feature in SQL Server 2014.
• Migrated databases from SQL Server 2005/2008R2 to SQL Server 2008 R2/2012/2014
• Migrated SQL servers from physical to VMware virtual environment.
• Installation of SQL Server 2014/2 and service packs on Windows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2/2012.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance using Database tuning advisor and SQL server profiler. Identifying and recommending the resolutions for the failed jobs in all the production servers.
• Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Worked on Foglight for monitoring servers.
• Supported Very Large databases (VLDB) up to 3TB and troubleshooting the problems in OLTP Environment.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Rebuilding indexes with different fill factors and update statistics manually.
• Good hands on experience in Change Management, Incident and Problem management.
• Involved in capacity planning, sizing and database growth projects.
• 24*7 On Call production support.

Environment: TSQL, MS SQL SERVER 2000/2005/2008 R2/2012/2014, SSRS, QUERY ANALYSER, VISUAL STUDIO 2008/2012, VB.NET, C#, WINOWS SERVER 2000/2003/2008 R2/2012, IIS.

Sr.SQL SERVER DBA

Confidential, Atlanta, GA

Responsibilities:

• Install, Manage and administer SQL server 2005\2008R2\2012\2014 SQL servers.
• Migrations of SQL server from one version of SQL server to another.
• Implemented side by side and In-place Migration of MS SQL server /2008R2/2012 and applied Patches and Service packs to update different versions of MS SQL server.
• Implemented new SQL Server 2012/2014 technique ALWAYS-ON High Availability groups.
• Building SQL 2008R2 cluster environments on VMware/ Physical environments.
• Applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability.
• Configured Transactional Replication and Log Shipping.
• Fix the Cluster and Replication issues on SQL Server 2005/2008R2/2012 servers with in very strong SLA’s.
• Usage of new compression Techniques in SQL Server 2008R2/2012 for backup and restore jobs.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Performed Administrative tasks in SQL Server using PowerShell.
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Experience working with change control process.
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams.
• Handled numerous Change Management requests on production servers.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• Worked Extensively on Remedy application Database server tuning.
• Configured Transactional replication on migrated server.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
• Experience in SQL Server Reporting Services (SSRS).

Environment: TSQL, MS SQL SERVER 2000/2005/2008 R2/2012/2014, SSRS, QUERY ANALYSER, VISUAL STUDIO 2008/2012, VB.NET, C#, WINOWS SERVER 2000/2003/2008 R2/2012, IIS.

Sr. SQL SERVER DBA

Confidential

Responsibilities:

• Installed MS SQL Server 2005/2008R2/2012 updating with latest service packs and security patches.
• Used online indexing and online restoring in SQL server 2008R2 and 2012.
• Setup Always-On High availability on 2012 SQL Servers.
• Worked on very large and complex databases and in a highly transactional environment.
• Good hands on experience in applying hot fixes, service packs and repairing SQL Instances.
• Migrating Databases from SQL server 2000/2005/2008 R2 to SQL server 2008R2/2012.
• Prepared maintained and modified SQL server installation and configuration documents.
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created Maintenance Plans for Regular Backups, Rebuilding of Indexes and data purging process as part of maintenance.
• Implemented Mongo DB for Log file data and insert huge volume of data.
• Extensively used Lite-Speed Backup with MS SQL SERVER 2005/2008R2.
• Worked on SQL server tools like Database Tuning Advisor, Profiler and Activity Monitor for performance analysis.
• Implemented log shipping for Production Server database as part of the disaster recovery.
• Created Maintenance plans, Update Statistics to improve performance, Rebuild indexes to reduce the fragmentation in 2008R2, 2008, 2005 Environment.
• Expert in Performance Tuning, Analyzed long running queries and tuned them to optimize the system performance.
• Worked closely with business and outside vendors to effectively plan, deploy and update database environment changes.

Environment: TSQL, MS SQL SERVER 2000/2005/2008 R2/2012/2014, SSRS, QUERY ANALYSER, VISUAL STUDIO 2008/2012, VB.NET, C#, WINOWS SERVER 2000/2003/2008 R2/2012, IIS.

Sr.SQL SERVER DBA

Confidential

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER /2008R2 on Windows 2003/2008R2.
• Installed MS SQL Server 2005/2008R2/2012 updating with latest service packs and security patches.
• Migrated DTS 2000 PACAKGES to SSIS 2008R2 packages and maintained the archival data using Control flow task.
• Installed and administered two-node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition in SAN environment.
• Checking Database Health by usingDBCC Commands and DMVs.
• Maintained Transactional Replication on production servers. Implemented and configured Performance Data Collector.
• Supported huge volume of databases.
• Configured the AWE and 3 GB switch for the 32 bit 2005 server.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented native log shipping on MS SQL SERVER 2008R2.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Implemented SQL server 2008 concepts like Data Partitioning, Snap shot Isolation. DB snapshot. DDL triggers, Try-Cache Blocks, Online indexing, DMV’s, DTA, SQL CMD and Dedicated Admin Connection, Common Table Expression (CTE).
• Implemented DATABASE MIRRORING ON MS SQL SERVER 2008R2.
• Extensively used Lite Speed backup with MS SQL SERVER 2005/2008R2.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers in T-SQL.
• Refactored and fine-tuned the queries and stored procedures in TSQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Implemented log shipping for Production server data base as part of the disaster recovery.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL SEVER 2000/2005/2008 R2, SSRS, Visual Studio 2005/2008R2, VB.Net, C#, Windows Server 2000/2003/2008 R2, IIS.

SQL SERVER DBA

Confidential, Atlanta, GA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2008/05 and service packs on Windows server clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents
• Upgrading/Migrating SQL server 2005/2000 databases to SQL server 2008 databases including DTS to SSIS packages.
• Migration from Dev to QA to prod environments
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled upto 2 TB Size databases with clustered environment.
• Implemented new features in SQL server 2008 like Policy Based management, table Compression and backup compression, SQL server Auditing, Resource Governor and merge statement in TSQL.
• Application support for front end feeds and ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Set up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev serversand 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.
• Analyzed execution plans and generated suggestions for improvement.
• Handled numerous change management requests on production servers
• Designed and developed SSIS packages using different control flow tasks, transformations and dataflow tasks.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• Supported24 X 7 Production environments.

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, OLAP cubes with SSAS, SSIS. Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Windows Server 2000/2005/2008 .

SQL Server DBA/Developer

Confidential

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on the financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• 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.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.

Environment: SQL Server 2000 Enterprise, Windows Enterprise Server, XML,Microsoft Visio 2003, SFTP, JAVA, J2EE