PL/SQL Developer

JAC Recruitment Pte Ltd; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A well‑established technology services company seeks a skilled Oracle PL/SQL Developer in Singapore. The role involves designing, optimizing, and maintaining PL/SQL stored procedures and database structures. Candidates should have a Bachelor's degree in Computer Science and at least 3 years of experience with Oracle databases. This position will require close collaboration with application developers and data engineers to ensure data integrity and compliance with security protocols.

Qualifications

• At least 3 years of hands-on experience in Oracle PL/SQL development.
• Experience with SQL query writing and optimization.
• Strong SQL scripting skills in modifying complex queries and stored procedures.

Responsibilities

• Design, develop, test, and deploy PL/SQL stored procedures.
• Optimize existing PL/SQL code for performance.
• Work with teams to translate functional requirements into technical solutions.

Skills

Oracle PL/SQL programming

SQL query optimization

Database schema design

Performance tuning

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle 11g/12c/19c

Job description

Company Overview

A well‑established technology services company delivering IT solutions, infrastructure support, and outsourced operational services. It works with clients across various sectors to enhance efficiency and strengthen digital capabilities.

Job Responsibilities

• Design, develop, test, and deploy PL/SQL stored procedures, functions, packages, triggers, and scripts.
• Optimize existing PL/SQL code for performance and maintainability.
• Work closely with application developers, data engineers, and business analysts to translate functional requirements into technical database solutions.
• Manage and maintain Oracle database structures including tables, views, indexes, and constraints.
• Conduct data analysis, data validation, and troubleshoot data inconsistencies.
• Assist with performance tuning, query optimization, and database debugging.
• Support data migration, ETL processes, and integration activities across systems.
• Ensure data security, quality, and compliance with company’s policies.
• Participate in code reviews and documentation of technical solutions.
• Provide production support for database‑related issues.

Job Requirements

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or related field.
• At least 3 years of hands‑on experience in Oracle PL/SQL development.
• Hands on experience in:
  • PL/SQL programming (packages, procedures, functions)
  • SQL query writing and optimization
  • Database schema design and data modelling
  • Performance tuning using Oracle tools (Explain Plan, TKProf, etc.)
• Experience with Oracle 11g/12c/19c or higher.
• Strong SQL scripting skill in modifying complex queries and stored procedures.

Application Information

Interested candidates can apply now. We regret that only shortlisted candidates will be notified.

Working Location: Singapore