mohit paidikondala

Hi , This is MOHIT.i have 1.5years of experience as a SQL Server dba.
currently working with VALUELABS.

Currently i am working for a project THE HOME DEPOT,USA.

i am working on activities like...

Installation of SQL server,
configuring databases,
taking backups and restores
creating and managing the users
working on performance issue,
and working oh High availability technilogies like log shipping anf mirroring and clustering and always on
and also working on upgradation and migration activities.

currently we are 8 member team and working in 24/7 support.

i worked on versions like  2012,2014 and 2017 and 2019.

My Day to Day responsibilities are resolving tickets (both incidents and change request) which includes.
Installation, Configuration and Administration in different versions like SQL Server 2012,2014,2017,2019.
Applying SQL Server patches, Cumulative packs and hot fixes.
Verifying  and resolving the SQL Server Blocking and Dead lock issues and Finding  and fixing the root cause
Resolving the Disk space issues and finding the root cause and implementing the permanent fixes.
Taking Full, differential and log Backups and restoring them when required
Refreshing the Test Databases from Production Data on need basis for Testing purpose.
Performing security activities like Creating logins, adding the users and managing the permissions.
Creating and scheduling the jobs and troubleshooting the failed jobs.
Performing Database Maintenance Activities like rebuilding/reorganizing indexes, update statistics, checking database integrity and clean up history on regular intervals.
Resolving Space Management issues like TempDB contention, Data and log file space issues.
Configuring and Troubleshootinghigh availability solutions like Log Shipping, Database Mirroring and  Replication.
Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2000,2005,2008R2
Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.
 

My Day to Day responsibilities are resolving tickets (both incidents and change request) which includes.
Installation, Configuration and Administration in different versions like SQL Server 2012,2014,2017,2019.
Applying SQL Server patches, Cumulative packs and hot fixes.
Verifying  and resolving the SQL Server Blocking and Dead lock issues and Finding  and fixing the root cause
Resolving the Disk space issues and finding the root cause and implementing the permanent fixes.
Taking Full, differential and log Backups and restoring them when required
Refreshing the Test Databases from Production Data on need basis for Testing purpose.
Performing security activities like Creating logins, adding the users and managing the permissions.
Creating and scheduling the jobs and troubleshooting the failed jobs.
Performing Database Maintenance Activities like rebuilding/reorganizing indexes, update statistics, checking database integrity and clean up history on regular intervals.
Resolving Space Management issues like TempDB contention, Data and log file space issues.
Configuring and Troubleshootinghigh availability solutions like Log Shipping, Database Mirroring and  Replication.
Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2000,2005,2008R2
Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.