Job Description :
5-7 years of PL/SQL developer with Oracle database working experience
Experience in Oracle SQL - tables, indexes, partitions, DB links
Experience in Oracle Advanced PL/SQL– Procedures, Packages, Triggers
Need to work with the application development team to review the performance of the new jobs/reports and propose new design for better performance
Experience in reviewing the existing architecture and propose improvements in design by resolving conflicts in current PL/SQL queries or jobs
Experience in tuning SQL queries & PL/SQL code for optimum performance
Database performance and data/reports analysis like AWR, ASH etc.
Oracle performance tuning Tools and Utilities like SQL Trace, TKPROF and EXPLAIN PLAN.
Oracle Event 10046 tracing
SQL Profile management – Profiling and Baselining