Senior Database Designer
Location
United States
Posted
72 days ago
Salary
Not specified
Bachelor Degree7 yrs expEnglishETLOracleSQL
Job Description
• Lead the development of a unified database structure that integrates data from eight distinct legacy systems into a single Oracle-based architecture
• Design comprehensive database schema's using Oracle technologies, creating detailed entity-relationship diagrams and defining normalization strategies
• Establish secure data architecture incorporating row-, column-, and cell-level access controls while supporting replacement of sensitive identifiers such as Social Security Numbers
• Collaborate with software engineers, DevSecOps teams, and government stakeholders to ensure database structure supports modular application development and seamless incremental deployment
• Design, develop, and maintain Oracle 19c or newer database systems with advanced schema design techniques
• Implement relational database normalization, performance tuning, and indexing strategies that enable efficient real-time and batch processing
• Collaborate with cross-functional teams including software engineers, DevSecOps teams, and government stakeholders
• Participate in Agile ceremonies including backlog refinement and sprint planning processes
• Define and maintain data mappings between legacy and modernized structures to support incremental migration
• Support test data generation and guide integration of secure data migration pipelines using ETL processes and tools
Job Requirements
- Bachelor's degree in computer science, Information Systems, Database Management, or related field
- Minimum 7 years of experience in senior database design and architecture roles
- Experience supporting government or defense agency systems preferred
- Security + CE/ IAT Level II certification
- Proficiency in Oracle 19c or newer database systems
- Advanced PL/SQL programming and optimization
- Strong experience with relational database normalization, performance tuning, and indexing
- Familiarity with data modeling, entity-relationship diagrams, and data dictionary creation
- Experience supporting or participating 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
- Experience with Oracle GoldenGate or other real-time data migration platforms.
Benefits
- Professional certifications
- Public Trust / IT II Security clearance eligibility - Must be a US citizen.
Related Guides
Related Categories
Related Job Pages
More Designer Jobs
Designer74 days ago
Full TimeRemoteTeam 501-1,000Since 2015H1B No Sponsor
PCB Designer creating layouts for Shield AI's aircraft products
Assembly
Production Designer
Included HealthAccess. Answers. Advocacy. We're raising the standard of healthcare for everyone.
Designer75 days ago
Full TimeRemoteTeam 1,001-5,000
Production Designer focusing on high-volume co-branded asset creation
Structural Designer / Engineer
Golden Prospects by YMPConnecting young mining professionals with golden opportunities!
Designer77 days ago
Full TimeRemoteTeam 11-50H1B No Sponsor
Structural Engineer designing homes for construction engineering firm in North Carolina
Designer79 days ago
Full TimeRemoteTeam 51-200H1B No Sponsor
CAD Specialist specializing in architectural lighting shop drawings
Assembly
United States