SUMMARY

• Goal oriented Database Administrator with proven technical leadership and project management skills with experience in a high - profile and challenging corporate environment. I have extensively worked with key business and operation stake holders, compliance, internal audit and regulators throughout the career.
• Extensively worked on SQL Server database Administrator, in with hands-on experience in installing, configuring, managing, monitoring, migrating and applying SQL Service Pack and troubleshooting SQL Server 2005 / 2008 / 2008 R 2 /2012 /2014 / 2016 instances in Prod, UAT, Test and Dev environments
• Practice with implementing, configuring and troubleshooting in Standalone, Windows Active-Active and Active-Passive Clustering, Backup/Recovery, SQL Server Security, Replication, Log shipping, Mirroring and SQL server 2012/2014 AlwaysOn failover High Availability and Disaster Recovery solutions
• Knowledge in various ETL, Reporting and strong SQL coding skills with SSIS and SSRS
• Constantly involved in SQL Server T-SQL in construction in Triggers, Tables, Store Procedure, User Defined Functions, Views, Indexes, relational databases models, and data integrity.
• Investigated and resolved the critical issues of significance including Query Performance Tuning and cpu, memory, IO bottleneck issues
• Provided technical support for various databases and applications to assure full operational conditions 24/7
• Solid understanding of Azure SQL DB and cloud computing service models (IaaS,PaaS,SaaS)
• Implemented large HA/DR Azure Cloud (Private & Public) environments for mission critical applications using Express route and 24x7 monitoring using Microsoft Azure monitoring solution.
• Familiarity with IGNITE8, Red gate SQL Data Compare 10, SQL Backup7, Share Point, DB Artisan 7.2, 8.1.5, BMC. IDERA SQL Diagnostic Manager.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/2008/2008 R 2/2012/2014/2016 , Sybase 11.0, 12.5, MySQL and Oracle

Cloud: Microsoft Azure Cloud Computing Platform & Services

Software: T-SQL, SQL, PL/SQL, IDERA SQL Diagnostic Manager, Solarwinds DPA, Red Gate SQL Backup7, Share Point, DB Artisan 7.2, BMC, SSIS, DTS. SSRS, Crystal Reports, Access, Performance Tuning, Capacity Planning, ODBC, JDBC, OLEDB, DTS, SSIS, SSRS

OS: Win 2012/2008/2003/2000 Server/Windows 2000 Professional/ UNIX (Sun Solaris), Red Hat Linux

Language: Windows Power shell, C+, COM+, Visual C++, .Net, HTML, SML, ASP, JSP, JavaScript, VB.

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

Sr SQL DBA

Responsibilities:

• Installed, configured, upgrade and maintained SQL Servers 2014,2016 on Windows Server platforms.
• Implemented MS SQL Server replication and HADR solution for MSSQL using log shipping or SQL mirroring and AlwaysOn Availability Groups
• Performed database monitoring and tuning using DMVs, Perfmon, profiler and other tools.
• Performed database refreshes of Development and QA databases.
• Worked with the application development team on production release deployments
• Deployments of SQLs server database schemas, SQL data compares and database contents with Redgate SQL compare SQL data compare and SQL change automation tools
• Created Public, Private Clouds based upon special emphasis on Microsoft Azure PaaS offerings covering compute, VM, Storage, Networking, Middleware, API Managements etc.
• Implemented large HA/DR Azure Cloud (Private & Public) environments for mission critical applications
• Solid understanding of Azure SQL DB and cloud computing service models (IaaS,PaaS,SaaS)
• Proficient in using Microsoft Azure pricing calculators to forecast pricing, peak time usage pricing & future growth
• Deployed windows SQL Server databases and schema with Docker container.

Confidential, Lawrenceville, NJ

Sr. SQL Database Administrator

Responsibilities:

• Hands on experience in Install, Upgrade, Migration, Performance Tuning, Patching in all SQL Server 2008/2008R2, SQL2012/2014 and SQL Server 2016 etc.
• Troubleshot day-to-day problems encountered on production databases and custom application issues
• Provided Expert level services as core SQL DBA, performance Tuning and backup/recovery
• Used DMV, SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code and third-party software DPA (Ignite8)
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Configuration and troubleshooting of Always-on availability on SQL server 2012/2014 and 2016
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Used several azure cloud service models (IaaS, PaaS,SaaS) and proficient in using Microsoft Azure pricing calculators to forecast pricing, peak time usage pricing & future growth.
• Migrating On-premises SQL databases to Azure cloud VM and Azure SQL
• Configured and implemented detailed monitoring of the MS Azure cloud networks, monitoring all the different fabric of Azure.

