- 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:
- Robust 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.
Good to Have:
- Experience with Oracle 12c/19c or later.
- Unix/Linux Shell Scripting.
- Performance monitoring and debugging.
- Banking / Financial Services domain experience.