Sr. SQL Server DBA

Location:

Chicago, IL

Posted:

December 27, 2017

Contact this candidate

Resume:

AMIT CHAUDHARY

Senior SQL Server DBA

****/****/****/**** **/2008/2005

PROFESSIONAL SUMMARY:

Around 10+ years of experience in Database Administration, Development and Design Extensive experience with SQL Server 2016/2014/ 2012/2008/2008r2/2005 in retail and banking sector.

Experience in managing Windows 2003/2008 R2/2012 servers in a clustered environment and Azure Cloud Servers.

Experience in supporting Very Large OLTP Databases of size 13 TB and troubleshooting the performance bottle necks.

Experience with SQL Server 2016/2014/2012/2008 R2/2005 installation, Migration, configuration, SSIS, SSRS and administration.

Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Log shipping, Always On, Clustering and Mirroring.

Handled multiple SQL Instances on Cluster environment and worked on configuring logical disks and RAID levels (Active/Active and Active/Passive).

Experience in Replication – Snapshot and Transactional replication.

Extensively worked on 32 bit, 64 bit and i64 clustered and standalone server environments.

Experienced in physical, logical database design by using Erwin and VISIO.

Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.

Identifying the bottle necks using SQL Server Profiler and Perfmon.

Experience in performing Online Indexing. Experience with monitoring, troubleshooting related issues.

Expert in implementing business logic by using TSQL, Stored procedures, triggers (DDL, DML) and functions (Inline & Multivalued Table functions.).

Experience in planning and implementing Microsoft SQL Server Security and database permissions

Proficient with database backup and recovery models.

Experience in Backup tools like SQL Safe and LITE SPEED for fast and efficient database backups.

Expert in configuring and using third party tools like IDERA Diagnostic Manager and Foglight

Experience in writing complex T-SQL (DDL, DML, and DCL).

Experience in using Dynamic Management views (DMV) to trouble shoot and improve server performance.

Configuration and Administration of SharePoint Server 2007.

Experience in working with Share Point in MOSS.

Experience with Normalized and de-normalized database design.

Industry working experience in SQL Server and DB2 database management, maintenance, and troubleshooting.

Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert from heterogeneous databases like Oracle, MS Access, and DB2.

Proficient with SQL Server Analysis Services.(SSAS)

Extensively worked on RDBMS concepts to design Relational Database model as per Business requirement

Extensively worked on VMware and Implemented SQL Server 2005/2008/2008R2.

Rebuilding the indexes at regular intervals for better performance.

Extensive experience in using Version control system tools for deploying scripts in various stages of SQL Server.

Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Operating Systems : Windows Server 2012/2008 R2/2003, Azure cloud server.

Databases : MS SQL Server 2016/2014/2012/2008 R2/2005, Oracle, Sybase, MS Access

ETL Tools : DTS (Data transformation services), Integration Services.

Database Tools : SQL Profiler, SQL Query Analyzer, Index Tuning Wizard,CluAdmin.exe, DTS Import/Export, SSRS, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, IP Mon, Lite Speed, TFS

IDERA Diagnostic Manager, Foglight Monitoring Tool, Red gate, CopyStrom Replication Tool, EMC Avamar backup tool.

Data Modeling : ER-Win v 4.0., VISIO

Languages : T-SQL, HTML, XML, C, Microsoft.NET, Java, Python, Power Shell.

Network Topologies : TCP/IP, FTP, SMTP

PROFESSIONAL EXPERIENCE

Sr. SQL Server DBA

Lurie Children’s Hospital Aug2017- Nov2017

Responsibilities:

Installed, maintained and patched the MS-SQL Server 2016,2014,2008R2 ; created, moved, upgraded, and deleted databases; implemented backup and recovery processes; performed routine maintenance on databases; monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views; implemented and maintained security rules and security audits; maintained state of audit readiness; problem resolution.

Deployed and maintained a SQL clustering environment.

Worked on and involved in implementing HA/DR Solution using Always ON and Mirroring.

Created and maintained Always On Availability Groups with Synchronous and Asynchronous Secondary Replicas. Determined time lags in Always On Availability Group Instances.

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery using Third Party tool EMC Avamar SQL Backup Tool.

Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.

Constructed SSIS packages tested and implemented to import-export OLEDB sources.

Analyze clustered/non-clustered index allocation and included columns, and optimization of query plans.

Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Database Engine Tuning Advisor.

Configuring TEMPDB on files and file groups and capacity planning of databases.

Environments:

SQL Server 2016, 2014, 2012 and 2008R2, Windows Server 2012, 2008r2 Power Shell Scripting, EMC Avamar Backup tools, SSIS, Epic System, Visio, Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Sr. SQL Server DBA

The Warranty Group, Chicago, IL Dec 2016-July 2017

Responsibilities:

Installing SQL Server 2016 on Azure Cloud Servers.

Prepared the SQL server configuring all SSL and Encryption with MMC Console and Force Encryption.

Implemented All the Futures available in SQL server 2016 and Build Various Environment: Production Environment, Development and QA Environment. Ability to manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems on windows & Azure platforms.

Configuring, maintaining SQL cluster and troubleshooting all cluster related issues and migrating SQL clusters from lower version to higher versions of SQL server 2012, 2014 and 2016.

Configured Always ON availability groups for HA/DR Solution.

Worked with third Party tool to Replicate and Migrate Data from Sales Force (SF) to SQL using CopyStrom Replication Tool.

Involved in Monitoring and troubleshooting replication issues.

