Oracle DBA (OMAN/UAE)

Database Administration:

• Install, configure, and upgrade Oracle database software and manage patches/updates.
• Manage and monitor Oracle database environments, ensuring high availability and performance.
• Perform regular database backups, restore operations, and disaster recovery processes.
• Assist with capacity planning and performance tuning, ensuring system efficiency.
• Support database security, including user management, access controls, and audits.
• Implement and monitor database replication, clustering, and high availability solutions (RAC, Data Guard).

Troubleshooting & Issue Resolution:

• Perform root-cause analysis for database issues and provide solutions.
• Handle incidents and service requests, ensuring timely resolution and minimal downtime.
• Troubleshoot complex database issues related to SQL performance, connection failures, and database crashes.
• Work closely with development and application teams to resolve issues related to application-database integration.

Database Monitoring & Optimization:

• Use Oracle Enterprise Manager (OEM) and other monitoring tools to oversee database health and performance.
• Analyze database logs and performance metrics to identify areas of improvement.
• Optimize queries and indexing for improved database performance.
• Implement and monitor database maintenance tasks like reorg, stats gathering, etc.

Support & Maintenance:

• Provide 24x7 support on call as part of the support rotation for critical systems and databases.
• Provide technical support during database outages or failures and participate in post-mortem reviews.
• Develop and maintain documentation for database configurations, processes, and troubleshooting guides.

Technical Skills:

• Strong knowledge of Oracle Database 12c, 18c, 19c, and/or 21c.
• In-depth knowledge of Oracle RAC, Data Guard, ASM, and RMAN.
• Expertise in SQL query optimization and PL/SQL programming.
• Familiarity with Oracle Enterprise Manager (OEM) and other database monitoring tools.
• Experience with Oracle AWR, ADDM, and ASH reports for performance tuning.
• Solid understanding of database backup, recovery, and disaster recovery methodologies.
• Experience with shell scripting or automation tools (e.g., Ansible, Python) is a plus.