Qureos Mentor

California Creative Solutions Inc.

Job Duties and Responsibilities:<ul><li>Lead the development of a unified database structure that integrates data from eight distinct legacy systems into a single Oracle-based architecture</li><li>Design comprehensive database schema's using Oracle technologies, creating detailed entity-relationship diagrams and defining normalization strategies</li><li>Establish secure data architecture incorporating row-, column-, and cell-level access controls while supporting replacement of sensitive identifiers such as Social Security Numbers</li><li>Collaborate with software engineers, DevSecOps teams, and government stakeholders to ensure database structure supports modular application development and seamless incremental deployment</li></ul>Technical Responsibilities<ul><li>Design, develop, and maintain Oracle 19c or newer database systems with advanced schema design techniques</li><li>Implement relational database normalization, performance tuning, and indexing strategies that enable efficient real-time and batch processing</li><li>Collaborate with cross-functional teams including software engineers, DevSecOps teams, and government stakeholders</li><li>Participate in Agile ceremonies including backlog refinement and sprint planning processes</li><li>Define and maintain data mappings between legacy and modernized structures to support incremental migration</li><li>Support test data generation and guide integration of secure data migration pipelines using ETL processes and tools</li><li>Other duties as assigned.</li></ul>Education &amp; Experience<ul><li>Bachelor's degree in computer science, Information Systems, Database Management, or related field</li><li>Minimum 7 years of experience in senior database design and architecture roles</li><li>Experience supporting government or defense agency systems preferred</li><li>Security + CE/ IAT Level II certification</li><li>Public Trust / IT II Security clearance eligibility - Must be a US citizen.</li></ul>Technical SkillsDatabase Technologies:<ul><li>Proficiency in Oracle 19c or newer database systems</li><li>Advanced PL/SQL programming and optimization</li><li>Strong experience with relational database normalization, performance tuning, and indexing</li></ul>Data Management:<ul><li>Familiarity with data modeling, entity-relationship diagrams, and data dictionary creation</li><li>Experience supporting or participating in ETL processes for data migration</li><li>Understanding of data quality analysis and governance practices</li></ul>Security &amp; Compliance:<ul><li>Understanding of database access control, encryption, and data masking practices</li><li>Knowledge of Zero Trust security principles and federal compliance frameworks</li><li>Familiarity with DoD environments and security standards</li></ul>Data Integration &amp; Migration:<ul><li>Working knowledge of ETL processes and tools</li><li>Experience with Oracle Goldengate or other real-time data migration platforms</li><li>Understanding of data mapping and transformation techniques</li></ul>Soft Skills<ul><li>Strong problem-solving and analytical thinking abilities for complex database architecture challenges</li><li>Excellent communication skills to collaborate effectively across Agile teams</li><li>Ability to work collaboratively with cross-functional teams including government stakeholders</li><li>Self-motivated with strong time management skills for managing multiple database deliverables</li><li>Adaptability to changing priorities and evolving government requirements</li><li>Detail-oriented approach to maintaining data governance and compliance standards</li></ul>Job Type: Full-timePay: $70,000.00 - $80,000.00 per yearEducation:<ul><li>Bachelor's (Required)</li></ul>Experience:<ul><li>Database design: 7 years (Required)</li><li>Database Architecture: 7 years (Required)</li><li>Oracle: 7 years (Required)</li></ul>License/Certification:<ul><li>CompTIA Security+ (Required)</li></ul>Work Location: Remote

Senior Database Designer

Join California Creative Solutions Inc. and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

California Creative Solutions Inc.

ABOUT_COMPANY

Senior Database Designer