Must be able to trace and tune SQL
Must be able use ad hoc SQL where
necessary
Must be able to leverage database abilities
Outer joins
Nested queries
Stored Procedures
Oracle Hints