2P Perfect Presentation · Al Jizah, Egypt · Posted 2026-04-07
Job Summary: We are seeking a highly experienced and performance-driven Oracle PL/SQL Backend Developer to join our backend team. The ideal candidate will have strong expertise in Oracle database development, advanced SQL and PL/SQL programming, and database performance tuning. This role requires hands-on experience in designing scalable database solutions, optimizing complex queries, and translating business requirements into efficient database implementations within enterprise environments.Key Responsibilities:Design, develop, and maintain database components using Oracle SQL and PL/SQL.Develop and maintain packages, procedures, functions, triggers, and views.Write and optimize complex SQL queries for high-performance applications.Perform SQL and PL/SQL performance tuning and execution plan analysis.Translate business requirements into technical database specifications and solutions.Prepare functional and technical documentation.Troubleshoot and resolve database-related production issues.Participate in code reviews and enforce database development best practices.Collaborate with cross-functional teams to ensure system scalability, reliability, and security.Required Qualifications:Bachelor's degree in computer science, Information Technology, Software Engineering, or a related field.5+ years of hands-on experience in Oracle SQL and PL/SQL development.Strong ability to write complex SQL queries including joins, analytical functions, and aggregations.Advanced PL/SQL programming skills including: Packages, Procedures, Functions, Triggers, Bulk Collect and FORALL operations, Dynamic SQL, Exception handling, Cursors and collections.Experience in SQL and PL/SQL performance tuning and execution plan interpretation.Ability to analyze user requirements and translate them into database designs and technical specifications.Preferred Qualifications:Experience with Oracle 19c or higher.Experience in enterprise systems (ERP, SIS, financial systems, etc.).Knowledge of indexing strategies, statistics management, and optimizer behavior.Familiarity with database security concepts (roles, privileges, auditing).Experience working in Agile environments.Familiarity with Git or other version control systems.Soft Skills:Strong analytical and problem-solving skills.Excellent teamwork and communication skills.Strong attention to detail and commitment to quality.Ability to work independently and take ownership of assigned tasks.