Senior Technical Specialist - System Database (DA1)

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.