Job Description: 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's degree in IT or Computer Science 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.