Oracle PL/SQL Developer

OLVRO Co. Ltd.; Pasay; On-site; PHP 781,200 - 1,004,400; Full time

Job summary

A tech company based in Metro Manila, Philippines is seeking a Senior Oracle PL/SQL Developer. This role involves designing, developing, and supporting enterprise applications with a strong focus on Oracle PL/SQL. Ideal candidates will have over 5 years of experience in Oracle PL/SQL development and a proven ability to handle production support. Candidates with a full-stack background are preferred, as it will aid in seamless system integration and rapid problem resolution.

Qualifications

• 5+ years of experience in Oracle PL/SQL development with exposure to production support.
• Strong expertise in Oracle Database and PL/SQL programming.
• Solid knowledge of SQL performance tuning and indexing.

Responsibilities

• Design and develop complex Oracle PL/SQL components.
• Provide Level 2 / Level 3 production support.
• Monitor, troubleshoot, and resolve database incidents.

Skills

Oracle PL/SQL development

Production support

SQL performance tuning

Incident management

Communication skills

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle Database

Java

.NET

REST/SOAP APIs

CI/CD pipelines

Job description

The Senior Oracle PL/SQL Developer is responsible for the end-to-end development, enhancement, and production support of enterprise applications and database systems. This role requires strong hands‑on expertise in Oracle PL/SQL development combined with the ability to support live production environments, troubleshoot incidents, and collaborate across application, infrastructure, and business teams. Full‑stack capability is preferred to support seamless system integration and faster issue resolution.

RESPONSIBILITIES:

• Design, develop, enhance, and maintain complex Oracle PL/SQL components including procedures, functions, packages, triggers, and views.
• Provide Level 2 / Level 3 production support, including issue investigation, root cause analysis, and permanent fixes
• Monitor, troubleshoot, and resolve database and application-related incidents in production environments
• Perform SQL optimization, performance tuning, and query refactoring for high-volume transactional systems
• Collaborate with application developers, QA, DevOps, and business stakeholders for end-to-end solution delivery.
• Participate in system enhancements, bug fixes, patching, and release deployments
• Conduct impact analysis for change requests and production issues
• Ensure data integrity, security, and compliance with coding and database standards
• Perform code reviews and provide technical guidance to junior developers
• Prepare and maintain technical documentation, SOPs, and knowledge base articles
• Support data fixes, reconciliations, and ad‑hoc reporting as required.

JOB REQUIREMENTS:

• Bachelor’s degree in Computer Science, Information Technology, or a related field
• 5+ years of experience in Oracle PL/SQL development with production support exposure
• Strong expertise in Oracle Database and PL/SQL programming
• Proven experience supporting mission‑critical production systems
• Solid knowledge of SQL performance tuning, indexing strategies, and execution plans
• Experience in application support, incident management, and root cause analysis
• Understanding of full SDLC, including development, testing, deployment, and post‑production support
• Ability to work in a support‑on‑demand or on‑call environment (if required)

Full Stack / Technical Exposure (Preferred):

• Experience with Java, .NET, or other backend application frameworks
• Basic to intermediate experience in frontend technologies (e.g., HTML, CSS, JavaScript)
• Experience with REST/SOAP APIs and system integrations
• Familiarity with Unix/Linux, shell scripting, and batch processing
• Exposure to CI/CD pipelines, Git, Jira, and Agile/Scrum environments
• Strong analytical, problem‑solving, and communication skills

Nice to Have / Advantage:

• Experience with Oracle Forms/Reports, Oracle APEX, or Oracle BI tools
• Experience in ETL, data migration, or data warehousing
• Oracle Certifications (OCA/OCP)
• Experience in regulated industries (banking, finance, insurance, telco)