SUMMARY:

• Around 23 years of Technical & Management experience as a Sr. SQL Server DBA, Architect, Team Lead, Database design, Production and development support DBA Operations.
• Extensive experience in creating and maintaining SQL AlwaysOn, MS SQL Clustering, Mirroring, replication and log shipping to provide High Availability and Disaster recovery solutions.
• Hands on experience in managing Production and Development support DBA, manage database team, team lead and Infrastructure operations management.
• Experienced in Performance tuning, Backup/recovery, Security and disaster recovery.
• Excellent experience in performance tuning, backup and query optimization.
• Excellent time and task management skills.
• Hired and lead the database administrators team here in US and offshore team in India.
• Experienced in Financial, Pharmaceutical, Technology and Communication Industries.
• Experience in creating technical documentation to create standards.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016, 2014, 2012 R2, 2008 R2, 2005, 2000, 7.0,SQL Server 2016 and 6.5, Oracle9i, 10g and 11g, Access and Dbase

Operating Systems: Windows 2012 R2, 2012, 2008, 2008 R2, 2003,2000 Windows workstation, NT 4.0 servers, Windows 95/98/XP, Windows 3.11, Millennium, 2000/XP/95/98, MS DOS, Novell Netware, Linux and UNIX

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

HA & DR: SQL Always - on, Fail over Cluster, Database Mirroring and Replication

Cloud Strategy: AWS & Microsoft Azure

Big Data Hadoop Eco System, HDFS: Map Reduce and MongoDB

Tools: Cluster administrator, Always ON Availability Groups, Erwin, Mirroring, Windows Azure SQL Database, Big Data, In-Memory optimized tables, Cloud, Windows Azure Blob Storage, Temporal table, Stretch Database, Polybase, Columnstore Index, Buffer Pool extensions, SQL AlwaysOn Round Robin load balancing, NetIQ, Performance Monitor, Dataware house, STAR and Snow Flag Schema, Profiler, SQL Query Analyzer and TSQL, SSIS, SSRS, SSAS, Delphix, Vertica, ScaleArc, Oracle Exadata, RAC, In-Memory OLTP, and Columnstore Index

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. SQL Server DBA, Architect & Team Lead

Responsibilities:

• As a Sr. SQL Server DBA/Architect/Team lead provided production support for 220 Servers out of which 121 servers are production servers and remaining development and test servers.
• Architect and implemented the SQL Always-On architecture in SQL Server 2014 to provide High Availability and Load balancing solution to the production servers.
• Experienced in installing and configuring SQL Server 2016 and had experience in new features like Query store, Always Encrypted, Row level security, Stretch database, Temporal table, SQL Always On with Round Robin load balancing and Enhanced In-Memory OLTP.
• Experience in upgrading from SQL Server 2014 to SQL Server 2016 and tested the application after successful upgrade.
• Experienced in installing and configuring SQL Server 2014, SQL Sever 2012, SQL Server 2008 R2 servers on Windows 2012 and 2008 servers, applied service packs and security fix.
• Worked on architecting SQL DBaas (Database as a Service) environment and Install and configure the environment for multiple groups.
• Architect the Cloud strategy to move Lower Environments, evaluated the Amazon AWS & Microsoft Azure and moved the lower environments to Cloud.
• Configured and maintained transaction and snapshot replication between the production servers for two different environments.
• Involved in upgrading from SQL Server 2008 R2 servers to SQL Server 2014 version. Tested the application and completed mission critical production servers successfully.
• Installed, configured and maintained SQL Server Fail over cluster instances for 2 production environments.
• Experienced in Architecting and working with application team to implement multiple products across multiple agencies.
• Installed, Configured and maintained the log shipping architecture to provide backup server for production environment.
• Created the strategy and lead the Database team to maintain database environment for different agencies.
• Configured the SQL AlwaysOn in Amazon AWS and Microsoft Azure environment.
• Experienced with creating 2014 and 2016 new features of In-Memory optimized tables, Columnstore indexes and Buffer Pool extensions.
• Experienced in setting up Database Mirroring for Production databases.
• Experience with SQL Server disaster recovery procedures and created the guidelines for them.
• Experience in setting up the security for Production and development environments.
• Experience in maintaining critical production SQL servers and troubleshoot database Problems.
• Experienced in working very highly secure environments which related to US economy policies for multiple agencies.
• 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.
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Created Work instructions document for SQL Server 2016, 2014 and 2012 and 2008 R2 installations, upgrades and 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. SQL Server DBA, Architect & Team Lead

Responsibilities:

