> Markdown version of [/jobs/ext/2237846-oracle-pl-sql-data-modeler](https://www.wearedevelopers.com/jobs/ext/2237846-oracle-pl-sql-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle PL/SQL Data Modeler

- **Company:** Dew Softech Inc
- **Location:** Philadelphia, PA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Databases, Data Integrity, Relational Databases, Database Design, Database Development, Database Storage Structures, Oracle Databases, Oracle (Applications), Oracle SQL Developer, PL-SQL, SQL Databases, Database Performance, Indexer, Er-Win, Toad (Software)
- **Published:** August 26, 2026
- **Apply:** https://www.dice.com/job-detail/33328702-0e8e-4eac-a862-fa722ead490b

## About the Role

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, * 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.

## Description

* 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.


## Related Videos

- [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core)
- [DataForce Studio](https://www.wearedevelopers.com/videos/1657-dataforce-studio)
- [How Gatsby Cloud's real-time streaming architecture drives <5 second builds](https://www.wearedevelopers.com/videos/418-how-gatsby-cloud-s-real-time-streaming-architecture-drives-5-second-builds)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)