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

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

Lawrence Hall

Community Wellness Advocate Job at Lawrence Hall

Role SummaryThe Community Wellness Advocate will provide mentorship, case management, and supportive services to youth and young adults ages 8-24 years old. This position focuses on engaging at-risk and justice-involved youth from high-crime and underserved communities... 

Confidential

Remote - Inpatient Coder Job at Confidential

 ...Emergency Department Facility Coder Position Summary...  ...emergency department medical records to accurately...  ...procedure, and facility coding in accordance with ICD-...  ...Guidelines Qualifications Experience coding emergency...  ...Type This is a fully remote position.... 

Cornerstone Renovations

Field Canvasser - Training Provided - 60K - 200K+ (Beaverton) Job at Cornerstone Renovations

 ...requiredjust confidence, great communication, and a strong work ethic. Why People Join Cornerstone (The Rewards): Massive Financial Upside: Enjoy a stable hourly base pay plus uncapped appointment bonuses and closed project commissions. Most team members earn a... 

Uline

Safety Coordinator Job at Uline

 ...: Columbus, Ohio Safety Coordinator Join Uline as we expand our operations to Ohio! Find fulfillment in your career - at Uline! As Safety Coordinator at our new Ohio branch, promote safety programs that reduce risks to our people and help us continue our industry... 

Bitus Labs

Game Backend Developer (Mandarin Speaker) Job at Bitus Labs

 ..., low-latency network applications Experience designing and developing RESTful APIs Familiarity with Protobuf or comparable serialization...  ...Chinese Experience in backend development, especially game and real-time service backends, is preferred Experience delivering...