This individual will act as the Database Modeler for the project and will provide technical guidance to develop, update, and maintain relational databases in ORACLE RAC and Linux environment. The Database environment for the project is Oracle and for the data sources, it will vary depending upon the data source. Prior experience with Oracle databases as DBA and developer will be required.
Duties:
. Provide end-to-end vision of project showing how the project’s logical design will translate into one or more physical databases. This includes data flows. In support of this function, the contractor shall perform data analysis, modeling, integration and warehousing functions - 25%
. Provide support to the project team to convert business and functional requirements to design, develop, validate, and implement logical and physical data models. This includes both relational and dimensional models- 50%
. Provide support in the development and maintenance of data dictionaries - 20%
Skills:
1. Demonstrated experience in Enterprise Data Modeling tool RDA.
2. Demonstrated ability to review business and technical/application requirements and interpret them into logical data model.
3. Ability to design physical database and generate DDL.
4. Experience with Dimensional Modeling, ER modeling, Star Schema design and full Data Warehouse lifecycle support.
5. Experience in defining/enforcing modeling and naming standards, with concise descriptions -
6. Prior experience as an Oracle DBA and developer.
Nice to have:
1. IDA and rational products.
2. Informatica and ETL concepts.
3. AGILE iterative development experience.
4. Healthcare system experience.
5. Massively parallel database experience.
6. Ability to create technical documentation content and templates.