# Senior Oracle PL SQL Developer at Encora

> Malaysia · Senior · Software engineering · open. Source: https://alderhq.app/jobs/greenhouse%3Aencora10%3A5170059007 (read 2026-11-21).

## Facts (observed)

- Company: [Encora](https://alderhq.app/companies/encora)
- Location text: Kuala Lumpur; Kuala Lumpur
- Where it can be done from (inferred): Malaysia (evidence: "Location: Kuala Lumpur; Kuala Lumpur")
- Posted: 2026-06-22 (152 days ago)
- First seen by alder: 2026-11-07 · last verified: 2026-11-20
- Reposted: 0 times · edited: 0 times
- Apply on the employer's site: https://job-boards.greenhouse.io/encora10/jobs/5170059007
- Skills listed (inferred): SQL

## Pay and sponsorship

- Posted pay: not posted

## Description (the employer's text)

### 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.

---
Data: alder (https://alderhq.app). Cite https://alderhq.app/jobs/greenhouse%3Aencora10%3A5170059007 and the date you read it. Observed facts come from the employer's own listing; location reach, level, family and skills are inferences.
