Database Expert - Large Scale Oracle Databases on Cloud

1. Bachelors degree in Computer science and Engineering
2. Minimum of 10+ years of experience on working with Oracle Databases on large production database fleets, with a strong focus on automation and cloud database management.
3. Extensive experience working with Oracle databases in cloud environments (AWS, Azure, Oracle Cloud) with a focus on automation, provisioning, and management.
4. Expertise in Oracle database features including Oracle RAC, Backup and Recovery, Data Guard, and GoldenGate, with a focus on automating high availability and disaster recovery setups especially in enterprise database environments with Terabytes of data.
5. Oracle certifications (e.g., Oracle Certified Professional (OCP), Oracle Cloud Infrastructure Architect).
6. Familiarity with containerized environments (Docker, Kubernetes) for deploying Oracle databases in cloud platforms.
7. Experience with Oracle Exadata and other high-performance Oracle database environments
8. Strong expertise in Oracle database management, including installation, configuration, tuning, and troubleshooting.
9. Proficiency in SQL, PL/SQL, Java and shell scripting (e.g., Bash, Python, PowerShell) for automation purposes.
10. Deep knowledge of cloud platforms (AWS, Azure, Oracle Cloud) and their native database offerings (e.g., AWS RDS, Oracle Autonomous Database, Azure SQL Databas

Key responsibilities :

1. Architect, deploy, and manage large-scale Oracle database environments in cloud platforms (AWS, Oracle Cloud, Azure).
2. Design and implement database architectures that ensure high availability, fault tolerance, and disaster recovery for mission-critical databases.
3. Architect and implement cloud-based Oracle database solutions with a focus on automation, high availability, disaster recovery, and performance tuning.
4. Manage cloud-native Oracle services such as Oracle Autonomous Database, Oracle Exadata Cloud Service, and AWS RDS for Oracle, including automation of their setup and management.
5. Continuously monitor and optimize cloud-based Oracle databases for performance, cost efficiency, and scalability using cloud-native monitoring tools (e.g., CloudWatch, Azure Monitor, OCI Monitoring).
6. Automate routine DBA tasks including provisioning, patching, backups, and security updates to minimize manual intervention and improve operational efficiency.
7. Automate security and compliance checks for Oracle databases, including encryption, access control, and auditing.
   Implement automated security patches and vulnerability remediation in cloud environments.
8. Ensure databases comply with industry standards, data protection regulations (e.g., GDPR, HIPAA), and organizational policies through automation.
9. Set up automated notifications and remediation processes for performance degradation, security breaches, or other incidents.
10. Create dashboards and reports to provide visibility into database health, performance, and cost efficiency.