Abhishek Nair

SQL Server DBA at TATA Consultancy Services

• India - Chennai
• My current job since February 2014

Team Size: 12
Database: SQL Server 2008 R2, 2012, 2014, 2016
Responsibilities:
•Proactively monitored the database health through automated scripts.
•Monitoring database alerts using Idera and Pagerduty.
•Participate in implementation of new QA and Production releases.
•Enforce Database Security by Managing user privileges and roles
•Worked on restoring of databases from Production to lower environments.
•Scrubbing data in lower environments to secure PII/NPPI data.
•Supported daily data load to Microsoft APS Server and fixed job failures.
•Worked on Partitioning huge data warehouse tables to replace traditional archiving process.
•Hands on experience on Control-M tool for monitoring jobs status and fixing the failures.
•Reviewed scripts to detect poor database performance, collecting required information, and root cause analysis.
•Designed and created databases, tables, views, store procedures and triggers.
•Rebuilding indexes at regular intervals for better performance.
•Fixing corrupted databases by restoring data from recent backup files.
•Monitored and modified Performance using execution plans and Index tuning.
•To analyze long running slow queries and tune the same to optimize application and system performance.
•Deploying new code base release to UAT and Production Environments.
•Export or Import data from other data sources using Import/Export SSIS.
•Worked with DBCC commands and Dynamic Management Objects.
•Solving the Bugs reflected by the Development and Testing team.
Role: SQL Server