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:
Solid hands-on experience in Oracle SQL and PL/SQL.
Expertise in Stored Procedures, Functions, Packages and Triggers.
Solid understanding of SQL query optimization and performance tuning.
Hands-on experience with Joins, Cursors, Collections and Exception Handling.
Good understanding of Oracle database concepts.
Valuable to Have:
Experience with Oracle 12c/19c or later.
Unix/Linux Shell Scripting.
Performance monitoring and debugging.
Banking / Financial Services domain experience.