Join our Talent Network >

Database Modeler

This job posting is no longer active.

Job ID: 196932
Location: ALEXANDRIA, VA, United States
Date Posted: Sep 27, 2019
Category: Information Technology
Subcategory: Cloud Comp Engr
Schedule: Full-time
Shift: Day Job
Travel: No
Minimum Clearance Required: None
Clearance Level Must Be Able to Obtain: Public Trust
Potential for Teleworking: No

Share: mail

Job Description

Description

 

SAIC is seeking a Database Modeler in support of a concentrated effort at a large Federal Agency to bring legacy, high priority IT systems up to current and supported operating levels while also addressing critical needs for high availability, fail-over capability, decoupling of highly connected systems, and/or cloud-based solution implementations. 

Job Specifications:

  • Designing or maintaining data representation models. Responsible for the definition and governance of the data model. Sets standards for how data is to be represented in corporate databases.

  • Identifies and manages data model domain data stewards and conducts data modeling enabling activities including the development of the Logical Data Model, Data Dictionary, Physical Data Models, data format specifications, model releases, data harmonization and mapping across the data models, the modification of tools to support data modeling, and software application programming interfaces and converters to enable data model implementations.

  • Shall have demonstrated skills, experience, and knowledge in supporting as well as implementing and maintaining Oracle and SQL data infrastructures as well as No-SQL data infrastructures

  • Collaborate with data source SMEs and technical customer leads to answer or document questions on structure, mission requirements and compliance concerns of the data flow and the data storage and representation in the corporate repositories. 

  • Tasks may include developing data models for optimal performance in databases; designing data structures for data interchange; developing metadata structures including dictionaries, taxonomies and ontologies.

  • Provides technical consulting for teammates and application teams for data naming, classification, design, and handling as a part of the first line of defense for data controls in designing systems.

  • Suggests and implements improvements in architecture, team processes, and functions.

  • Provides subject matter expertise to meet customer technical, schedule and cost requirements. 

  • Supports input to and development of analysis of alternates for systems future state considering high availability, fail-over capability, decoupling of highly connected systems, and/or cloud-based solution implementations.

 

Qualifications

  • Bachelor’s degree in Computer Science, or related field and 9+ years of experience in IT, Data Analysis, Data Manipulation, or related field.

  • Strong written and verbal skills

  • Excellent communication and presentation skills

  • Experience in performing Analysis of Alternatives (AoA)

  • Experience with ER/Studio, Erwin Data Modeler, and Oracle SQL Developer Data Modeler

  • Experience with most or all of the following:

    • Top Down / Requirements Driven Approach

    • Fact Tables and Dimension Tables

    • Multidimensional Model/Star Schema

    • Roll Up, Drill Down, and Pivot Analysis

    • Time Phased / Temporal Data

    • Operational, Logical, and Physical Data Models

    • Normalization and Denormalization

    • Model Granularity : Level of Detail

    • Areas that require specialized patterns are:

    • Data Mart / Frontroom - uses dimension modeling - the ROLAP star schema or the MOLAP cube

    • Data warehouse / Backroom - uses normalized ERD

    • Staging / Landing Area - looks like source system

Desired Qualifications

 

OS and Virtualization: HP-UX/AIX/Linux, Windows, Amazon AMI, VMWare, RHEV

Database: Oracle, MySQL, MS SQL, PostgreSQL, Datastax

Proficient in SQL for data analysis

Servers: Cisco UCS, HP, Dell, IBM

Database Consolidation and/or Separation, Data Migration from one Storage Platform to another

Monitoring: Splunk, AppDynamics, TeamQuest, HP Openview

Programming Languages Group A: COBOL and (Java or .NET or C++)

 

Database Consolidation and/or Separation, Data Migration

Cloud Migration, Implementation, AWS Services, FedRAMP, System Integration capability

Working experience with dimensional data modeling

Application Lifecycle Management (ALM), Rational ClearQuest/ClearCase, Rally, Subversion, Nexus, Jenkins, Sonar, Crystal Reports

Puppet, Chef, Ansible, Selenium, Jenkins, Nexus, and Docker

Agile methodologies




Overview

SAIC is a premier technology integrator, solving our nation's most complex modernization and systems engineering challenges across the defense, space, federal civilian, and intelligence markets. Our robust portfolio of offerings includes high-end solutions in systems engineering and integration; enterprise IT, including cloud services; cyber; software; advanced analytics and simulation; and training. We are a team of 23,000 strong driven by mission, united purpose, and inspired by opportunity. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $6.5 billion. For more information, visit saic.com. For information on the benefits SAIC offers, see Working at SAIC. EOE AA M/F/Vet/Disability

Share: mail

Similar Jobs

Senior Linux Systems Administrator

SPRINGFIELD, VA, United States
Information Technology

Senior Network Engineer Principal

SPRINGFIELD, VA, United States
Information Technology

SCCM Lead

ROCKVILLE, MD, United States
Information Technology

Database Engr Manager

CHANTILLY, VA, United States
Information Technology

Expert Service Now Architect

MCLEAN, VA, United States
Information Technology

VDI/Mobility SME

REMOTE WORK, VA, United States
Information Technology

NOC Specialist (Third Shift)

WASHINGTON, DC, United States
Information Technology

Watch Officer/Network Monitor, Night Shift, TS/SCI & Poly Required

HERNDON, VA, United States
Information Technology

Technical Writer

RESTON, VA, United States
Information Technology

Senior Project Manager

RESTON, VA, United States
Information Technology

Project Manager/Senior Architect/Lead

RESTON, VA, United States
Information Technology

Automated Tester

RESTON, VA, United States
Information Technology

IT Sys Engineer

SPRINGFIELD, VA, United States
Information Technology

Database Architect

ALEXANDRIA, VA, United States
Information Technology

Network Engineer SETA

CHANTILLY, VA, United States
Information Technology

Network Engineer SETA

CHANTILLY, VA, United States
Information Technology

AWS Cloud Engineer

CHANTILLY, VA, United States
Information Technology

Azure Cloud Engineer

RESTON, VA, United States
Information Technology

Enterprise Agile Strategist

LANHAM, MD, United States
Information Technology

Senior Service Now Architech

MCLEAN, VA, United States
Information Technology

Data Scientist Principal

UPPER MARLBORO, MD, United States
Information Technology

Sys Administrator Manager/Sr Manager

CHANTILLY, VA, United States
Information Technology

Sys Administrator Manager

CHANTILLY, VA, United States
Information Technology

Principal Network Engineer

ARLINGTON, VA, United States
Information Technology

Data Scientist

CHANTILLY, VA, United States
Information Technology