Education Qualification :
Any Graduate (Engineering / Science)
Skills :
Primary -> Technology | Implementation and Integration, upgrade, troubleshooting, DR, Log shipping | 4 - Advanced
Secondary -> Technology | On-Prem OS, Hypervisors . HCI Infrastructure , Implementation and Integration, DNS DHCP | 3 - Experienced
Secondary -> Technology | Monitoring solutions , Backup and Recovery | 2 - Knowledgeable
Certification :
Technology | Microsoft Certified: Azure Database Administrator Associate
Microsoft SQL Lead/SME with experience on installing, configuring and migrating databases
- Experience in Planning, Installation, Configuration of various old SQL Server versions on windows and Linux OS platform to N/N-1 version.
- Good experience on configuring Always On high availability on both windows and Linux operating system along with cross platform high availability configuration experience.
- Migrating SQL Databases from On-prem to Cloud, configure Geo-replication for High availability, manage database on Elastic pools and Manage inst
- Good experience in designing & implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping.
- Experience in identifying and defining atuomation using power shell scripting to automate the SQL tasks and jobs and Pulling day to day reports by using power shell scripts.
- Experience in ETL and data movement between excel, flat file, RDBMS like SQL Server using Bulk Insert, BCP utility, DTS and a variety of SSIS packages including custom transformations
- Experience in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex. Query Tuning, Server Tuni.ng, Disk Performance Monitoring, Memory Pressure and CPU bottleneck)
- Handling locking, Blocking & Deadlock Scenarios.
- Experience on Automation of SQL Server (Jobs, Alerts) and verifying that all scheduled Jobs have run successfully.