PL-SQL Developer

• 6 - 10 years of experience in Oracle based technologies

• 4+ years Experience with Oracle forms and Reports Technical Skills & Responsibilities:

• Strong expertise in Oracle Database and PL/SQL, including functions, procedures, triggers, packages, and performance tuning.

• Design and optimize complex SQL and PL/SQL; analyse execution plans and tune queries for high throughput and low latency.

• Develop and maintain Oracle Forms and Reports (12c), ensuring reliability, usability, and alignment with standards.

• Experience in tools such as Oracle SQL Developer, TOAD, PuTTY etc effectively for development, troubleshooting, and administration tasks. • Troubleshoot and resolve PL/SQL defects and performance issues; perform root-cause analysis and implement preventive fixes.

• Translate business and insurance domain requirements into clear technical designs and scalable database solutions.

• Conduct peer code reviews; enforce coding standards and implement unit/integration testing for database code.

• Experience working in Agile set-up – Active participation in Agile/Scrum ceremonies; refine user stories, estimate work, and deliver incrementally with high quality.

• Create and maintain technical documentation, including design specs, deployment guides, and runbooks.

• Good communication - Communicate proactively with stakeholders, testers, and cross-functional teams to clarify requirements and remove delivery blockers.

• Apply Unix commands and shell scripting for automation, deployments, log analysis, and environment maintenance.

• Integrate databases with internal/external services; exposure to calling web services from Oracle is desirable