SUMMARY

• Senior MS SQL Server DBA/Developer/Architect with Extensive knowledge in Managing SQL Server environment
• Over 9+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2016, 2012, 2008 R2, in Production, Development & Replication Environments.
• Extensive experience in installation, configuration, and maintenance of MS SQL Server 2016, 2012, 2008 R2
• Good experience in Upgrading and migrating from SQL server 2008 R2 to SQL server 2012/2014/2016.
• Expert in implementing/installing/configuring and migrating SQL Server to Microsoft Azure based cloud
• Expert in upgrading SQL Server environments from one data center to Microsoft Azure cloud
• Experienced in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in Active/Passive and Active/Active Clustering
• Extensive experience in Maintaining High Availability using Always On Availability Groups, Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2016/2014/2012/2008 R2/2005 to provide robust database solutions.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Expert in implementing log shipping and database mirroring.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
• Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
• Experienced in writing Windows Power-shell and complex T-SQL scripts to provide faster and better automated solutions.
• Experienced with SQL Server Store procedures, SSMS to create and manage objects as well as Troubleshooting Methods at server lever and database level.
• Participated in continuous improvement efforts in enhancing performance and providing increased functionality.
• Experience in Managing Security of SQL Server 2000/05/08/12/14/16 by creating Database Users, Roles and assigning proper permissions according to business requirements.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services(SSIS),Data Transformation Services (DTS), Bulk Insert, and Bulk Copy ( BCP)
• Experience with Reporting Services (SSRS, Crystal Reports) and Analysis Services (SSAS).
• Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation form previous versions.
• Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
• Proficient in troubleshooting database issues.
• Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
• Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications
• Team player with Good communication, interpersonal and business analysis skills.
• Experienced in working with production 24/7 Environment
• Expert working in Virtual Environment using VMWARE for SQL Server

TECHNICAL SKILLS

• Operating Systems: Windows 2012/2008 R2/2008/2003/2000 Server, Linux
• Databases: MS SQL Server 10.0/7.0/2000/2005/2008/2012/2014/2016
• Languages: T - SQL, PowerShell, PL/SQL, C, C#, VS 2005/08, ASP.net
• SQL Server/Oracle Tools: Management Studio, Microsoft Azure, Business Intelligence Development Studio, Visual Studio 2005, Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, DTS, Log Shipping, Server Network Utility, Database Tuning Wizard, Index Tuning Wizard, Informatica, SSIS, SSAS, SSRS, Microsoft Clustering Services (MSCS), OEM, SQL Loader, Toad, Data Pump Utility
• Report Tools: MS Reporting Services, SAS
• Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard, Double Take replication, Tidal Automation tool.
• Database Modeling & Other Tools: IDERA tools, Double Take, Tidal, SQL Compare, SQL Trace

PROFESSIONAL EXPERIENCE

Confidential, Whitehouse Station, NJ

Senior MS SQL Server DBA

Roles and Responsibilities:

• Managed Database environment in Development, Integration, QA, Performance and Production environment based on project requirement and company’s best practices.
• Expert in SQL Server Installation, configuration and management of 2016/2012/2008R2/2008/2005 servers in Cluster, stand-alone and Disaster recovery environment.
• Worked exclusively on Microsoft Azure and Amazon AWS for cloud based implementation of SQL Server
• Highly skilled in implementation and managing High Availability Environments like Always On Availability Groups, Clustering, Mirroring, Log Shipping and Replication Environment.
• Expert in create, manage and documentation of database solutions based on business requirement.
• Set up and configured Always On Groups for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting Always On Availability group environment.
• Migrated and Upgraded SQL Servers 2008/2012 to 2016 from Windows 2008/2012 servers to new servers using Windows server 2012 and Always On Availability Groups
• Experienced in Capacity planning of very large databases using partitions.
• Enforced Cyber Security for databases and involved in documentation to provide risk based solutions.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Troubleshoot problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.

Environment: SQL Server 2016, 2012, 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Red-gate, SQL Sentry, VISIO, Windows Server 2012, 2008 R2, SAN, VMWare, T-SQL.

Confidential, New York, NY

Senior MS SQL Server DBA

Roles and Responsibilities:

