Oracle Database Developer

Apptad Inc

Job Location:

Irving, TX - USA

Monthly Salary: Not Disclosed

Posted on: Yesterday

Vacancies: 1 Vacancy

Job Summary

total years of experience in PLSQL performance tuning. Preferred experience 7 years
Oracle version used in the most recent project (Oracle 19c preferred or higher)
Test handling large datasets/ tables(50 GB) ask any tables they remember and the size of the table and the information that is stored in table relevant to their project domain
Test experience on table partitioning strategies - Range partitioning list partitioning and Hash partitioning. Ask why and how they used these strategies in the project must explain with used case and expect confident answers
Test Performance tuning experience with actual hands-on. Candidate must explain using STAR methods no genetic answers/ solutions expected. Expect candidates talk about Oracle Optimizer EXPLAIN plans and AWR/ ASH
Test PLSQL experience with processing large datasets using BULK COLLECT and FORALL. Candidate must explain picking a scenario in project where he used these skills.
Test experience on Advanced SQL using Window functions. Candidate talks about Rownumber Rank DenseRank Lag and Lead windows functions confidently

total years of experience in PLSQL performance tuning. Preferred experience 7 years Oracle version used in the most recent project (Oracle 19c preferred or higher) Test handling large datasets/ tables(50 GB) ask any tables they remember and the size of the table and the information that is stored ...