Encora

Senior Oracle PL SQL Developer

Kuala Lumpur · Work style not stated

Apply on the employer’s site ↗See how well you match this job

You apply directly with the employer. ROLIVA does not submit applications from this page and is not the employer.

About the role

Description from the employer’s posting. Check the employer’s page for the current version.

EmployerEncora
LocationKuala Lumpur
Work styleWork style not stated
Employer posted3 months ago

Key Responsibilities

Design, develop, and maintain complex Oracle database applications using PL/SQL.
Develop and enhance Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Analytical Functions, and Autonomous Transactions.
Perform advanced SQL and PL/SQL performance tuning using tools such as AWR, ADDM, ASH, SQL Trace, and Explain Plan.
Design scalable database architectures, schema structures, indexing strategies, partitioning models, and high-availability solutions.
Lead data modelling activities, including logical and physical data design, normalization, constraints, indexes, and governance standards.
Design and implement ETL processes and data integration solutions for large-volume data environments.
Manage Materialized Views, replication mechanisms, and distributed database environments.
Execute data migration initiatives and large-scale data loading activities using SQL Loader and Oracle migration utilities.
Develop and maintain UNIX shell scripts for automation, batch processing, and operational support.
Support application database deployments, environment setup, release management, monitoring, backup, recovery, and production support activities.
Provide L3 production support, perform root cause analysis, and resolve critical incidents within SLA timelines.
Participate throughout the full Software Development Life Cycle (SDLC), from requirements gathering to post-production support.
Work closely with business users, infrastructure teams, security, risk, compliance, legal, and finance stakeholders.
Lead code reviews, establish development standards, and mentor junior developers.
Produce technical documentation, solution designs, operational procedures, and governance artifacts.
Drive database modernization initiatives and recommend innovative solutions to improve system performance, scalability, and reliability.

Show full description

Mandatory Requirements

Technical Skills

Minimum 10 years of Oracle database development experience.
Minimum 8 years of advanced PL/SQL development experience.
Strong experience with Oracle 10g, 11g, 12c, 19c, and preferably Oracle Autonomous Database (ADB).
Minimum 7 years of hands-on performance tuning and optimization experience.
Strong expertise in database architecture, schema design, partitioning, indexing, and high-volume database solutions.
Minimum 6 years of data modelling experience (logical and physical).
Minimum 5 years of ETL and data integration experience; Talend exposure is advantageous.
Experience managing Materialized Views and replication strategies.
Strong experience with SQL Loader and database migration projects.
Proven experience performing database migrations to Oracle environments.
Minimum 4 years of UNIX Shell Scripting experience.
Strong Application DBA exposure, including deployment, monitoring, backup, recovery, and production support.
Minimum 5 years of L3 production support experience in mission-critical environments.

See how well you match this job Apply on the employer’s site ↗

Check your resume against this job Free, no sign-up. Nothing you paste is stored.

Staying safe while you apply

Never pay to apply, interview or accept an offer. ROLIVA never asks you for payment to apply to a job.
Apply only through the official “Apply on the employer’s site” button, on the employer’s own site, and check that a recruiter’s email uses that employer’s own domain rather than a free email address.
Be cautious of an offer made with no real interview, or pressure to decide quickly or share financial details early.

Does something look wrong with this listing? Use “Report broken link” in the role details, or read ROLIVA’s full job-safety guidance ↗.

Preparing for this role with ROLIVA

Check the fit.
Compare the requirements with the experience you have confirmed, including gaps.
Prepare honestly.
Build interview stories and application drafts from your own evidence.
Keep track.
Save the role and record your own application status and follow-ups.

Create a free workspace or log in.