Oracle PL/SQL Data Modeler Job at DEW Softech, Inc, Philadelphia, PA

  • DEW Softech, Inc
  • Philadelphia, PA

Job Description

Senior Oracle PL/SQL Data Modeler

Location: Philadelphia, PA (Hybrid)

Position Type :Contract

We are seeking an experienced Oracle PL/SQL Data Modeler to design, develop, and maintain enterprise-level data models and database solutions. The ideal candidate will have 10+ years of experience working with Oracle databases, strong PL/SQL development skills, and extensive experience with ERwin or similar data modeling tools.

Key Skills: Oracle, PL/SQL, SQL, ERwin, Data Modeling, Logical Data Modeling, Physical Data Modeling, Database Design, TOAD

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.

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.

Job Tags

Contract work

Similar Jobs

AuraOne Human Data

Pathology Safety Evaluator Job at AuraOne Human Data

 ...Pathology Safety Evaluator is a remote clinical-review track for evaluating AI outputs that touch pathology. Reviewers grade differential reasoning, dosing logic, and guideline adherence; flag patient-safety issues; and document the corrected clinical reasoning so the... 

ABBVIE

MANAGER, CATEGORY MANAGEMENT - MEDIA Job at ABBVIE

 ...medicines and solutions that solve serious health issues today and address the medical...  ...collaborator and mentor to Procurement Specialists and other Category Managers. Be a...  ...market dynamics. ~ Ability to effectively communicate, with mid-to-senior level management... 

Trilogy Health Services

Housekeeping & Laundry Assistant Job at Trilogy Health Services

Ensuring that our facility is maintained in a clean, safe, and comfortable manner in laundered items, proper usage, storage and maintenance of all equipment, and labeling resident laundry with coverage starting in your first 30 days. Get Paid Weekly + Quarterly Increases...

Domino's Franchise

Level 1 Assistant Manager - 6300 NE 117th Ave. B8 Job at Domino's Franchise

 ...training evaluations completed by team member and manager. For assistants this ranges in Washington from $17.13-$19.44. Monthly bonuses...  ...delivery area to storage, work area, walk-in cooler. Prepare product. Receive and process telephone orders. Take inventory... 

Mayo Clinic

Research Fellow - Biochemistry & Molecular Biology - Xu lab Job at Mayo Clinic

 ...Cardiovascular Research, Professor of Biochemistry and Molecular Biology, Co-Director of the Cardiovascular Program, Robert and Arlene...  ...Qualifications Must have a Ph.D., M.D., or equivalent doctoral degree in a field deemed relevant by the program. Experience in cilia...