SAP BASIS L2 Consultant

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Installation / Upgradation / Migration of SQL Servers Apply any patches or service packs for SQL Server Configure High Availability/Disaster recovery solutions Configure automated alerts to send a mail to team if any issues Work on incidents, change tickets and problem tickets Setup Maintenance plans for Backups, Database integrity check, rebuild index and Update statistics and make sure to run all the jobs without any issues Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents Work closely with application developers to test, configure, and optimize servers based on application demands Handle database object deployment to Integration, QA, UAT, and Production Provide day to day support of high OLTP HA of SQL Server databases- Identify root causes of production problems and work with developers to resolve such problems Work on performance tuning like creating missing indexes Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes Assist developers with complex query tuning and schema refinement. Provide 24x7 support for critical production systems