Title: PL/SQL Developer
Duration: 6 Months (Contract to Hire)
Location: Bloomfield CT
Responsibilities:
- 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.
PL/SQL,Python,XML,JSON,CLOB,Performance Tuning