Start searching
Back to Jobs
Recently postedOther

Oracle PL/SQL Data Modeler

Dew Softech IncPhiladelphia, PA🇺🇸United States

Why this role stands out

This hybrid role offers a fantastic opportunity to leverage your extensive Oracle PL/SQL and data modeling expertise within a reputable company, contributing to enterprise-level data solutions. You'll thrive here if you are a seasoned professional with a passion for designing robust databases and optimizing complex PL/SQL code. Apply today to shape critical data architecture and grow your career!

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationPhiladelphia, PA, United States
OraclePL/SQLSQLData Analysis

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.

Similar jobs

Apply