SUMMARY:

• Certified SQL Server DBA with 7+ years of experience in SQL Server administration, implementation and support.Hands - on experience in supporting SQL Servers 2005/2008/2008 R 2/2012/2014/2016/2017. Specific Hands on Experience in administering SQL Server activities like Backup, Recovery, Replication, Always On, Log shipping, DB Mirroring, Performance tuning, SQL Server Profiler, Windows Performance monitor, activity monitor, SQL Server features like DMVs, DMFs to determine and resolve the issue. Strong Knowledge on Azure database administration.
• Expert in Disaster Recovery planning by configuring Clustering, Log-shipping, Mirroring and Replication
• Expertise in Installing, Configuring and Administrating MS SQL Server Clustered and Non-Clustered instances 2016/2014/2012/2008 R 2/2008/2005/2000 in OLAP and OLTP environments.
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in advanced features of SQL Server Always-ON Availability Groups (AAG) and HA/DR Troubleshooting.
• Implemented and troubleshoot Always-ON (AAG) on SQL Server 2012/2014/2016.
• Expert in Performance Tuning by analyzing the SQL Server Configuration, WaitStats, Locks, Blockings, Indexes and tuning the SQL queries using the Execution Plans.
• Expert in RDBMS/W installation, database server builds, applying patches, Applying patches in VM environments, upgrading, configuring, trouble shooting of SQL SERVER on Windows 98/2000/03/08/12 servers and Clustered VMware Environments.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Ability to work independently and as a Team member.

TECHNICAL SKILLS:

Languages: HTML, VB, C#, C++, T-SQL and Java

ETL Tools: Microsoft SSIS, DSSData Model: SSAS, Darwin, Erwin

Reporting Tools: QlikView, Tableau, SSRS,, Cognos BIBackup Software: SQLBackup, Redgate, SQLSafe, Litespeed, FTP, EMC, and TSM.

RDBMS & Tools: SQL Server 2000/ 2005/2008/2008 r2/2012/2014 and 2016, MS Access

2003/2007/2010/2013/2016 , SQL Loader, and Export/ImportOperating System: Windows NT/ 2000/2003/2008/2008 r2/Windows server 2012.

Third Party Tools: Litespeed, DB Artisan, RedGate,, Idera, Spotlight, Quest's Toad

Database Query Tools: SSMS, MS SQL Server QA, SQL Profiler, ETL,.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC, DC

SQL Server DBA

Responsibilities:

• Installing, configuring, upgrading, monitoring and troubleshooting SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017.
• Provide 24*7 support and on call support for SQL server databases.
• Troubleshoot issues with database instances, DR, replication and backups and eliminates root causes
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Experienced with creating SSIS packages for data import and export in SQL Server.
• Experienced with creating ETL package that extracts data from multiple data sources.
• Experienced in configuring and maintaining Always-On, Replications and Log-shipping.
• Implemented SQL Server 2014 Database Mirroring and Database Encryption.
• Installed and configured the MS SQL Fail over clustering for production servers.
• Perform database installation and configuration, tuning, capacity planning, health checks, backups & recovery and change management
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Installed Quest Software and experienced with LiteSpeed backup and Restore.
• Experienced with SQL Disaster recovery processes and documented the processes.
• Created the maintenance plan for database optimization and integrity checks.
• Experienced with improving SQL Server performance using windows performance monitor.
• Experienced with improving the database performance using execution plan, index tuning wizards and profilers.
• Worked with the SQL Developers to change the stored procedures codes to improve the performance.
• Manage Log Shipping to a standby by server using DR-Synch. DR-Synch is a Disaster Recovery and has lot of advantages over the inbuilt SQL Server Log Shipping.
• Experienced in change management processes to implement the changes to production environments.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients, etc.
• Involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshoot issues with the same. Applied hot fixes and Service Packs in clustering environments.

Confidential, Jersey City, NJ

SQL Server DBA

Responsibilities:

• Installed and configured MS SQL Server 2012, SQL 2014 and SQL server 2016
• Worked on complex SQL environments that include 300+ databases.
• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Wrote SQL queries, Stored Procedures, Functions, and Views.
• Setup and configured Always on Availability Groups for DR and Reporting
• Implementing and configuring Central Management Servers to centralize and manage instances of SQL Server 2008 R2 to SQL 2016.
• Responsible for a large scale of database migration from SQL server 2008\2008R2 to SQL server 2012, SQL server 2014 and SQL server 2016.
• Responsible for Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Used PowerShell script for SQL Server Maintenance activities
• Involved in database and log backups and restoration, planning backup strategies, and scheduling.
• Involved in developing & Deploying SSIS packages & SSRS Reports.
• Implemented Database mirroring for High Availability.
• Always-On Availability Groups (AAG) and High Availability /DR Setup and Configuration.
• Backing up master & system databases and restoring them when necessary.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshoot issues with witness servers.
• Designed and implemented comprehensive Backup and Restore Strategy for the point in time recovery. Prepared a document for Disaster Recovery Plan
• Responsible for Installing, configuring and maintaining SQL Fail over clustering
• Involved in creating Logical & Physical Database Design using data model tool Erwin.
• Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.
• Installations, Patching, Cumulative Upgrades, Security Updates on both stand-alone as well as Failover clusters.
• Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this database on requests.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Monitoring and Tuning SQL Server - Managing Messages, System Monitor, Setting Trace Flags, Setting up Job Notifications and Capacity Planning and Sizing.
• Using third party tool Idera, monitor all the servers and their jobs in a single Management Console.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Responsible for Installing and configuring SQL Server 2005 and 2008, 2008R2 and SQL server 2012
• Worked with SQL DBA team and SQL Developers to optimize the SQL queries and stored procedures.
• Installed and configured SQL server 2005 Reporting Services (SSRS), created user roles, managed security built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
• Provided 24 X 7 dedicated supports to hundred and eight Production, development and clustered servers.
• Done Capacity and Disaster Recovery (DR) planning for Production Servers.
• Implementing Database Mirroring using high safety with automatic failover for Disaster Recovery.
• Developed the metrics and trending processes for SQL database sizing and growth.
• Daily monitoring of two-node active-passive SQL cluster in a host environment.
• Applied service packs and security fixes for all SQL Servers, and provided database administration support.
• Experience in using SSIS (SQL Server Integration Services) for data ETL extraction, transformation and loading across different databases like Oracle, MS Access, and flat files using tools like export/import wizard, SSIS packages.
• Migrated SQL servers from Physical machines to Virtual machines. Migration of the databases, jobs, SSIS packages, linked servers.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008\2012
• Performed the database backups for production, test and development environments.
• Created the backup and restore strategy for the all three environments.
• Worked with the database optimization, Performance tuning and index tuning for optimization of queries.