Senior Data Modeler – Oracle Database

Location: Dallas, Texas (On-site)
Experience: 5–9 Years
Employment Type: Contract

Job Overview

We are looking for an experienced Senior Data Modeler with strong expertise in Erwin Data Modeler, Oracle Database, SQL, and PL/SQL. The candidate will be responsible for designing, developing, and maintaining logical and physical data models, ensuring database architecture follows industry best practices, and supporting enterprise data management initiatives.

Key Responsibilities

• Design and maintain logical and physical data models using Erwin Data Modeler.

• Develop normalized (3NF) transactional models and dimensional models (Star/Snowflake schemas).

• Work with Oracle databases to design and maintain database structures.

• Create and modify tables, indexes, constraints, sequences, synonyms, and materialized views.

• Perform forward engineering, reverse engineering, model comparison, and DDL generation.

• Analyze database structures and recommend improvements for performance and scalability.

• Collaborate with developers, architects, business analysts, and technical stakeholders.

• Maintain data dictionaries, metadata, data lineage, and technical documentation.

• Ensure data integrity, normalization, referential integrity, and database design standards.

• Provide technical guidance and review database design and SQL/PLSQL implementations.

Required Skills

• 5–9 years of experience in Data Modeling, Database Design, or Data Architecture.

• Strong hands-on experience with Erwin Data Modeler (Version 9.x or higher).

• Advanced SQL and Oracle PL/SQL knowledge.

• Experience with Oracle 11g, 12c, 19c, or 21c.

• Strong understanding of 3NF, normalization, denormalization, Star Schema, and Snowflake Schema.

• Experience with DDL, database objects, indexing, and partitioning.

• Knowledge of entity-relationship modeling, primary keys, foreign keys, cardinality, and referential integrity.

• Understanding of query execution plans and database performance tuning.

• Experience with Git, model versioning, and comparison tools.

Preferred Qualifications

• Experience with Snowflake, AWS, Azure, or Oracle Cloud.

• Knowledge of Collibra, Alation, ER/Studio, or PowerDesigner.

• Exposure to ETL/ELT, Data Governance, and Master Data Management (MDM).

• Experience with PostgreSQL, Microsoft SQL Server, Data Vault, Hadoop, or MongoDB.

• Experience in financial services, healthcare, insurance, or utilities.

Work Arrangement

This is an on-site contract position in Dallas, Texas. Candidates must be comfortable working from the client location.