add photo
Ratnesh
ratnesh.k.khandelwal@gmail.com
732-603-1224
Morris Plains, NJ 07950
Senior MS SQL Server DBA
14 years experience W2
0
Recommendations
Average rating
206
Profile views
Summary

  • Nine+ years of IT experience in Database Administration, System Analysis and Design, Development and Support for MS SQL Server.
  • Expertise in Managing PRODUCTION Databases on MS SQL Server 2019/2017/2016/2012 in VIRTUAL and PHYSICAL environments.
  • Managed MS SQL Servers in High Availability and Disaster Recovery environments
  • Provided 24/7 and on-call Support for PRODUCTION environment
  • Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization.
  • 4+ Years' experience in setting up Always ON Availability groups.
  • Managing Virtual Machines in IAAS & PAAS, supporting max size of 4 TB hosted in Microsoft Azure.
  • Expert in Migrating On Premise SQL Databases to SQL Azure using DMA & DMS (Offline & Online).
  • Having experience in configuring Virtual machines using Azure portal.
  • Having experience in creating the alerts for VMs using Azure Portal.
  • Reviewing the Activity logs and troubleshooting the errors.
  • Having knowledge on configuring managed disks and un managed disks in Azure.
  • Configured Log Analytics for Virtual Machines and SQL AZURE Pass databases.
  • Having knowledge on storage accounts and storage replications.
  • Experience in moving on premises MS SQL Server databases to Azure using bacpac files.
  • Experience in creating the database maintenance tasks using Azure Automation.
  • Experience in working with Azure SQL Database Import and Export Service.
  • Experience in working with Point in time restores in Azure.
  • Configured Long Term Retention (LTR) backups for Mission critical databases.
  • Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool.
  • Creating logins, users and assigning the permissions to the users in Azure.
  • Configured Active Geo Replication, Failover Groups using Azure portal.
  • Monitoring the alerts using the Operations Management Suite (OMS) in Azure portal.
  • Expertise in ACTIVE/ACTIVE and ACTIVE/PASSIVE Clustering.
  • Experience in implementing Disaster Recovery and High Availability Solutions using Database Mirroring and Log Shipping.
  • Hands on experience in Backup and Restoration of databases, Automating Administration and Security maintenance.
  • Performed Capacity Planning, Data Modeling and Logical/Physical database design.
  • Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures.
  • Configured and maintained Transactional and Snapshot replication.
  • Estimated disk storage requirements for database software, files & database administration needs.
  • Monitored the database server performance and if required and tuned, if required TSQL queries, Stored procedures etc.

Experience
Education
not provided
Skills
Database Backups
2022
10
DBA
2022
10
SQL
2022
10
SQL Server
2022
10
Disaster Recovery
2018
6
Triggers
2018
6
Data Security
2018
5
SSRS
2018
5
Compliance
2022
4
Data Replication
2022
4
MS Azure
2022
4
Performance Tuning
2013
1
Production Support
2013
1
VMWare
2013
1
Data Modeling
0
1
Database Design
0
1
Stored Procedure
0
1
System Analysis
0
1