SUMMARY:

• Around 7+ years of IT experience, which includes Administration, System Analysis, Design, Development, Testing, Security and Support in Microsoft Database Technologies 2017/2016/2014/2012/2008/2005.
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, Database Maintenance plans, and Database Consistency Checks using DBCC commands.
• Worked in 24x7 Production on call support as well in SQL Build team.
• Experience with Migration and Upgrades.
• Experience on high availability SQL Server solutions, including SQL Server Always ON, Replication, Log shipping, DB Mirroring and SQL Server clustering.
• Exposure to cloud technologies.
• Virtualizing databases on Microsoft Azure cloud for more reliability and high availability.
• Migrated databases from on - premises to Microsoft Azure.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in managing Windows servers in a clustered environment.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters.
• Experience in implementing Replication models such as Snapshot and Transactional and experience in Configuring, Managing and optimizing transactional replication in OLTP environments.
• Experience with SQL Server installation, Migration, configuring SSIS, SSRS.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases.
• Experience in database refresh to Test and Dev environments.
• Experience in creating backup strategies, maintenance jobs and alerting jobs.
• Experienced in routine Database maintenance activities i.e. Monitoring of jobs and Backup/Recovery procedures also by using of the 3rd party tools (Solarwinds DPA, Red Gate Tools, Idera)
• Experience in Performance Monitoring, disk I/O waits, CPU workload and memory usage of the servers.
• Experience in using Microsoft’s in built tools like SQL Profiler, Extended events, Windows Performance monitor, Query store, Tuning advisor and Tuning MS SQL Server applications.
• Experience with analyzing query plans, using Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking issues.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Worked on partition table in SQL.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Knowledge on Power Shell
• Experience in using TSQL and SQL Scripts
• Excellent team player with good communication skills having ability to adapt new technologies.
• Enthusiastic, flexible and project oriented with strong interpersonal skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Languages: TSQL, C, Prologue, Scheme

Networking Skills: Network Administration, TCP/IP

Databases: MS SQL Server

Operating Systems: Windows, Macintosh

Software Tools: Solarwinds DPA, Idera, Red gate, Lite Speed, DreamweaverVisual Studio, Adobe, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

SQL Server DBA

Responsibilities:

• Maintaining and monitoring SQL servers and databases.
• Provide 24/7 production on call support for SQL Server.
• Worked closely with developers in designing and developing and send project status reports
• Installed SQL Server 2012, 2016, 2017 on various servers
• Migrated Production environment from SQL Server 2008/2012 to SQL Server 2017.
• Performed SQL Server Service Pack upgrades.
• Installed and configured SSRS.
• Implemented Always-On feature for high availability and disaster recovery.
• Moved databases from database Mirror to Always On
• Worked on cluster patching and also upgraded SQL Server 2008 to SQL Server 2012 in both standalone and cluster servers.
• Implemented Transactional Replication on various production servers and its maintenance.
• Maintain database mirroring on some of the servers yet to migrate to new versions.
• Migration of databases and solving issues during migration from 2008/ 2012 to 2017 servers
• Worked on Query optimization using in built tools of SQL Server such as query store, tuning advisor and 3rd party tools such as solarwinds DPA.
• Created automated maintenance plans, backup jobs and schedules on every SQL Server.
• Performed analysis over the changes and created reports.
• Automated database backup and alerting jobs.
• Automated alerts, notifications and database email on every new server.
• Automated jobs for daily and weekly indexing updates, and replication.
• Automated jobs on updating statistics, to check consistency of databases using DBCC commands and to create index.
• Created column store indexes and non-clustered indexes to improve performance.
• Responsible for database refresh to Test and Dev environments.
• Responsible for monitoring usage of disk space on physical drives of all servers.
• Configure linked servers and managing servers using central management server.
• Worked on In-memory OLTP, temporal tables and audit features.
• Worked on Azure migration while migrating databases of few applications to Microsoft Azure.
• Used stored procedures to automate jobs for index rebuilding and database backup.
• Maintained all databases and monitored performance, dead locks, blockings, memory usage, CPU workload and wait stats.
• Designed and created new databases and assisted developers in solving duplicate key errors, creating table structures in building new web applications and transferring data.
• Optimized databases and queries for better performance using in built SQL tools.
• Worked on import and export features to push data between servers.
• Enhancing security and user permissions.
• Worked on change tracking feature and change data capture.
• Responsible in regular monitoring of error logs and Job activity monitoring.
• Performance tuning, monitoring and create reports using tools such as Solarwinds DPA
• Setup profiler traces for slow running queries and tune them accordingly using profiler or extended events and performance monitor.
• Worked on new SQL Server Operational Studio.
• Performed special backups during production support.
• Created ER Diagrams and helped in making documentation for database structures.
• Solved issues with Orphan users and login permissions during migration of databases from one server to other while creating a new production environment of SQL Servers.

Environment: SQL Server 2017/2016/2012 \2008R2 Enterprise Edition, SQL Server Reporting Services, PowerShell, Spotlight, Solarwinds DPA, Visual Studio, .Net, ASP.Net,, Windows, MS-office.

Confidential

Graduate Intern program

Responsibilities:

• Installed, configured and maintained SQL SERVER 2005.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Migration of databases from SQL Server 2005 to SQL Server 2008.
• Developed views and adding/changing tables for data load and transformation, and data extraction.
• Monitored Log shipping as high availability solution.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Rebuilding the indexes at regular intervals for better performance.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.

Environment: SQL Server 2008R2, 2005 Standard Edition, PowerShell, Visual Studio, .Net, ASP.Net,, Windows Server 2008 Enterprise Edition, MS-office.