SUMMARY:

• 16+years of experience in Database Administrationusing MS SQL Server 2000/2005/2008/2008 R2/2012, 2014, 2016.
• Having solid experience in installing SQL server Cluster 2005, 2008, 2012, 2014and 2016.
• Having solid experience in SQL Always on (HADR) in SQL 2012, SQL 2014 and SQL 2016.
• Experience in working with SSIS (ETL) in SQL2005,2008,2012,2014 and with SSRS2005,2008,2012,2014.
• Proficientin writing SQL queries, stored procedures, database triggers, exception handlers
• Expert in Migration from older version of SQL server to SQL Server 2012/2014/2016.
• Extensive knowledge in Tuning SQL queries, T/SQL queries & improving the performance of the Database.
• Excellent communication skills and experienced in client interaction while providing technical support and knowledge transfer.
• Excellent writing skills and the ability to conceptualize and effectively document.
• Self - motivated and goal-oriented with a professional attitude towards co-workers.

TECHNICAL SKILLS:

Database: MS SQL SERVER 2000/2005/2008/2012, 2014,2016, Oracle

CASE Tools: ETL, SSIS, SSRS, ERWIN, VISIO, Visual Studio

Languages: T-SQL, Powershell

Operating System: WINDOWS 2000/2003/2008/ NT/2012

Other Tools: Best Practices Analyzer(BPA),SystemCenter Operations Manager 2007 (SCOM), MOM,SQL Lite Speed, Octopus,Spot Lite, Performance Analysis, Foglight, Red Gate, Service Now, Power BI

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr.SQL Server DBA

Responsibilities:

• Installed SQL Server Cluster 2008/2012/2014/2016 (both 64 bits and 32 bits) on both Active-Passive and Active-Active-Passive nodes.
• Added Node to the existing SQL Server Cluster 2008/2012/2014/2016 on both Active-Passive and Active-Active-Passive nodes.
• Installed SQL SSAS, SSRS 2008/2012/2014 both 64 and 32 bits (both default and named instances).
• Installed and congifured SQL Always on in SQL 2012,SQL 2014 and SQL 2016.
• Migrated from SQL Server 2000/2005/2008/2012 to SQL Server 202/2014/2016.
• Coordinated with venders such as HP,Dell, Confidential etc
• Moved Database from on prem server to Cloud.
• Managed team in Offshore and coordinated with client team.
• Closely worked with Solution Architects and sales teams in developing proposals, plans, and communication
• Designed and implemented Server Hosting as per requirements in a cost effective manner.
• Conducted System Analysis, Design, Development and Implementation of various Applications and the subsequent transition to Enterprise resource planning (ERP) and Web Enabled Application.
• Experienced of Application Code Review.
• Participated in meetings impacting databases physical design.
• Designed High Avalibility (HA) and disaster recovery (DR) a by using Cluster/SQL Always ON/Mirroring.
• Verified scripts and fixed bugs in the T-SQL Code.
• Supported 24*7 production support and solved all kinds of critical problems.
• Monitored Database through Foglight /Red gate
• Wrote documentation for different issues such as deployment, patching security etc.
• Created and Maintained DB Key Performance Index (KPI) report using SSRS/Power BI.

Environment: T-SQL, SQLServer20 OLTP,TCP/IP,SAN,PCI information, TFS,Share point,Windows 2003, 2008, MS Office,IIS and, Power shell, Foglight

Confidential, Redmond, WA

Sr.SQL Server DBA

Responsibilities:

• Installed SQL Server Cluster 2008 on both Active-Passive and Active-Active-Passive nodes.
• Added Node to the existing SQL Server Cluster 2008 on both Active-Passive and Active-Active-Passive nodes.
• Maintained High Availability such as Replication (Web store Transactional replication) as far database disaster technique.
• Maintained High Availability such as Log Shipping and Mirroring as a database disaster technique.
• Made database back up using SQL Litespeed (Full, Differential, Log and File group back up) and restore it.
• Supported 24*7 production support and solved all kinds of critical problems.
• Used profiler and performance tuning to get better performance.
• Monitored daily activities and DB health status using System Center Operations Manager 2007 (SCOM) and DB Mail.
• Created and Maintained DB Key Performance Index (KPI) report using SSRS 2008.
• Synchronized different environments such as Developer, testing, Pre-production and production.
• Installed different security patches, cumulative updates,service packs and hot fixes in both pre production environment (PPE) and production environment.
• Deployed different packages in different environments such as per production, production data bases through Octopus.
• Migrated Data bases from SQL server 2005 to SQL Server 2008 in production environment.
• Detemine the problems such as dead lock, blocking and fix the problem.
• Monitored Disk IO, SAN space, CPU utilization, Log space etc.
• Maintained Database integrity, scan density of index and defrag index and re-build new index for better performance of the servers.
• Used DBCC utilities to fix data corruption in application databases.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment: T-SQL, SQLServer2008OLTP,TCP/IP,SAN,System Center Operations Manager 2007 (SCOM), Windows 2008, EMC SAN, PCI information, MS Office,IIS,Octopus, product studio, Web Store, power shell.