• As a Sr. SQL Server DBA/Architect/Team lead provided production support for 200 Servers out of which 85 servers are production servers and remaining development and test servers.
• Architect and implemented the SQL Always-On architecture in SQL Server 2014 to provide High Availability and Load balancing solution to the 64 TB SQL Server which supporting the CapitalIQ.Com website
• Experienced in installing and configuring SQL Server 2014, SQL Sever 2012, SQL Server 2008 R2 servers on Windows 2012 and 2008 servers, applied service packs and security fix.
• Installed SQL Server 2016 Community review 3.1 version to test SQL Server 2016.
• Involved in upgrading from SQL Server 2008 R2 servers to SQL Server 2014 version. Tested the application and completed mission critical production servers successfully.
• Installed, configured and maintained SQL Server Fail over cluster instances for 2 production environments.
• Architect the Cloud strategy to move Lower Environments, evaluated the Amazon AWS & Microsoft Azure and moved the lower environments to Cloud.
• Configured the SQL AlwaysOn in Amazon AWS and Microsoft Azure environment.
• Configured and maintained transaction and snapshot replication between the production servers for two different environments.
• Experienced with creating 2014 new features of In-Memory optimized tables, Columnstore indexes and Buffer Pool extensions.
• Experienced in setting up Database Mirroring for Production databases.
• Installed, Configured and maintained the log shipping architecture to provide backup server for production environment.
• Experience in setting up the security for Production and development environments.
• Experience in maintaining critical production SQL servers and troubleshoot database Problems.
• 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.
• 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.
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Created Work instructions document for SQL Server 2014 and 2012 and 2008 R2 installations, upgrades and patches.
• Experienced in database sizing and capacity planning for new and existing projects.
• Initiated the Implemented the Information Architecture to capture Enterprise Database Environments.
• Created the strategy and lead the team to integrate the Confidential & Confidential and newly acquired SNL Financials database operations.
• Excellent team lead and player and worked on call rotation.

Confidential, NJ

Sr. Lead SQL Server DBA/Team Lead

Responsibilities:

• Act as Lead SQL Server DBA and Team lead, provided production support for 210 Servers out of which 125 servers are production servers. These servers are located all around the globe.
• Managed the Database Operations team to provide production and development support for application team located in United States of America and around the globe 125 IT Staff members.
• Experienced in installing and configuring SQL Sever 2012, SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 servers on Windows 2008 servers, applied service packs and security fix.
• Involved in upgrading SQL Server 2008 to SQL Server 2012. Tested the application after the successful upgrade.
• 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.
• Configured and maintained transaction and snapshot replication between the production servers for two different environments.
• Experienced with creating 2014 new features of In-Memory optimized tables, Columnstore indexes and Buffer Pool extensions.
• Experience in setting up the security for Production and development environments.
• 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.
• Experienced with improving SQL Server performance using performance monitor, index tuning wizards, profiler and execution plans.
• 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.
• 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 Validating FDA regulated systems
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Created Work instructions document for SQL Server 2012,2008R2 server installation, upgrade and apply 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

Lead MS SQL DBA (Production and Development Support), Team Lead

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 and SQL Server 2000 servers and applied service packs.
• Involved in upgrading from SQL Server 2000 to SQL Servers 2005 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, assigns 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.
• Excellent team player and worked on call rotation.

Confidential, CO

Sr. SQL Server DBA /Team Lead

Responsibilities:

• Worked as a Production and Development support DBA provided 24*7 Production Support for 123 servers out of which 87 servers are production servers.
• Confidential call centers Sales and Calls handled reports are generated by the System Called DV2 (DELTA Version 2), IIS and CGI Servers are running in the top of SQL Server, the ONLINE Report Is Accessing From all the Call Centers.
• For production servers, there is no downtime for these servers. 20 Mission critical applications are running on these servers.
• Involved to setup Fail over Clustering Architecture for SQL Server databases for mission critical applications. Created Logical data modeling for production database and data ware housing Projects using Erwin Tool. Created the Physical Database design for production database.
• Involved in replication setup, configuration and maintenance in all types of replication like snapshot, transactional and Merge replication.
• Worked on new features of SQL 2000 user defined functions, multiple instance of SQL server, fail over clustering enhancements, log shipping, new backup and restore procedures, Internet Integration and OLAP enhancement.
• Created the Production database backup and restore strategy and implemented the procedures. Involved in Database recovery procedures.
• Involved in tuning the database and server performance. Worked with Profiler to trace and tune the database.
• Upgraded experience from SQL 6.5 to 7.0 and From SQL 7.0 to 2000. Installed and Configured SQL 2000 on WINDOWS 2000 system.
• Configured and maintain a Microsoft SQL server2000 fail over cluster. Worked on Log shipping, Data Transformation services (DTS).
• Experienced with Data ware Housing concepts, Designed Dimensional models schemas like STAR and Snowflake schemas.
• Monitored the database from the corporate office. Used to get alerts from NetIQ application.
• Experienced with configuring log shipping environments to provide backup server strategy.
• Experience with SQL Server disaster recovery procedures and created the guidelines for them.
• Installed and configured Analysis services for Data ware housing project.
• Built and process the cubes. Configured the security roles to the OLAP environment.
• Created and used the Data mining models. Optimized the data ware housing environment.
• Installed and configured SQL Server CE version in PDA.
• As a lead DBA, lead the Database Administration team to install configures and maintains the Production environments for mission critical applications. Involved in Strategic planning to initiate new projects.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• 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.
• Experienced in SQL Server tuning techniques to optimize the SQL queries and stored procedures.
• 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 2000 servers.
• Experienced in database sizing and capacity planning for new and existing projects.
• Excellent team player and worked on call rotation.

