SUMMARY

• Over 8+ years’ experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Servers 2014, 2012, 2008 R2, 2008, 2005 & 2000 in various domains like Finance, Manufacturing, Insurance.
• Expertise in installation, configuration, Managing, Monitoring and Troubleshooting of MS SQL server.
• Expertise in Database Administration of very large and complex databases in SQL Server 2014, 2012, 2008 R2, 2008 and SQL Server 2005/ 2000
• Expertise with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Migrated Databases from SQL Server 2005 and SQL Server 2008 legacy application to SQL Server 2012 and 2014 with deprecation of clustering and mirroring HA solutions and replace with Always On solution and applied hot fixes, and Service packs to update different versions of MS SQL server.
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008 R2 and 2012).
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Worked in Active - Active Cluster environment as a High availability solution.
• Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Experienced in installing and working with SQL server on VMware Environment.
• Expertise in writing good standard T-SQL queries, stored procedures, Indexed views, User Defined Functions (UDF), Triggers, Distributed Queries and Common Table Expressions (CTE) and relational database management (RDBMS).
• Expert in Using DMV’s, Performance dash board, and database snapshot
• Implemented Always On Availability Group as High Availability and Disaster Recovery solution on SQL Server 2012.
• Used Activity Monitor to Easily Watch Processes and performance in Database.
• Regularly purged the database with sensitive data to reduce the risk of it being disseminated.
• Secured the data with an effective disaster recovery plan and tested it.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead Lock Issues by using SQL commands.
• Experience in creating Jobs, Alerts, SQL Mail Agents.
• Experience working with Production and 24 x 7 on Call environments.
• Team player with excellent Interpersonal, communication and analytical skills.

TECHNICAL SKILLS

Languages: .NET, T-SQL, XML, C,C+

Tools: SSIS, SSRS, SSAS,SQL SENTRY, SQL Profiler, Performance Monitor, SCOM, Backup Utility, SQL Lite Speed, Visio 2000, Red Gate, Fog Lite, SQL Sentry

Application Software: Visual Studio 2005/2008/2010 , TFS, MSOffice Suite 2003/2007/2010

ETL &reporting tools: SIS, SSRS, SSAS,DTS

Operating Systems: Windows 2000/2003/2008/2012/ XP/VISTA/7, LINUX, VMware, ESX servers

Databases: MSSQLServer2012/2008R 2/2008/2005/2000 , MS Access

PROFESSIONAL EXPERIENCE

Confidential - Detroit, MI

SQL SERVER DBA

Responsibilities:

• Installed and troubleshooting SQL servers 2014, 2012,2008.
• Configured ALWAYS ON setup between different Data centers and on Multi Subnet Cluster.
• Configuring and Managing Log Shipping and Database Mirroring.
• Creating Jobs and Schedule them for execution on Daily, Weekly, and Monthly bases.
• Implementing the snapshot isolation and DDL triggers.
• Rebuilding/Reorganizing the indexes at regular intervals for better performance.
• Used SQL Server Profiler, SQL Server Agent.
• Designed and created backups & recovery strategies.
• Install, configure, upgrade and patch SQL server software, features and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Performed various calculations using complex expressions in the reports and created report models.
• Maintained system monitoring jobs and provided high availability support.
• Participated in Database Architecture and data modeling design.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL.
• Interacted with Team, Designed and developed database using ER diagram, Normalization and relational database concept.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Allocate system storage and plan future storage requirements for the database system.
• Create primary database storage structures after application and developers have designed applications.
• Maintained Fail-Over Cluster Servers in SQL Server 2008 & 2014.
• Performed database monitoring and Performance tuning.
• Monitor Servers activity, and worked with clients to solve different problems.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.

Environment: SQL servers 2014, 2012, 2008, SQL server management studio, SQL profiler, SSIS, SSRS reporting tool.

Confidential - Tamp, FL

SQL SERVER DBA

Responsibilities:

