SUMMARY:

• Above 5 years of IT experience in production support role supporting windows 2008/2008 R2, SQL Server 2014, 2012, R2/2008/2005, IIS 7.0, in a large scale 24x7 operations/production web service environment.
• Experience in upgrading SQL Server to newer versions and applying service packs, hot fixes and Installation.
• Experience in Installing and Configuring SQL Server Active/Active and Active/Passive clusters.
• Worked on SAN for SQL Server Databases and good understanding in Capacity Planning.
• Experience in Implementing Raid 1, 5 and 10 Technologies.
• Backup and Disaster Recovery
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server 2005 and SQL Server 2008 in OLTP Environments.
• Implemented and maintained Database Mirroring in SQL Server 2008.
• Configured and managed SQL Server AlwaysOn and Availability Groups.
• Configured Windows cluster on servers in different geographical locations for AlwaysOn
• Implemented Log Shipping in SQL Server 2008 and SQL Server 2012.
• Implemented and configured Clustered Server in Active/Active mode and Active/Passive mode.
• Experienced in configuring Database Maintenance Plan Wizard and scheduling it in accordance with the management.
• Good Knowledge of Peer to Peer Replication in SQL Server 2008.
• Performance Monitoring and Tuning
• Monitored production servers using tools like SQL Profiler, PerfSPY, Geneva Monitoring, Solarwinds, Performance Counters and SQL server logs.
• Tuned SQL server performance by analyzing the execution plans
• Strong debugging skills and the ability to solve complex problems.
• T - SQL, PowerShell and Automation
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in writing Debuging T-SQL queries and Automating DBA daily activities.
• Experienced in PowerShell scripting and automation.
• Experience in Database Capacity Plan
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Experience in Creating Roles and Assigning Permissions to the users.
• Experience working on Production Server including Weekends and change control support over nights
• Experience in contacting Confidential PSS and other vendors for product and technical support
• Experience in providing 24/7 support.

PROFESSIONAL EXPERIENCE:

SQL Engineer

Confidential, Redmond, WA

Responsibilities:

• Worked on Huge environment supporting 100+ large customers each ~25tb
• Supported over 9000 servers in the migration process to Gen9 servers
• Worked on configuring High Availability methods mainly Mirroring as required by customers
• Worked on Azure SQL instances as a part of migration from physical servers to Azure
• Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Dealt with Data corruption issues and used best practices to resolve issues
• Analysed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks
• Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012 environments.
• Configuring, tuning and optimizing SQL Server .
• Used Perfspy for getting more information about disk pressure, memory pressure etc.
• Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues
• Used PowerShell for troubleshooting network, Server and SQL issues

Sr. SQL DBA

Confidential, Bothell, WA

Responsibilities:

• Worked on 24*7 high traffic e-commerce OLTP environments.
• Worked on SQL Server 2014 and Configured in around fifty servers which includes a fresh install and in place upgrade from older versions.
• Pushed SQL standards across all the servers and created documents.
• On boarded the fresh installed servers, added to monitoring and backup tools.
• Configured failover clustering as one of the solutions of high availability and Log shipping for DR.
• Implemented AlwaysOn on servers migrated to SQL 2014 and built new servers with SQL 2014.
• Mentored Jr. DBA’s, provided training on SQL new features AlwaysOn and Database Management Warehouse. Also configured clustering on servers in different geographical locations.
• Worked on storage migration from 3Par HP to Hitachi storage.
• Moved the data across old and new drives including the customer dbs and system dbs.
• Worked with customers on performance issues and built a reporting solution for server health
• As part of server consolidation, moved databases that are less utilized and analyzed their performance on shared environment.
• Developed solution for monitoring resource policies and dependencies on failover cluster and wrote a script for clearing SCSI persistence reservation in case of disk failure issues during failover.
• Coordinated and patched 400+ servers as part of bi-annual patching cycle.
• Participated in DR exercise that involves bringing the databases online on 200+ servers with decreased RTO.
• Involved in design meetings and helped developers in optimizing queries for better performance.

SQL DBA

Confidential, Bellevue, WA

Responsibilities:

• Intensively worked on SQL Server 2008 and Configured in around fifty servers which includes a fresh install and in place upgrade from 2005.
• Setup redundant servers to avoid one point failures using EMC DMX technology “Cloning” and SQL Database Mirroring for highly active servers.
• Investigated data missing issues and helped Development team in finding the bugs in code.
• As a service build engineer, On boarded lots of new applications and involved actively from the day of pre-baseline to till the go alive date.
• Configured Resource Governor on production environments to comprise the resource between SQL server and Report Server.
• Implemented Change Data Capture (CDC) feature of SQL 2008 to improve the ETL performance.
• On boarded all the pre-production and production servers to a single monitoring tool, System Center Operations Manager (SCOM) 2007, and used appropriate management packs to monitor the server side and SQL server configurations.
• Monitored jobs on daily basis and created knowledge base articles to support level 1 & 2 service desk teams.
• Worked a bit on front end tools such as MOSS 2007, MSInsight, SSRS and Excel 2010.
• Implemented all Major and Minor releases (QFE’s and Hotfixes) into pre-production and production environments, and rebuilt the pre-production system on par with production prior to the all major releases.
• Automated most of the DBA stuff using Windows and SQL integrated PowerShell.
• Used PowerShell to Automate backup and restore strategies in preproduction environments and to some extent of SQL installation.
• Installed monthly mandatory security patches of Operating system and SQL to make the servers non-compliant to security breach.
• Optimized disk space by using Data Compression on Tables and Indexes, SQL lite speed backups for sql 2005 and SQL native compressed backups for SQL 2008.
• Troubleshoot the performance issues using database tuning advisor, sql profiler and dynamic management views. Configured maintenance jobs to run in a non-active window to keep up the server performance.
• Worked on NLB and SQL Cluster environments, efficiently used to reduce the downtime for the business users.
• Provided KT to the newly hired team, and closely worked with the team in India and helped them in various aspects to solve the issues in time.

SQL DBA

Confidential

Responsibilities:

• Monitoring around 250 servers (SQL and Web Servers) and responsible for day-to-day operation and maintenance of production servers.
• Applying Major Upgrades Monthly/Quarterly releases on the Servers and troubleshooting issues faced while installing the patches.
• Making decisions and troubleshooting the SQL server issues
• All open issues and scheduled tasks to be completed as scheduled
• Involved in the project team working towards confirming to the framework and recommendations of the IT Infrastructure Library for IT Service Management
• Application owner for critical Confidential platinum reporting applications
• Involved in the Release Management Implementation team Confidential
• Installation/Upgradation of SQL Server: Planning, Installation of SQL 2005, Upgradation to SQL2005, Failover Cluster/Active Active Installation, Fixing Cluster issues, Quorum failure issues
• Server Migration: Planning, Migration of SQL 2000 to SQL 2000/2005
• Disaster prevention and recovery: Backup options, Strategies, restoring databases. Full, Differential and Log backups. Point in time restores.
• Database and Server performance: File groups, Performance monitor, and SQL profiler, Resolving performance issues with long running queries, blockings and deadlocks. Trace flags, Page file settings, 3 GB/PAE switches
• High Availability Monitoring: Log Shipping, Replication, Clustering