SUMMARY

• Around 12 years of technical experience as a Sr. MS SQL DBA, Database management team, Database design, production and development support DBA. Extensive experience in creating and maintaining MS SQL Clustering, AlwaysOn, replication and log shipping.
• Experienced in Performance tuning, Backup/recovery, Security and disaster recovery.
• Involved in configuring and maintaining Log shipping in production environment.
• Excellent experience in performance tuning, backup and query optimization.
• Excellent time and task management skills.
• System administration of Windows 2000, 2003,2008,2008R2, 2012, 2016 and Windows NT.
• Experience in creating technical documentation to create standards.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2017, 2016, 2014, 2012 R2, 2008 R2, 2005, Oracle12ci and 11g, Access and Dbase

Operating Systems: Windows 2016, 2012 R2, 2012, 2008, 2008 R2, Windows 10/8/7, MS DOS, Novell Netware, Linux

Applications: MS Office, Adobe (Reader, Photoshop, Flash cs3), Foxit Reader, SQL Mail and Outlook Express

Tools: Cluster administrator, Alaways ON Availability Groups, Erwin, Mirroring, Windows Azure SQL Database, Big Data, In - Memory optimized tables, Cloud, Windows Azure Blob Storage, Columnstore Index, Buffer Pool extensions, NetIQ, Performance Monitor, Dataware house, STAR and Snow Flag Schema, Profiler, SQL Query Analyzer and TSQL, SSIS, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. SQL Server DBA

Responsibilities:

• Act as Lead SQL Server DBA and Team lead, provided production support for 310 Servers out of which 125 servers are production servers. These servers are located all around the globe.
• Lead the DBA team to provide production and development support for application team located in United States of America.
• Experienced in installing and configuring SQL Server 2017, 2016, 2014, SQL Sever 2012, SQL Server 2008 R2, SQL Server 2008 on Windows 2016, 2012, 2008 servers, applied service packs and security fix.
• Involved in upgrading SQL Server 2014 environments to SQL Server 2016 and 2017. Tested the application and completed the successful upgrade.
• Experienced with Alwayson Availability Groups for High availability and Disaster recovery solutions.
• Installed, configured and maintained SQL Server Fail over cluster instances for 4 production environments.
• Installed, Configured and maintained the log shipping architecture to provide backup server for production environment.
• Experienced with Migration, Consolidation and Upgrade of Datacenters databases.
• Experienced with Windows Azure SQL Databases.
• Configured and maintained transaction and snapshot replication between the production servers for two different environments.
• Experience in setting up the security for Production and development environments.
• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, profiler and execution plans.
• Experienced in creating backup strategy for production, development environment and implemented them.
• Experienced in Database Mirroring for Production databases.
• Experienced in SQL Server DTS, SSIS, SSAS and SSRS business intelligence data tools.
• Experience with SQL Server disaster recovery procedures and created the guidelines for them.
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Experienced in backing up to Windows Azure Blob Storage and store it to Cloud.
• Experience in maintaining critical production SQL servers and troubleshoot database Problems.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Experience in improving server performance using performance monitor tool.
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Created Work instructions document for SQL Server 2017,2016,2014 and 2012 R2 installation, Upgrading from SQL Server 2008 to 2014 and 2016 SQL Servers and applying patches.
• Experienced in database sizing and capacity planning for new and existing projects.
• Excellent team lead and player and worked on call rotation.

Confidential, NJ

Sr. MS SQL DBA

Responsibilities:

• 24*7 Critical production support for J&J 158 servers out of which 110 servers are production servers, 48 servers are development and test servers.
• Experience in installing and configuring SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012 R2 servers with applied service packs.
• Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and SQL Server 2008 to SQL Servers 2012 R2 and test the SQL Server after the upgrade and bugs fixing.
• Installed, configured and maintained SQL Server Fail over clustering for 5 production environments.
• Installed, configured and maintained transactional replication, snapshot replication in production environments.
• Configured Log shipping for 2 environments to create a Disaster Recovery Stand by servers.
• Experienced with Alwayson Availability Groups for High availability and Disaster recovery solutions.
• Experienced in SQL Server DTS, SSIS, SSAS and SSRS.
• Experience with SQL Server disaster recovery procedures and created the guidelines for them.
• Experienced with FDA regulation for validated systems for pharmaceutical companies requirements.
• Responsible for database backup and restore, monitor production servers activity, Problem solving, scheduled jobs, SQL Server error log and space usage.
• Created the backup and restore strategy for production and development environments.
• Created the logical and physical data modeling using Erwin tool for development projects.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Involved in tuning the database and server performance. Worked with Profiler to trace and tune the database.
• Responsible for stored procedure optimization, Performance tuning of databases.
• Created Logical data modeling for production database and data ware housing Projects using Erwin Tool.
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Experienced in leading DBA team, Off shore team, assign tasks and interact with the different groups to manage the servers.
• Created database for different projects and created objects like Tables, Views and Stored procedures.
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Experience in maintaining critical production SQL servers and troubleshoot database
• Problems.
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Experienced in database sizing and capacity planning for new and existing projects.
• Experienced in setting up the database data center for different departments.
• Installed and configured Analysis services for Data ware housing project. Built and process the cubes.
• Experience in improving server performance using performance monitor tool.
• Experienced in fine tuning using SQL Server Profiler.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Experience in maintaining critical production SQL servers and troubleshoot database
• Problems.
• Experienced in SQL Server tuning techniques to optimize the SQL queries and stored procedures.
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk and memory devices
• Experienced in database sizing and capacity planning for new and existing projects.
• Created Work instructions document for SQL Server 2000,2005,2008R2 and 2012 R2 installation, Upgrading from SQL Server 2000 to 2005 and 2008 SQL Servers and applying patches
• Excellent team player and worked on call rotation.

Confidential

SQL Server DBA

Responsibilities:

• Supported over 200 databases instances in production and pre-production environments (SQL Server 2005 and 2008)
• Upgraded sql 2005 to 2008, applied latest service packs and hot fixes
• Facilitated SQL Server 2008 cluster and SQL Server replicating server
• Performed routine maintenance, including backup & recovery in sql server 2008
• Created and maintained jobs and maintenance plans
• Responsible for Database tuning, creation & design
• Facilitated SQL server 2005 and sql 2008 server migration in Datacenters
• Performed analysis on tables, indexes and code in order to optimize query performance
• Used SQL Profiler and performance monitor to trace database performance
• Use table partitioning to improve system performance over all
• Configured SQL 2008 cluster for mission crititcal application to provide 24*7 up environment
• Setup and configured SSRS (reporting services) for business
• Installed and configured SSAS (analysis service) for data warehousing
• Setup, configured and monitored log shipping for critical databases
• Installed database mirroring in high performance mode to avoid downtime
• Setup policies in sql 2008 using standard conditions, targets and facet. configured and monitored transactional and merge replication
• Supported SQL Server production & pre-production release roll-outs
• Administer sql server security using sql and windows authentication and setup different proxy account to grant certain permission.
• Configured Linked server for application team to run adhoc queries
• Design & development of preprod/integ/development DB refreshes with Production data
• Transformation and Uploading the information from different platforms into SQL Server databases using DTS, BCP, BULKINSERT and SSIS (integration service) packages
• Worked With storage team to configure and design SAN for databases instance.