PROFESSIONAL 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.
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Expert in SQL Azure Administration on Cloud Computing
• Migrated Data from diverse source to MS SQL Server environment with SSIS and to AZURE/AWS (Iaas /paas) cloud.
• Taking Bacpac and restoring the SQL AZURE databases.
• Provisioning SQL database and SQL Server VM on Windows Azure.
• Setup data sync services on SQL Azure. Mange Security and provide access to the users in SQL Azure.
• Experienced in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in Active/Passive and Active/Active Clustering
• Expertise in T - SQL writing stored procedures and PowerShell Automation scripts for Automating of manual process and Administrative tasks.
• 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 automatedsolutions.
• 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) and Analysis Services (SSAS).
• 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 working with production 24/7 Environment

TECHNICAL SKILLS:

Operating Systems: Windows 2012/2008 R 2/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, AWS Redshift, 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, Intergration, 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/2008 R2/2008/2005(Enterprise) servers in Cluster, stand-alone and Disaster recovery environment.
• Worked exclusively on Microsoft Azure and Amazon AWS for cloud based implementation of SQL Server.
• Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers.
• Managed Amazon Redshift clusters such as launching the cluster by specifying the nodes and performing the data analysis queries.
• Worked onPowerShell Scripting and writing Automation scripts for Administration.
• Development of Automation tools, database tunning and support of development teams.
• Highly skilled in implementing and managing High Availability Environments like Always On Availability Groups, Clustering, Mirroring, Log Shipping and Replication Environment.
• Conducted Performance Tuning and Query Optimization in AWS Redshift.
• 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 groups environment.
• Migrated and Upgraded SQL Servers 20 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.
• As part of a Corporate DB2 DBA Team, provided support to Application Developers with the z/OS (mainframe) version 10/11
• 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.
• Reconfigured SSIS catalog database and security. Experienced in creating ENV and using dynamic parameters.
• Created automated solutions for Backup and recovery for Always on Availability group databases.
• Install, setup and configured Red-gate SQL backup software for encrypted backup and recovery solution.
• Experienced in setup, configure and managing of SQL Sentrydatabse performance software. Created alerts for automatic notifications and baselined production database servers.
• Worked with Microsoft support to resolve service pack and other issues in the cluster and non-clustered environment.
• 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 deploying and managing SSIS packages using Catalog database and its security.
• Performed Integration service package migration and reconfiguration, (SSRS) reporting service migration and configuration.
• Provided rotational on-call support for the weekends and ongoing projects.

Environment: SQL Server 2016, 2012, 2008 R2/2008/2005(Enterprise), Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, AWS Redshift, 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, Intergration, QA, Performance and Production environment based on project requirement and company’s best practices.
• Configure firewall rules, user permission, database auditing for Azure SQL databases and Azure SQL VM.
• Setting up SQL backups directly to blob / raw storage | Restore performance.
• Experienced on creating the VM machine in SQL Server Azure and configured the Transaction replication from Physical server to Azure SQL Server database.
• 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 20 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 Informantion) data in all environement.
• Expert in troubleshooting production problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.
• RedesignedT-SQL Solutions into Powershell to use more flexibility and generation and administration of backup, replication and automation routines.
• Setting up GoldenGate replication between Oracle RAC databases or Single database instances.
• Successfully implemented Oracle character set migration using streams and Goldengate for multiple clients
• Routinely check and applied Service Packs as well as developed Pre-Checklists for new servers to apply latest service packs.
• Development of Automation 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(Enterprise), Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, SSRS, SQL Sentry, Lite-speed, SQL Sentry, VISIO, Oracle GoldenGate, 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.
• Migrated and Upgraded SQL Servers 20 /2014 from Windows 2003 servers to new servers using Windows server 2012.
• Enforced Database related security policies and managed security to restrict excessive privileges in production servers.
• Experienced in managing PII(Personal Identifiable Informantion) data in all environement.
• Expert in troubleshooting production problems using DMV’s, SQL Server Native tools as well as Third Party tools like SQL Sentry Performance Advisor.
• Routinely check and applied Service Packs as well as developed Pre-Checklists for new servers to apply latest service packs.
• Worked with Microsoft support to resolve service pack and other issues in the cluster and non-clustered environment.
• 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.
• Install, configured and managed MDS(Master Data Services) and DQS(Data Quality Services)
• Experienced in deploying and managing SSIS packages using Catalog database and its security. .
• Performed Integration service package migration and reconfiguration, (SSRS) reporting service migration and configuration.
• Experienced in following streamline process of Confidential to handle Production Environment.
• Expert in creating, managing and updating documents and transferring knowledge between team members to support large environment.
• Provided rotational on-call support for the weekends and ongoing projects.

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 AlwaysOn 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 and 2008 versions and applied SQL service packs and patches.
• Monitored Windows and SQL Server logs to proactively resolve issues.
• Set up traces and Profiler to fix performance issues.
• Analyzed deadlocks & blocking on the server.
• Fixed problems related to memory, CPU, I/O, Disk, etc.
• Enforced company’s security policies by creating logins and assigning them proper roles and privileges.
• Generated DDLs in ERWIN to create objects in non-prod databases as per project need.
• Coordinated change controls for production rollouts.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Migration of data through DATA PUMP Export- Import from 10 g to 11g R2 RAC database.
• Troubleshooting and performance tuning skills for Oracle RAC, ASM and Stand-alone databases.
• Properly configured and distributed User DBs and Tempdb files to escalate performance.
• Participated in yearly BCE (Business Continuity Exercises) to validate DR strategy.
• Provided 24X7 on-call support throughout the project.

