Oracle PL / SQL Developer

Oracle Pl / Sql Developer

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.
• Must author code that is clear, unambiguous, succinct and non-repetitive.
• Performance Tuning : Serve as the subject matter expert in advanced Oracle PL / SQL performance tuning, with a primary focus on optimizing SQL execution and PL / SQL code by :
• Analyzing and manipulating memory structures (e.g., Shared Pool, Plan Cache, Data Buffer Cache, PGA).
• Making use of Bulk processing approaches where appropriate.
• SQL Optimization : Write, review, and optimize complex SQL queries using Execution Plans and leveraging advanced techniques like hints, index optimization, and materialization to ensure fast data retrieval.
• Initiate SQL changes based on objective, measurable data.
• Troubleshooting : Diagnose and resolve complex production issues related to execution performance and memory contention.
• Must have expert knowledge of using the built-in debugging methods provided by their development tool of choice.
• Data Modeling : Collaborate with data architects to refine data models, ensuring designs are optimized for PL / SQL access patterns and memory efficiency.
• Documentation : Create and maintain technical documentation, including specifications, design documents, and operational guides for database objects, code invocation, debugging, and logging.

Required Skills & Qualifications :

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