I am excited to respond to your freelance offer for implementing automated health checks for your Oracle databases. I'm thrilled to share that I already have a complete and ready-to-deploy solution available for your servers. This solution covers all the parameters mentioned in your offer:
Disk Space: Early warnings for low space and utilization trends.
Network Connectivity: Verification of inbound/outbound connections, latency, and potential failures.
Query Performance: Identification of slow queries, execution analysis, and potential optimization.
Backup Status: Confirmation of successful backups, integrity checks, and alerts for any anomalies.
My solution is developed in Ansible, ensuring its portability and easy maintenance. I have extensive experience using Ansible to automate complex tasks in heterogeneous environments, including Oracle databases on both Windows and Linux platforms.