Key Responsibilities :
Database Performance & Optimization :
- Performance Tuning : Perform advanced SQL tuning, indexing, partitioning, and query optimization to ensure peak performance.
- Troubleshooting : Use Oracle's advanced tools like AWR, ASH, SQL Profiles, and SQL Baselines to efficiently troubleshoot and resolve performance issues.
- Configuration : Optimize memory, CPU, and storage configurations for specialized environments like Exadata, Oracle RAC, and cloud platforms.
High Availability & Disaster Recovery :
Data Protection : Maintain and manage Data Guard, Oracle RAC, and RMAN-based backup / recovery strategies to ensure business continuity.Disaster Recovery : Implement and test zero-data-loss disaster recovery using Flashback Technology and Snapshot Standby. Conduct regular DR drills and failover testing to ensure compliance.Security : Secure the database using technologies like TDE (Transparent Data Encryption) and robust database auditing.Automation & DevOps Integration :
Monitoring : Use Oracle Enterprise Manager (OEM) Cloud Control for comprehensive database monitoring, alerting, and performance management.Scripting : Develop and manage automation scripts using Shell scripting and Ansible for various operational and administrative tasks.Incident Management : Use tools like ServiceNow and Jira to track and manage requests and incidents efficiently.Required Skills & Experience :
10+ years of relevant experience in Oracle Database administration.Databases : Expertise in Oracle 19c, with hands-on experience in Active Data Guard, Oracle Real Application Cluster (RAC), and Automatic Storage Management (ASM).Cloud Platforms : Experience with cloud environments like Oracle Cloud Infrastructure (OCI) and AWS RDS for Oracle, as well as Exadata Cloud Service (ExaCS).Scripting : Strong proficiency in SQL, PL / SQL, Shell Scripting, and Ansible.Tools & Competencies : A deep understanding of Performance Tuning methodologies, and familiarity with monitoring tools like Oracle Enterprise Manager.Security : Knowledge of TDE and Database Auditing.AI / ML : A basic understanding or exposure to AI tools would be a plus.(ref : hirist.tech)