Summary:
The Database Technical Expert will be responsible for performing a deep technical audit of large-scale eBanking applications, identifying performance bottlenecks, and implementing solutions to ensure optimal application performance. This role focuses on the Oracle database and Java-based web applications, requiring expertise in database model design, architecture, and query execution for performance tuning. The position collaborates closely with offshore vendors and internal teams to enhance database performance, particularly in the Supply Chain Financing IT domain.
Responsibilities:
- Lead in analyzing the current application design and database model for performance optimization.
- Audit database queries and procedures to identify performance issues and suggest improvements.
- Propose optimization techniques for database models and queries.
- Collaborate with offshore teams to enhance database assets and performance.
- Identify the 20% of queries causing 80% of slowness issues.
- Analyze SQL queries to avoid cartesian products and pinpoint full table scans.
- Read and analyze AWR reports to derive actionable insights.
- Communicate findings and areas of improvement with teams.
Requirements:
- Expertise in Oracle 19C, 21 database products.
- Proficiency in SQL language for performance tuning.
- Ability to write efficient SQL queries considering server and network resources.
- Experience with Oracle database runtime configuration and optimization.
- Exposure to relational database object mapping frameworks (e.g., iBatis, Hibernate).
- Hands-on experience with Java is advantageous.
- Strong troubleshooting and analytical skills with high accuracy.
Qualifications:
- Graduate degree in IT/Computer Science or related fields.
- 10-15 years of total experience, with the last 7 years focused on database application performance.
- Previous experience in the banking domain is highly preferred.
- IT design and development exposure is an advantage.
- Certification in database optimization/tuning is a plus.