• Developed T-SQL Stored Procedures for Export & Import of data from databases and transaction databases of different agencies in SQL servers 2005 and 2008.
• Performed query tuning, assigning proper Indexes for better performance.
• Implementing Replication for Reference Data across different Instances of the application.
• Created and maintained databases, created roles and manage user permissions.
• Developed SSIS packages and schedule jobs for loading data between different sources.
• Worked on updating and maintaining customer information using Slowly Changing Dimension for address and last name changes using SSIS.
• Configured Transaction Replication Production to DR Servers and Reporting Server with Multiple subscribers.
• Experience working on databases and instances with different Collation settings.
• Extensive experience in creating indexes, export and import of data using DTS and SSIS packages, VBScript and other utilities.
• Migrated DTS Packages from SQL Server 2000 to SQL Server 2008 R2.
• Analyzed SQL queries causing performance problems.
• Created Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performed query plans and making sure each and every query is using appropriate useful Indexes.
• Created and Modified T-SQL Stored Procedures/Triggers for validating the integrity.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Extensive experience in multidimensional data modeling, such as star schemas, snowflakes, de normalized models, handling slow-changing dimensions/attributes.
• Supported SQL Server DB backups (online/offline), logical backups and SQL scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
• Troubleshoot installation errors both independently and with Development Team support
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: SQL servers 2005, 2008, SSIS, SSRS reporting tool, performance tuning monitor, Database tuning adviser

Confidential - New York

SQL SERVER DBA

Responsibilities:

• Involved in Administering MS SQL Server, performing day-to-day tasks such as checking indexes and modifying procedures etc.
• Worked on SQL servers 2000/2005/2008 did Performance tuning for servers, queries, index tuning and query optimization using SQL Server Profile, Performance monitor, Query Analyzer.
• Involved in utilizing T-SQL and Visual Basic Programming to write program units for conversions.
• Involved in Data Mapping, writing stored procedures for conversion and performing quality testing before the sign of Setting up security, creating groups, user defined roles, logins, granting permissions.
• Worked with different data models, normalization & de-normalization of tables.
• Planned and implemented various SQL, T-SQL statements, stored procedures and triggers according to the requirements of the projects for the OLTP database systems.
• Migrated data from different servers to data ware house.
• Worked on Maintenance, installation, performance monitoring and tuning.
• Created master ghost images using Symantec Ghost software and HW/SW inventory.
• Installed configured Linux operating system on laptops and desktops for different application use.
• Developed and designed databases, stored procedures, triggers, and views using T-SQL
• Performed database migration using Backup-restore, Attach and detach and copy methods.
• Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
• 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.

Environment: SQL servers 2000/2005/2008 , performance monitor, Excel, MS Access, SSAS, OLAP

Confidential

SQL SERVER DBA/ DEVELOPER

Responsibilities:

• Installed and configured SQL Server 2008 and maintained 50 servers.
• Upgraded and migrated the servers from SQL Server 2000 to SQL Server 2005/2000.
• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Security features were implemented for restricted set of users.
• Wrote SQL stored procedures to implement business logic.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Deployed SSIS packages to production server.
• SQL Query Performance Tuning using SQL Sentry Performance Monitoring Tool, Analyzing the Query Execution Plans, Used SQL Profiler 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 and User-Level Security Strategy, Authentication Modes, configure database Logins and Users.
• 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.

Environment: SQL servers 2000/2005/2008 , SSIS, SSRS

Confidential

SQL SERVER DBA/ DEVELOPER

RESPONSIBILITIES:

• Developed database objects like Tables, views, stored procedures, indexes etc.
• Installation of SQL Server 2005 with latest Service Packs.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Implemented Views and Triggers to keep track of the product purchases.
• Developed views, DDL triggers and user-defined functions.
• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for reports generation in migration process.
• Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
• Maintained both development and production server in syncs
• Involved in Log Shipping, replication.
• Worked in 24x7 production environment.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Environment: SQL server 2005, SSIS, SSAS, SSRS, Office 365, T-SQL, MS windows7/XP, Visual Studio 2014.