More than 9+years experience as database admin and experience on installation,configuration,setup, database /sql tuning.
Need to identity few things for DB/sql tuning
If there are lot of DML execution on tables or huge size of tables.
Sql query level tuning- Need to check explain plan of query and oracle advisory
Db level - check parameters, Awr and addm report and filesystem storage