Oracle Database Developer

Apptad Inc.
Irving, United States of America
18 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Irving, United States of America

Tech stack

Big Data
Oracle
Oracle Applications
Oracle SQL Developer
Performance Tuning
PL-SQL
Sql Optimization

Job description

Job Description: Job Role:- Oracle Database Developer Job Location:- Irving, Texas Job Description We are seeking a highly skilled Senior Oracle Developer to join our dynam…

  • 1 month ago

Requirements

  • 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 Row_number, Rank, Dense_Rank, Lag and Lead windows functions confidently

Apply for this position