Job Details: DB2 Database Architect / DBA

Job Title:	DB2 Database Architect / DBA
Job ID:	2554
Company:	Everest Consultants Inc.
Position Type:	Contract
Pay Rate:	$60/hr to $80/hr
Skills:	DB2-UDB, AIX, Data modeling, logical and physical design, SQL Tuning
Date Posted:	Sep-25-08

Start Date: ~6 months

Interview: Personal

Background Investigations: Criminal - City, Criminal - State, Criminal - Nation

Job Description:

Project Background:

==============

The Self Sufficiency Modernization Program supports automation improvements in several areas, including benefit programs for Oregon citizens and internal systems used by caseworkers and field staff. This is a major effort with both short and long-term deliverables including web-based applications, data warehouse work, and a large data migration / conversion effort.

Data Architect Position:

===============

This role is will have primary responsibility to support development teams and projects. The role will include work as a data architect (data modeling, database design), database developer (stored procedures, SQL development), and database administrator (data loading, optimization, support, etc).

Project support will include:

1) database design for a series of web-based applications that include integration with legacy systems,

2) data conversion from legacy mainframe systems (VSAM) to normalized data in a DB2 environment and

3) planning for a data warehouse effort. This position will be part of the Self Sufficiency Modernization development team but will also work under the direction of the existing DB2 operational team.

Technologies Involved:

The legacy applications reside in a mainframe environment. DB2 is the primary relational database platform (AIX) and WebSphere / J2EE is a potential web application environment. Cold Fusion is a supported development platform that will be used for short-term solutions. There is a need to support efforts towards a SOA-based architecture. We plan development work to employ agile methodology where appropriate.

Skill Set:

======

-Lead data modeling work.

-Create and document logical/physical design.

-Design and implement proof of concept and development prototype work.

-Work with system admins and DRM group to implement database solutions.

-Creation of database and various objects.

-Write scripts to unload data and automate autoloader scripts.

-Create test cases for benchmark testing.

-Performance tuning was an on going process, tuning queries.

-Support SQL tuning / optimization, DB/DBM parameter tuning, different levels of memory allocations

-Utilize tools for export, import, load, autoloader and database snapshots.

-Creating and Monitoring Users, authorities and responsibilities and password management.

-Backup & Recovering Database, Online database backup, archived redo log file and offline database backup.

-Tuning the application for the best performance.

-Tuning the Database and the system for the best performance.

-Day-to-day attending to the developer queries in sorting out database problems.

-SQL Programming -- developing database views and stored procedures.

Requirements:

=========

-7+ years of database development experience, including DB2 / UDB ver. 8 and above

-5+ years of SQL programming, including stored procedures.

-7+ years of data modeling experience.

-Experience support DB2 on multiple platforms (AIX, zOS)

-Ability to interact with team members including business owners

-Familiarity and experience with legacy mainframe data systems (VSAM) helpful.

---------------------------------------------------------

Location: [rss]	US-OR-Salem
Telecommute:	No (Onsite Position)
Contact Name:	Rajkumar
Contact Phone:	503-941-4157
Contact Email:	raj@everestinc.com
URL:	http://www.recruitingcenter.net/clients/EverestInc/publicjobs/canviewjobs.cfm
Contact Comments:
If you are interested in pursuing this opportunity, please send your resume in word format with salary expectations. You can also apply online by visiting our careers web page at the following URL and search for Job ID: 2554.

Principals only. Recruiters, please do not contact this job poster.

---

View other jobs in US-OR-Salem »
View other jobs in US-OR »

View other DB2 Architect jobs, DB2 jobs, Systems Architect jobs, IT Contract jobs, Tech jobs

View other jobs requiring these skills: DB2-UDB, AIX, Data modeling, logical and physical design, SQL Tuning

View other postings by Everest Consultants Inc. »