Senior Oracle PL SQL Developer

encora10

Kuala Lumpur

On-site

MYR 180,000 - 280,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Encora in Kuala Lumpur seeks a senior Oracle Database Developer/DBA to design, implement, and optimize Oracle-based applications. You will drive performance tuning, data modelling, ETL, and migrations while ensuring robust availability and governance.

You will collaborate with cross-functional teams across business, security, and operations, providing L3 production support and contributing through the SDLC from requirements to post-production support.

Qualifications

  • At least 10 years of Oracle database development experience.
  • Minimum 8 years of advanced PL/SQL development.
  • Strong experience with Oracle 10g, 11g, 12c, 19c, and Oracle Autonomous Database (ADB).
  • Minimum 7 years of hands-on performance tuning and optimization.
  • 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 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.

Responsibilities

  • Design, develop, and maintain complex Oracle database applications using PL/SQL.
  • Develop and enhance Stored Procedures, Functions, Packages, Triggers, and Dynamic SQL.
  • Perform advanced SQL and PL/SQL performance tuning using 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.

Skills

Oracle DBA
PL/SQL
Oracle 10g-19c
Oracle ADB
Performance tuning
DB architecture
Data modelling
ETL integration
Talend
Materialized Views
Replication
SQL Loader
DB migrations
UNIX Shell
Production support

Tools

UNIX Shell

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Oracle PL SQL Developer
Senior Oracle PL SQL Developer

Encora Inc. • Kuala Lumpur

On-site
MYR 284,900 - 407,000
Senior Data Engineer
Senior Data Engineer

DIGITAL BRIGHT TECHNOLOGIES • Kuala Lumpur

On-site
MYR 180,000 - 270,000
VICE PRESIDENT DATABASE ENGINEERING
VICE PRESIDENT DATABASE ENGINEERING

AmBank Group • Petaling Jaya

On-site
MYR 180,000 - 320,000
Senior Database Engineer – Oracle & Cloud Ops
Senior Database Engineer – Oracle & Cloud Ops

Singtel • Kuala Lumpur

On-site
Confidential
Database Engineer (Oracle & SQL Server)| Penang
Database Engineer (Oracle & SQL Server)| Penang

Commerz Global Service Solutions • Bayan Lepas

On-site
MYR 133,920 - 200,880
Shift allowance
Senior Software Engineer — Enterprise Apps & Integrations
Senior Software Engineer — Enterprise Apps & Integrations

RHB Group • Selangor

On-site
MYR 60,000 - 90,000
Oracle Database Administrator
Oracle Database Administrator

MY01 Wolfspeed Malaysia Sdn. Bhd. • Ipoh

On-site
MYR 120,000 - 180,000
Senior Engineer, Database Service
Senior Engineer, Database Service

Singtel Group • Kuala Lumpur

On-site
MYR 68,000 - 85,000
Senior Developer – AML
Senior Developer – AML

Accenture PLC • Kuala Lumpur

On-site
MYR 180,000 - 240,000
Database Developer
Database Developer

Agensi Pekerjaan Penta Consultancy Sdn. Bhd • Kuala Lumpur

On-site
MYR 60,000 - 110,000