- Kuala Lumpur Federal Territory Malaysia
Working Location
Job Description
Responsibilities
Role: Senior Oracle PLSQL Developer
As a Senior Oracle PL/SQL Developer, your key responsibilities are as follows:
· Write database PLSQL packages, procedures, functions and triggers
· Develop, validate, and maintain applications written in Oracle PLSQL
· Implement and maintain the database design
· Provide technical assistance by responding to enquiries regarding errors or questions
· Participate as a team member on defined standards and working practices
· Develop technical analysis and design specifications based on functional requirements
· Lead the analysis of business requirements such as propose, design and implement technical solutions
Technical Skill Requirements:
· Strong SQL, PLSQL Skills
· Strong competency in writing efficient and complex queries including Stored Programs, Procedures, function, Triggers
· Exposure to PL/SQL advance concept of Collections, Bulk Collect, PL/SQL Tables, Materialized Views, Table Partitioning Analytical function etc.
· Expertise in Optimization techniques, Performance Tuning and Query Optimization using Explain plan, traces, AWR Report
· Knowledge on Oracle Forms and Reports (D2K) is an added advantage
Professional Skill Requirements:
· Candidate should possess a Bachelor Degree in IT or Computer Science
· Atleast 5+ Years of developer experience in Oracle PL/SQL
· Prior working experience in a development team lead capacity will be an added advantage
· Understand full life cycle development: Architecture, Unit Testing and Production Support
· Analytical, Organizational and Problem-Solving Skills
· Ability to work independently and as part of the team
· Aptitude for debugging problems in complex, unfamiliar code. Strong Troubleshooting skill is required.
· Expertise in writing and executing SQL queries and statements
· Excellent oral and written communication skills
· Good to have related Oracle Certification such as Oracle Certified Associate (OCA) or Oracle Certified Professional (OCP)
Experience in Life Insurance Industry is an added advantag
Important Information
Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.