* Design and implement a data warehouse * Assist in the design and development of the ETL system for
loading data into the warehouse.
* Analyze, design, recommend and implement the optimization
strategy for the data warehouse, including:
* Indexes
* Denormalization strategy
* Partitioning strategy
* Assist in designing and reviewing the design of the warehouse
data model, and implement the design that is developed.
* Write all database software to support the data warehouse,
including:
* PL/SQL procedures,
* Triggers,
* Periodic processes, and
* Other software support as needed.
* Work with other programming resources to facilitate any
software development external to the database.
* Work with end customers to design and optimize analytical
queries within Conrep.
* Assist the DBA in the development and implementation of the
data warehouse's storage policy.
* Create and maintain documentation on the development internals and operation of all products that are developed.
* Other functionality as required.

KEY QUALIFICATIONS
------------------
* Minimum 3 years experience with Oracle data warehouses,
preferably data warehouses in excess of 1 TB, including:
* Experience designing and implementing ETL strategies for
data warehouses
* Experience designing and optimizing queries against data
warehouses
* Minimum 5 years experience writing Oracle PL/SQL software,
including PL/SQL procedures, functions, packages and triggers.
* Background in a consultative and contract environment
preferred.
* Experience working in small teams in a fast-paced environment.
* Undergraduate degree in a computer-related field or equivalent experience.
* Knowledge of software architecture and design patterns.
* Experience with complex SQL for data extraction.
* Ability to write technical and business documentation. A short writing sample should be included in your application.
* Experience with source code control systems, in particular

Subversion.

KEY TECHNOLOGIES
----------------
* PL/SQL
* Oracle 10g (10.2.0.3)
* Oracle RAC, RMAN, DataGuard, and Veritas/SAN technologies
* Subversion source code control system.