Oracle PL/SQL & Java Developer

Overview

Job Title: Oracle PL/SQL & Java Developer

Location: Kuala Lumpur, Malaysia

Duration: 12-Month Renewable Contract

Experience Required: 6+ Years

Job Summary:

We are looking for an experienced Oracle PL/SQL & Java Developer with a strong background in database development (60%) and Java-based application development (40%). The ideal candidate should have deep expertise in Oracle PL/SQL, Unix, and Core Java, with hands-on experience in modern frameworks and cloud-native tools.

Key Responsibilities:

Oracle PL/SQL Development (60% focus):

Develop and maintain complex SQL and PL/SQL procedures using Oracle 10g/11g/12c.

Create and manage Tables, Views, Constraints, Sequences, and Synonyms.

Develop Stored Procedures, Functions, Packages, Collections, Cursors, Triggers, and use user-defined exceptions.

Apply Pragma Autonomous Transactions, Bulk Collect, FORALL, Oracle Hints, and Explain Plans for performance tuning.

Perform SQL query optimization and performance tuning.

Work in Unix/Linux environments for deployment and scripting tasks.

Java Development (40% focus):

Develop and maintain enterprise applications using Java 17+, Spring Boot 3.3+, and Microservices architecture.

Design and build RESTful APIs, using OpenAPI/Swagger 2.0.

Experience with Hibernate, Spring Data JPA, and JMS/Messaging Queues.

Work with AWS cloud services, including Kubernetes, MSK, Docker, Elastic Search (AWS OpenSearch), Kibana, and Grafana.

Conduct unit testing using JUnit, Mockito, and other Java testing frameworks.

Hands-on experience in PostgreSQL and Oracle 19c databases.

Required Skills & Qualifications:

5+ years of experience in Oracle PL/SQL development and Java programming.

Strong knowledge of Oracle 10g/11g/12c and PostgreSQL/Oracle 19c.

Proven hands-on coding experience with Core Java, J2EE, and Spring Boot.

Practical experience with REST APIs, Microservices, and Docker containers.

Familiarity with AWS services including MSK, Kubernetes, and OpenSearch.

Excellent knowledge of performance tuning, query optimization, and Unix scripting.

Good communication and problem-solving skills.

Bachelor's degree in Computer Science, Engineering, or a related field.

Preferred Tools & Technologies:

Java 17+, Spring Boot 3.3+, JUnit, Mockito

Oracle 10g/11g/12c, Oracle 19c, PostgreSQL

Unix/Linux

Docker, Kubernetes, AWS MSK

Elastic Search (OpenSearch), Kibana, Grafana

JMS, Messaging Queues, RESTful Web Services

Swagger/OpenAPI 2.0

Job Type: Contractual / Temporary
Contract length: 12 months

Pay: ₹181,977.30 - ₹202,197.00 per month

Location Type:

• In-person

Work Location: In person