Join our Talent Network >

Database Modeler

Job ID: 196932
Location: ALEXANDRIA, VA, United States
Date Posted: Sep 10, 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

Cloud Developer (Remote)

FLEXWORK, VA, United States
Information Technology

Network Administrator Lead (flexwork)

FLEXWORK, VA, United States
Information Technology

Technical Lead (flexwork)

ROCKVILLE, MD, United States
Information Technology

Sr. Cloud Operations Analyst

RESTON, VA, United States
Information Technology

Business Process Analyst

FLEXWORK, VA, United States
Information Technology

Business Process Analyst

FLEXWORK, DC, United States
Information Technology

IT Sys Engineer Senior

CHANTILLY, VA, United States
Information Technology

Cloud Software Developer

RESTON, VA, United States
Information Technology

Mobility Lead (Remote)

FLEXWORK, VA, United States
Information Technology

Cloud System Administrator

RESTON, VA, United States
Information Technology

Service Desk Lead-ITSM certified (flexwork)

FLEXWORK, VA, United States
Information Technology

IT Security Team Manager

GREENBELT, MD, United States
Information Technology

Requirements Analyst

VIENNA, VA, United States
Information Technology

Sr Manager of Business Analysis

RESTON, VA, United States
Information Technology

Cloud Operations Manager

RESTON, VA, United States
Information Technology

Data Scientist Sr Principal

RESTON, VA, United States
Information Technology

Data Operations Senior Network Engineer (VG00011)

WASHINGTON, DC, United States
Information Technology

Sr. Enterprise Data Architect Principal

RESTON, VA, United States
Information Technology

Classified IT Engineer

CHANTILLY, VA, United States
Information Technology

Classified IT Engineer

LORTON, VA, United States
Information Technology

Business/Requirements Analyst (flexwork)

ROCKVILLE, MD, United States
Information Technology

Cloud Developer (Remote)

FLEXWORK, DC, United States
Information Technology

Database Admin Lead (Remote)

FLEXWORK, VA, United States
Information Technology

O365 Migration Project Manager

ROCKVILLE, MD, United States
Information Technology

System Development and Engineering Manager

WASHINGTON, DC, United States
Information Technology

Provide your information to receive jobs that fit you by keywords, location, and more,
and then receive great opportunities based on your skills and experience.

Join our Talent Network >