Database Developer
About the role
SCCI 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. You will 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.
Responsibilities
- Database Design & Modeling
- Design, implement, and maintain relational and non-relational database schemas aligned with enterprise data standards
- Develop logical and physical data models that support scalability, performance, and maintainability
- Normalize and optimize table structures while balancing performance considerations
- Enterprise Data Ontology Development
- Contribute to the definition and evolution of an enterprise-wide data architecture
- Map data elements across systems into a unified conceptual model
- Define relationships, hierarchies, and semantic consistency across datasets
- Collaborate with stakeholders to standardize naming conventions and data definitions
- Structured & Unstructured Data Integration
- Analyze unstructured and semi-structured data (JSON, logs, documents, etc.) and design strategies to structure and integrate it
- Develop transformation pipelines to align disparate data sources into cohesive schemas
- Support metadata tagging and classification efforts
- Data Transformation & ETL Support
- Build and maintain a pipeline to extract, transform, load (ETL/ELT) and cleanse data
- Ensure data integrity, consistency, and traceability across systems
- Support data lineage and auditability requirements
- Cross-System Data Alignment
- Work across multiple project teams to reconcile differences in data structures and definitions
- Identify duplication, inconsistency, and gaps in existing data models
- Propose and implement standardized solutions
- Performance & Optimization
- Tune queries, indexes, and database configurations for performance and efficiency
- Monitor database health and implement improvements as needed
- Documentation & Governance
- Maintain clear documentation of schemas, data models, and ontology mappings
- Support data governance initiatives, including data quality standards and validation rules
- Contribute to best practices and development standards
Qualifications
- Must be a U.S. Citizen and be able to obtain and maintain an active Secret Security Clearance
- Bachelor's (BS) Degree in Information Systems, Computer Science, Engineering, or Math; Or five (5) years technical experience with information management in lieu of degree
- Three (3) - Six (6) years of experience in database development
- Strong proficiency in SQL and relational database design (e.g., PostgreSQL, SQL Server, Oracle, MySQL)
- Experience designing normalized schemas and understanding tradeoffs with denormalization
- Familiarity with handling semi-structured/unstructured data (e.g., JSON, XML, document stores)
- Experience with ETL/ELT processes and data transformation pipelines
- Solid 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 Clearance
- Experience contributing to or working with data ontologies, semantic models, or knowledge graphs
- Familiarity with data cataloging, metadata management, or data governance tools
- Exposure to NoSQL databases (MongoDB, Cassandra, etc.) and hybrid data architectures
- Experience with cloud data platforms (AWS, Azure, GCP)
- Experience with Docker containerization
- Knowledge of data lineage, data quality frameworks, and master data management (MDM)
- Basic scripting or programming skills (Python, Bash Script, etc.) for data processing
Benefits
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.