SUMMARY:

• Senior SQL Server DBA with 8 years of hands - on experience in SQL Server implementation, maintenance, administration and 24x7 support. Possess very strong analytical skills and is an expert problem identifier with the ability to work both independently and as a team player. Effective and precise in verbal and written communication skills, presentation and interpersonal skills. Worked in various industries such as internet and technology, retail e-commerce, and property management and supported SQL Servers versions 2000/ 2005/2008/2008 R2/2012 and 2014.
• Hands on experience on High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and AlwaysOn Availability Groups, Replication, Log Shipping and Mirroring.
• Experience in installation, configuration, maintenance and optimization of SQL Server HADR solutions.
• Experience with partially contained databases.
• Experience in Performance Tuning, Backup and Recovery, Query Optimization and Security.
• Experience in Upgrade/Migration of MS SQL Server 2005/2008 to MS SQL Server 2008R2, 2012 and 2014.
• Experience in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions.
• Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
• Expert in creating DTS packages to utilize SSIS functionalities and DB dependency resolutions.
• Created various SSIS, SSRS and SSAS Packages to serve company needs.
• Familiar with PCI Compliance Standards required for Retail Industry.
• Expert in using DTA/Extended Events/PerfMon/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queries.
• Able to benchmark and load test new instance builds for performance with DB load simulators.
• Responsible for securing SQL Server, user management, assigning permissions and roles.
• Expert in VMware virtualization, Hardware/Software Clustering, RAID and SAN/NAS technology.
• Strong System Administration background in Windows and Linux environments.
• Hands on experience of Microsoft SharePoint 2010 in Azure Cloud, Amazon EC2 server instances.
• Experience in creating technical documentations and process archiving and change management.
• Experience in working independently as well as in team-oriented environments.
• Expert in problem solving, analysis and conflict resolutions.
• Experience in supporting and maintaining large databases and troubleshooting their problems.
• Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, HTML, VB, .NET, Java, PERL, ASP, PHP and XML

ETL Tools: SSIS, BI (BIDS/SSDT).

Data Modeler: SSAS, SQL Developer Data Modeler, TOAD Data Modeler.

Reporting & Audit Tools: SSRS, Report Builder and SSDT, Idera SQL Compliance Manager and SQL Secure.

Backup Software: SQLBackup, LiteSpeed, RedGate, Idera SQLSafe, VEEAM and Backup Exec.

RDBMS & Tools: SQL Server 2005/2008/2008 R2 and 2012, MS Access 2003/2007/2010/2013 Oracle 11gR2, MySQL 5.0+, SQL Loader and Export/Import, PowerShell.

Operating System: Windows 95/98/XP/Vista and 7, 8, Windows NT/ 2000/2003/2008 and 2008R2, 2012 servers and *NIX OS. VMware, Hyper-V virtualization.

Third Party Tools: RedGate, Spotlight, and IderaSQLsuite, Toad Development Suite, phpMyAdmin, Olas s Maintenance Scripts, Iometer, PuTTY, Wireshark.

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer, Toad for SQL/MySQL/Oracle.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

SQL Server DBA Consultant

Responsibilities:

• Responsible for installing, configuring, and maintaining AlwaysOn Availability Groups and Failover clusters.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for installing and configuring MS SQL Server 2005, 2008, 2008R2 and 2012 on Windows 2003, 2008, 2008R2 and 2012 and applying service packs and security fixes on these MS SQL Servers.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Resolved post-migration dependency issues of databases using SSIS packages.
• Monitor the health and performance of SQL OS, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintain Log Shipping between various environments.
• Create necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operate and oversee database and log backups and restoration, planning backup strategies, and scheduling.
• Backing up master & system databases and restoring them when necessary.
• Optimizing the Indexes, adding/deleting them when necessary for better performance.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Involved in improving database performance using Extended Events, SQL Profiler, Trace Flags, Execution plan and DTA and third party tools.
• Work with installation, configuration and creation of SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Confidential, Greensboro, NC

SQL server Database administrator

Responsibilities:

• Responsible for Installing and configuring SQL Server 2008, 2008R2 and 2012 on Windows server 2008/2008R2/2012.
• Setup and configured SQL failover cluster with shared disk for redundancy of critical SQL instances.
• Installed and configured SQL server 2008 Reporting Services (SSRS), created user roles, managed security, built reports and deployed them to production. Worked with configured SSRS to monitor all jobs on daily basis, fixed the failed jobs and re-ran them.
• Provided 24x7 dedicated support to hundred and twenty Production, development and clustered servers.
• Responsible for configuring and maintaining Transactional, Snapshot and Merge replication in production environments.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel and MS Access to MS SQL Server databases.
• Developed the metrics and trending processes for SQL database sizing and growth.
• Daily monitoring of two-node active-passive SQL cluster in a host environment.
• Applied service packs and security fixes for all SQL Servers, and provided database administration support.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008 and from SQL Server 2008 to SQL Server 2008R2 and 2012.
• Tested newly built servers for performance impact with DB load simulators before moving to production.
• Automated common operations and tasks, created critical production alerts and design practices for portability using DACPAC.
• Experience in consolidating the package and the parameters for projects using ISPAC.
• Performed database backups and migrations for production, test and development environments.
• Worked with SQL DBA team and SQL Developers to help optimize, performance tune, create indices and optimization of slow running queries and locks using scripts and Database Tuning Advisor (DTA).

Confidential, Peabody, MA

Database Administrator

Responsibilities:

• Responsible for MS SQL Server 2005 and 2008 and database administration.
• 24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
• Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
• Involved in validating SQL Servers, which was installed on validated environments.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented/revised those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Applied monthly patches and hot fixes. Worked with application team to test the successful upgrades.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Installed and configured SQL Server Analysis services (SSAS) for data warehousing projects.

Confidential, Daytona Beach, FL

SQL server Database Administrator

Responsibilities:

• Installed and configured SQL Server 2005/2008 and Service Packs on Windows 2003 Servers
• Installed and configured 64 Bit SQL Server 2005 active\active cluster instances.
• Upgrading to SQL Server 2008 Servers from SQL Server 2005
• Worked on Clustering with shared disks in SAN Environment
• Worked with System Admin team to verify RAID configuration and also SAN configuration.
• Used VPN client to support from home during weekends.
• Worked with Development team to help their issues and modifying the stored procedures and triggers
• Data Loading with SSIS, DTS, BCP and Bulk Insert tools. Loading of large data between the databases.
• Maintenance plan for full, differential, t-log backup and database recovery in complex recovery scenarios.
• Performed performance analysis using CPU, I/O and memory counters using perfmon/Iometer.
• Used SSIS, SSAS Services in SQL Server 2008. Used wizards and other features extensively in 2008.
• Responsible for managing Transactional Replications. Worked with Active/Passive Clustering Environment.
• Escalated critical issues regarding production servers to Microsoft.
• Scheduling Backups and checking the Backups on a regular basis.