SUMMARY:

• (6) years as a Microsoft SQL Server Database Administrator. Skilled in the areas of Connection, Maintenance, Migration, Backup, DR Planning, Performance Tuning, Security, SSIS, SSRS, ETL, TSQL, SAN, Data Modeling and design.
• Detail oriented hardworking professional with an effective combination of logical, analytical, communication and documentation skills.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows Server /Windows XP/Windows Vista

RDBMS/DBMS: Microsoft - SQL Server 2005/2008/2008 R/2012/2016

Business Intelligence (BI)/Data Model Tools: Microsoft SQL Server Reporting Services 2005/2008/ 2008 R/ 2012

SQL Tools: Idera (SQL Server Diagnostic Manager, SQL Safe), RedGate (SQLCompare, SQL Data Compare), SQL Sentry Performance Advisor, Solarwinds

Version Control: Microsoft Team Foundation Server, SQL Source Control, Share point

ETL Tools: SSIS, DTSX

Reporting: SSRS (SQL Server Reporting Services/Server)

Data Modeling: ERWin, VISIO, Toad Data Modeler

Scripting Language: T-SQL, PowerShell, .Net.TSQL

Hardware/Storage: EMC 5200

Technologies Used: HVR Replication, Clustering, Idera, Replication, Log shipping.

Database Upgraded (development, testing and production environment): SQL Server 2008 R2 to SQL server 2012

Database Migrated (development, testing and production environment): MySQL 4.1.0/5.0.1 databases to SQL Server 200

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL SERVER DBA

Responsibilities:

• Manage SQL Servers that hold the CRM, Sales, Productivity, and Inventory databases of the BUDR applications
• Experienced in installing, managing, and administering SQL server 2008R 2/ 2012/ 2014/ 2016 SQL servers
• Applied Patches and Service packs to update different versions of MS SQL server and windows server
• Perform Administrative tasks in SQL Server using PowerShell script, including installation of SQL Servers
• Exported data from SQL Server to multiple destinations using SQL Server Integration Services (SSIS) for sales forecast and other purposes
• Implemented side-by-side and in-place migration of MS SQL server 2008R2 to 2012 and SQL server 2012 to 201 6
• Configured Database mail, Linked Servers, Transparent Data Encryption (TDE), Change Data Capture (CDC) and. Change Tracking (CT)
• Strong working experience in SQL native database Backup and restore as well as Idera - SQL Safe Backup solution and LiteSpeed
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery with Point-in-Time Recovery option
• Proactively monitor the production database(s) and optimize stored procedures for better performance and resolve deadlock, block, and locking conflicts and resource utilization
• Identify and analyze long running slow queries and tune the same to optimize application and system performance using extended events, DMV, Wait status, and other tools
• Create and schedule maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Experienced in working with Alwayson Solution for both High Availability (HA) and Disaster Recovery (DR) options
• Implemented SQL Server 2012 AlwaysOn Availability Groups (AG) with two secondary nodes
• Applied patches and hot fixes on AlwaysOn Failover Cluster (FCI) production and non-production environment
• Built SQL 2012 multi Node cluster environments on VMware/ Physical environments
• Prepare different documentation (SQL Server Build Guide, Database Decommissioning steps, restore steps,) and update them in timely manner

Confidential

SQL DATABASE ADMINISTRATOR

Responsibilities:

• Daily administration involved monitoring each instance of SQL Server to verify good data backups, transaction log backups, space availability; jobs running properly, and checking server logs
• Created SQL Server Job Agents to assist with report creation and database maintenance jobs.
• Performance monitoring via Native Tools such as Activity Monitor, Extended Events, PerfMonitor, DMV, Data Tuning Advisor (DTA), and SQL Profiler.
• Analyzed, tested, configured and implemented methods of improvements for SQL Server, database, transaction, and query performance in relation with Input/Output /CPU /Memory /Network /TempDb optimization.
• Suggested and implemented database performance monitoring and performance tuning practices; troubleshoot and resolve database design and performance issues.
• Query optimization, index management, buffer pool management, transaction log management
• Active in all phases of system development; planning and analysis, design, development, and testing
• Developed and maintained technical documentation and operational procedures for areas of responsibility.
• Experience with Export/ Import data to and from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/ OLEDB data sources
• Managed MS SQL Cluster (Active/Passive), Multi node cluster.
• Installed, Configured and Maintained Database Mirroring using automatic fail-over as High Availability (HA) solution
• Configured and implemented Log Shipping as Disaster Recovery (DR) solution
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Involved in data modeling for the application and created ER diagram using ERWin
• Applied SP (Service Pack) and HOT Fixes on SQL Server (2000, 2005, 2008) and Windows Server (2008, 2003, 2000)