Software Engineer jobs

Senior Oracle PL SQL Developer

EncoraKuala Lumpur, Malaysia10+ years experience

Pay not listed

Looks real. 2 things to check before you apply.

On Encora’s own careers site (Greenhouse), checked open today.

  • To check: Posted by the employer 5 months agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteGreenhouse board
  • Checked: Checked open todayGreenhouse board
  • Checked: No reposts foundGreenhouse board
  • Trust score 85 / 100 · Looks good

This job is outside the US, so these US-only checks are not applied: pay-transparency law, pay likely required by state law, US visa sponsorship wording.

See all 6 checksShow fewer
How we check

Summary, requirements and match are for US jobs for now.

Full job description

From Encora’s careers site

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.
Show full descriptionShow less
  • 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.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

SQL Developer

Bright Vision Technologies · Remote · US only

$115k–$165k/yrFull-time

StrongChecked open todayPosted yesterday

Senior Platform Engineer

Arta Finance · Bay Area, CA

$110k–$205k/yrFull-timeHybrid

StrongChecked open todayPosted yesterday

See more like this