Oracle PL / SQL Developer

Job Description

Job Description

Project Overview :

We are seeking a highly skilled and experienced Oracle PL / SQL Developer with expert-level knowledge of Oracle Database Development Memory Management to join our core development team. The ideal candidate will be instrumental in designing, developing, and optimizing high-performance database solutions, focusing specifically on maximizing efficiency and scalability through deep memory utilization expertise.

Key Responsibilities :

• Design and Development : Design, develop, test, and implement robust, high-volume, and high-performance PL / SQL stored procedures, functions, packages, and triggers.

Must be able to strictly adhere to and propose changes and improvements for the established set of development coding and naming standards.

Analyzing and manipulating memory structures (e.g., Shared Pool, Plan Cache, Data Buffer Cache, PGA).

Initiate SQL changes based on objective, measurable data

Must have expert knowledge of using the built in debugging methods provided by their development tool of choice.

Required Skills & Qualifications :

SGA (System Global Area) components : Shared Pool Library Cache (Plan reuse), Data Dictionary Cache (object reference resolution), Data Buffer Cache (data reuse) and Redo Buffer.

bind variable values

Soft Skills : Strong analytical, problem-solving, and communication skills; ability to work independently and collaboratively in an agile environment. Code Review and Git Repo Version Control experience.

Benefits : Competitive benefits package including health, dental, vision, life insurance coverage, 401(k) Plan, Training Programs, Accrued Paid Time Off (PTO) and Paid Holidays.

Equal Opportunity Employer / Veterans / Disabled