Oracle Database Developer

Apptad Inc.

Irving, TX, United States

2 months ago

Apply on careerjet.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

careerjet.com

Tech stack

Big Data Oracle Databases 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