Database Designer

Job Summary:

Dinè Source is seeking a Database Designer to support an ongoing application system modernization effort. This role is critical to consolidating eight disparate legacy subsystems into a single, modernized Oracle database architecture that will serve 2.9 end users. The candidate will contribute to building a secure, high-performance, cloud-native database environment that supports the transition to a government-owned, government-operated pay system.

 

Job Duties and Responsibilities:

· Design and implement consolidated Oracle database schema structures that integrate data from multiple legacy subsystems into a unified, normalized data model

· Collaborate with senior data architects and application developers to create entity-relationship diagrams, define data types, and establish indexing strategies that support high-performance operations

· Support the mapping of data elements between legacy and modernized formats, ensuring seamless data migration and integration across all eight disparate subsystems

· Participate in Agile development cycles including sprint planning, backlog refinement, user story development, and integrated testing activities to ensure database changes align with application requirements

Technical Responsibilities

· Design, develop, and maintain Oracle database schemas with detailed entity-relationship diagrams, data types, indexing strategies, and normalization requirements

· Implement database access controls and encryption solutions aligned with Zero Trust principles, DevSecOps practices, and federal security standards including NIST SP 800-53

· Support Extract, Transform, and Load (ETL) activities using tools such as Oracle GoldenGate or Apache Nifi to facilitate data migration from legacy systems

· Collaborate with cross-functional teams including application developers, security engineers, and system administrators to ensure database integration supports overall system modernization goals

· Participate in code reviews, database testing, and deployment processes following established DevSecOps pipeline procedures

· Contribute to technical documentation including data dictionaries, schema documentation, and migration procedures

· Other duties as assigned

 

Job Requirements (Education/Skills/Experience):

Education & Experience

· Bachelor's degree in computer science, Information Systems, Database Management, or related technical field

· Minimum 3 years of experience in database design, development, or administration

· Security + CE/ IAT Level II certification

· Public Trust / IT II Security clearance eligibility. Must be a US citizen.

Technical Skills

Database Technologies:

·

o Proficiency in Oracle database design and dSQLlopmeSQL(SQL, PL/SQL)

o Experience with relational database design principles and normalization (3NF)

o Knowledge of indexing strategies and database performance optimization

Data Management:

·

o Familiarity with data modeling, entity-relationship diagrams, and data dictionary creation

o Experience supporting or partiETLating in ETL processes for data migration

o Understanding of data quality analysis and governance practices

Security & Compliance:

·

o Understanding of database access control, encryption, and data masking practices

o Knowledge of Zero Trust security principles and federal compliance frameworks

o FamilDoDity with DoD environments and security standards

Development Tools:

·

o Basic experience with Agile development toJirasuGitLabJira, GitLab, or ServiceNow

o Experience creating and maintaining technical documentation

Soft Skills

· Strong analytical and problem-solving abilities with attention to detail in database design

· Excellent communication skills for collaborating with cross-functional teams and documenting technical specifications

· Ability to work effectively in fast-paced Agile development environments with changing priorities

· Self-motivated with strong time management skills to meet sprint deadlines and project milestones

· Adaptability to evolving technical requirements and new technologies in the modernization effort

 

Preferred Qualifications

· Experience with cloud-native database architectures and Microsoft Azure environments

· FamilFedRAMPwith FedRAMP IL5 hosting requirements and compliance frameworks

· Knowledge of financial systems, pDoDicularly DoD pay and accounting systems

· Experience GoldenGatee GoldenGate, Apache Nifi,ETL similar ETL tools

· UnderNISTding of NIST SP 800-53 security controls and Risk ManagementRMFamework (RMF)

· Experience working in government contracting enviDoDments or DoD projects