Pl/SQL Developer

•    Should have experience working with large volumes like millions of rows, and able to write complex queries and perform tuning.
•    Should be able to create a materialized view to refresh data from one database to another database on a daily/hourly basis.
•    Should have knowledge of create a data model for holding an online exam with normalization.
•    Should be able to create an oracle scheduler job to run a certain PL/SQL block with frequency of required time interval.
•    Should be able to find out a table size and find out for a given table where the data is being stored.
•    Experience in handling Oracle XML/JSON/CLOB data
•    Also, having experience Python is an additional benefit for this role.