Responsible for developing, optimizing, and maintaining Oracle PL/SQL code to support application development and business requirements. Design, develop, and maintain PL/SQL code (packages, procedures, functions, triggers, and scripts).
Optimize and tune existing SQL queries and PL/SQL code for performance.
Write complex queries to support data extraction, transformation, and reporting. Collaborate with application developers, analysts, and business users to implement and improve database solutions.
Create and maintain database documentation, including data dictionaries Debug and troubleshoot production issues related to PL/SQL code or database performance.
Qualifications:
Total exp: 5 + yrs, Rel exp: 3 to 5 yrs.
Mandatory skills:
Strong expertise in Oracle databases (11g/12c/19c).