Oracle DB Healthcheck Automation via Ansible

Hello. I've been working with Oracle from 2001. I know Oracle DB on Linux/Windows. I've been installing and working with ansible in past. You can check my experience on LinkedInt => [login to view URL] I know how to create such playbook in Ansible.

Hello, I have 10 years of experience in Oracle DB. I will create Ansible automation to do regular health checks on given parameters. Regards, VishnuLal

Hello I can write and deliver the playbook in 2-3 days max please message me thanks I will provide working playbook after local testing , Please explain your configuration so i can replicate

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.

Installed and configured Oracle databases and MYSQL for development, Test and Production environments on multiple environments using manual and DBCA method Administrating Oracle databases (10g, 11g ,12c and 19c) on Linux platforms. ImportinG FILES TO MYSQL databases. Performing Re-org for better performance and optimization of space. Monitored & troubleshoot all database issues in Standalone and RAC environments. Set up database users, manage database permissions and setup database roles. Experienced In 12c multi-tenant databases. Creation of DB Links and granting privileges as per requirement to users to access other databases. Good experience in User Management, Privilege Management, Space Management. Implement and maintain Oracle Dataguard Physical and Logical standby databases for disaster recovery. Good experience on RMAN configuration and performing RMAN Backup, Restore and recovery. Performed database refreshes and database cloning Knowledge and Experience on applying Patch. Knowledge on UNIX Scripting (Used to write shell scripts & implemented Using cronjob for day to day activities. Good experience on Database and schema level refreshes as well as object level export/import using both data pump as well as traditional export. Good experience on configuring alert monitoring for both Standalone and RAC environments using crontab.

Hello, I'm excited about the opportunity to work on your project requiring extensive experience in Infrastructure automation, monitoring IT systems. I believe my skills align well with your requirements, and I am confident in my ability to deliver a high-quality solution. Please feel free to reach out if you have any questions or if you would like to discuss the project in more detail. Thank you for considering my bid.

My name is Samuel and I'm a database expert. Currently my main job is to develop solutions using code, to deliver the infrastructure as a platform, using ansible, terraform, crossplane, golang, among others. I made a code recently to apply psu patch in the oracle doing several validations with ggs, dbhome, etc... I am available to help you

I can help in this. Have done the same for one my client. Experienced in Oracle DB and latest versions.

Industry standard Ansible Roles instead of basic playbooks will be developed for different OS environment