Job ID: 1926418
Location: ALEXANDRIA, VA, United States
Date Posted: Oct 29, 2019
Category: Information Technology
Subcategory: Database Engr
Shift: Day Job
Minimum Clearance Required: None
Clearance Level Must Be Able to Obtain: Public Trust
Potential for Teleworking: No
SAIC is seeking a database developer 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.
Database Developer will play a crucial role in designing the data model by following the best practices and industry standards, making use of the standard tools and technique, adopting frameworks and services needed by current and forward-looking features.
Responsible for interacting with the business and Data Architects and collecting the requirements for data model for the target system and from the current system.
Database engineer will be responsible for translating business requirements into conceptual, logical, and physical data models.
Responsible for building optimal databases to store data coming from legacy systems, and provide bi-directional dataflow.
Past experience in translating business requirements into conceptual, logical, and physical data models.
Experience in creating entity relationship diagrams and multi-dimensional data models, reports and diagrams.
In-depth understanding of Normalization techniques and Data Modeling principles
Experience with one of the Data Modelling Tools: Erwin / Oracle Developer / ER Studio
Experience with OLTP & OLAP Modelling
Solid knowledge in ETL process and tools (Tableau, ODI,Informatica) to perform data mapping, migrate databases.
Knowledge of Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.
Should have generated data definition language (DDL) used to create the database schema
Enforce standards and best practices around data modelling.
Should have excellent problem solving and time management skills.
Should have good communication skills to interact with business and data architects for data model management and version control.
Experience administering Oracle database on AWS - RDS environment.
Experience in writing code using Oracle's PL/SQL language.
Solid knowledge of Oracle 10g/11g/12c/18c and technical database concepts, such as: logical relational data modeling, physical data modeling,
Experience in tuning large instances, data replication and backup/recovery techniques
Ability to obtain Public Trust Clearance
Familiar with other databases such as MySQL, MS SQL Server, MongoDB
Familiar with AWS RDS services and implementation.
ETL Advanced Training is a plus
Any DB related certifications is a plus.
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