SUMMARY

• Over 12 years of experience in Administration, Upgradation & Performance Tuning, Data analysis for very large and complex enterprise databases in MSSQL Server 2012, 2008R2, 2005 and 2000. Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience in configuring and maintenance of SQL Server Clustering.
• Assisted application development teams on infrastructure capacity planning and system design.
• Experience in Configuring Always - On, Log shipping, Mirroring, and Replication.
• Implemented proactive monitoring using native T-SQL scripts for production databases.
• Experience in Database Backup, Restore and recovery using native SQL Backups and 3rd party tools such as Litespeed.
• Experience in Database upgrade from SQL 2000/2005/2008 R2 to SQL 2012.
• Experience in Managing SSRS Reports by providing necessary permissions, creating new data-driven subscriptions, and scheduling automated report generation.
• Identify and resolve locks / long running queries and performance related issues using SQL DMVs.
• Comprehensive knowledge on SQL Server running on VMWare and Confidential Hypervisor.
• Comprehensive knowledge on working with PowerShell scripts to replace some of the manual DBA tasks.
• Experience in developing stored procedures, functions, triggers using T-SQL.
• Worked on 24x7 database maintenance projects and provided end to end application DB support.
• Comprehensive knowledge on SQL Server instances hosted in Confidential Azure platform.

TECHNICAL SKILLS

Operating System: Windows 2012, 2008, 2003 & 2000, Windows NT 4.0, Windows 95, UNIX

Web Technologies: HTML, ASP, ASP.net, FRONT PAGE

Relational Database: MS-SQL 2012, 2008R2, 2005, and 2000, SQL Azure, Sybase 10, MS-Access, Visual Interdev&ETL Tools Crystal Report

Web Servers: IIS 8.0

Others Software: Azure AppInsight, KustoExplorer, Azure Storage Explorer, Visual Source Safe, VisioSQL Lite speed, Citrix Client, PowerShell, Unix Shell Scripting, Arc-Server, Veritas backup software, PC-Anywhere

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

System Analyst - Database Administrator

Responsibilities:

• Managing SQL 2012 Servers and IIS Servers in production and pre-production environment.
• Database Administration on production servers with server configuration, performance tuning and maintenance.
• Administering SQL Server High Availability (Failover Clustering, Availability Group, replication & Log Shipping).
• Administrating SQL Server instances hosted on Confidential Azure.
• Identify performance bottlenecks, propose & execute changes for improvement.
• Provide technical recommendations on current and future SQL server requirements, impact analysis for inter-related applications environment.
• Performing Planned/Unplanned failover to DR site.
• Performing IIS troubleshooting/administration in case of production web site issues.
• Administering applications on Windows Azure and App Insight monitoring.
• Taking appropriate actions per the received alert from monitoring system against application SQL servers and web servers.
• Monitoring and setup log shipping and replication.
• Generating reports as per client/business request by writing T-SQL queries.
• Managing service accounts and taking care of password reset/update activities.
• Monitoring and administration of user access to applications.
• Participating in triage meetings with Business and Engineering to discuss on existing production bugs, requirements, and enhancements.
• Assist development teams with production migration and continuing support of all SQL platforms.
• Document database related architecture, best practices, and standards of development.
• Follow SOX guidelines during project execution.
• Proficiency in Service Management Framework - Incident, Change, Release, Problem managements.

Environment: MS SQL Server 2012 and 2016, SQL Azure, ASP.Net, VB.Net, C#, PowerShell, Windows Server, IIS

Confidential

Service Manager & Production DBA

Responsibilities:

• ManageMS SQL 2005 and 2008servers, IIS web servers of critical internal and client facing worldwide applications of Confidential .
• Debugging and fixing the problems raised in Production Environment.
• Understanding thoroughly the design and functioning of the applications.
• Involved in Performance tuning, T-SQL scripts which takes longer execution time using DMV’s.
• Manage and present weekly / monthly project reports.
• Code level Trouble Shooting and handling performance issues.
• Analyze the issues raised by users, assigning appropriate priorities, and providing solutions to users
• Building and maintaining UAT and Production and configuring applications on app servers.
• Installation of Builds & Patch releases for all apps in UAT and Production and Windows Administration of the app servers.
• Monitoring and SQL Jobs and troubleshooting and fixing the SQL Jobs in case of failure.
• Handling Planned/Unplanned downtime incidents in production environment.
• Build and configure UAT environment for application testing team.
• Troubleshooting issues related to applications in UAT and Production.
• Worked on migrating the SSIS packages from lower environment to UAT & Production as per application team request.
• Documentation of issues and providing training of new team members.

Environment: ASP.Net, VB.Net, C#, ASP, MS SQL Server 2005, 2008R2, Windows 2008 R2, IIS

Confidential

Database Administrator

Responsibilities:

• Manage standalone and VM MS SQL Server 2000 and 2005 version.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Scripted all the SQL Agent jobs and deployed the same in the upgrade SQL instance.
• Transaction replication setup and troubleshooting.
• Performing database backup and restore in Production, Development, and Test environment.
• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.
• Setup, monitor and troubleshoot transaction replication.
• Setup, monitor and troubleshoot log shipping in UAT and Production.
• Monitoring database and log storage threshold.
• Created script for SQL Servers disk capacity planning.
• Monitoring SQL jobs, database maintenance plan.
• Creation of Users, Roles and managing Security, implement effective database security practices and procedures
• Manage and provide application access to users via Citrix.
• Create and re-evaluate Indexes and made needed modifications for better performance.
• Worked closely with the application team in identifying the issues connecting to the new destination instances hosted in VM.
• Follow Amex Process Standards as per IMR and CMR guidelines.

Environment: Windows Server 2000, SQL Server 2000, 2005, Citrix Client, Visio, MS Access

Confidential

Production Support DBA

Responsibilities:

• Setup, monitor and troubleshot SQL Server log shipping in production.
• Setup, monitor and troubleshot SQL Servertransaction replication.
• Apply IPAKs, security patches and hot fixes based on all production servers.
• Monitor and troubleshooting SQL Cluster related issues.
• Performing database backup using SQL Lite and restore databases as per user’s requests.
• Monitoring database and log storage and disk storage threshold.
• Monitoring SQL jobs, create database maintenance plan as per define guidelines.
• Once the application checkout is completed, we implemented the DBA Maintenance jobs such as Database Consistency check, Index defragmentation using SQL Agent.
• During the time of application maintenance window, we stopped the log shipping and applied the tail log backup from source to destination and made the secondary as primary.

Environment: Windows Server, SQL Server 2000 & 2005, IIS 5.0