Database Architect.

Location: Albany : NY

Duration :2 years

Rate Open / most competitive

This is not a C2C opportunity.. Green card, Citizens, EAD, TN visa, H1 transfers will be considered.

PROJECT OVERVIEW
This project is an ongoing effort to provide the development, maintenance, and support activities to maintain a complex and highly integrated application which consists of several development and end user supported environments.

The following activities are indicative of the assignments/outcomes expected of the Data Architect:

* Participation in requirement and design sessions
* Create packages for the new architecture.
* Participate in database design within an existing Oracle database structure.
* Write complex functions and procedures for new packages and update existing packages in an established Oracle database using pre-defined business rules.
* Work with developers to design and write complex packages to support their needs.
* Work with Database Administrators to implement design changes and new packages.
* Provide database support to developers who write code using WCF, WPF and .Net. developing appropriate system documentation,
* Monitor the performance of the database recommending improvements
* Support data warehouse/data mart activities


MANDATORY SKILL/EXPERIENCE:
1. Five years experience in designing and implementing high volume multiple database environments (specifically Oracle 9i, Oracle 10g, or higher)

2. Three years experience in the following:
> design strategies for migration from hierarchical structures to relational databases and integrating those on multiple platforms
> design and implementation of data warehousing and data mart activities in a heterogeneous database environment
> the development and implementation of operational standards and protocols
> knowledge transfer, transition of systems and mentoring

DESIRABLE SKILL/EXPERIENCE:
1. Good communication and interpersonal skills.
2. At least 4 years experience in design strategies for migration from hierarchical structures to relational databases and integrating those on multiple platforms.
3. At least 4 years experience of general data modeling experience using enterprise modeling tools for Oracle 10g or higher environments.
4. At least 4 years experience as a database architect/developer in an Oracle 10g or higher environment developing packages, stored procedures, views, triggers and functions etc.
5. At least 4 years experience monitoring and improving the performance of an Oracle 10g or higher database for a large scale n-tier application.
6. At least 4 years experience in the design and implementation of data warehouse and data mart activities in a large scale database environment.
7. At least 4 years experience in performing knowledge transfers to client staff of Oracle database techniques supporting the development of database structures for large scale n-tiered applications.