TL;DR

Senior Oracle PL/SQL Developer: Design, develop, optimize, and support complex database systems with an accent on PL/SQL programming, stored procedures, triggers, and performance tuning. Focus on delivering efficient and scalable database solutions aligned with business and technical requirements, ensuring data integrity, and resolving database-related performance issues.

Location: On-site in Kuala Lumpur

Company

Encora is a digital engineering and modernization partner to enterprises and digital native companies, with over 9,000 experts in 47+ offices and innovation labs worldwide.

What you will do

Design, develop, and maintain PL/SQL code, stored procedures, packages, functions, and triggers.
Optimize complex SQL queries and PL/SQL blocks to improve performance.
Collaborate with application developers, business analysts, and data architects to implement robust database solutions.
Analyze and troubleshoot database-related performance issues and provide recommendations.
Ensure data integrity, consistency, and security through proper development practices.
Assist in data migration, transformation, and integration between systems.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or a related field.
5+ years of hands-on experience with Oracle PL/SQL development.
Strong expertise in writing and optimizing complex queries, stored procedures, packages, and functions.
Experience with performance tuning, query optimization, and indexing strategies.
Familiarity with Oracle 11g/12c/19c databases.
Solid understanding of relational database design, data modeling, and normalization.

Culture & Benefits

Encora hires professionals based solely on their skills and qualifications, and does not discriminate based on various factors.

Senior Oracle Pl/sql Developer