Database Developer

Job DetailsJob Location: Dahlgren, VA 22448Position Type: Full TimeOverviewSCCI is seeking a mid-level Database Developer to join our team! In this position you will support the design and implementation of a cohesive enterprise data ontology across a diverse portfolio of projects and systems. This role is central to transforming fragmented and unstructured data into a unified, well-modeled data ecosystem that supports analytics, interoperability, and long-term scalability. If you have strong database design expertise to support relating data across systems join our team and work closely with architects, data engineers, and domain stakeholders to define consistent data structures, normalize and map disparate datasets, and contribute to a shared enterprise data vision. This position is located in Dahlgren, VA. SCCI offers a comprehensive and competitive benefits package including Health, Dental, Vision, Life and Disability benefits, 401k with Company Match, time off consisting of 2 weeks of paid vacation, 48 hours of sick/personal leave, and 11 paid Holidays. Responsibilities:Database Design & ModelingDesign, implement, and maintain relational and non-relational database schemas aligned with enterprise data standardsDevelop logical and physical data models that support scalability, performance, and maintainabilityNormalize and optimize table structures while balancing performance considerationsEnterprise Data Ontology DevelopmentContribute to the definition and evolution of an enterprise-wide data architectureMap data elements across systems into a unified conceptual modelDefine relationships, hierarchies, and semantic consistency across datasetsCollaborate with stakeholders to standardize naming conventions and data definitionsStructured & Unstructured Data IntegrationAnalyze unstructured and semi-structured data (JSON, logs, documents, etc.) and design strategies to structure and integrate itDevelop transformation pipelines to align disparate data sources into cohesive schemasSupport metadata tagging and classification effortsData Transformation & ETL SupportBuild and maintain a pipeline to extract, transform, load (ETL/ELT) and cleanse dataEnsure data integrity, consistency, and traceability across systemsSupport data lineage and auditability requirementsCross-System Data AlignmentWork across multiple project teams to reconcile differences in data structures and definitionsIdentify duplication, inconsistency, and gaps in existing data modelsPropose and implement standardized solutionsPerformance & OptimizationTune queries, indexes, and database configurations for performance and efficiencyMonitor database health and implement improvements as neededDocumentation & GovernanceMaintain clear documentation of schemas, data models, and ontology mappingsSupport data governance initiatives, including data quality standards and validation rulesContribute to best practices and development standards Essential Skills and Experience:Must be a U.S. Citizen and be able to obtain and maintain an active Secret Security ClearanceBachelor's (BS) Degree in Information Systems, Computer Science, Engineering, or Math; Or five (5) years technical experience with information management in lieu of degreeThree (3) - Six (6) years of experience in database developmentStrong proficiency in SQL and relational database design (e.g., PostgreSQL, SQL Server, Oracle, MySQL)Experience designing normalized schemas and understanding tradeoffs with denormalizationFamiliarity with handling semi-structured/unstructured data (e.g., JSON, XML, document stores)Experience with ETL/ELT processes and data transformation pipelinesSolid understanding of data modeling concepts (ER diagrams, dimensional modeling, etc.)Ability to translate business/domain concepts into structured data representations Preferred Skills and Experience:Active Secret Security ClearanceExperience contributing to or working with data ontologies, semantic models, or knowledge graphsFamiliarity with data cataloging, metadata management, or data governance toolsExposure to NoSQL databases (MongoDB, Cassandra, etc.) and hybrid data architecturesExperience with cloud data platforms (AWS, Azure, GCP) Experience with Docker containerizationKnowledge of data lineage, data quality frameworks, and master data management (MDM)Basic scripting or programming skills (Python, Bash Script, etc.) for data processing SCCI is committed to providing a comprehensive and competitive benefits package to meet the needs of Employees and their families. EOE of Veterans and Disabilities.