> Markdown version of [/jobs/ext/1502331-senior-database-modeler](https://www.wearedevelopers.com/jobs/ext/1502331-senior-database-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). --- # Senior Database Modeler - **Company:** Dine Source - **Location:** Scottsdale, AZ, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Third Normal Form, Amazon Web Services, Data Analysis, Audit Trail, Microsoft Azure, Big Data, Cyber Security, Information Systems, Databases, Data Architecture, Data Dictionary, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Migration, Data Profiling, Relational Databases, Database Design, Database Queries, Entity Relationship Models, Logical Data Models, Meta-Data Management, Metadata Repositories, Oracle Databases, Oracle (Applications), Oracle SQL Developer, Oracle Warehouse Builder, Reference Data, Zero Trust Network Access, PL-SQL, Information Technology, Data Lineage, Data Management, Physical Data Models, Oracle Cloud Infrastructure, Legacy Systems - **Published:** July 30, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=05dd544fe3c7d8b2 ## About the Role The ideal candidate will possess extensive experience in conceptual, logical, and physical data modeling, Oracle database design, data migration, and enterprise data architecture within highly regulated environments., * U.S. Citizen with ability to obtain and maintain Public Trust clearance. * Bachelor's degree in Computer Science, Information Systems, Engineering, or related field. * 10+ years of experience in Data Modeling, Data Architecture, or Database Design. * Strong experience designing: + Conceptual Data Models + Logical Data Models + Physical Data Models * Extensive experience with Oracle Database environments. * Strong understanding of: + Relational database design + Third Normal Form (3NF) + Referential integrity + Data governance + Data lineage + Metadata management * Experience supporting large-scale data migration and legacy system modernization initiatives. * Experience developing source-to-target mappings and supporting ETL/ELT processes. * Strong SQL skills and working knowledge of PL/SQL. * Experience with data modeling tools such as: + Oracle SQL Developer Data Modeler + ERwin + ER/Studio + Sparx Enterprise Architect * Excellent written and verbal communication skills. Preferred Qualifications * Experience supporting DoD, DFAS, or other Federal Government modernization programs. * Experience designing enterprise Oracle architectures. * Experience with Oracle Label Security (OLS), Oracle Database Vault (DV), and Transparent Data Encryption (TDE). * Experience supporting cloud-hosted Oracle environments (Azure, OCI, AWS, or similar). * Knowledge of SFIS, SLOA, financial management, payroll, retirement, or annuitant systems. * Familiarity with Zero Trust Architecture principles and DoD IL5 environments. * Oracle certification(s) preferred. ## Description Diné Source is seeking a Senior Oracle Data Modeler / Data Architect to support a large-scale federal modernization initiative for the Defense Finance and Accounting Service (DFAS). This role will be responsible for designing and governing enterprise data models, supporting legacy system consolidation, and ensuring the integrity, security, and scalability of a modern Oracle-based data architecture., * Design and maintain conceptual, logical, and physical data models supporting enterprise-wide modernization initiatives. * Develop and govern enterprise canonical data models used to consolidate multiple legacy systems into a unified Oracle platform. * Design highly normalized (3NF) Oracle database structures that support scalability, performance, maintainability, and data integrity. * Create and maintain Entity Relationship Diagrams (ERDs), data dictionaries, metadata repositories, and architecture documentation. * Define primary keys, foreign keys, surrogate key strategies, reference data structures, and enterprise naming standards. * Collaborate with business analysts, application architects, developers, and database administrators to translate business requirements into data models. * Develop source-to-target mappings and support ETL/ELT design activities for legacy system migrations. * Perform data analysis, data profiling, data quality assessments, and reconciliation activities. * Support implementation of Master Data Management (MDM), data lineage, and governance practices. * Ensure database designs align with federal security, auditability, and compliance requirements. * Participate in architecture reviews, design sessions, and modernization planning activities. * Support implementation of Oracle security architecture including Oracle Label Security (OLS), Oracle Database Vault (DV), and related controls. * Perform other related duties as assigned. ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [DataForce Studio](https://www.wearedevelopers.com/videos/1657-dataforce-studio) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [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) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)