Oracle Database Administrator

A skilled and proactive Oracle Database Administrator (DBA) is required to manage the installation, configuration, and performance of Oracle databases. This critical role focuses on ensuring high availability (HA) and disaster recovery (DR) readiness, primarily through the administration of Oracle RAC and Data Guard. The DBA will be responsible for RMAN backup/recovery, rigorous performance tuning, security, patching, and providing on-call troubleshooting and support. Strong automation and scripting skills are necessary for success.

Main Responsibilities

• Installation & Configuration: Install, configure, and upgrade Oracle database software across production, testing, and development environments.
• High Availability & DR:
  
  

Install, configure, and maintain Oracle Real Application Clusters (RAC), monitoring cluster health and ensuring high availability.

• Configure and manage Oracle Data Guard (physical and logical standby) to ensure disaster recovery readiness and conduct periodic DR drills.
• Database Management: Create and maintain database structures (tablespaces, indexes, partitions) and manage storage allocation and security, including encryption and auditing.
• Performance Tuning: Monitor performance using tools like Oracle Enterprise Manager Cloud Control (OEM), and perform SQL query tuning, index optimization, and instance-level tuning.
• Backup & Recovery: Develop and maintain RMAN backup strategies (full, incremental, archived logs), and rigorously test and validate backup and restore processes.
• Maintenance & Patching: Plan, test, and apply Oracle security patches, critical updates, and upgrade databases with minimal downtime.
• Troubleshooting & Support: Diagnose and resolve database errors, connectivity issues, and provide support to application teams, including participation in on-call rotations.
• Automation: Develop shell scripts, SQL scripts, and PL/SQL procedures to automate routine database tasks and implement proactive monitoring.
  
  

Main Requirements

• 3-5 years of proven experience: ability to install, configure, and upgrade Oracle database software.
• Bachelor's degree in information technology, Computer Science, or a related technical field, or equivalent practical experience and certifications.
• RAC and Data Guard Skills: Experience with the installation and maintenance of Oracle Real Application Clusters (RAC) and configuring and managing Oracle Data Guard.
• Troubleshooting: Strong skills in identifying and resolving slow-running queries, locking issues, bottlenecks, cluster-related performance, and failover issues.
• RMAN Proficiency: Expertise in developing and maintaining RMAN backup and recovery strategies, and managing Data Guard for high availability.
• Security & Compliance Focus: Knowledge of implementing and maintaining database security, and ensuring compliance with corporate standards and audit requirements.
• Scripting: Ability to develop shell scripts, SQL scripts, and PL/SQL procedures for automation.
• Collaboration: A willingness to work closely with developers, system administrators, and network teams for integrated solutions, and provide technical guidance.