SQL Database Administrator

Key skill requirement (Mandatory) :

• Install, configure, and maintain SQL / MySQL databases.
• Monitor database health, including storage, indexing, fragmentation, and performance.
• Perform regular backups, restores, and disaster recovery (DR) planning.
• Analyse and optimize SQL queries, stored procedures, and indexing to improve performance.
• Investigate and resolve deadlocks, blocking, and connection issues.
• Troubleshoot and Perform root cause analysis (RCA) for database performance issues.
• Monitor CPU, memory, disk I / O, and query execution plans to identify bottlenecks.
• Configure SQL Server Profiler, Extended Events, and Performance Monitor for troubleshooting.
• Develop PowerShell / Python scripts or SQL Server Agent Jobs for automating routine tasks

ref : hirist.tech)