SUMMARY

• Eight years of experience as a SQL Server DBA in IT, Banking, Technology provider firms.
• Experience in installation and configuration of MS SQL Server 2016, 2014, 2012, 2008 R2 instances in Production/QA/Development environments.
• Expertise in migration of SQL Server 2005 to SQL Server 2008 R2/2012, 2008 R2 to 2014.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2005/2008 R2 databases.
• Experience running a SQL Server environment in Amazon Web Services (AWS).
• Experience on migrating the physical servers to Azuredatabases.
• Experienced in implementing Replication Models such as Transactional and Snapshot in SQL Server 2005 and 2008 R2 in OLTP environments.
• Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
• Excellent skills in developing Backup & Recovery procedures and Database Security procedures to maintain Data Integrity.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Expertise in deployment and scheduling of SSIS packages.
• Experienced in SQL Server performance tuning, query optimization, Database Maintenance plans, Database Consistency Checks using DBCC and DMV’S.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Expertise in monitoring the production server with SQL Profiler, SiteScope Monitoring, Idera Diagnostic Tool, Solarwinds DPA.
• Expertise in identifying, troubleshooting issues and documenting root cause analysis.
• Experience working in 24X7-production support.
• Strong communication, presentation, documentation, analytical and problem solving skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2016, 2014, 2012, 2008 R2, 2005

SQL Server Tools: Management Studio, SQL Server Data Tools, Business Intelligence Development Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor, Availability Groups.

Cluster Solution: Microsoft Windows Cluster, AlwaysON availability groups

Languages: T-SQL, PowerShell, ASP.NET, C#, .NET Framework

Third Party Tools: Idera’s diagnostic manager, Red Gate SQL Compare/Data Compare/Source Control/SQL Monitor, Solarwinds Database Performance Analyzer.

PROFESSIONAL EXPERIENCE

Confidential, Newtown, PA

Database Administrator

Responsibilities:

• Installed and configured SQL Server 2014/2016 Enterprise edition for Production/UAT environments in AWS cloud environment. In addition, Migration of SQL Server databases from 2008 R2 to 2014/2016.
• Configured Availability Groups for production databases and added primary and secondary replicas.
• Configured and maintained transactional replication for one of the legacy database for reporting purposes.
• Responsible for SQL database administration, detect, and analyze SQL performance issues.
• Created Jobs for Regular Backups and Rebuilding of Indexes and Integrity Checks using Ola Hallengren’s scripts.
• Monitoring Production SQL Servers using Solarwinds DPA.
• Maintaining the database consistency with DBCC, DMV and DMF are at regular intervals.
• Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues and generated reports using PAL tool.
• Monitored and modified Performance using execution plans and Index tuning.
• Code review and deploy any and all SQL Server related items like SQL Scripts, RDL report files and SSIS ETL packages.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Experienced in writing complex TSQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Optimizing stored procedures and queries to generate SSRS reports, Power BI dashboards and Jasper server reports for data analysis.
• Solving Tickets on Daily Basis for Production Issues.
• Provided dedicated supports for SQL Server production server 24/7 shifts.

Environment: Windows server 2012R2, AWS, MS SQL Server 2014, SSIS, SSRS, Power BI, Jasper report server.

Confidential, Mason, OH

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 Enterprise edition in the Production/QA environment.
• Responsible for SQL database administration, detect, and analyze SQL performance issues.
• Responsible for SQL server upgrades and SQL server patch management.
• Created Jobs for Regular Backups and Rebuilding of Indexes and Integrity Checks using Ola Hallengren’s scripts.
• Experience working withAzure SQL Database Import and Export Service.
• Experience indeploying SQL Databases in Azure.
• Worked on Database refreshes from PROD to QA/Dev Environments.
• Monitored and modified Performance using execution plans and Index tuning.
• Code review and deploy any and all SQL Server related items like SQL Scripts, RDL report files and SSIS packages.
• Maintain and troubleshoot transactional and snapshot replication models.
• Writing queries to generate reports for data analysis using SQL Server Reporting Services (SSRS).
• Solving Tickets on Daily Basis for Production Issues.

Environment: Windows server 2012R2, MS SQL Server 2012, Red Gate SQL Monitor, SSIS, SSRS, Avamar Backup/Restore.

Confidential, Boulder, CO

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 Enterprise edition in the Production/QA environment.
• Responsible for SQL database administration, detect, and analyze SQL performance issues.
• Responsible for SQL server upgrades and SQL server patch management.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Scheduled jobs for backup, and created alerts for error reporting.
• Maintaining the database consistency with DBCC, DMV and DMF are at regular intervals.
• Implemented Database Mirroring for live production database to support production needs.
• Monitored and modified Performance using execution plans and Index tuning.
• Deploy any and all SQL Server related items like SQL Scripts, RDL report files and SSIS packages.
• Maintain and troubleshoot transactional and snapshot replication models.
• Writing queries to generate reports for data analysis using SQL Server Reporting Services (SSRS).
• Created application roles, assign required permissions to roles, assign to database users.
• Solving Tickets on Daily Basis for Production Issues.

Environment: Windows server 2003/2008/2008 R2, MS SQL Server 2012/2008R2/2008/2005

Confidential, Richfield, OH

SQL Database Administrator

Responsibilities:

• Installed and configured SQL Server 2012/2008R2 Enterprise/Standard edition in the Production/QA environment.
• Administered SQL Server Instances running on 2005/2008R2/2012 across DEV, QA and Production environments.
• Involved in the maintenance of high availability 5 - Node Active-Active Cluster Production environment.
• Worked on upgrading SQL server instances and applying service packs and hot fixes.
• Implement, maintain and troubleshoot high availability solutions such as Transactional and Snapshot Replication and Database Mirroring.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Ensured company best practices for any and all SQL Server related items.
• Use RedGate Toolbelt for Database backups, Schema compare and Data compare.
• Troubleshoot server and query performance, DMV’s, Execution plan analysis, Performance Dashboard.
• Implemented procedures to detect poor database performance, collecting required information and root cause analysis.
• Deploy any and all SQL Server related items like SQL Scripts, RDL report files and SSIS packages.
• Worked on automated solutions to manual deploy processes.

Environment: Windows server 2003/2008R2/2012R2, MS SQL Server 2012/2008R2/2005, TFS 2008/2013, RedGate Source Control, RedGate SQL Compare, TortoiseSVN.

Confidential, Madisonville, OH

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012/2008R2 Enterprise/Standard edition in the production/DR/Test/Dev environment.
• Monitored the Daily Full Back-up and Transactional log backup jobs.
• Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers
• Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring.
• Implemented and maintain database security (create and maintain users and roles, assign privileges).
• Written and executed complex T-SQL queries using SQL Server Management Studio for back-end data validation testing.
• Identified issues related to poor performance of complex SQL queries by analyzing missing indexes and unused indexes.
• Reduced the deadlocks by using the SQL Server Profiler and setting up Trace flags for every day monitoring.
• Troubleshoot and Resolved issued problems with the production server via the ticketing system BMC remedy.
• Created and Deployed RDL in SSRS server to maintain Disk space monitoring of all servers including Stage Environment.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.
• Monitoring the servers using Idera Diagnostic Manager.
• Provided dedicated supports for SQL Server production server 24/7 shifts.

Environment: Windows server 2003/2008/2008 R2, MS SQL Server 2012/2008R2/2008/2005, Idera Diagnostic Manager, BMC remedy.