- Write complex SQL Queries.
- Create Tables, Synonyms, Views, Global Temporary Table
- Use Index, Hints, Joins, Sequences and partitions
- SQL Queries performance tuning using Explain plan
- SQL Loader, External Table and UTL_FILE package.
- Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL / SQL and SQL Loader.
- Perform initial design reviews and recommend improvements.
- Perform design and development of Oracle applications according to project requirements.