Description

You will design and optimize database logic within an Oracle environment.

Responsibilities

• Write and optimize complex SQL queries to reduce SGA, PGA, and TempSpace usage.
• Develop and tune stored procedures and views for maximum performance.
• Manage the storage and querying of JSON data within Oracle DB tables.
• Participate in Agile development processes and sprint cycles.
• Maintain high code quality through thorough documentation and unit testing.

Required Skills

• 6+ years of experience in Oracle database development.
• Advanced Oracle SQL and PL/SQL expertise.
• Hands-on experience with Bulk Collect operations.
• Proficiency in handling JSON and XML data structures.
• Proven ability to optimize database performance and resource consumption.
• Experience working in an Agile development environment.
• Strong unit testing and technical documentation skills.
• Bachelor's degree or equivalent graduate-level education.

Key Skills

Education

Any Graduate