Description

You will own the design, performance, and availability of Oracle Database environments in an enterprise setting. This role requires deep expertise in schema design, locking strategies, and SQL/PL/SQL tuning. You will manage database infrastructure on AWS and Linux, including Exadata and ASM, while ensuring robust backup, restore, and disaster recovery processes.

Responsibilities

• Design and tune database schemas, access patterns, and locking strategies for high-performance enterprise applications.
• Modify database structures and update existing objects to meet evolving application requirements.
• Configure, monitor, and manage Oracle Cache, storage allocation, and future capacity planning.
• Implement and support Oracle databases on AWS and Linux platforms, including Exadata and ASM.
• Author and maintain SQL and PL/SQL code, and develop shell scripts for automation.

Required Skills

• 7+ years of demonstrable experience in Oracle Database design, tuning, and enterprise support.
• Proficiency in SQL, PL/SQL, and shell scripting languages.
• Experience configuring and managing Oracle Cache and database server performance.
• Strong understanding of Exadata hardware/software components, including storage cells, InfiniBand, and Smart Scan.
• Experience with Oracle Automatic Storage Management (ASM) and storage planning.
• Ability to design and implement backup/restore services and disaster recovery solutions.
• Experience installing, upgrading, and patching Oracle database software.
• Strong analytical, technical, and time management skills with effective communication abilities.

Key Skills

Education

Any Gradute