Database Designer
Posted 66ds ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Database Designer to support modernization efforts for a government-owned pay system. Designing and implementing Oracle databases while collaborating with cross-functional teams in an Agile environment.
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
- 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
Requirements:
- 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.
- Proficiency in Oracle database design and dSQLlopmeSQL(SQL, PL/SQL)
- Experience with relational database design principles and normalization (3NF)
- Knowledge of indexing strategies and database performance optimization
- Familiarity with data modeling, entity-relationship diagrams, and data dictionary creation
- Experience supporting or partiETLating in ETL processes for data migration
- Understanding of data quality analysis and governance practices
- Understanding of database access control, encryption, and data masking practices
- Knowledge of Zero Trust security principles and federal compliance frameworks
- FamilDoDity with DoD environments and security standards
- Basic experience with Agile development tool such as Jira, GitLab, or ServiceNow
- Experience creating and maintaining technical documentation
Benefits:
- Health insurance
- Professional development opportunities
- Paid time off
Report this job
Job expired or something wrong with this job?












