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

SThIQXNEcWkweENsbmhkNERMaEZLZVU9
  • 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

South Dakota State Government

Intern - Geologist (Summer) Job at South Dakota State Government

 ...and installation of monitoring wells, water sampling, mapping, data analysis, and GIS mapping of aquifers and bedrock geology. Experience...  ...in glacial and bedrock sediments. The student will assist with geophysical logging of test holes and will see how the logs are used to... 

BSA Sea Base

Keys Adventure Mate (BEC) - Spring 2027 Job at BSA Sea Base

 ...Keys Adventure Mates lead Keys Adventure crews throughout the entirety of their seven-day adventure. Keys Adventure mates are responsible for their crew from the moment they arrive until the moment they depart, which includes one single night stay on primitive Big Munson... 

Mass General Brigham

Oncology Infusion Nurse Practitioner MGBCI Job at Mass General Brigham

 ...range of professionals, including doctors, nurses, business people, tech experts,...  ...shifts MGBCI BWH Summary The Nurse Practitioner is an advanced practice registered nurse...  ...Nurse Practitioner experience caring for an oncology-focused patient population required.... 

Checkwriters

Business Development Representative Job at Checkwriters

 ...through consistent and timely follow-up. Maintain accurate and detailed records of prospect interactions, activity, and next steps in HubSpot. Collaborate with our Sales and Marketing teams on campaigns, prospecting strategies, and other business development initiatives... 

Nihon-Teppan Co. Ltd.

Virtual Assistant (remote) Job at Nihon-Teppan Co. Ltd.

This is an entry-level position perfect for job seekers with little experience but eager to learn and grow. Job Responsibilities: Process purchase orders for customers Record and reconcile inventory of products Track and manage incomings and outgoings...