SUMMARY

• Over 10+ years of experience as SQL Server DBA/Developer with SQL Server versions 2000/2005/2008/2012/2014 , also worked on Window Azure and Databases & MY SQL Databases.
• Excellent Experience in MS SQL Server installation and configuration, performance Tuning, Upgrades, Backup/Recovery and Managing Security. Excellent knowledge of Confidential Cluster, SQL Server Replication, Log Shipping, Mirroring (HADR) and SQL Server 2012/2014.
• Excellent Understanding of Performance Tuning of SQL Server and Windows Servers.
• Designed, maintained and documented highly transactional OLTP system scaling up to 10 million transactions.
• Writing Stored Procedure, Functions, Views, Triggers.
• Provided strategic partnership around the implementation of a new product from data and database perspective as well as generating ideas for optimization and enhancement of the existing platforms.
• Strong understanding of major components of SQL SERVER Architecture
• Defined and Administered Database Standards, Controls, Procedures and Documented the same and monitoring the development of SQL Server Automated
• Experienced in handling End to End Project Management Activities which include Planning, Design, Scope Management, Estimation, Resource Administration and completion of project within specified Timeframes and Parameters
• Providing technical support to Application Development Teams and Setting/Maintaining Standards
• Developed and implemented T - SQL coding standards according to best practices lead to 99.9999% uptime.
• Excellent skills in Leading & Managing Project Teams throughout the Project Lifecycle and providing them Support & Guidance on Technical and Project-Related Issues.
• Managed the Installation, Configuration and Up Gradation of Server Software

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008/2012/2014 , Windows Azure, MY SQL 5.6, Oracle 9iProgramming Languages: C, C++, VB 6.0, T-SQL, PL/SQL, VBScript, HTML, ASP.Net, Powershell

Tools & Utilities: SCOM, Spotlight, SiteScope, ILO, SQLLitespeed, ER Studio (ERWIN,), Visio

Operating Systems: Windows Server 2012, 2008 (R1, R2), 2003, Windows NT Server 4.0, UNIX, DOSOthers: MS SSIS, MS-Office

PROFESSIONAL EXPERIENCE

Confidential, WA

Sr. MSSQL Database Administrator

Responsibilities:

• Technical support services consisting of Tier 3 level System Administration across multiple areas of subject matter expertise for Confidential Corp.
• Managed 100+ Production/QA+Dev servers with multiple databases, with couples of them over 10-12 terabytes both in Cluster environment with Mirroring and Replication.
• Responsible for building new infrastructure for EOL and Migration database of 2008 to SQL 2012 & SQL 2014 Servers and Cloud databases (windows azure).
• Working knowledge of Azure VMs, Azure Virtual Network, Service Bus, Azure Storage, X.509 certificate in Confidential Azure.
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups. Experience working with LiteSpeed
• Developed several database structures, complex SQL queries, writing stored procedures, views, triggers and user-defined functions.
• Identifying Slow Running queries by profiler, T-SQL & analyze and optimized them.
• Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc.
• Performed Code Reviews and developed Coding Standards considering SQL Server Best practices
• Optimized T-SQL Queries for efficient retrieval of data by analyzing execution plan and optimizer cost. Re-designed indexes as required
• Analyzed and Tuned SQL Servers Performance using performance monitor and SQL Profiler
• Working closely with Engineering Team to understood there requirement and working closely with them for performance enhancement of databases
• Responsible for Deployments on Database Servers.
• Attend weekly production support status meetings with Clients and address the gaps, if any.
• Provided Production Support on a 24*7 basis.
• Recommendation/Configuring of availability strategies database mirroring, clustering and Setting up database for replication, log shipping and Database mirroring and monitoring the setup & Creating SSRS reports
• Implementing Service Pack upgrades on SQL Servers for QA/Dev and Production Database.
• Monitoring database growth activities & and take proactive steps to avoid Transaction Log & Space Issues
• Worked on incident management issues as per IMR/Tickets raised.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Responsible for code review prior to project implementation of databases objects like Views, Stored Procedure, Triggers etc. to provide structure to stored data and maintain database efficiently.
• Performing the root cause analysis of production issues.
• Ensuring automation of monitoring MS-SQL Server using PowerShell and T-SQL

Confidential

Sr. MSSQL Database Administrator

Responsibilities:

• Managed a geographically distributed Application Support Team providing services for Deployment, Incident and Infrastructure Mgt. for portfolio of Confidential business applications and services.
• Onsite-offshore coordination, designed processes for effective client communication with offshore teams.
• Responsible for handling Production environment of the client Confidential Corp having Databases in 8-10 TB’s.
• Migrated SQL Server 2008 Clusters to Always On Failover Cluster Instances in SQL Server 2012.
• Implemented and Maintained Disaster Recovery for Production Database Environment Recommendation/Configuring availability strategies Database Mirroring (Always on), Clustering and Setting Up database for Replication, Log Shipping and monitoring the setup.
• Responsible for query optimization using SQL tools such as SSMS, SQL Profiler and Index tuning wizard. Worked on incident management issues as per IMR/Tickets raised by UTS monitoring system
• Performance tuning of the database regions like T-SQL having high response time(s), monitor and resolved performance related factors of existing/new applications. Provided Production Support on a 24*7 basis.
• Working closely with various teams at client location to gather and understand the database requirement setting up of new MSSQL Server 2008 and 2012 databases in both development and production environments and coordinating with the clients for enhancements.
• Attend weekly production support status meetings with Clients and address the gaps, if any.
• Performed Service Pack updates and deployments on SQL DB Servers on test and production environments
• Integrated Database Maintenance jobs with SQL Lite speed to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Monitoring database growth activities & and take proactive steps to avoid Transaction Log & Space Issues
• Responsible for query optimization using SQL tools such as SSMS, SQL Profiler and Index tuning wizard. Worked on incident management issues as per IMR/Tickets raised by UTS monitoring system
• Performing the root cause analysis of production issues and ensuring monitoring automation of MS-SQL Server
• Documented all the processes involved in maintaining the database for future references, Involved in discussions with clients to adapt the new technologies like Partitioning, mount points, resource governor, email alerting for regular tasks and encryption was involved in building new Infrastructure for SQL Server 2012

