Senior Oracle PL/SQL Data Modeler – Onsite Philly

Talent Portus; Delaware; On-site; USD 120,000 - 180,000; Full time

Job summary

Talent Portus is seeking an experienced Oracle PL/SQL Data Modeler for a Philadelphia DHS IT engagement. The role requires 10+ years of Oracle database development and data modeling, with strong SQL/PLSQL and hands-on Erwin Data Modeler. Onsite work in Philadelphia, PA with local candidates only, no relocation.

You will design enterprise data models, optimize schemas, and support production environments. Join a collaborative team that focuses on robust data architecture, performance tuning, and

Qualifications

• 10+ years of Oracle Database Development & Data Modeling.
• Strong Oracle SQL/PLSQL development experience.
• Hands-on Erwin Data Modeler experience.
• Logical & Physical Data Modeling.
• Database design, normalization, schema optimization & performance tuning.
• Packages, Procedures, Functions, Triggers and Complex Queries.
• Enterprise/Legacy Application Support.
• Unit Testing, Debugging & Production Support.
• Strong communication and collaboration skills.

Responsibilities

• Design and maintain enterprise data models.
• Develop complex SQL/PLSQL and troubleshoot legacy applications.
• Support database development and production environments.
• Collaborate with teams to ensure data integrity and performance.

Skills

Oracle data modeling

Oracle SQL/PLSQL

Erwin Data Modeler

Logical & Physical modeling

Database design & normalization

Stored procedures & triggers

Enterprise/legacy support

Unit testing & production support

Strong communication

Tools

Erwin Data Modeler

TOAD for Oracle

Job description

Talent Portus is seeking an experienced Oracle PL/SQL Data Modeler for a Philadelphia DHS IT engagement. The role requires 10+ years of Oracle database development and data modeling, with strong SQL/PLSQL and hands-on Erwin Data Modeler. Onsite work in Philadelphia, PA with local candidates only, no relocation.

You will design enterprise data models, optimize schemas, and support production environments. Join a collaborative team that focuses on robust data architecture, performance tuning, and