Confidential, North Brunswick, NJ

Sr. SQL Database Administrator

Responsibilities:

• Maintained a stable process of database refresh from production to internal
• 24 x 7 Production Support
• Responsible for regular database maintenance process and disk defrag procedures in Production and Non production environments
• Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long running queries using SQL DMV and third party software IDERA SQL Diagnostic Manager.
• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and indexing.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Configuration of Log shipping and Replication and Always-on availability
• Experience with PowerShell Scripting
• Configuration of Mirroring (Synchronous &Asynchronous)
• Provided strategic direction for the database team and functioned as the technical/project leader on projects.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012, TSQL, RED GATE, AlwaysON, Mirroring, Clustering and Log Shipping

Confidential, Mt. Laurel, NJ

SQL Server Database Administrator

Responsibilities:

• Created and managed multiple databases and assisted in capacity planning
• Monitored, maintained database systems and troubleshoot problems that may arise
• Maintained data integrity and security (managed roles and permissions of database users)
• Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
• Developed strategies and implemented solutions for managing back-ups, restoration and replication
• Supported software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures
• Effectively coordinated and communicated with all the stakeholders
• Set up and maintained database infrastructure for the company’ Confidential Power BI needs

Confidential, New York, NY

Production SQL Server DBA

Responsibilities:

• Implemented and maintained databases, perform software installations and upgrades, monitor database performance, perform capacity planning and SQL Server clustering, and manage database Quality Assurance including database consistency check
• Implemented and troubleshooted in Performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performances Monitor and built in performance reports in SSMS, Query Plans, and Database Tuning Advisor
• Responsible for applying service pack and hot fix to all version of SQL Server
• Managed MSSQL Server (storage, memory, processing) and their dependencies and performance bottlenecks
• Responsible for maintaining database security, and high availability such as transactional replication, SQL Clustering, Log shipping
• Review/apply Stored Procedures, Triggers, and other TSQL code developed by developers
• Monitored and ensured Disaster Recovery for critical database
• Managed the granting of access to testing, development application and system databases
• Implemented various automated scripts to monitor disk space, fragmentation, failed jobs step, backup and mirroring activities, and configured various job alerts for immediate notifications

Confidential, New York, NY

Production SQL Server DBA

Responsibilities:

• Provided 24/7 support to SQL Server Production serves (MS dynamics financial systems) and Production Historical server for analytics systems
• Monitored strategies, processes, and procedures to ensure data integrity; optimized/reduced data redundancy; maintained required level of security for all production and tested databases
• Extensive experience in SQL Query Performance tuning by Using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, built in performance reports in SSMS, Query Plans, and Database Tuning Advisor to optimize the queries and enhance the performance of database servers for SQL Query Performance tuning
• Managed the granting of access to testing, development application and system databases
• Environment: SQL Server 2000/ 2005/2008/2008 R2

Confidential, Hartford, CT

Production SQL Server DBA

Responsibilities:

• Maintained databases, performed software installations and upgrades, monitored database performances, performed capacity planning and SQL Server clustering, and managed database quality assurance including database consistency check
• Implemented various automated scripts to monitor disk space, fragmentation, failed jobs step, backup and mirroring activities, and configured various job alerts for immediate notifications
• Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation
• Performing backup and recovery tasks and restoring databases (when database is moved from one environment to other or database is crashed and needs manual recovery)
• Provided 24X7 supports to SQL application developers on production servers

Confidential, Brooklyn, NY

Production MS SQL Server DBA

Responsibilities:

• Performed performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, DBCC commands and in-built SQL tools like SQL Profiler, DTA (Database Engine Tuning Advisor)
• Implemented custom Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding. Indexes, defragmenting Databases, Shrink Database, and Database complete backup)
• Migrated SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2
• Responsible for installing SQL Server on the new build Standalone and Clustered servers
• Disaster Recovery for critical database with compliance for HIPPA
• Migrated DTS packages in SQL Server 2000 to SSIS of SQL Server 2005

Environment: SQL Server 6.5/7.0/2000/ 2005/2008/2008 R2