PROFESSIONAL SUMMARY:

• IT Professional with 8+ 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/2014 /2016 and also configured Always ON Availability Groups.
• Acquaintance in supporting Very Large databases (VLDB) up to 6TB and troubleshooting the problems in OLTP Environment.
• 24 X 7 Production 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/2005/2008 to 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 of Cubes using SSAS and using MDX Queries.
• Knowledge 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.
• Flexible, Enthusiastic and project oriented team player with excellent 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/2003/2008 /2008 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 SQL Safe, Idera SQL DM, FogLight, Idera, Lite Speed, Spotlight, Fog light, SharePoint Designer 2007, Erwin 4.x/7.x.

PROFESSIONAL EXPERIENCE:

Sr. SQL SERVER DBA

Confidential, Austin, TX

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008R 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.
• Supported 24 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 2012/2014/2016 instance.
• Worked on very large and complex databases and in a highly transactional environment.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Implemented in memory OLTP feature in SQL Server 2014/ 201 6 .
• Migrated databases from SQL server 2005/2008R2 to SQL Server 2012/2014/2016
• Migrated SQL servers from physical to VMware virtual environment.
• Installation of SQL Server 2016/ 2014/2012/2008 /05 and service packs on Windows Server Clustered environment.
• 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.
• 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.
• 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.
• 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.

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, Charlotte, NC

Responsibilities:

• Installation and Maintenance of SQL Server 2008/2008R2/2012/2014 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.
• Supported 24 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.
• Configured data partitioning/table partitioning on 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 2008R2/2012/2014
• Migrated SQL servers from physical to VMware virtual environment.
• Installation of SQL Server 2012/2008/05 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 the backup operations, batch commands, scripts have 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 Solarwinds for monitoring servers.
• Supported Very Large databases (VLDB) up to 6 TB and troubleshooting the problems in OLTP Environment.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Good hands on experience in Change Management, Incident and Problem management.
• 24/7 on call 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, Camp Hill, PA

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 2000 to 2005/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.
• Created user permissions and security in ACTIVE DIRECTORY.
• Handled numerous Change Management requests on production servers.
• Reorganizing or Rebuilding Indexes based on the Index fragmentation.
• 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).

Sr. SQL SERVER DBA

Confidential, Canton, MA

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 D atabase T uning A dvisor, P rofiler and A ctivity 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.
• Created user permissions and security in ACTIVE DIRECTORY.
• Executed batch SQL scripts by using Powershell scripts.
• 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, Harrisburg, PA

Responsibilities:

• Implemented SIDE BY SIDE Migration of MS SQL SERVER 2000 to 2005/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 using DBCC 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, Dataware House SSAS Visual Studio 2005/2008R2, VB.Net, C#, Windows Server 2000/2003/2008 R2, IIS.

SQL Server DBA/ Developer

Confidential

Responsibilities:

• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Written and executed complex 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