Encora10

Senior Oracle PL SQL Developer

Kuala Lumpur

hirly Pro

Get in front of the people hiring at Encora10

Reach the hiring manager at Encora10 on LinkedIn, from your own account
hirly applies to this job for you, with unlimited applications
A resume and cover letter written for this job, unlimited
The hiring manager and recruiter at Encora10, with contact details

Get Pro for this job →

$49 a month · ₹1,999 for 30 days in India · cancel any time

Get past the screening software and onto a recruiter's desk

hirly rewrites your resume for this job — matching the keywords and skills in the posting, moving your most relevant experience to the top, and writing a cover letter to fit. About 30 seconds.

Keywords matched to this posting
Fit score before you apply
Cover letter included

Matched against 3M live jobs from 220,000+ employers in 200+ countries.

Tailor my resume for this job →

Apply from your AI assistant

Connect hirly to Claude or ChatGPT and ask it to apply to this job. hirly tailors your resume, fills the employer’s form and asks before sending.

See how it works

Some employer sites stop an application at a CAPTCHA or sign-in and hand it back with a link. Applying needs a paid plan. Works with any assistant that supports MCP.

hirly's read of this role

Role family: Engineering
Seniority: Senior
Country: MY
Work mode: Remote-friendly
First seen by hirly: 4 Sept 2026

Derived automatically from the posting. Upload your resume above to see how the role scores against it.

the posting

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.

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.

Original posting on Encora10's site ↗

Listed on hirly, a job board. hirly is not the employer: Encora10 is hiring for this role.

Want this one?

Upload your resume and hirly rewrites it for this job and writes the cover letter — in about thirty seconds, before you sign up.

Tailor my resume for this job