REQUIRED SKILLS
- Good coding practices using PL/SQL.
- PL/SQL skills include packages, procedures, functions, triggers, materialized view and batch coding skill such as bulk collections, dynamic SQL, and parallel processing.
- System analysis, design and development of back-end PL/SQL applications
- Oracle SQL & PL/SQL Optimization (SQL Trace, TKPROF, explain plan, hints, efficient SQL statements, domain index)
- Participate in performance tuning activities
- Experience in database architecture, data modeling, database design and implementation.
- Experience in writing / debugging shell scripts.
KEY RESPONSIBILITIES AND ACCOUNTABILITIES
- Analyze, develop, unit test and maintain software application in support of the achievement of business requirements within the given timeline.
- Ensure detail specification of the program to be coded is clear and understood well and follow standard coding practice and industry standard.
- Provide maintenance and troubleshooting support to help resolve technical issues with production systems by debugging, research and investigation.
- Assist Team Leader in carrying out the unit test to ensure all bugs and mistakes are corrected in the programs written.
- Prepare documentation on programming tips, standards and guidelines and transfer the knowledge to other junior programmers as and when required.
- Progress of on-going tasks and issues on related matters; and continuously enhance expertise and knowledge on application development and other related technology and methodology.
