Database Administrator (SQL & Azure)

Continuously monitor database performance using Redgate SQL Monitor, Azure Monitor, Query Store, and Extended Events. 

Identify and optimize slow-running queries through indexing, query tuning, and execution plan analysis. 

Evaluate and fine-tune automatic tuning options (e.g., force last good plan, auto-index management). 

Ensure automated backups (point-in-time recovery, long-term retention) are configured and tested. 

Implement and maintain High Availability (HA) and Disaster Recovery (DR) strategies using Azure Auto-Failover Groups and Geo-Replication. 

Manage database user access and permissions following least privilege principles. 

Regularly audit database security and firewall rules. 

Review and address issues identified in Azure Vulnerability reports. 

Monitor for suspicious activity using Azure Defender for SQL. 

Ensure compliance with regulatory requirements such as GDPR, HIPAA, and company policies. 

Monitor and manage database size growth, archiving historical data and purging obsolete records. 

Perform index maintenance (rebuild/reorganize based on fragmentation levels). 

Update statistics for efficient query execution. 

Identify and deprecate unused or outdated database objects. 

Respond to database alerts and performance degradation issues. 

Investigate and resolve blocking, deadlocks, and long-running transactions. 

Collaborate with developers to troubleshoot and optimize application-database interactions.