PROFESSIONAL SUMMARY:

• Fourteen + years of experience as a Database Administrator (DBA) in fields including Financial, Pharmaceutical, Insurance, Healthcare and IT industry working on different version of MS SQL Server 2000/2005, 2008/2008 R2/2012/2012 R2, 2014, 2016, 2017
• Experience with SQL Server High Availability technologies e.g. Always On, Mirroring, Replication, Logshipping
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Enforced standards and best practices around data modeling efforts.
• Solid understanding of high availability architectures such as Clustering and SAN
• Mentored/coordinated SQL Server DBA teams, including Offshore, operating in a 24x7 environment in accordance with all service level agreements and customer expectations.
• Monitor project, delivery schedules and resources.
• Led team in proper escalation of internal tickets to both vendors and internal technical & service delivery team members supporting specific functions and technologies.
• Ensure team is conducting proper ticketing, documentation, process adherence, etc.
• Provide the correct team support - detailed investigative and analytical information - when problems occur.
• Support root cause analysis and define action plans to prevent future outages and ensure continuous availability of services and meeting all service level agreements.
• Develop and maintain support documentation of work performed with detailed process steps.
• Provide subject matter expertise as needed; including estimating levels of effort and troubleshooting.
• Recognize areas of process improvement; initiate and implement approved changes, and document policies, processes and procedures.
• Monitor and report on performance and customer satisfaction levels and research methods to improve overall client support.
• Maintain a relationship with the customer base, continuously gathering feedback concerning the perceived quality of support.
• Conduct regularly scheduled meetings with customer to provide project related status.
• Experience in Installing and configuring MS SQL Server Database Engine, MS SQL Server Reporting Services, MS SQL Server Analysis Services.
• Experience in installing and configuring MS SQL Server Database Engine on physical and virtual servers (VMWare).
• Built and Maintained standards for SQL Server High Availability and Disaster Recover technologies including but not limited to Log Shipping, Database Mirroring, Database Replication and SAN Replication (as it pertains to SQL Server)
• Strong understanding of Microsoft Best Practices for SQL Server Configuration.
• Experience in applying hot fixes, cumulative updates on SQL Server Database Engine.
• Experience of performance tuning and MS SQL Server administration in various enterprise environments as DBA
• Extensive experience in working with Query Analyzer, Database Tuning Advisor, SQL Server Profiler for administrative tasks.
• Involved in migration of MS SQL Server Database engine from and and 2008 R2, R2 to 2012 versions.
• Experience in prepping up the servers with replication, Log shipping and Database Mirroring as part of DR- Strategy.
• Experience in taking backups, restoring backups, converting 3rd party backup to native SQL Server backups.
• Experience in using SSIS for various ETL process and using BCP and Bulk insert techniques as feeds to the databases.
• Created, monitored, and executed all SQL related Jobs in production environment
• Experience in scheduling, maintaining and monitoring jobs, alerts, SSIS packages using SQL Server Agent.
• Held responsible for creating SQL Server authenticated accounts and NT authenticated accounts in SQL Server environments.
• Installed and configured databases (including tables, views, keys, etc), administer policies, standards, procedures and guidelines necessary to effectively maintain the database environment.
• Knowledge of Windows server administration, RAID and SAN Storage Technologies.
• Good knowledge of Database portioning of tables for better performance in VLDB environments.

SKILL MATRIX:

Operating Systems : Windows 2016, 2012 R2, 2008 R R2/2000 Servers, Windows XP/NT/Vista, Linux, VM

Programming Languages : T-SQL, PL/SQL, C, C#, Java, VB.NET, HTML, XML, Batch Scripting.

Databases: MS SQL Server 2017, 2016, 2014, 2012, 2008R 2/2008/2005/2000

Client Tools : SQL Server Management Studio, SQL Query Analyzer, Toad for SQL Server, Visual Studio, SQL Server Business Intelligence Development Studio (SSIS, SSRS), SSDT, SQL Server Report Manager.

Tools (Other) : AIX, LINUX, PHP, NetApp, NetBackup, TSM, HyperBac, SQL Litespeed, Spotlight, Foglight, Powershell, VMWare, SQL Change Manger, Remedy, Maximo

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Enforced standards and best practices around data modeling efforts.
• Solid understanding of high availability architectures such as Clustering and SAN
• Mentored/coordinated SQL Server DBA teams, including Offshore, operating in a 24x7 environment in accordance with all service level agreements and customer expectations.
• Monitor project, delivery schedules and resources.
• Led team in proper escalation of internal tickets to both vendors and internal technical & service delivery team members supporting specific functions and technologies.
• Ensure team is conducting proper ticketing, documentation, process adherence, etc.
• Provide the correct team support - detailed investigative and analytical information - when problems occur.
• Support root cause analysis and define action plans to prevent future outages and ensure continuous availability of services and meeting all service level agreements.
• Develop and maintain support documentation of work performed with detailed process steps.
• Provide subject matter expertise as needed; including estimating levels of effort and troubleshooting.
• Recognize areas of process improvement; initiate and implement approved changes, and document policies, processes and procedures.
• Monitor and report on performance and customer satisfaction levels and research methods to improve overall client support.
• Maintain a relationship with the customer base, continuously gathering feedback concerning the perceived quality of support.
• Conduct regularly scheduled meetings with customer to provide project related status.
• Experience in Installing and configuring MS SQL Server Database Engine, MS SQL Server Reporting Services, MS SQL Server Analysis Services.
• Experience in installing and configuring MS SQL Server Database Engine on physical and virtual servers (VMWare).
• Built and Maintained standards for SQL Server High Availability and Disaster Recover technologies including but not limited to Log Shipping, Database Mirroring, Database Replication and SAN Replication (as it pertains to SQL Server)
• Strong understanding of Microsoft Best Practices for SQL Server Configuration.
• Experience in applying hot fixes, cumulative updates on SQL Server Database Engine.
• Experience of performance tuning and MS SQL Server administration in various enterprise environments as DBA
• Extensive experience in working with Query Analyzer, Database Tuning Advisor, SQL Server Profiler for administrative tasks.
• Involved in migration of MS SQL Server Database engine from and and 2008 R2, R2 to 2012 versions.
• Experience in prepping up the servers with replication, Log shipping and Database Mirroring as part of DR- Strategy.
• Experience in taking backups, restoring backups, converting 3rd party backup to native SQL Server backups.
• Experience in using SSIS for various ETL process and using BCP and Bulk insert techniques as feeds to the databases.
• Created, monitored, and executed all SQL related Jobs in production environment