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.
