What are the responsibilities and job description for the Oracle PL/SQL Developer position at LorganTech?
Job Location : Houston, Tx
Local candidates preferred.
Job Description :
Expertise working with Oracle SQL and PL/SQL (advanced concepts such as bulk collect, handling data in JSON/XML format)
Expertise with writing complex Oracle queries and optimizing them to reduce SGA/PGA/TempSpace usage
Proficient in storing, querying, manipulating JSON data in Oracle database tables
Proficient in creating complex queries and views using data stored in JSON format
Proficient in optimizing performance of stored procs and views accessing data stored in JSON format documentation
Dev/Unit Testing
Participate in Agile development
Years Required/Preferred Experience
7 yrs Required Expertise working with Oracle SQL and PL/SQL (advanced concepts such as bulk collect, handling data in JSON/X
7yrs Required Expertise with writing complex Oracle queries and optimizing them to reduce SGA/PGA/TempSpace usage
7 yrsRequired Documentation
7yrs Required Dev/Unit Testing
7 yrs Required Agile Development
4 yrs Required Proficient in storing, querying, manipulating JSON data in Oracle database tables
4 yrs Required Proficient in creating complex queries and views using data stored in JSON format
4 yrs Required Optimizing performance of stored procs and views accessing data stored in JSON format
Job Type: Contract
Pay: Up to $60.00 per hour
Schedule:
- 8 hour shift
Work Location: Hybrid remote in Houston, TX 77002
Salary : $60