Oracle PL/SQL Backend Developer

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.