Senior Oracle PL SQL Developer

Encora, Kuala Lumpur

What you will do

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.