Find jobs
Pricing
Sign in
FIND JOBS
PRICING
SIGN IN
SIGN UP
← Back
EN
Encora
Senior Oracle PL SQL Developer
Save
Tailor resume
Apply
Location
Kuala Lumpur
Type
full-time
Department
Malaysia Team
Company size
1,001–5,000 people
First seen
1w ago
Last seen
2d 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.
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.
More roles at Encora
Software Engineer - Bash, Linux & Migration
Software Development Manager
Senior Network Automation & AI Engineer
Test Lead
VMware Cloud Foundation (VCF) Engineer
Seekless
Product
Find jobs
Companies
Pricing
Legal
Privacy
Terms
Cookies
© 2026 SEEKLESS, INC. ALL RIGHTS RESERVED.
BUILT WITH CARE