PROFILE SUMMARY

• Work Experience of 7 Years in SQL Consulting/IT Production Support/Release Management/Live site Migrations.
• Experienced in Database Administration, System Administration, Configuration, Development and Large scale Operations/Production support of SQL Server 2000,2005,2008 and 2012, Windows 2003/2008 R2 and IIS at Microsoft
• Corporation
• Experienced in High Availability, Disaster Recovery, Query Tuning and Optimization, Up - gradations/Migrations, Data warehousingand worked on Terabyte databases
• Good understanding of ITIL framework.
• Ability to support and manage Enterprise mission critical applications, Operations experience in a 24*7*365 support model
• Experienced in configuring and administrating AlwaysOn SQL 2012/2014.
• Good understanding on latest features in SQL server such as extended events, Management Data warehouse, Database Audit specification, Resource Governor, Change Data Capture and Change Tracking.
• Configured solutions for disaster recovery based on business requirement on RTO (recovery time object) and RPO (Recovery point object)
• Experienced in configuring and maintaining high availability solutions such as Failover Clustering, Database Mirroring, LogShipping and Replication.
• Good in automating regular activities of DBA using T-SQL and PowerShell.
• Experienced in working with Microsoft Production support and running PSSDiag for enhanced troubleshooting purpose.

TECHNICAL SKILLS:

Data Bases: MS-SQL Server 2005/2008/2012

Scripting: T-SQL, Batch scripting, power shell

Operating Systems: Windows 2000/2003/2008 R2 Advanced Server

Business Intelligence: SSIS, DTS, SSRS

Application Health Monitoring: MOM 2005/SCOM 2007

Web servers: IIS 6.0/7.0, SharePoint 2010

Networking: DNS WINS, TCP/IP, VLANs, DHCP, Routing, ACL’sLoad Balancing, Routing and NetScaler

Storage: EMC SAN, DMX Symmetrix, HP DAS/Blade, RAID types

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Database Administrator

Responsibilities

• Work closely with database and system administrators to ensure all mission /business critical systems/databases perform optimally.
• Apply SQL database administration knowledge to define efficient and optimal database layout, and analyze and improve database performance.
• Working with developers and define schema objects, 24/7 support, backup and recovery, patches, upgrades, software installation, schema changes and tuning.
• Schedule and participate in technical and customer reviews and should be able to communicate effectively with both technical and non-technical audiences.
• Work closely with others in a true global / cross cultural team environment and able to define, plan and implement long term goals and tasks
• Implementing the High Availability solutions for SQL Servers using Clustering and Database Mirroring.
• Configuring the Databases with best practices suitable for SharePoint Farms
• Backup options, Strategies, restoring databases. Full, Differential and Log backups. Point-in-time restores.
• System Performance Monitoring and Tuning. General Trouble Shooting, using SQL I/O and to check the disk contention, SQL Dashboards, Resource Monitor, Performance Monitors and enhance the Database performance.
• Built already an environment with SQL Server 2012 Always On and Virtualized SQL Server.
• Working on Future Road Maps on SQL Server 2012, Virtualization, Implementation of Office 365 and Azure.
• Plan future-state infrastructure (storage capacity planning, server SKU recommendations, short Stroking, Array Configuration recommendations, etc.)
• Working on SSIS for Reporting Data warehouse from Local Databases.
• Automate the processes using PowerShell and windows command shell.
• Working on sending business communications to users and other team on scheduled downtimes, planning the downtimes and Implementation.

Confidential, Washington

Database Administrator

Responsibilities

• Implementing the High Availability solutions for SQL Servers using Clustering and Database Mirroring.
• Building new SQL Servers for SharePoint Farm Servers.
• Configuring the Databases with best practices suitable for SharePoint Farms
• Backup options, Strategies, restoring databases. Full, Differential and Log backups. Point-in-time restore.
• System Performance Monitoring and Tuning. General Trouble Shooting, using SQL I/O and to check the disk contention, SQL Dashboards, Resource Monitor, Performance Monitors and enhance the Database performance.
• Built already an environment with SQL Server 2012 Always On and Virtualized SQL Server.
• Working on Future Road Maps on SQL Server 2012, Virtualization, Implementation of Office 365 and Azure.
• Plan future-state infrastructure (storage capacity planning, server SKU recommendations, short Stroking, Array Configuration recommendations, etc.)
• Discovering the servers, adding Urls to monitoring.
• Working on New Management Packs, importing and setting the thresholds, testing and implementation in Production.
• Working on SSIS for Reporting Data warehouse from Local Databases.
• Working on SSRS, Power -View, Power-Pivot dashboards to Automate Monthly Reports
• Preparing common Monthly Availability, Asset/Change/Incident Management reports.
• Automate the processes using PowerShell and windows command shell.
• Working with L2 team on Daily Incidents, SCOM alerts, Job Monitoring.
• Working on application builds, SQL Builds, security patching, password updates.
• Working on sending business communications to users and other team on scheduled downtimes, planning the downtimes and Implementation.
• Working with Solution Managers, Development team and build teams to debug the user/application issues.
• Creating KNet articles and other KB Articles/SOPs and update the SharePoint with updated information. Documented actions and procedures for quick problem resolution
• Authored Known Error documents for incidents and issues for all supported-IT applications and services

SQL DBA

Confidential, Dallas, TX

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.
• Created performance dashboard reports to analyze the system resource utilization, Index fragmentation and missing indexes.
• 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.

Confidential, New Jersey

Database Administrator

Responsibilities

• Problem Management. To assist the Incident Management team to drive down the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents.
• High Availability. Review and design high-availability solution based on the available technologies. (Windows 2003/2008 Clustering and SQL 2005/2008 Clustering, Replication (Transactional, Peer to Peer),Database Mirroring)
• Business Continuance/Disaster Recovery. To identify and to implement best practices to ensure continuance of business operations and to reduce the risk and impact of potential disaster scenarios.
• Performance Tuning. Analyze current performance issues to determine trends; provide solutions to increase performance, reliability and connectivity.
• Security. To assist our customer with security design, configuration and to provide best practices to ensure our customers’ environment is safe and secure.
• Application and platform deployment planning. Assist with the planning and implementations/deployment of application upgrade within the platform environment.
• Technology solution research. Help to identify, understand and deploy new MS technologies that meet scalability and manageability needs for our customers.
• Capacity planning assistance. To assist customers’ Capacity Management team by reviewing platform capacity design and offer best practices solution.