Database Developer

SCCI; Dahlgren (VA); Presencial; USD 90.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health

Dental

Vision

Life and Disability benefits

401k with Company Match

2 weeks paid vacation

48 hours sick/personal leave

11 paid Holidays

Descripción de la vacante

SCCI is seeking a mid-level Database Developer to design and implement a cohesive data ontology across diverse projects in Dahlgren, VA. You will work with architects, data engineers, and stakeholders to normalize and map datasets for analytics and interoperability.

Responsibilities include data modeling, ETL/ELT development, and cross-system data alignment, with a focus on scalable, well-documented data solutions. Requires US citizenship and ability to obtain a Secret clearance.

Formación

• Must be a U.S. Citizen and able to obtain and maintain an active Secret Security Clearance.
• BS degree in Information Systems, Computer Science, Engineering, or Math, or 5 years of related experience in lieu of degree.
• 3-6 years of database development experience.
• Strong proficiency in SQL and relational database design (PostgreSQL, SQL Server, Oracle, MySQL).
• Experience designing normalized schemas and tradeoffs with denormalization.
• Familiarity with semi-structured data (JSON, XML, document stores).
• Experience with ETL/ELT processes and data transformation pipelines.
• Solid data modeling concepts (ER diagrams, dimensional modeling).
• Ability to translate business concepts into structured data representations.

Responsabilidades

• Database Design & Modeling: design, implement, and maintain relational and non-relational schemas.
• Enterprise Data Ontology Development: contribute to enterprise-wide data architecture and mappings.
• Structured & Unstructured Data Integration: analyze and structure unstructured data and pipelines.
• Data Transformation & ETL Support: build ETL/ELT pipelines and ensure data integrity.
• Cross-System Data Alignment: reconcile differences across project teams and standardize data.
• Performance & Optimization: tune queries, indexes, and configurations for performance.
• Documentation & Governance: maintain schemas, mappings, and data governance practices.

Conocimientos

SQL

Relational DB design

Data modeling

ETL/ELT

JSON/XML

NoSQL

Cloud platforms

Docker

Scripting

Security clearance

U.S. citizenship

Educación

BS in Information Systems

BS in Computer Science

BS in Engineering

BS in Math

5 years related experience

Herramientas

PostgreSQL

SQL Server

Oracle

MySQL

MongoDB

Cassandra

AWS

Azure

GCP

Descripción del empleo

Overview

SCCI is seeking a mid-level

Overview

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

• 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
• 11 paid Holidays

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

Essential Skills and Experience:

• 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

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.