Sql Server DBA

Biplab Gupta USA CITIZEN

929-***-**** ***************@*****.***

Professional Summary

Over Six years of professional experience administering SQL server Databases including versions 2008R2, 2012, 2014 and 2016.

Expertise in T-SQL writing stored procedures, triggers and functions.

Experience in Disaster Recovery Planning and Security Management operations.

Expertise in SQL server installation, configuration, upgrade, and migration of databases.

Expertise in troubleshoot SQL performance issues by using Execution Plans, SQL Profiler, Performance Monitor, Trace files, and Index Tuning.

Identified SQL Server Locks, Blocks, and Deadlock situations utilizing System Stored Procedures, DMVs, and Activity Monitor.

Implemented Replication including Snapshot, Merge, Peer-to-Peer and Transactional.

Designed and implemented HA/DR strategy utilizing Maintenance Plan, SQL Server Log Shipping, Database Mirroring, Always On, and Failover Clusters

Hands on experience in creating, updating, and executing SSIS packages.

Strong experience in mentoring team members and writing documentation.

Designed data Partitioning solutions for tables and indexes.

Strong Experience in creating jobs, Alerts, SQL Mail Agent and Scheduling DTS and SSIS Packages.

Experience in maintenance plans to perform index de-fragmentation, reorganize index, rebuild index, and update the index statistics.

Experienced in supporting 24/7 on-demand applications.

Professional Experience

NBTY, Long Island, NY

SQL Server DBA May 2016 to Present

Responsibilities:

Installed and configured new SQL Server 2012, 2014 and 2016.

Migrated database from 2012 to 2014 and 2016.

Applied SQL Server service packs and hot-fixes as they become available for updates.

Scheduled maintenance tasks, planned production upgrades and capacity planning.

Checking Database Health by using DBCC Commands and DMVS.

Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.

Perform SQL Server service pack and Windows Service pack upgrades.

Troubleshoot performance problems and fine-tuning of databases.

Expertise in designing databases and capacity planning.

Rebuilding the indexes at regular intervals for better performance.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.

Performed Query Optimization, Debugging, Tuning, and Improvising performance of the databases.

Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration

Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities

24 X 7 Production Database on Call Support

Cigna, Hartford, CT

SQL Server DBA February 2014 – May 2016

Responsibilities:

Installed, Configured, and Managed SQL Server 2012, and 2014 in development, test, and production environment

Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

Responsible for Database Backup, Restore and Point-in-Time Recovery

Monitored Server Activity, Error Log, space usage, and solving problem as needed

Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.

Audited and generated monthly management reports

Created the database, tables, table spaces, data objects, setting privileges, indexes, and user logins.

Implemented security, generate and review report periodically and enforce security mechanism

Proactively monitored the production database(s) and optimize stored procedures for better performance; Resolve locking conflicts and resource utilization

Applied Transparent Data Encryption to protect securable across multiple servers.

Developed, deployed and monitored SSIS Packages.

MTA, New York, NY SQL Server DBA June 2012 - February 2014

Responsibilities:

Installed, configured SQL Server 2008 R2 and 2012 for all environment.

Upgraded SQL Server 2008R2 to SQL Server 2012.

Closely work with business analyst to deploy databases and manage availability.

Experienced working with SQL Server High Availability solution such as Windows Clustering, Log Shipping and Mirroring.

Performance tuning & optimization of servers in production, test environment.

Worked with developers to tune-up performance of SQL and T-SQL query.

Setup and configured Database mail for notification purposes.

Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs

Perform SQL Server service pack and Windows Service pack upgrades.

Created and managed database security, data encryption, and applied object level security

Technical Skills:

Operating Systems: Windows Server 2012/2008 R2, Windows XP/ 7/8/10, VMware

Database: MS SQL Server 2016/2014/2012/2008R2

Languages: T-SQL

Reporting/Analysis Tool: SSRS (SQL Server Reporting Services), Crystal Report

Data Modeling: SQL Server Database Diagram, ERWin, RedGate,VISIO

Other Tools: SharePoint 2010, Quest LiteSpeed, Remedy Ticketing System, JIRA.

MS Office: Word, Excel, Access, Outlook and PowerPoint.

Education/Certification:

Bachelor of Business Administration

Microsoft Certified Professional (MCP)- SQL server 2016

***Reference will be provided upon request

Contact this candidate