Senior Oracle Data Modeler - Hybrid, ERwin Expert

Dew Softech, Inc; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 160,000; Part time

Job summary

Dew Softech, Inc. seeks an experienced Senior Oracle PL/SQL Data Modeler to design, develop, and maintain enterprise-level data models for Oracle databases in a hybrid Philadelphia setting. The role emphasizes strong PL/SQL development and ERwin data modeling capabilities.

The ideal candidate has 10+ years of experience, deep knowledge of relational database concepts, and hands-on design of logical and physical models. Collaboration with analysts and developers is essential.

Qualifications

• 10+ years of Oracle database development and data modeling experience.
• Advanced knowledge of Oracle SQL and PL/SQL.
• Strong hands-on experience with ERwin Data Modeler.
• Extensive experience designing logical and physical data models.

Responsibilities

• Design and maintain logical and physical data models for Oracle database environments.
• Develop models based on analysis of business requirements working in conjunction with business analysts.
• Develop and optimize complex Oracle PL/SQL packages, procedures, functions, triggers, and SQL queries.
• Use ERwin Data Modeler to create and maintain enterprise data models and database documentation.
• Work with application developers, architects, and business teams to translate requirements into scalable database designs.
• Analyze existing database structures and recommend improvements to performance, scalability, and data integrity.
• Perform data analysis, database design, normalization, and schema optimization.
• Support database development, testing, troubleshooting, and production implementation activities.

Skills

Oracle

PL/SQL

SQL

ERwin

Data Modeling

Logical Data Modeling

Physical Data Modeling

Database Design

TOAD

Tools

ERwin Data Modeler

TOAD

Job description

Dew Softech, Inc. seeks an experienced Senior Oracle PL/SQL Data Modeler to design, develop, and maintain enterprise-level data models for Oracle databases in a hybrid Philadelphia setting. The role emphasizes strong PL/SQL development and ERwin data modeling capabilities.

The ideal candidate has 10+ years of experience, deep knowledge of relational database concepts, and hands-on design of logical and physical models. Collaboration with analysts and developers is essential.