SUMMARY:

• Over 8 years of IT experience as SQL Server Database administrator, providing 24/7 support of both development and production databases.
• Hands - on working experience in Installing, configuring, upgrading and managing SQL Server 2012/2008/2005 and required Service Packs.
• Experience in supporting Large Databases, monitoring, troubleshooting and documenting root cause analysis.
• Experience in Creation and maintenance of databases, providing SQL Server security by assigning logins, server/database roles and server permissions.
• Experience in implementing efficient Disaster prevention and Recovery Strategies and High availability using Database Backup and Restore, Database Snapshot, Partitioning, Replication, Log shipping, Clustering (Active/Passive), Database Mirroring and SQL Server 2012 Always On.
• Implementing high availability with Always On Availability Groups and failover clustering
• Experience in trouble shooting SQL Server Jobs, and job monitoring tool.
• Involved in automation of administrative tasks such as creating jobs, schedules, alerts using SQL Server agent, monitoring and troubleshooting the jobs.
• Used tools like SQL profiler for Monitoring and Tuning MS SQL Server.
• Experience using DBCC Utilities for Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Good understanding of SDLC, RDBMS, Normalization/De-normalization, RAID levels and Linked Servers.
• Excellent backend skills in creating SQL objects like tables, constraints, user defined data types, indexes, views, functions, stored procedures, and joins for developer applications.
• Adept on Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS).
• Expertise in data migration and data center migration.
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Extract, Transform and Load (ETL Tools) data using DTS Import/Export utility, deployment utility DTS Packages and SQL Server Integration Services (SSIS).
• Hand-on experience on creating SQL Server Reports using SSRS 2012.
• Working knowledge of Microsoft Dynamics CRM.
• Good verbal, written communication, presentation, problem solving and conflict resolution skills.
• Detail oriented with client interaction and knowledge transfer.

Databases: MS SQL Server 2000/2005/2008/2012

ETL Tools: DTS, SSIS

Tools: MS Office 2003, MS Excel 2003/, MS Outlook 2003, Erwin, MS Visio, SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), Tableau 8.1

Backup and Monitoring Tools: Aramark GRID, Quest Litespeed, Spotlight, Redgate. Ignite, DPA, Splunk, Perfmon.

Operating systems: Windows Server 2012/2008/2008 R2/2003.

PROFESSIONAL EXPERIENCE:

Confidential, Iselin, New Jersey

SQL Server DBA

Responsibilities:

• Day-to-day management of a centralized MSSQL Server platform
• Installation of SQL Server 2012 on Windows Cluster, applying service pack and security fixes as necessary.
• Configuring Replication from Production to Reporting server and adding articles as and when new tables are created.
• Configured Log Shipping as a Disaster Recovery Planning for Critical databases.
• Install, manage & troubleshoot multi node multisite SQL Server clusters(Active/Passive)
• Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs.
• Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults
• Create and manage user databases and their sizes. Migrate databases from Dev to Higher environment.
• Defining roles for various users as per the teams they belong to, as to give right access to right people.
• Create and manage users and grant necessary permissions.
• Schedule user jobs and execute them on demand.
• Setup operators for user job notification.
• Coordinating with Rackspace for adding various resources (Space/Memory/CPU) for improving performance and for capacity planning.
• Used query execution plan to improve query performance by identifying expensive operators and optimizing them by restructuring the query and adding necessary indexes.
• Review Stored Procedure, analyze and create recommendation on it to improve performance such as creating indexes to avoid deadlock, key lookup.
• Used SQL Profiler and DPA to identify long running queries and optimize them, capture and analyze deadlock graphs to resolve deadlocks and blocking.
• Perform code reviews on the database objects created by developers, enforcing best practices and coding standards.
• Participated in the organization’s change management process for production releases with different application groups. Managed version upgrades working with Development, UAT, QA, and Production Environments.
• Created various Dashboards and Reports using SSRS for performance Tuning and application error logs as to track performance of applications.
• Created reports for Release scripts for deploying change scripts to Prod Environment.
• Creating Subscription for SSRS Reports.
• Work with individual application resources to coordinate testing of new releases and upgrades from application perspective.
• Work in the onsite-offshore team structure. Lead standup meetings to discuss daily updates/issues.

Environment: SQL Server 2012/2008R2/2008/2000, SSAS, SSRS, SSIS, Windows 2012/2008R2/2003, DTS/SSIS, DPA (Database Performance Analyzer), Rackspace.

Confidential, Phoenix, Arizona

SQL Server DBA

Responsibilities:

