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.