The Database Architect will design, maintain and build conceptual, logical and physical database models. The Database Architect will be responsible for database architecture, design, and creation, optimization, deriving conversion and migration methods for existing data, and developing automated conversion and migration methods.
The Database Architect will be responsible for the planning, installation, configuration, maintenance and production monitoring of database instances.
Meet with business stakeholders and other technical team members to gather and analyze application requirements
Design database solutions to satisfy application (business and technical) requirements
Implement database solutions using available database development tools
Provide first level operational support for development and production
Provide written status reports to management regarding project status,
task, and issues/risks
Oracle RAC 11g experience from the development perspective (database
and application), PL/SQL, Solaris, etc.
Ability to analyze existing ETL code in both PL/SQL and shell script,
and determine impacts and remediation.
Ability to analyze existing database schema DDL/instance layout and
determine impacts migrating to new target schema/instance environment.
Strong experience in Informatica ETL tools
Strong experience in Business Process Modeling (BPM)
Ability to provide guidance to offshore developers and to lead certain
Ability to interact with external DBAs and help
SAS is mandatory, experience of Multidimensional Modeling is prefered.