SUMMARY

• Over 10+ yrs Experience in IT and as SQL Server DBA (2016, 2014, 2012, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) with Healthcare, Insurance and Retail Management Domains.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2016,2014, 2012, 2008R2, 2005, 2000
• Experience in Installation, Configuration, Maintenance and Administration of Servers
• Good experience inDatabase design & architecture
• Good Experience inBackup & Recoveryscenarios
• Good experience in implementing High Availability & Disaster Recovery solutions usingAlways ON, Clustering, Replication, Mirroring and Log Shipping
• In - depth knowledge onDatabase Internals
• Good knowledge & experience on Cloud Computing like Azure/AWS
• Experience working as aDEVOPSAutomation Engineer for database deployment
• Experience in designingETLfor data movement between excel, flat file, RDBMS
• Expert in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex., Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
• Handlinglocking,Blocking&DeadlockScenarios
• Expertise inIndex tuning, rebuild, reorgstrategies
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) with different methodologies likeAgile, Scrum & Waterfalletc. and capable of handling responsibilities independently as well as a proactive team member

TECHNICAL SKILLS

Database Version: SQL Server 2000,2005,2008R2,2012,2014,2016

Platform: Windows 2012,2008 R2, Windows 2003, Windows 2000 Advanced Server

Tools: Used: SQL Lite, Spotlight, Red gate SQL Compare, Ignite8, Solar Winds Performance Analyzer, Power shell, SQL Sentry Plan Explorer, Dynatrace, DMVs, DBCC Commands

Development Tools: SSMS, Visual Studio 2010,2012,2013,2015, BIDS 2005,2008,2012

ETL Tools: SSIS, DTS, SSAS, SSRS, Crystal Reports, Excel

Version Control: TFS 2015,2012,2010

Modeling Tools: Erwin, MS Visio

Operating system: Windows 2012/2008/2003/2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Software Packages: MS Office 97/2000/XP, 2003, 2007, 2013, Office 365

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Spotlight,Foglight, Redgate.

PROFESSIONAL EXPERIENCE

Confidential, Springfield, IL

Responsibilities:

• Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse
• Create and support the ETL to facilitate bringing data into the data warehouse using SSIS or other technologies
• Create and support the Analysis Services 2008/2012 cubes to help with query performance
• Monitor and troubleshoot performance issues on the data warehouse servers
• Define and promote the team’s design principles and best practices for data warehousing architecture and techniques
• Research and promote new tools and techniques to shape the future of the data warehouse environment
• Work with business teams to be able to define requirements for real time reporting
• Perform migrations from SQL server 2008 to newer version
• Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse
• Create and support the ETL to facilitate bringing data into the data warehouse using SSIS or other technologies
• Create and support the Analysis Microsoft SQL Services 2008/2012 cubes to help with query performance
• Experienced with deployments, Maintenance and troubleshooting applications on Microsoft Cloud infrastructure AWS
• Monitor and troubleshooted performance issues on the data warehouse servers
• Define and promote the team’s design principles and best practices for data warehousing architecture and techniques
• Research and promote new tools and techniques to shape the future of the data warehouse environment
• Work with business teams to be able to define requirements for real time reporting
• Create and maintain reports using SSRS
• Perform migrations from SQL server 2003 to newer version.
• Recently completed Deployment was involved from starting to ending.
• Worked on Backups and restores.
• Data Obfuscation, data scrubbing.
• Involved in moving data to AWS server.

Confidential, Pittsburgh, PA

SQL Server DBA

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R 2/ 2012/2014/2016 in Production, QA, Test and RND Environments.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the and converting them into technical specifications.
• Implemented High Availability in SQL 2012/2014/2016 by configuring Always On Availability groups across Windows Server FailoverClustering using Failover Clustering Instances
• Creating databases and logins and users with permissions in Microsoft SQL SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Worked on high availability SQL Server solutions, including Mirroring, SQL Server clustering and Always on
• Created Linked servers accordingly in between the different servers based on the requirement.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked on Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.
• Implementation of Backup, Re-index, DB Shrink,and other database maintenance jobs through Stored Procedures and Implemented Pager options to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Define db scripts versioning system to keep track of database versions for all environments.
• Administer, maintain, develops and recommends policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery &Automation of Backups using maintenance plans.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.
• 24/7 on Call Support for Production Databases.
• Experience in scheduling Backups and Restore and Maintenance plans using Native & Third-party tools (Avamar SQL Backup).

Environment: MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005, T-SQL, MS SQL ServerIntegrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, .Net Framework

