Oracle PL/SQL Data Modeler

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

Job Title: Oracle PL/SQL Data Modeler
Client: Philadelphia Department of Human Services IT
Location: Philadelphia, PA Onsite
Interview: Onsite interview may be required

Local Candidates Only: Candidates must currently reside in the Philadelphia Tri-State area (PA, NJ, or DE). No relocation allowed.

Job Summary:
Seeking an experienced Oracle PL/SQL Data Modeler with 10+ years of Oracle database development and data modeling experience. The candidate will design and maintain enterprise data models, develop complex SQL/PLSQL, troubleshoot legacy applications, and support database development and production environments.

Required Skills:

• 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

Preferred: TOAD for Oracle, Source Control, Third-Tier/Production Support experience.