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

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

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

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

• Knowledge about Oracle VPD

• Knowledge of Python is a desirable and a plus

• Strong coding, debugging, and analytical skills

• Knowledge about Oracle architecture and process

• 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 in Containers

Job Type: Full-time

Salary: $87,155.63 - $104,961.62 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• Day shift
• Monday to Friday

Security clearance:

• Confidential (Preferred)

Ability to Commute:

• Jersey City, NJ 07302 (Required)

Ability to Relocate:

• Jersey City, NJ 07302: Relocate before starting work (Required)

Work Location: In person