Senior SQL/Oracle Software Architect
Makes high-level design choices and dictates technical standards, including software coding standards, tools, and platforms. Designs multi-leveled architecture or component interactions of a large scale software system.
60-84 months
Candidate able to work independently, without assistance and provides guidance to others. May have an advanced education.
Requirements:
- 84 Months experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modeling including star schema, snowflake schema, etc.
- 84 Months experience in a data modeling tool (e.g., ErWin, ER/Studio).
- 84 Months experience in relational data management disciplines and design and development experience using Oracle technologies.
- 84 Months experience with SQL programming.
- 60 Months experience working with business intelligence tools (e.g., OBIEE 11G).
- 60 Months experience working with ETL tools (e.g. Informatica).
- 60 Months experience with designing, creating applications and health care Data Warehouse and business intelligence reporting solutions.
- 48 Months experience working with HIPAA requirements or similar standards and NYS Accessibility Standards.
- 48 Months experience with reviewing the data modeling of others for compliance and accepted standards of development.