Oracle DB Developer — DW & Performance Specialist

LTM; Jersey City (NJ); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Comprehensive Medical Plan Covering<br

Short Term and Long-Term Disability

401(k) Plan with Company match

Life Insurance

Paid Paternity and Maternity Leave

Job summary

LTM in Jersey City, NJ is seeking an Oracle DB Developer to design, optimize, and maintain Oracle databases and associated ETL/ELT processes. The role requires strong data modeling experience and collaboration with business analysts and data architects.

The position offers a hybrid work arrangement (3 days in office) and a comprehensive benefits package, including medical, dental, vision coverage, disability insurance, a 401(k) plan with company match, and parental leave.

Qualifications

• Strong proficiency in Oracle databases and development in package procedures and materialized views.
• Experience in performance optimization and troubleshooting of Oracle systems.
• Experience in building large data warehouse dimensional models and ETL/ELT processes.
• Strong data analysis and communication skills with stakeholders.

Responsibilities

• Collaborate with business analysts, data architects, and stakeholders to translate requirements into technical solutions.
• Design and optimize data warehouse dimensional models and ETL/ELT processes.
• Provide Oracle system administration expertise.
• Support performance troubleshooting and resolve issues.

Skills

Oracle DB

Performance tuning

ETL/ELT

Data warehousing

Stakeholder communication

Job description

LTM in Jersey City, NJ is seeking an Oracle DB Developer to design, optimize, and maintain Oracle databases and associated ETL/ELT processes. The role requires strong data modeling experience and collaboration with business analysts and data architects.

The position offers a hybrid work arrangement (3 days in office) and a comprehensive benefits package, including medical, dental, vision coverage, disability insurance, a 401(k) plan with company match, and parental leave.