• Day-to-day management of a centralized MSSQL Server platform
• Installation of SQL Server 2012 on Windows Cluster, applying service pack and security fixes as necessary.
• Implementing high availability with Always On Availability Groups and failover clustering
• Install, manage & troubleshoot multi node multisite SQL Server clusters(Active/Passive)
• Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs.
• Being the first line SME   escalation point for database issues
• Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults
• Create and manage user databases and their sizes. Migrate databases from Dev to Higher environment.
• Create and manage users and grant necessary permissions.
• Schedule user jobs and execute them on demand.
• Setup operators for user job notification.
• Used query execution plan to improve query performance by identifying expensive operators and optimizing them by restructuring the query and adding necessary indexes.
• Review Stored Procedure, analyze and create recommendation on it to improve performance such as creating indexes to avoid deadlock, key lookup.
• Used SQL Profiler to identify long running queries and optimize them, capture and analyze deadlock graphs to resolve deadlocks and blocking.
• Deploy and scheduled SSIS package and reports as per user requests. Migrated SSIS package from SQL Server 2008 to 2012 from Dev to higher environments.
• Using PowerShell scripts on regular basis for getting instance specific details.
• Perform code reviews on the database objects created by developers, enforcing best practices and coding standards.
• Working with Avamar team for backup and restore of Database for all environments.
• Implemented yearly password management/maintenance procedures involving production updates of password changes for SQL Services, Replication, Reporting services and Database connection strings.
• Participated in the organization’s change management process for production releases with different application groups. Managed version upgrades working with Development, Extract, Testing and PSM Teams.
• Created Dashboard for Incident and Change management using Tableau 8.1 for tracking incidents.
• Creating Subscription for SSRS Reports.
• Work with individual application resources to coordinate testing of new releases and upgrades from application perspective.
• Work in the onsite-offshore team structure. Lead standup meetings to discuss daily updates/issues.

Environment: SQL Server 2012/2008, SSAS, SSRS, SSIS, Windows 2012/2008R2/2003, DTS/SSIS, Ignite, DPA, SCCM, SCOM, Splunk Service Now Ticketing, Tableau 8.1.

Confidential, MD

SQL Server DBA

Responsibilities:

• Day-to-day management of a centralized MSSQL Server platform
• Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs.
• Being the first line escalation point for database issues
• Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults
• Installed and configured multiple SQL server instances including service pack installation.
• Setup maintenance plan to perform full database and transaction log backups, check integrity of databases, rebuilt indexes and update statistics.
• Setup database mail and configured mail profiles for various applications.
• User creation and permission management.
• Proactively monitor and resolve all SQL server related job alerts.
• Schedule user jobs and execute them on demand. Setup operators for user job notification.
• DB backup and restore management as per user request to refresh environments or to recover lost data.
• Used SQL Profiler to identify long running queries and optimize them, capture deadlock graphs and optimize the query to resolve deadlocks and blocking.
• Participated in the organization’s change management process for production releases with different applications.
• Perform problem determination (root cause analysis) and document the source and proposed resolution.
• Documentation and enforcement of DB development best practices.
• Installed Microsoft SQL Server 2005 and 2008 R2 on New Production and Test servers with latest Security updates involving Service Packs and Security patches as they are released.

Environment: SQL Server 2012/2008/2005 , Windows 2008/2003, DTS/SSIS, SQL Compliance Manager, Microsoft Dynamics CRM.

Confidential, St. Petersburg, FL

SQL Server DBA

Responsibilities:

• Responsible for 24*7 production support.
• Installation of SQL Server, applying service pack and security fixes as necessary.
• Involved in Database optimization, performance tuning, monitoring and capacity planning.
• Worked with development team to create Stored Procedures and triggers as per application needs and deploying the same.
• Worked with SQL Profiler for troubleshooting and performance tuning.
• Worked with Index tuning wizards for development databases.
• Involved in analyzing execution plans for database optimization.
• Participated in Query tuning processes for SQL developers.
• Configured and maintained transactional replication for production servers.
• Performed Backup, Restore and Disaster Recovery.
• Prepared Step by Step Installation document.

Environment: MS SQL Server 2008/2005, Windows Server 2003, SSAS, SSRS, SSIS, T-SQL, Oracle 10g, ERWIN, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• 24*7 critical production supports for production and test servers
• Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 servers. Installed service packs and applied latest security fix
• Upgrade SQL Server 2000 servers to MS SQL Server 2005 servers. Worked with the application administrators to make sure applications are working fine after the upgrade
• Managed SQL Server configurations to run in optimal conditions
• Maintained critical production SQL servers and troubleshoot database problems
• Created a procedure to recover databases in the disaster situations
• Used SQL Server tuning techniques to optimize SQL queries and stored procedures
• Created the SOP (Standard operating procedures) for all SQL Server activities like Backup and Restores, Security and regular Database administration tasks
• Installed SQL Server, applied service packs and security fixes as necessary
• Created DTS packages for data manipulations and application related jobs
• Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk and memory devices
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects
• Created guidebook to secure SQL Servers
• Experienced with creating documentations for the SQL Server and SQL Cluster installations and apply service packs

Environment: MS SQL Server 2005, Windows Server 2003, T-SQL, SQL Profiler, ERWIN, DTS, SSRS.