Confidential, Lake Forest, IL

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005/2008R2/2012 and administered nearly 50+ servers ensuring zero downtime.
• Installed and Configured SQL Server 2005 and SQL server 2008 enterprise editions and Upgraded the existing databases to SQL Server 2008.
• Worked as Application Primary DBA for the projects assigned.
• Collaborate with the SAP Project Management, Business and Systems Analysts and user departments to develop specifications for system enhancements for continuous functional improvement.
• Good Knowledge in Active/Passive and Active/Active Clustering and implemented RAID technology on windows 2003 servers.
• Installed, configured and maintained SQL Server Failover clustering (Active/Passive) for 15 production environments and for many mission critical applications.
• Addressed the Replication Issues. Created new replications, implemented Mirroring to maintain high availability of the data between the servers.
• Involved in implementation of Replications like Snapshot and Transactional in OLTP environments.
• Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors)
• Experience in creating complex SSIS packages using proper control and data flow elements and deployed the packages and scheduled them.
• Extensive experience with SSIS packages in creating ad hoc reports using EXCEL and XML files, used as a ETL tool to pull data from SQL server(OLTP) to Teradata(data warehouse), maintenance tasks, providing alerts through email, Scheduling tasks and to generate scripts during migration and upgradation.
• Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks, managing triggers.
• Effectively using DBCC commands, Dynamic Management Views (DMV), SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Involved in Partitioning Databases and Tables for better Performance.
• Experience in taking Backups and restoring using various 3rd party tools like Lite-speed, VERITAS and created Disaster recovery strategy and automated the tools to perform scheduled backups.
• Experienced with Managing user accounts and security in Standard, Integrated and Mixed Security. Assigned user permissions SA, DBO AND Ownership Chains
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Configured and maintained SSRS for local area reporting and have good knowledge in SSAS
• Assisted project activities as per PMI Project Lifecycle methodology.
• Managing and Coordinating with the offshore team on daily Database maintenance activities
• Worked as a team member for 24X7 on call production support.

Environment: SQL Server 2012/2008R2/2005, Windows 2003/2008, Lite-speed, VERITAS, ETL, SSIS, SSRS, .ASP, VB scripting, MS Excel and MS Access, Oracle, Teradata, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential, Lake Forest, IL

SR. SQL SERVER DBA

Responsibilities:

• Install, Configured SQL Server 2014, 2012, 2008, 2008R2, Enterprise & Standard editions on 64-bit systems.
• Involved in Planning for Upgrades and Migration of major systems from SQL Server 2005 to SQL Server 2012 and from Microsoft SQL SQL Server 2008 R2 to 2012/2014.
• Created the backup and restore strategy for production and development environment.
• Involved in Quality Test (QA) of Data for successful Migration.
• Created SSIS packages for various Data Source and Data Destination Mappings for transfer.
• Worked on setting up and managing Merge and Transactional Replication.
• Monitoring SQL Server Jobs and Troubleshooting on failure.
• Experience in Configuring and Maintaining Database Snapshots.
• Implemented Database mirroring and Log shipping for disaster recovery.
• Trouble shooting issues on Replication/Log Shipping/Back up & Recovery.
• Involved in migration of databases from SYBASE / ORACLE to SQL server 2012 using SSMA.
• Maintaining the servers - applying patches and service Packs.
• Involved in Performance Tuning on Production, QA and Staging servers of the current project
• Backup and Restoration of System and User databases.
• Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on Production server.
• Rebuilding the indexes at regular intervals for better performance.
• Created extensive reports using SSRS.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Used the Execution Plan to improve the optimization of the T-SQL code
• Maintained various databases for Production and Testing using SQL Server 2012/2008 R2.
• Planning the location of data, index and Transaction log files on the disk.
• 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 ETL application.

Environment: MS SQL Server 2014, SSIS, SSRS, SSMS, SSMA tool, BCP command, RED GATE, Replication, ALWAYSON, Logshipping and Clustering.

Confidential, IL

Database Administrator (SQL)

Responsibilities:

• Installed SQL Server 2008/2008R2/2012 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version 2005 to 2008 R2.
• Installed Microsoft Service Packs/Patches/Hot fixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
• Worked with Transparent Encryption (TDE), table compression, database compression and merge statements using SQL server 2012.
• Query Optimization and Performance tuning for optimization such as maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Provide 24X7 support for the Critical issues such as Server Failures and Database inconsistencies such as Database Log File full, Suspect, Offline, Missing log files etc.

Environment: SQL Server 2014/2012/2008 R2 /2008/2005 Microsoft SQL Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7).