Overview
On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)
No Travel Required
Skills
Data Modeling
Data Architecture
Data Quality
Data Migration
Data Integrity
ER/Studio
ERwin
Extract
Transform
Load
Microsoft Azure
Migration
Normalization
Oracle
Pivotal
Meta-data Management
RDBMS
Scripting
Amazon Web Services
Data Structure
Data Governance
Data Integration
Data Warehouse
Database Administration
Database Design
Job Details
Job Title: Logical Data Modeler - Oracle
Job Location: Houston, TX - Onsite - Preferring a local resource at this moment
Job Description:
We are seeking a highly skilled and detail-oriented Logical Data Modeler with expertise in Oracle database technologies to join our Database Team. This role is pivotal in designing, developing, and maintaining logical data models that support enterprise data strategies, ensuring data consistency, integrity, and accessibility across systems. The desired role would also perform some database administration tasks.
Key Responsibilities:
- Design and maintain logical data models that reflect business requirements and support enterprise data architecture.
- Collaborate with business analysts and stakeholders to gather and interpret data requirements.
- Translate business needs into normalized data structures and entity-relationship diagrams (ERDs).
- Ensure logical models align with physical database implementations and performance goals.
- Maintain metadata and data dictionaries to support data governance and lineage.
- Support data integration, migration, and transformation efforts by providing data modeling expertise.
- Conduct impact analysis for changes to data models or business processes.
- Stay current with industry trends, tools, and best practices in data modeling and database design.
- Installs, configures, and maintains database management software and related tools following recommend standards and security guidelines.
- Supports the application development teams in the design and creation of secure database structures and objects, migrating changes through the project development life cycle and into the production environment.
- Develops scripts and processes to perform data migration requests related to refreshing development and test environments from production.
- Performs performance and tuning of the overall database in addition to application specific queries.
- Support ETL database functions and processes.
- Other duties as assigned.
Required Qualifications:
- 3+ years of experience in data modeling, database design, or data architecture.
- Strong understanding of relational database concepts, normalization, and data integrity.
- Proficiency in data modeling tools (e.g. ERwin, ER/Studio, etc.).
- Familiarity with data governance, metadata management, and data quality principles.
- Excellent analytical, problem-solving, and communication skills.
Preferred Qualifications:
- Bachelor's degree or technical certification with a minimum of three (3) years' related experience.
- Experience with supporting Oracle databases.
- Experience with cloud platforms (e.g., Azure, Google, and AWS) and cloud-native databases.
- Exposure to database administration tasks such as installation, configuration, and maintenance of Oracle DBMS.
- Experience supporting development lifecycle environments and data migration scripting.
- Knowledge of data warehousing and ETL processes.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.