Senior Data Architect

Job type:
on-site
Start date:
n.a
Duration:
n.a
From:
ISSG, Inc. - Information Systems Services Group
Location:
Missouri
Published at:
03/10/2015
Country:
flag_no USA
Project ID:
864708

Warning
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Senior Data Architect

Description

The candidate will work with a team of business users, Java developers, architects and designers to implement applications given specific business requirements. The Architect must understand business objectives, translate them into application design, transition the application into operational status, and assist with application support and maintenance.

Responsibilities:

Creates and maintains logical and physical data models

Performs physical design and performance tuning

Develops and implements a security strategy per established security standards

Creates and maintains the physical database schemas

Analyzes and incorporates data from interfacing systems

Assists in maintaining development database instances

Creates and maintains stored procedures

Generates test data

Attends use case reviews

Provides support for system migration activities and documentation

Reviews developer SQL for accuracy and performance

Assists in production problem resolution

Composes and executes ad hoc queries for user requests

Assists in troubleshooting database connectivity issues

Qualifications

5+ years experience in data analysis and Oracle database administration

Excellent written and oral communications

Experience with the following: Oracle SQL Developer or Toad for Oracle, Oracle Enterprise Manager, Oracle RDMSUtilities, DML, DDL, and PL/SQL

Experience with the following a plus: Rational Data Architect, Hibernate, Rational Team Concert, Sun Unix operating system

Experience with Business Intelligence design concepts and Data Mart/Data Warehouse database design (Star Schemas) a plus.

Bachelors Degree in any field of study or commensurate experience required.