Oracle Pl/Sql Developer

As a Senior Oracle PL/SQL Developer, your key responsibilities are as follows:- Write database PLSQL packages, procedures, functions and triggers- 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**:- **At least 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 advantage**Job Type**: ContractContract length: 12 months**Salary**: RM6,162.10 - RM10,000.00 per month**Benefits**:- Health insuranceSchedule:- Monday to FridayAbility to commute/relocate:- Petaling Jaya: Reliably commute or planning to relocate before starting work (required)