Confidential, Omaha, NE

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 both 64 bits and 32 bits (multiple instances).
• Created SQL Server Clustering on multiple nodes.
• Maintained High Availability such as Mirroring.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Used Replication (both Transactional and Merge replication) to move databases from SQL server 2000 to SQL server 2005.
• Made database back up (Full, Differential, Log and File group back up) and restore it.
• Perrticipated in SDLC methodologies such as planning, analysis, design and implementation.
• Installed different security patches, cumulative updates,service packs and hot fixes in both pre production environment (PPE) and production environment.
• Wrote documentation for all the Database maintenance related issues.
• Imported and Exported (Migrated) data (ETL) from different sources other than SQL server (such as Oracle, DB2, Access, Flat files) using Import/Export wizard.
• Migrated old dts packages from SQL server 2000 and converted into SSIS packagesinto SQL server 2005.
• Interpreted product source code to resolve customer issues and debugging bugs.
• Created both Tabular, Matrix, drill down reports using SSRS 2005.
• Created reports by using bar chart, pie chart to analyze critical data in SSRS 2005.
• Synchronized different environments such as Developer, testing, Pre-production and production.
• Created and Maintained DB Key Performance Index (KPI) report using SSRS 2005.
• Used different DMV commands to determine the problems.
• Supported 24*7 production support and solved all kinds of critical problems.
• Created stored procedures for the business logic using T-SQL.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Wrote documentation for different issues such as deployment, patching security etc.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Designed Database modeling using MS Visio (VSS).
• Created both physical and logical database design.
• Performed Database Normalization (3NF).

Environment: T-SQL, SQLServer2000, 2005 OLTP, Foglight, SAN,.NET,TCP/IP,Visual Basic, Oracle,DB2DTS, SSIS, ETL,Performance Point,ProClarity,Share point,DDL, DML, OSSQL,TFS, HP Polyserve, MySQL Confidential report analyzer,EDW,Unix,Windows 2003,CRM,SSAS,MS Office,IIS

Confidential, NM

SQL Server Developer /Architect

Responsibilities:

• Technologies involved in this application include SQL Server 2000, 2005 Replication, Confidential Analysis Services and Confidential DTS (ETL).
• Created DTS packages for the data cleansing/transfer (ETL) and transformation.
• Designed Database Schema using third party tools like Erwin (ERStudio).
• Created stored procedures for the business logic using T-SQL.
• Coding of several database Triggers, Stored Procedures and maintaining Integrity Constraints.
• Migrated databases from SQL server 2000 to SQL server 2005.
• Migratedold dts packages into SSIS packages.
• Detemine the problems such as dead lock, blocking and fix the problem.
• Partitioned tables, Views to run query more faster.
• Supported 24*7 production support and solved all kinds of critical problems.
• Created both Tabular, Matrix, drill down reports using SSRS 2005.
• Created reports by using bar chart, pie chart to analyze critical data in SSRS 2005.
• Migrated date from MySQL to SQL Server 2005.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Synchronized different environments such as Developer, testing, Pre-production and production.
• Participated in design of LOGICAL and PHYSICAL databases and applied knowledge of database design standards.

Environment: T-SQL, SQLServer2000, 2005 OLAP, Performance Point,.NET,DB2,MS Office, DDL, DML, OSSQL, ETL, TCP/IP,SAN,DTS, SSIS, J2EE, VB script, ProClarity,Powershell,MySQL Confidential report analyzer,windows 2000, 2003, IIS,XML,DNS, Unix,ORM,ERStudio 7.x.

Confidential

SQL Server DBE

• Develop test and tune database code and information.
• Support product development and quality assurance teams.
• Design and maintain SQL scripts.
• Provide technical support and guidance to staff and clients.
• Generate reports and spreadsheets detailing database changes and performance

Environment: T-SQL, SQLServer2000,MS Office, DDL, DML, analyzer,windows 2000