Environment: SQL Server 2008 R2/2008/2005(Enterprise), 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

Confidential, Purchase, 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 AlwaysOn 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 and 2008 versions and applied SQL service packs and patches.
• Monitored Windows and SQL Server logs to proactively resolve issues.
• Set up traces and Profiler to fix performance issues.
• Analyzed deadlocks & blocking on the server.
• Fixed problems related to memory, CPU, I/O, Disk, etc.
• Provided 24X7 on-call support throughout the project.

Environment: SQL Server 2008 R2/2008/2005(Enterprise), Active/Active, Active/Passive Clustering, Mirroring, Log Shipping, Replication, Physical, Virtual, SSIS, SSAS, Diagnostic Manager, Double Take, Tidal, VISIO, Windows Server 2008 R2, SAN, VMWare, T-SQL

Confidential, Tallahassee, FL

MS SQL Server DBA

Roles and Responsibilities:

• Working as a Production and Development DBA responsible for SQL Server Database servers in production, development, UAT and QA Environment.
• Implemented Always on Availability Groups using SQL Server 2012 to support reporting and high availability requirement.
• Created three node active/active/passive clusters with 2008 R2 WSFA for Guidewire Application in Load Test and Production environment to support Policy, Billing, and Claim Center.
• Extensively worked on migration project to move all production stand-alone and clustered servers to a new Data Center facility.
• Implemented and maintaining Mirroring and log shipping solution on SQL Server 2008 R2 for DR/HA.
• Configured, tested, implemented and maintained Transaction replication in development, test and production environment to support Business reporting requirements.
• Involved in DR exercise for Virtual servers using EMC’s SRDF (Symmetrix Remote Data Facility) and Physical Clusters using replicated drive system.
• Implemented Merge and Snapshot replication solutions based on Business Requirements.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
• Worked on Upgrade project to upgrade SQL 2005/2008 servers to SQL 2012 using in place and side by side for the same server. Backup/restore and EMC replication to upgrade on a different server.
• Created the standard documents for Disaster recovery testing and implemented them.
• Writing Windows PowerShell scripts to provide faster and better automated solutions.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003. Linux, Oracle 11g R2, 11g R1, 10g R2

Confidential, New York, NY

MS SQL Server DBA

Roles and Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Interacted with Developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC (Testing) machines.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
• Involved in troubleshooting all the performance issues for different database applications.
• Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Documented all the steps and procedures for future references.
• Interacted with concern application team in fixing the problems when ever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries
• Provided 24 x 7 Production support for the database and application issues.

Environment: MS SQL Server 2008 R 2/2008/2005/2000 (Enterprise), SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003.

Confidential, BASKING RIDGE, NJ

MS SQL Server DBA

Roles and Responsibilities:

• Upgraded most of SQL Server 2005 to SQL Server 2008 R2
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project.
• Involved in Monitoring Performance of different production servers.
• Implemented Database mirroring for disaster recovery.
• Maintained various databases for Production and Testing using SQL Server 2005.
• Planning the location of data, index, and Transaction log files on the disk.
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler.
• Created the backup and restore strategy for production and development environment.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Experience in creating and executing SQL Server Integration Services (SSIS) packages.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
• Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Used BCP and Bulk Insert utilities.
• Worked with SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2005/2008 R2, SSIS, SSRS, SSAS, Windows Server 2008 R2/2003