Pl/Sql Developer

We are looking for a PL/SQL developer with 4+ Yrs exp.
**Roles and Responsibilities**:- Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
- Extensively worked on creating database objects including tables, indexes, views, sequences, packages.
- Worked with Bulk Collectionsfor bulk load processing.Involved in code walk through and review sessions with the development team.
- Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.
- Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.
- Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language)....