Should have good knowledge in creating packages, procedure, functions, triggers, collections scheduler jobs. Should have knowledge in advanced SQL queries and Performance tuning techniques.