• Build Database environment in Development, Integration, QA, Performance and Production environment based on project requirement and company’s best practices.
• Highly skilled in implementing and managing High Availability Environments like Clustering, Mirroring, Log Shipping and Replication Environment.
• Expert in create, manage and documentation of database solutions based on business requirement.
• Set up and configured Database mirroring for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting mirroring environment.
• Experienced in handling large databases up to 5 terabyte in size.
• Migrated and Upgraded SQL Servers 2005/2008 to 2012 from Windows 2008 servers to new servers using Windows server 2012 and Always On Availability Groups
• Enforced Cyber Security for databases and involved in documentation to provide risk based solutions.
• Experienced in managing PII(Personal Identifiable Information) data in all environment.
• Expert in troubleshooting production problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.
• Redesigned T-SQL Solutions into Powershell to use more flexibility.
• Created automated solutions using T-SQL and Powershell for Backup/Recovery, security, replication of the data etc.
• Developed Crystal Reports to access the data mart and deliver accurate data for any given fiscal period. Developed dynamic cursor driven PL/SQL stored procedures to feed Crystal Reports to provide much better performance .
• Routinely check and applied Service Packs as well as developed Pre-Checklists for new servers to apply latest service packs.
• Development of Automated solutions to decrease manual labor and increase proficiency.
• Participated in routine Power-down and Disaster Recovery tests and failovers. Documented and managed lesson learned to make future failover even smoother.
• Experienced in performance enhancement for Data Warehouse processes as well as slow running queries.
• Greatly reduced slow running Queries by proper indexing and updating statistics.
• Experienced in creating and managing backup and recovery solutions using Lite-speed, native backups as well as network backups.
• Experienced in deploying and managing SSIS packages using Catalog database and its security.

Environment: SQL Server 2012, 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Lite-speed, SQL Sentry, VISIO, Windows Server 2012, 2008 R2, SAN, VMWare, T-SQL.

Confidential, Jersey City, NJ

Senior MS SQL Server DBA

Roles and Responsibilities:

• Installed, configured, Managed and supported SQL Server 2005, 2008, 2008 R2, 2012 and 2014 in clustered and non-clustered environments.
• Experienced in supporting Global environment with more than 1400 SQL Servers in diff geographical areas such as Germany, USA, China, Japan, South Africa and India.
• Highly skilled in managing High Availability Environments like Always On, Clustering, Mirroring, Log Shipping and Replication Environment.
• Set up two node and multimode cluster including Always On as new DR solutions with removal of SAN replication between windows servers.
• Set up and configured Database mirroring for Disaster Recovery as well as for stand by solutions. Experienced troubleshooting mirroring environment.
• Experienced in handling large databases up to 5-10 terabyte in size.

Environment: SQL Server 2014, 2012, 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL

Confidential, New York, NY

Senior MS SQL Server DBA

Roles and Responsibilities:

• Installed, configured and supported SQL Server 2005, 2008, 2008 R2, 2012 in clustered and non-clustered environments.
• Handled and Supported Data Center migration Project from NY to NJ.
• Carried out best practices and remediation of database servers to increase performance and reduce management overhead.
• Installed, configured, test, document and implement SQL Server Always On Functionality.
• Reconfigured Replication, Mirroring, log shipping and clustering during Data Center migration.
• Configured and migrated IDERA auditing server with IDERA support.
• Install, configure and troubleshoot Double Take (SAN) replication.
• Installed and configured Tidal agent for centralize Job management for enterprise solutions.
• Created Live Vault backup strategy to have better recovery solutions and less downtime for database servers.
• Administered SQL Server’s linked servers to facilitate distributed Queries.
• Performed capacity planning and resource allocation for SQL Servers in all the environment
• Created databases and database’s objects like tables, views for different SQL Server projects.
• Configured, monitored and troubleshoot Failover clustering (Active/Active, Active/Passive)
• Developed and tested storage strategies and disaster recovery plans for databases.
• Created plans and procedures to migrate mission critical databases to HP Servers.
• Upgraded SQL Server 2000 to 2005 and 2008 versions and applied SQL service packs and patches.

Environment: SQL Server 2008 R2/2008/2005, Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Linux, Oracle 11g R2, 11g R1, 10g R2, Diagnostic Manager, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL