Name : Anukshya Das
Email : danukshya AT gmail.com
Designation : Senior System Engineer (MS-SQL SERVER DBA) G
Objective :-
To be a part of an organization which offers me an opportunity to continuously learn, evolve myself and contribute for organization, such that my growth is linked to that of organization and to be an asset to the organization.
Expertise Summary :-
** IT Professional with 4.3 years of experience in SQL Database Administration.
** Experience in installation of different version of SQL SERVER (2016,2014,2012, 2008R2/2008/2005).
** Played a major role in database maintenance, Security and upgrading.
** Troubleshooting of High Availability & Disaster Recovery techniques like always on Availability Groups(Backup and Restore), Database Mirroring, and Log Shipping, Replication.
** Daily routine DBA tasks like handling user's permissions and space issues on Production and Development Servers and handling maintenance Jobs.
** Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2, 2012,2014,2016.
** Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases and databases Maintenance.
** Monitoring different servers including backup, disk space, Job failures, connectivity.
** Hands-on experience in resolving lockings, deadlocks and performance issues like CPU, I/O, Memory bottlenecks.
** Performing regular backup and restore operations whenever required.
** Adept at proving database troubleshooting issues like Locking, Blocking and Deadlocking, fail over maintenance and database recovery.
** Extensively used tools like Spotlight,SQL Profiler for monitoring performance issues.
** Experience in creating Jobs, Alerts.
** Handled numerous Change Management requests on production servers and Supported 24 X 7Production
Work History :-
** I have one year experience in Infosys and currently working with Wipro Technologies from September 2016 to till date.
** I have done PGDM project on TAX Management and learn many new things.
Qualification :-
** B.Sc(I.S.T) from Ravenshaw University.
** H.S.C from State Board in 2010.
** S.S.C from State Board in 2008.
** PGDM(Supply Chain and Management) in 2019
Technical Exposure :-
DBA Skill : Database Administration of MS SQL Server 2005,2008,2008R2,2012,2014
Programming : T-SQL.
Operating System : Windows XP, Windows Server 2008/2008 R2/2012
SQL Server Tools : Management Studio, Enterprise Manager, Profiler, Performance Monitor, SSRS, Microsoft Clustering Services (MSCS), SSIS
Network Topologies : TCP/IP.
Database Utilities : Spotlight
Ticketing Tools : Service Now and BMC Remedy,cherwell
Professional Experience :-
Project Experience :
Client : Royal DSM, Harte Hanks, McClatchy,Ingredion,NiSource
Team size : 5,6
Role : SQL Server DBA
Environment : SQL Server 2000/2005/2008/2008R2/2012/2014 On Windows server 2007/2008R2
Duration : Nov 2016 to till date
Employment : Permanent
Job Responsibilities :
** Working as an IT Production support person helping the end users in solving the problems faced by them.
** Monitoring nearly 300 servers and analyzing the databases size ranging from 2GB to 14TB
** Installing SQL Server 2005, 2008 and 2008R2 on windows environment and applying patches.
** Performed DBA Tasks which included checking the job fails and troubleshooting the issues.
** Providing disk spaces by reducing the size of files.
** Identifying the Blocking issues and kill the processes according to the clients discussion and their suggestion.
** Setting up security on server level, database level and object level.
** Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e.
purging older Backups, unused Files etc.
** Extensively involved in giving access rights in database level, Objects level and column level as per requirement.
** Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
** Developing, implementing and administering database policies and procedures and provide technical support and assistance to all database end-users.
** Making documentation which we are implementing new tasks in our environment.
** Providing 24/7 Supports for Production, Development & Test Servers of MSSQL Servers.
** SQL server Installation, Patch maintenance and up gradation.
** Checking specific backup and restoration files are storing specified drives are not.
** Database refreshes from production backup to Stage, test and Development environments.
** Checking the database data file and log file is located specific drive and observe the available free space.
** Checking Alerts and resolve issues to take appropriate action as need.
** Managing Security of the Database.
** Implementation of SQL Logins, Roles and Authentication Modes.
** Checking Fragmentation and Resolving Fragmentation issues.
** Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio and SQL Server Agent.
** Rebuilding the indexes at regular intervals for better performance.
** Migration of database from SQL server 2008R2 to SQL server 2012.
** Performing Refresh activities.
** Creating Databases, logins, users and giving appropriate roles and permissions
** Managing space for data files and log files.
** Providing 24/7 Supports for Production, Development & Test Servers of MSSQL Servers.
Personal Details :-
Date of Birth (DOB) : 20/06/1993
Alt-Email id : anutriveni2009 AT gmail.com
Date :
Place :