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 database security best practices an