Datawarehouse DBA / DB2 DBA

Chicago, IL

6 Months Contract

Data Warehouse DBA (DB2 AIX)

Responsible for designing, modeling, developing and supporting Database Management Systems (DBMS). Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements. Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning. Develops database and warehousing designs across multiple platforms and computing environments. Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.


Excellent knowledge of DB2 Version 9.7 and DB2 V10.5 for AIX

AIX scripting

Bachelor’s Degree in Computer Science, Information Systems, or other related field

Strong Background working in Data Warehouse environment

In depth knowledge and experience in DB2 AIX within an enterprise level environment

Knowledge of load balancers,


DB2 LUW 9.7, 10.1, and 10.5

Very strong knowledge of HADR, replication, CDC, range partitioning, Disaster Recovery with business continuity, Perform routine maintenance (Backup and Recovery, REORGS, RUNSTATS, etc), Stored procedures, Provide load and Performance testing support, Monitor Database space usage, Monitor database performance bottlenecks, etc.

UNIX scripting skills (Perl, Shell, VBS, etc.)

Previous experience leading a functional team or project

Independently solves complex problems

Takes a new perspective using existing solutions, works independently, receives minimal guidance