{"schemaVersion":"jobsearcher.job.v1","id":"2d1e9c54715b803e60373b01","url":"https://jobsearcher.com/jobs/2d1e9c54715b803e60373b01","canonicalUrl":"https://jobsearcher.com/jobs/2d1e9c54715b803e60373b01","title":"Senior Oracle PL/SQL Data Modeler","description":"Senior Oracle PL/SQL Data Modeler\nLocation: Philadelphia, PA (Hybrid)\nPosition Type :Contract\n\nWe 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.\n\nKey Skills: Oracle, PL/SQL, SQL, ERwin, Data Modeling, Logical Data Modeling, Physical Data Modeling, Database Design, TOAD\n\nResponsibilities\n\nDesign and maintain logical and physical data models for Oracle database environments.\nDevelop models based on analysis of business requirements working in conjunction with business analysts.\nDevelop and optimize complex Oracle PL/SQL packages, procedures, functions, triggers, and SQL queries.\nUse ERwin Data Modeler to create and maintain enterprise data models and database documentation.\nWork with application developers, architects, and business teams to translate requirements into scalable database designs.\nAnalyze existing database structures and recommend improvements to performance, scalability, and data integrity.\nPerform data analysis, database design, normalization, and schema optimization.\nSupport database development, testing, troubleshooting, and production implementation activities.\nQualifications:\n\n10+ years of Oracle database development and data modeling experience.\nAdvanced knowledge of Oracle SQL and PL/SQL.\nStrong hands-on experience with ERwin Data Modeler.\nExtensive experience designing logical and physical data models.\nStrong understanding of relational database concepts, normalization, indexing, constraints, and database performance.\nExperience working with large, complex enterprise databases.\nStrong analytical, troubleshooting, and communication skills.\nExperience with TOAD for Oracle is a plus.\n\nFlexible work from home options available.","company":"Dew Softech","rawCompany":"dew softech","city":"Coatesville","state":"PA","isRemote":false,"isActive":false,"createdAt":"2026-08-31T10:59:52.635Z","occupations":[{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Oracle PL/SQL Data Modeler","description":"Senior Oracle PL/SQL Data Modeler\nLocation: Philadelphia, PA (Hybrid)\nPosition Type :Contract\n\nWe 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.\n\nKey Skills: Oracle, PL/SQL, SQL, ERwin, Data Modeling, Logical Data Modeling, Physical Data Modeling, Database Design, TOAD\n\nResponsibilities\n\nDesign and maintain logical and physical data models for Oracle database environments.\nDevelop models based on analysis of business requirements working in conjunction with business analysts.\nDevelop and optimize complex Oracle PL/SQL packages, procedures, functions, triggers, and SQL queries.\nUse ERwin Data Modeler to create and maintain enterprise data models and database documentation.\nWork with application developers, architects, and business teams to translate requirements into scalable database designs.\nAnalyze existing database structures and recommend improvements to performance, scalability, and data integrity.\nPerform data analysis, database design, normalization, and schema optimization.\nSupport database development, testing, troubleshooting, and production implementation activities.\nQualifications:\n\n10+ years of Oracle database development and data modeling experience.\nAdvanced knowledge of Oracle SQL and PL/SQL.\nStrong hands-on experience with ERwin Data Modeler.\nExtensive experience designing logical and physical data models.\nStrong understanding of relational database concepts, normalization, indexing, constraints, and database performance.\nExperience working with large, complex enterprise databases.\nStrong analytical, troubleshooting, and communication skills.\nExperience with TOAD for Oracle is a plus.\n\nFlexible work from home options available.","datePosted":"2026-08-31T10:59:52.635Z","dateModified":"2026-08-31T10:59:52.635Z","hiringOrganization":{"@type":"Organization","name":"Dew Softech","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Coatesville","addressRegion":"PA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"2d1e9c54715b803e60373b01"},"url":"https://jobsearcher.com/jobs/2d1e9c54715b803e60373b01"}}