Job Summary:
We are seeking an experienced Oracle Database Administrator (DBA) Level 3 with over 7 years of hands-on experience in managing and optimizing Oracle databases. The ideal candidate will possess a deep understanding of Oracle database architecture, performance tuning, and backup and recovery strategies. This role requires a proactive approach to database management and a commitment to ensuring high availability and security of database systems.
Responsibilities
- Manage and maintain Oracle databases, ensuring optimal performance, security, and availability.
- Implement and monitor database backup and recovery strategies to safeguard data integrity.
- Perform database upgrades, migrations, and patching as required.
- Troubleshoot and resolve database issues, providing timely support to application teams.
- Conduct performance tuning and optimization of SQL queries and database configurations.
- Develop and maintain database documentation, including architecture diagrams and operational procedures.
- Collaborate with development teams to design and implement database solutions that meet business requirements.
- Monitor database performance and implement proactive measures to prevent issues.
- Ensure compliance with data governance and security policies.
- Participate in on-call rotation for database support.
Mandatory Skills
- Extensive experience with Oracle Database (version 11g and above).
- Strong knowledge of Oracle database architecture, including RAC and Data Guard.
- Proficient in SQL and PL/SQL programming.
- Experience with database performance tuning and optimization techniques.
- Hands-on experience with backup and recovery solutions, including RMAN.
- Familiarity with Oracle Enterprise Manager and other monitoring tools.
- Solid troubleshooting skills and ability to work under pressure.
Preferred Skills
- Experience with cloud-based Oracle database solutions (e.g., Oracle Cloud).
- Knowledge of