Confidential, CO

Sr. SQL Server DBA

Responsibilities:

• Worked as a Production and Development support DBA, provided 24*7 Production Support for 112 servers out of which 79 servers are production servers located all around USA, supported from Corporate DBA team.
• Responsible for production support and migration.
• Involved in upgrading from SQL 6.5 to 7.0 and From SQL 7.0 to 2000. Installed and Configured SQL 2000 on WINDOWS 2000 system.
• Experience in Log shipping and Data Transformation services (DTS).
• Experienced with Data ware Housing concepts, Designed Dimensional models schemas like STAR and Snowflake schemas.
• Installed, configured and used Data Protection for Microsoft SQL Server which complements TSM (Tivoli Storage Manager) for database backup and restore operation.
• Configured and maintained replication methods like snapshot, transactional and merge replication.
• Worked on new features of SQL 2000 user defined functions, multiple instances of SQL server, log shipping and IIS.
• Installed, configured and maintained SQL Fail over clustering for 2 production environments.
• Experience with SQL Server disaster recovery procedures and created the guidelines for them.
• Installed, Configured and maintained three different replication environments, like Transactional, snapshot and merge replication in production environments.
• Experienced with configuring log shipping environments to provide backup server strategy.
• Experienced in SQL Server tuning techniques to optimize the SQL queries and stored procedures.
• Experience in maintaining critical production SQL servers and troubleshoot database problems.
• Experience in improving server performance using performance monitor tool.
• Involved in scripting, security, space management, jobs scheduling and maintenance, etc.
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Experienced in database sizing and capacity planning for new and existing projects.
• Excellent team player and worked on call rotation schedule.

Confidential, CA

SQL Server DBA

Responsibilities:

• Worked as a Production and Development support DBA, provided Production Support for 22 servers out of which 14 servers are production servers.
• Installed and configured MS SQL Server 6.5 on Windows NT 4.0 Server.
• Involved in size manipulation of Devices, Databases, and Transaction logs, experienced with managing user accounts and security involved in scheduling tasks and setting alerts.
• Involved in creating backup strategy for production and development servers.
• Involved in designing the database for data mart in data warehouse project.
• The database designed in Star schema design. The fact table and dimension tables are created for effective Data mart Design.
• The mainframe text files and paradox database files are converted into SQL server to SQL Server using data junction converting tool
• Multi location servers are administered from a single location.
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers.
• Involved in managing task scheduling, Setting up a SQL mail, managing alerts, monitoring and tuning SQL server, SQL Performance monitoring and troubleshooting.
• Experienced with Fail over clustering and maintain them for production environments.
• Experience in configuring and maintaining transactional and merge replication for production servers.
• Created the backup and restore strategy to production, development and test environments.
• Experience in creating tables, stored procedures, views, functions, and triggers.
• Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk and memory devices.
• Created DTS packages for data manipulations and application related jobs.
• Experienced in SQL Server tuning techniques to optimize the SQL queries and stored procedures.
• Experience in maintaining critical production SQL servers and troubleshoot database problems.
• Involved in data refresh between different environments.
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers.
• Experience with change management procedures used remedy software.
• Excellent team player and worked on call rotation.

Confidential

Sr. Systems Analyst

Responsibilities:

• Installed MS SQL Server 6.5 on Window NT 4.0.
• Involved in upgrading from MS SQL Server 6.0 and involved in size manipulation of Devices, Databases, Transaction logs, Creation of triggers, views and using System Stored Procedures.
• Experienced with managing user accounts and security in Standard, Integrated and Mixed Security. Assigned user permissions SA, DBO, DBOO AND Ownership Chains.
• Involved in Backed up and restored user and System Databases.
• Imported and exported data between MS SQL servers and Non Microsoft SQL servers using SQL Transfer manager and bulk copy program.
• Involved in scheduling tasks and Setting Alerts, Managing Task Scheduling, setting up a SQL mail, managing alerts, monitoring and tuning SQL Server, SQL Performance monitoring, monitoring and tuning memory, SQL server memory allocation, Tempdb in RAM and monitoring locks.
• Involved in set up and configuring replication, SQL server 6.0 replication.
• Experienced with different types of replications and different replication scenarios like Central Publisher, Central Publisher using remote distributor, Central Subscriber and replication topology.