1- Analyze the Business needs
2- Design DB tables for the Business requirements
3 - write PL/SQL scripts, procedures to get your requirements fulfilled.
4- smart solutions to your issues and problems
5- maintain a good performance
6- modify your existing scripts to match your business requirements
7- Write SQL Statements with good quality and performance