Implemented tight security to SQL server instances, databases by providing least privileges to the users/groups and protecting the database backups by enabling [TDE] Transparent database encryption on sensitive & critical databases. Also, implemented the Row-Level Security (RLS) Keeping Data to its boundary to restrict the access to user to their organization/groups. And used Dynamic Data Masking (DDM) to encrypt the critical data.

Configured Server Memory for maximum Performance and effective utilization.

Configured Temp DB for to increase the performance of SQL Server.

Performing Azure backup & restore from Azure container (Blobs) to SQL database during disaster recovery for DR testing.

Our responsibility is to ensure that the data available on 24*7 without any performance issues. Perform Post Incident Review on major incidents.

Analyze current performance issues to determine trends, provide solutions to increase performance, reliability and connectivity. Expertise in Query Performance & Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs

Applying service packs, upgrades & security patches on both standalone and clustered instances of SQL server.

Hands on experience in using data partitioning/table partitioning on huge tables containing millions of rows for better performance.

Environments:

SQL Server 2016, 2014 and 2012, Windows Server 2012, 2008r2, Azure Cloud servers, New Relic, Power Shell Scripting, Python, CopyStrom Replication tool.

SQL Server DBA

WELLS FARGO Bank, Minneapolis, MN March2015 –October 2016

Responsibilities:

Installed SQL Server 2014/2012/2008R2/2008/2005 on Windows Clustered and standalone environments with latest service packs.

Upgraded SQL server databases from 2000/2005/2008 to 2008R2/2012/2014.

Experience in working and troubleshooting 12TB Very Large databases (VLDB) in OLTP Environment.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 20014/2012/2008R2/2008.

Configured AlwaysON availability groups and mirroring within SQL Server 2012 environment.

Configured log shipping and Mirroring for multiple databases as a part of DR.

Involved in Migrating Database from SQL Server 2005/2008 to SQL Server 2012/2014.

Implemented high availability on the various servers using replication/mirroring.

Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.

Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.

Analyze long running slow queries and tune the same to optimize application and system performance.

Reorganize/Rebuilding the indexes at regular intervals for better performance.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Improve the performance of SQL Queries and stored procedures using SQL Profiler.

Configuring TEMPDB on files and file groups and capacity planning of databases.

Configuring and deploying SSIS packages and SSRS reports.

Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).

Data migration using DTS services across different databases like Oracle, MS access & flat files.

Contacted various users in gathering the requirements and documented the necessary changes.

Environment:

SQL Server 2014, 2012, 2008R2, 2005, Windows 2012,2008 R2, 2003 Server, Symantec net backup, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler, REMEDY.

ENSOCARE, Omaha, NE Dec 2013 – Dec2014

Senior SQL Server DBA

Responsibilities:

Managed multiple servers in Production, Development and QA environments.

Installed configure SQL Server 2012/2008 R2/2008 on windows 2008 R2 environment.

Worked on 32 bit, 64 bit clustered environments.

Worked extensively on SQL Server 2008 R2 Transactional Replication.

Configured logical drives and RAID levels Using HP Array Configuration Utility.

Involved in Monitoring and troubleshooting replication issues.

Configured Server Memory for maximum Performance and effective utilization.

Configured Temp DB for to increase the performance of SQL Server.

Monitoring SQL server performance using profiler to find performance and deadlocks.

Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization

Involved Design, Troubleshooting and Deployment of SSIS packages

Migrated DTS packages to SSIS packages

Involved in deploying XMLA scripts to SSAS and also maintained the security of SSAS databases.

Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.

Refresh the Production databases to DEV and QA environments for new releases.

Used Dynamic Management Views (DMV) for monitoring the performance of the server

Used Change Data Capture (CDC) to audit DML and DDL Operations on various tables.

Used new security feature called AUDIT in SQL 2008 R2 on both server level and database level

Worked with CONFIO IGNITE Tool by setting up alerts for the Monitors of various SQL Servers

Worked and generated reports using SQL Server 2008 R2 Reporting Services (SSRS)

Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner

Maintaining the database consistency with DBCC at regular intervals

Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Created Maintenance Plans that helped in effective disk utilization and index maintenance.

Effectively managed disk space using LITE SPEED for Data base Backups

Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.

Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.

Worked in JIRA ticketing system and resolved tickets ranging from P1 to P4.

Environment: Windows 2008 R2/2012, MS SQL Server 2005/2008/2008R2/2012/2014,MSCS,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, Clustering, Mirroring, Log Shipping

CITIZENS Bank, Tallahassee, FL June 2012 – Dec 2013

Senior SQL Server DBA

Responsibilities:

SQL Server Database Administrator

Installed SQL Server 2012/2008/2008 R2/2005 on windows 2003/2008 environment.

Worked across 90 servers and more than 200 databases with OLTP Database Size 13 TB.

Managed Servers in Clustered, Mirrored and Log Shipped Mode

Worked extensively on SQL Server 2008 R2 Transactional Replication.

Configured logical drives and RAID levels Using HP Array Configuration Utility.

Involved in Monitoring and troubleshooting replication issues

Configured Server Memory for maximum Performance and effective utilization.

Configured Temp DB for to increase the performance of SQL Server.

Monitoring SQL server performance using profiler to find performance and deadlocks.

Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization

Involved Design, Troubleshooting and Deployment of SSIS packages

Migrated DTS packages to SSIS packages

Involved in deploying XMLA scripts to SSAS and also maintained the security of SSAS databases.

Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.

Refresh the Production databases to DEV and QA environments for new releases.

Used Dynamic Management Views (DMV) for monitoring the performance of the server

Used Change Data Capture (CDC) to audit DML and DDL Operations on various tables.

Used new security feature called AUDIT in SQL 2008 on both server level and database level

Worked with IDERA Tool by setting up alerts for the Monitors of various SQL Servers