Senior Oracle Data Modeler: PL/SQL & ERwin Expert

Dew Softech Inc; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Dew Softech Inc in Philadelphia, PA is seeking a Senior Oracle PL/SQL Data Modeler for a hybrid, contract engagement. You will design, develop, and maintain enterprise data models and Oracle database solutions, leveraging 10+ years of experience.

The role requires strong PL/SQL, ERwin experience, and collaboration with developers and business teams to translate requirements into scalable database designs, optimize performance, and ensure data integrity.

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.
• Strong understanding of relational database concepts, normalization, indexing, constraints, and database performance.
• Experience working with large, complex enterprise databases.
• Strong analytical, troubleshooting, and communication skills.
• Experience with TOAD for Oracle is a plus.

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

Data Modeling

Logical Data Modeling

Physical Data Modeling

Database Design

TOAD

ERwin

Tools

ERwin Data Modeler

TOAD for Oracle

Job description

Dew Softech Inc in Philadelphia, PA is seeking a Senior Oracle PL/SQL Data Modeler for a hybrid, contract engagement. You will design, develop, and maintain enterprise data models and Oracle database solutions, leveraging 10+ years of experience.

The role requires strong PL/SQL, ERwin experience, and collaboration with developers and business teams to translate requirements into scalable database designs, optimize performance, and ensure data integrity.