Oracle Database Developer 26-02644

Genesis10; Pennington (NJ); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology solutions firm seeks a Senior Database Developer to design and optimize enterprise data systems using Oracle databases. This role involves writing complex PL/SQL, data modeling, and ETL pipeline design. Ideal candidates should have mastery of Oracle databases, experience with data warehousing architectures, and proficiency in data modeling tools. This position offers a long-term contract with opportunities for mentoring and growth.

Qualifications

• Expert-level knowledge of Oracle databases including RAC and Partitioning.
• Deep understanding of Data Warehousing principles and MDM.
• Proven database performance tuning skills.

Responsibilities

• Design and implement robust, scalable data models.
• Write and optimize complex PL/SQL packages.
• Assist in MongoDB integration strategies.
• Design ETL pipelines for data migration.

Skills

Oracle 12c/19c knowledge

Data Warehousing

Performance Tuning

Data Modeling Tools

Tools

ERwin

Toad

Oracle SQL Developer Data Modeler

Job description

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position. (No C2C)

Title: OracleDatabase Developer

Duration: 12+ months (with possible extension)

Role Overview

We are looking for a Senior Database Developer with a strong foundation in Data Architecture to lead the design, optimization, and scaling of our enterprise data systems. You will be the primary authority on Oracle database development while driving the architectural roadmap for our evolving data landscape. A "nice-to-have " familiarity with MongoDB is highly desired as we explore hybrid cloud and document-based storage solutions.

Key Responsibilities

• Database Architecture: Design and implement robust, scalable data models (Relational and Document-based) that align with business requirements and enterprise standards.
• Oracle Development: Write and optimize complex PL/SQL packages, procedures, functions, and triggers. Perform deep-dive performance tuning using SQL Trace, TKPROF, and Explain Plans.
• Data Modeling: Create and maintain Logical and Physical data models using tools like ERwin, Toad, or Oracle SQL Developer Data Modeler.
• NoSQL Integration: Assist in the strategy and implementation of MongoDB for specific high-velocity or unstructured data use cases.
• Migration & ETL: Design data migration strategies and ETL pipelines to move data between legacy systems, Oracle, and NoSQL environments.
• Mentorship: Act as the subject matter expert (SME) for development teams regarding database best practices, indexing strategies, and schema design.

Required Technical Skills

• Mastery of Oracle: Expert-level knowledge of Oracle 12c/19c, including RAC, Partitioning, and Advanced Security.
• Architectural Knowledge: Deep understanding of Data Warehousing (Star/Snowflake schema), ODS design, and Master Data Management (MDM).
• Performance Tuning: Proven ability to tune highly fragmented or slow-performing databases in high-concurrency environments.
• Data Modeling Tools: Proficiency in ER diagrams and architectural documentation.