Home


Name                          : Anurag Dobade

Career Summary    :  12 Years

Level                         : Senior Consultant 


PROFESSIONAL EXPERIENCE:

3. PayTabs Global [ Jan 2022 – Present ]
Database Administrator 
Clients: Saudi Arabia
Environment: SQL Server on Linux, Multi-Cloud, MySQL [Azure, Huawei, Raya]

 Responsibilities:     


  • Installation & configuration of SQL Server for Supporting SDLC role in App Development, QA, Staging, Testing & Production Env.
  • Have good understanding of SQL Architecture & Database Best Practices.
  • Experienced working with Multi - Cloud Vendors including Azure, DETASAD Cloud, Huawei Cloud, Orange Cloud, Raya Cloud, SQL RDS & AWS Servers.
  • Migrated SQL Server Databases from OnPremises [Windows Server/Azure/RDS] to Ubuntu Linux for Reducing Operating Costs as per requirements & handling all the activities including, CU Patching, DR - DRILL, Clusterless / Clustered AlwaysOn with Log Shipping & maintenance of SQL Server Databases in Linux Systems.
  • Implementing change & Performing Quarterly activities of RDS SP upgrades, Patch Upgrades, & Yearly Planned DR - Drill, PCI Audits of Databases. Also stopping of VM Servers of Pay-As-You model to save Costs as requested.
  • Have experience working with Incident, Problem, Capacity, Patch Management, Change Management & Supplier Management Teams for handling many issues/incidents & daily activities in Production.
  • Experience in implementing SQL Servers in Linux environment, configurations, online/offline package installation, applying best practices and implementing High Availability feature like CoroSync Cluster, Clustered & Clusterless Always On, Log Shipping on Linux Server & Managing DR-Drills, CU Patches in Linux.
  • Experience in MySQL, Master/Slave Replication, SQL Server Failover Cluster, Always On, Database Mirroring, Log Shipping & Replication.
  • Implementing and managing permissions for Roles, Logins, Contained Users, Schemas.
  • Good knowledge of T- SQL Queries, DML, DDL, CTEs, Cursors, Temp & Table Variables, Views, Stored Procedures.
  • Experience in Performance Tuning, Indexes, Recompiling Procedures & optimization using Execution Plans & Troubleshooting Wait Types of High-CPU Usage, IO, Memory, Network Latencies & Capacity Planning.
2. Clover Infotech [ April 2018 – Jan 2022 ]
SQL SERVER DBA 
Clients: Mumbai [ KOTAK Bank , IIFL, SUD, Edelweiss ]
Environment: SQL Server on Premises, Azure Cloud

TECHNICAL SKILLS

Database

MS SQL 2000,2005,2008,2012 ,2014 ,2016 and 2017, 2019

Database Tools

SQL Enterprise manager, Management Studio , Profiler,

Performance Monitor.

Operating Systems

Windows 2008 Server, Windows server 2012 , Windows server 2016

MS SQL Supporting Technologies

MS SQL Log Shipping, Mirroring, Replication, Clustering, Always on and Performance Monitoring.

    

Role:

Independently handling Clients Site technically and operations wise in executing work related to database management. 


MS SQL SERVER EXPERTISE SUMMARY

  • 7+ Years of experience as SQL Server Database Administrator

  • Manage all clients , prepare roster for team and co-ordinate with team & client

  • Experience in Installing, configuring, managing and troubleshooting of SQL Server 2005,2008,2008 R2 ,2012,2014 and 2016

  • Experience in Security(Creating logins & users and assigning the Permissions)

  • Experience in resolving the orphan logins

  • Implementing the various types of backup plans depending on application size on requirement

  • Experience in configuration and troubleshooting SQL Server High-Availability data solutions Clustering, Always-On, Log shipping, Mirroring and Replication

  • Experience in handling large size of production Database over 2 TB and providing 24/7 production support for Database and Application

  • Experience in resolve Dead Locks/Long Running Queries and Blocking

  • Experience on SQL Server Performance tuning

  • Experience in recovering the crashed/suspect database.

  • Experience in working with startup parameters

  • Experience in configuring Schedule Tasks, SQL Jobs (maintenance plans) and Alerts

  • Experience in Migrations, Upgrades of SQL Server Upgrades (from SQL Server 2000 ,2005 ,2008R2 to 2012,2014,2016)

  • Experience on SQL Server database Administration activities like providing  Database security, transaction of Log File full issues, Shrinking DB/ file activities, Configuring DB mail, Automation of sending Mails when DB Blocks occur, Tracking Database file growth

  • Experience in configuring SQL Server Indexes. Creating Indexes for enhancing the performance when require

  • Experience on applying Service packs/Hot Fixes/Cumulative Update

  • Experience in DBCC commends.


TECHNICAL EXPOSURE:

Database: MS SQL Server 2000,2005, 2008, 2008 R2, 2012,2014,2016 and 2017.

Database Tools: SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Profiler, Database Tuning Advisor, SQL Server Business Intelligence Development Studio, Reporting services configuration Manager, SSRS,SSIS

Programming Languages: T-SQL

Operating System: WINDOWS SERVER 2003/2008/2008R2/2012/2012R2/2016.

PROFESSIONAL EXPERIENCE:

 PROJECT: - 1    

Client Name :   Edelweiss , SUD Life Insurance

Duration    : May 2018 to Jan 2020

Position   : Primary Consultant ( MS SQL DBA) 

