Key Responsibilities
• Develop, maintain and optimize complex Oracle PL/SQL procedures, functions, packages and triggers.
• Write complex SQL queries and perform database performance tuning.
• Troubleshoot database issues and optimize query execution.
• Work on indexing, partitioning and execution plans.
• Handle data migration, data validation and database troubleshooting.
• Collaborate with application development and testing teams.
• Ensure coding standards, quality and technical documentation. Mandatory
Skills:
• Strong hands-on experience in Oracle SQL and PL/SQL.
• Expertise in Stored Procedures, Functions, Packages and Triggers.
• Strong understanding of SQL query optimization and performance tuning.
• Hands-on experience with Joins, Cursors, Collections and Exception Handling.
• Good understanding of Oracle database concepts. Positive to Have:
• Experience with Oracle 12c/19c or later.
• Unix/Linux Shell Scripting.
• Performance monitoring and debugging.
• Banking / Financial Services domain experience.