SUMMARY:

• 14 plus years of IT Experience and 10 years in Database Administration, System Analysis, Design & Production Support of MS SQL Servers 2017/ 2016/2014/2012/2008 R2 in Production, PSE, QA & Development environments & High Availability AAG/Cluster Environments.
• Expertise in MS SQL Server Installation, Configuration, Upgrading/Patching, Performance Tuning, Query Optimization, Backup/Recovery, Client/Server Connectivity and running Database Consistency checks Using DBCC.
• Expertise in Database Migration from 2012 to 2014/2016 versions & 2008 R2 to 2014/2016 as per MS EOL. SQL Server Patching/Security /GDR/Cumulative updates as MS release bulletin & Audit standards.
• Expertise in configuring and managing Always - On Groups (AAG), DB Mirroring, Log Shipping & Replication
• Administration of MS Azure & MS SQL Server 2017/ 2016/2014/2012/2008 R2 Production environments
• Production Support L3 DBA, RCA, Change management & Disaster Recovery Exercise
• Setting up Always-On Groups (AAG)/WFC Clustering/ Database Mirroring & Log Shipping in heterogeneous production environment
• Working with Performance tools SQL Profiler/Perfmon/Execution Plan/SQL Nexus/Quest Spotlight
• Financial/Billing/Telecom/Healthcare domains
• Excellent communication & interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, Coppell, TX

Sr. SQL Server DBA

Responsibilities:

• Marinating and supporting 400 plus SQL Servers including Prod, PSE, QA & Dev environments in multiple datacenters including SG, UK & NL
• Responsible for installing, configuring, and maintaining SQL Server 2019/2016/2014/2012 as per supported LOB applications
• Aligned with Windows, Network, VMWare, Storage and Firewall teams to stack for business needs.
• Led Disaster Recovery, high availability solutions & Change management process, Participate DR Exercise.
• Responsible for large-scale SQL Server database migrations from SQL Server 2008 R2 and SQL 2012 as per Confidential EOL
• Escalated and handled Critical Incident and problem Tickets (Sev1, Sev2 high) and assisted On-call rotation, DR Exercise & troubleshooting SQL Server Service outages
• User administrations, Baseline Standards, SQL Server Service account password reset and Change Management process.
• Worked on MS Azure POC project and configured SQL Managed Instances and Azure database migration & Key Vault.

Environment: Confidential Azure, Confidential SQL Server 2016/2014/2012/2008 R2 SSIS/SSRS/SSAS Standard/Enterprise editions, Windows server 2012/2008 R2/VM Ware, Clustering, Always-On Groups, Confidential FCI clustering, DB Mirroring, Replication, Log Shipping

Confidential, Lewisville, TX Database Administrator

Responsibilities:

• Supported 300 plus SQL Servers (SQL Server 2012, 2008R2, 2008, 2005, 2000)
• Administered MS SQL Servers by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Performed Database integrity Checks, updated Database Statistics and performed re-indexing daily
• Migrated and supported of databases for Production, Integration and Development environments. Working on Clustered environment and Installation of SQL Server and SQL Hotfixes
• Provided 24 x 7 Production support for the database and application issues.
• Implemented Production, Integration and Development environment, Hardware requirements and support. Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Worked with BRP (Business recovery plans) and capacity planning (number of boxes, amount of space, memory, rate of database growth).
• Migrated databases and applications to Ditech/Estate Organizations as part of separation.

Environment: SQL Server 2012/2008 R2, 2008, 2005, Windows Server 2008 R2 Advanced Servers, SSIS, SSRS, SSAS,BMC, SFTP, CMIS, Perfmon, Profiler, PSSD, HP Polyserv Clusters, MS Clustering

Confidential, Dallas, TX

SQL Server DBA Lead

Responsibilities:

• Supported 300 distributed DB servers (SQL Server 2012/2008 R2/2005/2000) on regular basis for 800 databases with 4 TB databases.
• Managed team of 7 DBA’s including SQL Server & Oracle and mentoring DBA’s
• Administered MS SQL Servers by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Performed Database integrity Checks, updated Database Statistics and performed re-indexing daily
• Interacted with various departments for new release and troubleshooting of applications
• Worked on Clustered environment and Log Shipping, Replication, DB Mirroring, SSIS, SSAS & SSRS. Providing 24 x 7 Production support for the database and application issues.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Worked on BRP (Business recovery plans) and capacity planning (number of boxes, amount of space, memory, rate of database growth).

Environment: SQL Server 2008 R2, 2008, 2005, SQL Server 2000, Windows Server 2003/2008 R2 Advanced Servers, SSIS, SSRS, SFTP,NDM,IIS,CMIS, EMC Backups, Perfmon, Profiler, PSSD

Confidential, Dallas, TX

Sr. SQL Server DBA

Responsibilities:

• Monitored and supported 130 East & West distributed servers (SQL Server 2008/2005/2000 ) on regular basis for 2 TB databases.
• Supported databases for Production, Integration and Development environments (Change Management System).
• Worked on Clustered environment and Log Shipping, DB Mirroring, SSIS
• Supported Production, Integration and Development environment, Hardware requirements
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• Worked with MS DTC for the windows server 2003 and in cluster environment.
• Performed Users security permissions and Migrated entire database objects from one server to another server.

Environment: SQL Server 2008/2005, SQL Server 2000, NDM, Secure Plus, VSS, Windows 2003 Advanced Servers, BMC, SQL Light Speed, IIS, SSIS Packages, SQL Litespeed, SQL Toolbelt

Confidential, NJ

SQL Server DBA

Responsibilities:

• Provided Prod Support for 43 NA & International distributed servers on regular basis.
• Installed and configured MS SQL Server 2005/2000 (Enterprise, Standard and Developer Editions)
• Created databases, tables, rules, defaults, triggers, indexes, and stored procedures.
• Data Transfers between various servers using Import/Export, BCP and DTS Packages and DTS Jobs.
• Performed database recovery using the backup sets and maintenance plans.
• Created schema objects, granting roles and privileges to the users, compilation of procedures etc. Integration, Backup-Recovery and testing. Disaster recovery procedure and recovered multiple servers
• Managed DBCC, Performance Monitor and Sql Profiler for Monitoring memory, processor

Environment: MS SQL Server 2005/2000, Visual C++, VB, and Crystal Reports. ERWin 4.0 was used as CASE Tool, Clarify Windows 2003 Advanced Server

Confidential, Redmond

Production Support DBA

Responsibilities:

• Designed and analyzed databases for Confidential SQL Server 2000 (Standard and Enterprise Editions).
• Installed and configured Server Mail and alerts. Monitored database performance and tuning, restored DB and managed security, disaster recovery and migration of servers.
• Created system procedures for processing data across applications. Performing database recovery using the backup sets and maintenance plans.
• Performed data transfer/migration using Export/Import and Data Transformation Services.
• Created packages, procedures, functions, and triggers, handled database performance and tuning.
• Performed Database restores and managed Security & Disaster recovery and migration of servers
• Configured SQL Server Mail and alert configuration.

Environment: MS SQL Server 2000, Windows 2003 Advanced Server, MS SQL Server 2000, VC++, VB .Net, VSS