SUMMARY:

• 8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Always - On Availability Groups (AAG) and HA/DR Troubleshooting
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Hands on experience in DR processes including Log Shipping and Database Mirroring.
• Experience in Auditing, Resource governor and transparent data encryption(TDE)
• Worked on configuring SQL Server with minimum privileged access.
• Multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 and SQL Server 2014 migration from SQL Server .
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Data center servers and handling 1.4 TB databases.
• Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Can create Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Reporting Services (SSRS) and Clustering.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS:

Operating Systems: Windows 2000/2003/2008/2008 R2/2012/2012R2 Server

Databases: SQL Server 2014/2012/2008 R2/2008/2005, MS Access

Languages: T-SQL

SQL Server Tools: Management Studio, Business Intelligence Development Studio, SQL Server Data Tools, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Database Tuning Wizard, Index Tuning Wizard, SSIS, SSRS, Microsoft Clustering Services (MSCS)

Report Tools: MS Reporting Services

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Data Modeling and Other Tools: ERWIN, Litespeed, SQL Spotlight, Redgate SQL Compare, SQL Trace

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

SQL Server DBA

Responsibilities:

• Install SQL Server 2014/2012/2008 R2/2008/05 on Windows Clustered and standalone environments with latest service packs.
• Upgrade SQL serverdatabases from 2000/ R2/2012
• Experience in working and troubleshooting2TB Very Largedatabases (VLDB) in OLTP Environment.
• Configure AlwaysON availability groups in SQL server 2012
• Configure log shipping for multipledatabases as a part of DR.
• Configure Replication andDatabasemirroring.
• Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune thedatabases, queries, performance related issues like memory CPU and I/O issues.
• Analyse long running slow queries and tune the same to optimize application and system performance.
• Reorg/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.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Serverdatabases and to setup ideal memory, min/max server options.
• Involved in trouble shooting and fine-tuning ofdatabases for its performance.
• Improve the performance of SQL Queries and stored procedures using SQL Profiler.
• Configure TEMP DB on files and file groups and capacity planning ofdatabases.
• Configure and deploying SSIS packages and SSRS reports.
• Documenting procedures.

Environment: SQL Server 2014, 2012, 2008R2, 2005, Windows 2012, 2003 Server, Symantec netbackup, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler

Confidential

Senior SQL Server DBA

Responsibilities:

• Installed and configuredSQLServer 2014/2012 on Windows versions
• Presented SSIS Upgrade methodology and Best Practices to fellow DBAs and Developers.
• SetupDBAMaintenance Database and Maintenance Plan for Backup, Database Integrity & Index Maintenance.
• Worked extensively on installation, upgrade, migration and configuration of MSSQLServer 2008/2012 andSQLServer Cluster forSQLServer 2012 andSQLServer 2005.
• Applied service packs and security fixes in Clustered and Standalone environments.
• Created High-Availability Groups for application high availability usingSQLServer 2012.
• Configured Transaction Replication Production to DR Servers and Reporting Server with Multiple subscribers.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Installed, configured and troubleshootSQL2012 AlwaysOn Availability Groups in between the data centers and participated in DR test.
• Setup Database Mirroring usingSQLServer 2008.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Experience in Transparent data encryption (TDE).
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• SQLQuery Performance Tuning usingSQLSentry Performance Monitoring Tool, Analysing the Query Execution Plans, UsedSQLProfiler for optimizing the store procedure.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Environment: SQL Server 2014/2, Windows 2012 R2/2008 R2/2008/2003, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Data tools, SQL Server Management Studio, Team Foundation Server (TFS)

Confidential

Senior SQL Server DBA

Responsibilities:

• 24 X 7 Production Database On Call Support.
• Monitoring of SQLServer 2005/2008/2008 R2
• Installed, configured and maintainedSQLserver 2005/2008/2008 R2/2012 and applied hot fixes, cumulative updates and service packs.
• Installed and administered Two-Node Cluster Configuration (Active/Active and Active/Passive) in SQLServer 2008R2.
• Upgrade databases fromSQLServer 2005 toSQLserver 2008 R2 andSQLServer 2008 R2 toSQL server 2012.
• Implemented the newSQLServer 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.
• Extensive Database experience in MS SQL Server in various capacities including Database/schema Design, Database Deployment, Database Up gradation and migration.
• Implemented, configured and troubleshooting Snapshot and Transactional Replication
• Extensive experience in troubleshooting mirroring, log shipping.
• Rebuilding/Monitoring the indexes at regular intervals for better performance.
• Performing database checks and maintaining the database health.
• Configured database mail, linked server and database mirroring as per the application requirement.
• Created Maintenance plan for regular database Full, Differential, and T-log backup.
• Planning and implementing the Snapshot and Transactional Replication of MSSQLServer Databases, successfully configured/administered transactional replication using MSSQLServer 2005/2008/2008 R2.
• Successfully implemented High-Availability solution in MSSQLServer 2005/2008/2008 R2
• Implemented disaster recovery forSQLServer Production Database as Fail-Over or Standby servers.
• Used Log Shipping Technique for warm backup solution for MSSQLServer databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Used tools likeSQLServer Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.
• Manage and maintain database changes in Development, QA, Staging and Production

Environment: SQLServer 2005/2008/2008 R2, Windows 2000, 2003/2008,SQLLiteSpeed,SQLSpotlight and VSS, SSRS, SSIS, EXCEL 2007.

Confidential

SQL Server DBA

Responsibilities:

• Responsible for Installation, configuration and complete administration of MS SQL Server 2008/2005.
• Migrateddatabases from SQL Server in Dev/QA/production environments.
• Installation & maintenance of SQL Clustering.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).

  Configured and Maintained Replications (Transactional).

• Implemented database mirroring with High Availability Mode in SQL 2008.
• Assisted SQL developers in optimizing SQL queries and Stored Procedures.
• Created backup strategy for Dev/QA/Production environments.
• Setup and configureddatabasemail for notification purposes.
• Extensively used DBCC statements to check physical and logical consistency of thedatabase.
• Export & Import data from MySQL, and Access Database including flat files like text, excel, and into SQL Serverdatabases.
• Assisted in creating new SSRS 2008 reports as well as updating current reports to meet new requirements.
• Supported the database deployments for the new releases.
• Identified unused indexes; created missing indexes and regular reorg/rebuild Index maintenance.
• Worked on the capacity planning and benchmarking SQL Server hardware, CPU, Memory, cache, Disk IO, RAID, Network.
• Prepared and documented database backup’s and maintenance plans.
• Worked with the 3rd party tools like LiteSpeed and RedGate.

Environment: SQL Server 2008/2005, Windows 2008/2003, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), RedGate, LiteSpeed

Confidential

SQL Server DBA

Responsibilities:

• Established and maintained policies, standard operating procedures, and associated documentation for user interaction with the database environment.
• Moved all non-clustered indexes to new file group for better performance tuning.
• Handled up to 2TB database sized database with clustered and replication environment.
• ImplementedSQLlogins, roles, authentication nodes as a part of securities polices for various categories of users.
• Checking the general Health of the servers for identifying Bottlenecks Analysing Identifying and Resolving performance issues of the server
• Automating all the Tasks using Jobs and maintenance plans Configuring DB mirroring and testing the failovers manually to ensure high availability
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database
• Establishes and maintains policies, standard operating procedures, and associated documentation for user interaction with the database environment.

Environment: SQLServer 2000, 2005, Windows Server 2003