PL/SQL Developer

EPS Malaysia; Sepang; On-site; MYR 50,000 - 70,000; Full time

Job summary

A leading tech company in Malaysia seeks a professional with expertise in PL/SQL to develop back-end applications. Responsibilities include system analysis, design, and performance tuning of Oracle SQL. Candidates should possess strong skills in PL/SQL and database architecture. This is an excellent opportunity for someone looking to enhance their skills in a dynamic environment.

Qualifications

• Experience in system analysis, design, and development of back-end PL/SQL applications.
• Familiarity with Oracle SQL and PL/SQL optimization techniques.
• Experience in writing and debugging shell scripts.

Responsibilities

• System analysis, design and development of back-end PL/SQL applications.
• Participate in performance tuning activities.
• Optimize Oracle SQL & PL/SQL.

Skills

PL/SQL skills including packages, procedures, functions, triggers

Database architecture and design

Shell scripting

Job description

Responsibilities

• System analysis, design and development of back-end PL/SQL applications.
• Participate in performance tuning activities.
• Oracle SQL & PL/SQL Optimization (SQL Trace, TKPROF, explain plan, hints, efficient SQL statements, domain index).
• Experience in database architecture, data modeling, database design and implementation.
• Experience in writing / debugging shell scripts.

Skills and Qualifications

• PL/SQL skills includes packages, procedures, functions, triggers, materialized view and batch coding skills such as bulk collections, dynamic SQL, and parallel processing.