Description

You will manage and optimize Oracle database instances across cloud and on-premises environments.

Responsibilities

• Diagnose performance bottlenecks including CPU, memory, disk I/O, and tablespace issues.
• Execute database recovery operations, including point-in-time restores and table recovery using Oracle Flashback.
• Manage application jobs using the Oracle job scheduler.
• Monitor and alert on performance metrics to ensure system stability.
• Perform periodic security checks to maintain established security policies.

Required Skills

• 10+ years of experience in Oracle database administration.
• Expertise in tuning SQL plans, identifying high-cost operations, and applying SQL patches or hints.
• Deep knowledge of SGA/PGA tuning and index optimization.
• Proficiency in backup and restore operations, including validation and retention management.
• Experience managing Oracle instances on Azure VM (RHEL) and AWS RDS.
• Ability to use AWS CloudWatch and Performance Insights to take corrective action.
• Strong proficiency in SQL and PL/SQL.
• Experience with shell scripting on the Linux platform.
• Hands-on use of SQL Developer, Toad, and Oracle Enterprise Manager (OEM).

Preferred Skills

• Bachelor's degree in Computer Science.

Key Skills

Education

Bachelor's degree in Computer Science