Senior Database Designer

DesignerDesignerFull TimeRemoteTeam 1-10Since 1999H1B No SponsorCompany SiteLinkedIn

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 Categories

Related Job Pages

More Designer Jobs

PCB Designer II

Shield AI

Autonomy for the world.

Designer74 days ago
Full TimeRemoteTeam 501-1,000Since 2015H1B No Sponsor

PCB Designer creating layouts for Shield AI's aircraft products

Assembly
California + 2 moreAll locations: California, Massachusetts, Texas
$91.7K - $137.5K / year

Production Designer

Included Health

Access. 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

United States
$81.3K - $137.3K / year

Structural Designer / Engineer

Golden Prospects by YMP

Connecting 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

North Carolina
$75K - $110K / year

Card Designer

VIZX International

International Staffing Solutions Recruiter Jobs in Kenya

Designer79 days ago
Full TimeRemoteTeam 51-200H1B No Sponsor

CAD Specialist specializing in architectural lighting shop drawings

Assembly
United States