Environment : SQL Server 2008/2012/2014/2016/2017

Team Size   : 5

Roles and Responsibilities                                                    

  • Team lead, Handled Team of 5 Members.
  • Installing and  Configuring SQL Server, including service pack deployments
  • Maintenance and Administration of databases with respect to performance, accessibility, availability and security
  • Configuring automated data backups through Jobs/Maintenance Plans and configuring alerts & operators
  • Configuring and troubleshooting SQL Server High-Availability data solutions Clustering, Always-On
  • Configuring and implementing disaster recovery plan & Backup policy
  • Working on SSIS packages for Data migration purpose and db maintenance plans
  • Monitoring the Disk Space of all the Servers and maintain Disk space on the drives above threshold.
  • Maintaining the Indexes by checking fragmentation percentage and running the Defragmentation procedure
  • Generating Query Execution plans. Analyze and send the report for better Execution plan to enhance the performance
  • Tuning objects, queries to improve the response time and Optimization of server performance
  • Monitoring SQL Server performance through performance monitor to find bottlenecks and diagnose potential problems
  • Applying Service packs/Hot Fixes/Cumulative Update
  • Resolving tickets and sending feedback
  • Recovered Suspect\corrupt  Databases
  • Involved in trouble shooting cases where the Log file full and tempdb full
  • Involved in resolving Blocking and Dead lock performance issues
  • Configuring SQL Backups through Maintenance Plans/Jobs and Alerts using Database Mails for Jobs and Checking SQL full backups, and re-run and troubleshoot if failed
  • Managing SQL Server level and Database level security by Creating SQL Logins with appropriate roles
  • Configuring and troubleshooting SQL Server High-Availability data solutions Clustering and logshipping
  • Creating DB users and assigning roles for data access, Creation of Windows Users and groups and granting the privileges
  • Migration of databases from SQL Server Lower version to SQL Server Higher versions
  • Regular checking of the database consistency using DBCC commands and fixing suspect  pages issues when found.
  • Back up master & system databases and restoring them when necessary
  • Configuring alerts SQL Server (Services, Disk spaces) 
  • Giving support to the client and provide knowledge Transfer sessions at the client’s place
  • Monitoring SQL Server performance through performance monitor to find bottlenecks and diagnose potential problems
  • Closing all the points related to audits
  • Applying Service packs/Hot Fixes/Cumulative Update

PROJECT: - 2

Client Name :  IIFL Securities

Duration    : Jan2020 to Dec 2021

Position   : Primary Consultant ( MS SQL DBA) 

Environment : SQL Server 2008/2012/2014/2016/2017

Team Size   : 8

Roles and Responsibilities     

• Analyze Long Running Queries and find root cause of slowness to optimize application and system
performance.
• Experience in capturing useful information from Buffer using DMV’S
• Capturing wait types of queries and performing their fixes.
• Hands on experience of analyzing query Execution Plan and improving for better performance.
• Creating Effective Indexes as per analysis of execution plan for better performance.
• Configured Trace and Perfmon on live server to capture deadlocks and to collect resources utilization stats.
• Re-indexing/Rebuilding of Table Indexes to improve performance & reduce fragmentation.
• Involved in capacity planning and providing necessary recommendations to client.
• Trouble shooting blocking, space issues and slow running queries.
• Movement of tempdb to faster drive and user databases from one drive to other.
• Involved in Table Partitioning for more than 2 TB of table and managing to optimize queries.


Preparing Monthly MSR & Performance Documents For:
✓ Server Configuration Parameters
✓ System Study Overview
✓ Server Health Check CPU, Memory, IO etc
✓ Duplicate Indexes document
✓ Unused Indexes
✓ Missing Indexes
✓ New Index Suggestions
✓ Heap & Archive Tables
✓ Maintenance Plans (Statistics, Index Rebuild/Reorganize)


1. Sony Infosys[ Feb 2010 – Apr 2015]
Hardware & Network Engineer
Clients: Nanded
Environment: Windows 7, XP, Windows Server 2000, MicrosoftOffice

 Responsibilities


•Installing Windows XP,Vista,Windows7 on DOS desktop/laptops & Updating Windows SP,  Migrating Win ME/ WinXP to Windows 7 without user data loss.
•Fixing missing drivers, Microsoft Office 2000/2003 to 2007 upgrade,Tally, Photoshop, Pager,Antivirus. Sharing Drives,Printer,Scanner in LAN.
•Improving Performance by Disk Fragmentation & Upgrading RAM, CPU Cores.
•Attaching Phone & Modem Card,Infrared,Bluetooth,Internet,Graphics Card,TvTuner.
•Assembling or building computer from different parts as per requirements.
•Resolving OS Startup using Hiren's Boot, BSOD,Auto Restart/Shutdown, Virus corrupt system files, Lost login password, Linux/windows multiple OS bootup etc
•Replacing RAM,CMOS Cell, Floppy, DVD lens, Recovering damaged Hard Disk.
•Configuring System for Training Institutes[School Lab, MS-CIT, Typing, GTA Gaming/Internet Cafe], VGA./HDMI for One CPU Multi-User(Client-Server). 


EDUCATION
  • Completed BE Comp. Science  from SRTMU University.


ACHIEVEMENTS  

  • Implemented Always on , Cluster as HADR in PROD environment.
  • POC for Cloud Migrations

CERTIFICATES 


Post a Comment