Sql Server Database Administrator
Current•Planning the installation of Microsoft SQL Server Configuration, Upgrade, Migration & application of Windows, SQL Patching during scheduled database downtimes after hours to ensure databases are up to date in virtualized environments. •Migration from on-prem to cloud using DMA, Backup & restore...•Deploy, configure Azure VM, VN & RG.•Utilize Azure Monitor and Azure Log Analytics to proactively monitor database health and set up alerts for critical incidents.•Managed Azure Active Directory, including user access, permissions, and group policies.•Experience in Performance Tuning, Query Optimization, using Performance Monitor and other related monitoring and troubleshooting tools.•Experience in troubleshooting database integrity, performance, blocking & deadlocking, replication, log shipping, connectivity, security issues...•Implementing Security following best practices and standards.•Ability to detect & troubleshoot SQL Server-related CPU, memory, I/O, disk space, other resource contention & database connectivity.•Use Redgate SQL Monitor & in-built tool to manage and monitor SQL databases and servers.•Performed in-place upgrade and, then Side by Side for new applications in the Company.•Create and maintain database documentation about company standards procedures, technology features, production troubleshooting issues and business reports for prompt communication.•Set up Azure Site Recovery for Virtual Machines backups for Disaster Recovery.•Participation in on-call rotation to provide 24/7 support for critical database issues & emergencies and maintain business up.•Worked independently as a technical team member and also assisted in mentoring other team members.•Developed technical subject matter expertise on business application systems and identified requirements and made technical recommendations based on industry best practices.•Proficiency in working with vendors to implement technical solutions and diagnose database malfunctions.