Environment: MS SQL Server 2012, MS SQL Server 2008 (R1 & R2), SSRS, Windows Server 2008 R1, UTS

Confidential

Sr. MSSQL Database Administrator

Responsibilities:

• Responsible for handling Production environment of the client Confidential Corp having Databases in 8-10 TB’s.
• Configuring/Maintaining Clustering, replication, Log Shipping & Mirroring, Maintenance Plan
• Responsible for Migration SQL Server 2008 to SQL Server 2012.
• Working closely with various teams at client location to gather and understand the database requirement setting up of new MSSQL Server 2008 and 2012 databases in both development and production environments and coordinating with the clients for enhancements.
• Optimized T-SQL Queries for efficient retrieval of data by analyzing execution plan and optimizer cost. Re-designed indexes as required.
• Provided Production Support on a 24*7 basis.
• Recommendation/Configuring of availability strategies database mirroring, clustering and Setting up database for replication, log shipping and Database mirroring and monitoring the setup.
• Coordinating service pack updates on SQL DB Servers on test and production environments
• Involved in discussions with clients to adapt the new technologies like Partitioning, mount points, resource governor, email alerting for regular tasks and encryption
• Was involved in building new Infrastructure for SQL Server 2012
• Integrated Database Maintenance jobs with SQL Lite speed to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Monitoring database growth activities & and take proactive steps to avoid Transaction Log & Space Issues
• Responsible for query optimization using SQL tools such as SSMS, SQL Profiler and Index tuning wizard.
• Worked on incident management issues as per IMR/Tickets raised by UTS monitoring system
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Responsible for code review prior to project implementation of databases objects like Views, Stored Procedure, Triggers etc. to provide structure to stored data and maintain database efficiently.
• Performing the root cause analysis of production issues.
• Ensuring the automation of monitoring MS-SQL Server

Environment: MS SQL Server 2012, MS SQL Server 2008 (R1 & R2), Windows Server 2008 R1, UTS

Confidential

Database Administrator (MS SQL Server 2008/2005 & MY SQL)

Responsibilities:

• Responsible for handling the Production & Staging Environment.
• Taking care of the Backups and Restoration Tasks of MS-SQL & MY SQL having databases in 8-9 TB’s.
• Maintaining/Configuring Clustering, Replication-MS SQL & MY SQL, Logs Shipping & Mirroring, Maintenance Plan.
• Preparing documents for Disaster Recovery and perform disaster recovery exercise once in a Year.
• Performance tune Stored Procedures, Triggers, Functions & long running queries by looking at query plans, IO Statistics,
• Joining Techniques, and Outdated Statistics & Indexes.
• Monitoring Database Growth and plan for the data storage and servers and bring about effective
• Perform Capacity Planning & utilization
• Preparing the schedule for the maintenance job of various events.
• Ensuring the automation of monitoring MS-SQL Server.
• Preparing / writing stored procedure, triggers, views, and functions for different projects.
• Assisting the Programmers for optimizing SQL queries.
• Database refresh in test environment with the production database backup
• Coordinating service pack updates on SQL DB Servers on test and production environments
• Monitoring health of the database server and checking error log or event log for database errors.
• Managing new database objects including tables, indexes, SQL queries, & stored procedures for data manipulation.
• Drafting documents for Jobs, Replication, Server Capacity, Database Size, etc.
• Performing the root cause analysis of production issues.
• Performing Weekly Maintenance of SQL Servers

Environment: MS SQL Server 2008/2005, MY SQL 5.6, Windows Server 2003

Confidential

Responsibilities:

• Responsible for Database Designing, writing Stored Procedure, Triggers, Functions & Views
• Designing and implementing the backup & restoration strategy and recovery disaster planning.
• Maintaining replication, log shipping and mirroring and query Optimization.
• Creating & managing new database objects including tables, indexes, SQL queries, and stored procedures for data manipulation. Installing SQL Server 2000 and applying service pack for SQL Server 2000 production servers.
• Periodically checking all databases with DBCC commands for maintaining the consistency and integrity.
• Preparing a daily report for all production servers.
• Implementing security / SQL Server Hardening.
• Monitoring, analyzing and identifying disk I/O, memory and processors bottlenecks.
• Establishing a procedure to migrate databases, logins, and jobs to new environment servers.
• Looking after the SQL Server query tuning and optimization for various applications.
• Accountable for daily maintenance of SQL Servers included reviewing SQL error logs, event viewer.