SUMMARY:

• Over 12 years of experience in IT as Database Administrator of Microsoft SQL Server 2016, 2014, 2012, 2008, 2005.
• Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and non - clustered environments.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Successfully implemented Log Shipping Technique used for warm standby solution for SQL Server databases.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in SQL Server Failover Clustering, Database Mirroring and Always On Availability.
• Experience in creating packages and Jobs.
• Expert in Tuning SQL queries & improving the performance of the Database.
• Efficient multitasking and performance under pressure

TECHNICAL SKILLS:

Database: MS SQL Server 2016, 2014, 2012, 2008, 2005, 2000

Operating Systems: Windows 2016/2012/2008/2003

Programming Languages: SQL, PL/SQL

Tools/ Technologies: Remedy, Cluster Administrator, Redgate SQL Monitor, Idera SQL Diagnostic Manager, Redgate SQL Compare, Solarwinds, Performance Dashboard Reports, MS Visio, MS Outlook, Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Server Administrator

Responsibilities:

• Created and maintained Database Mirroring between Primary and Secondary data centers.
• Configured and maintained Always On Availability Groups for High availability and disaster recovery purpose.
• Experience in database recovery strategies.
• Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Installed, configured and maintained Active/Active and Active/Passive SQL fail over clustering in SQL 2012.
• Installed and configured SQL Server 2008, 2008 R2, 2012, 2014 and 2016 and applied service packs and security fix in physical and virtual environments.
• Providing 24x7 support in production, test and development environments.
• Upgraded the SQL Servers from 2005, 2008 to 2012, 2014 and 2016.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation, backup and update statistics.
• Used Redgate SQL Monitor tool to monitor the SQL Server activities.
• Used Idera diagnostic manager to monitor SQL Server health and activities.
• Experience with the production deployments using Redgate SQL Compare.
• Provided technical support to internal developers and external clients.
• Experience in writing T-SQL Queries and stored procedures.
• Performed the in-place and side-by-side SQL Server upgrades.
• Configured and maintained Log Shipping as part of disaster recovery system.
• Generated the daily, weekly and monthly reports for the disk usage, CPU and memory usage etc.
• Creating backup plans for production, test and development servers.
• Set up security features for SQL Servers and maintain the user access.
• Created maintenance plan for database consistency and optimization.
• Involved in implementing security features for MS SQL Servers, such as creating and granting permissions on various Objects, assigning permission to user(s), role(s) and column level permission

Confidential, CT

SQL Server Administrator

Responsibilities:

• Installation, upgrade and configuration of MS SQL Server 2005/2008 in clustered and non-clustered environments.
• Applied service packs and security fixes in physical and virtual environments.
• Installed, configured and maintained fail over clustering in SQL Server 2005 and 2008 for production and test servers.
• Managed and resolved the orphaned users.
• Created and maintained Database Mirroring between the data centers.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Experience in improving SQL Server performance by using profiler and index tuning wizards.
• Providing support for more than 260 databases including production, test and development servers. Also, provided 24x7 support to production databases.
• Implemented backup strategy for production, test and development servers.
• Experience in writing T-SQL Queries and stored procedures.
• Setup database maintenance plan and monitored daily database activities.
• Scheduled and monitored all maintenance activities of SQL Server including database consistency check, DB shrink and index defragmentation.
• Configured and maintained Log Shipping as part of disaster recovery system.
• Provided technical support to internal developers and external clients.
• Configured and maintained transactional and snapshot replications.
• Performed daily based tasks, like backup and recovery, scheduling jobs by using SQL Server Management Studio, SQL Server Agent.
• Frequently refreshed data from Production to Test and Development environments.

Confidential, TN

SQL Server DBA

Responsibilities:

• Worked with development team on new projects that rolled into the production environment and assisted them in tuning the SQL queries using SQL Profiler.
• Scheduled packages and different maintenance tasks using MS jobs.
• Performed installation of SQL Enterprise 2005/2008 in 64bit version and 32bit version, applied service packs on clustered and standalone servers.
• Evaluated database/SQL performance and performed maintenance duties such as tuning, backup, restoration, disaster recovery, database consistency check, rebuild indexes, and update statistics.
• Ensured Server & Application performance tuning and optimization.
• Implemented and maintained database security.
• Supported more than 200 databases in production, test and development environments.
• Experienced with restoring the databases.
• Creating backup plans for production, test and development servers.
• Experience in writing T-SQL Queries and stored procedures.
• Set up security features for SQL Servers and maintain the user access.
• Installed and configured fail over clustering in SQL 2005 in test and production environments.
• Migrated SQL server 2000 databases to 2005.
• Created the DTS Packages to do Import and Export operations to SQL Servers.
• Created maintenance plan for database consistency and optimization.

Confidential, TN

SQL Server DBA

Responsibilities:

• Implemented security practices for SQL Servers, such as creating and granting permissions on various objects, assigning permission to user(s), role(s) and column level permission.
• Created and scheduled jobs and maintaining log files
• Configured backup and maintenance procedure for production, test and development environments according to SLA.
• Installed and configured SQL 2000, SQL Server 2005 on Windows 2000, 2003 servers and applied service packs
• Configured and maintained database mirroring in SQL Server 2005 to provide database high availability.
• Successfully implemented indexes on tables for optimum performance.
• Created the DTS Packages to do Import and Export operations to MS SQL Servers.
• Experienced in all techniques used to improve performance using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Created backup strategy and maintenance plan for database consistency and optimization.
• Configured log shipping to provide DR solution.