Oracle Developer

Raag Solutions; Jersey City (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking a skilled data engineer with extensive experience in Oracle Exadata, SQL, and PL/SQL. This role involves implementing ETL solutions for large datasets and optimizing performance through SQL tuning techniques. The ideal candidate will have strong analytical skills and familiarity with reporting tools like Tableau, along with a solid understanding of Oracle architecture. If you are passionate about data and thrive in a dynamic environment, this opportunity is perfect for you.

Qualifications

• 7-10 years’ experience in Oracle Exadata, SQL, PL/SQL.
• Experience with analytic reporting tools like Tableau.
• Strong coding, debugging, and analytical skills.

Responsibilities

• Implement ETL solutions for large volumes of data using various modeling techniques.
• Perform application tuning using SQL performance tuning tools.
• Optimize memory usage in Oracle Server Process Architecture.

Skills

Oracle Exadata

SQL

PL/SQL

SQL performance tuning

Python

Analytical skills

Tools

Tableau

EXPLAIN PLAN

SQL*TRACE

TKPROF

AUTOTRACE

AWR Reports

Job description

ONLY LOCAL CANDIDATES - JERSEY CITY

7-10 years’ experience in Oracle Exadata, SQL, PL/SQL

• Implement ETL solutions for large volumes of data by applying various data warehouse modeling techniques such as Star Schema, Data partitioning, Data compression, and Direct path loads, maximizing re-usable components and services that incorporate versioning, reconciliation, and exception handling.

• 2-3 years’ experience in SQL performance tuning. Perform application tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, and AWR Reports.

• Have a clear understanding of Oracle Server Process Architecture and memory structures such as PGA (Program Global Areas) and SGA (System Global Areas) to optimize memory usage.

• Knowledge about Oracle VPD.

• Knowledge of Python is desirable and a plus.

• Strong coding, debugging, and analytical skills.

• Knowledge about Oracle architecture and processes.

• Knowledge of computer science data structures and algorithms.

• Experience with analytic reporting tools like Tableau.

• Analytical skills to perform technical and functional analysis with strong communication skills.

• Experience working in regulatory projects is strongly desirable.

• Experience working with Containers.