22ITC an American IT Staffing Company, is a fastest growing web design, web development and a leading national IT Staffing agency based in Astoria, New York, providing professional staffing, IT Staffing and IT Services solutions nationwide. We at 22ITC, offers a wide range of IT services such as Website Design, Website Development, Applications and Products development, Mobile Application Development, support and maintain legacy applications, Project management Consulting, Quality Consulting, Consulting in Test Automation solutions, Re-engineering and Integration Services, Contract Staffing, IT Staffing, IT services and Business Process Outsourcing (BPO).22ITC continues to look for experienced technology professionals to join our team of great people!

Datawarehouse DBA / DB2 DBA

Chicago, IL
6 Months Contract

Visa Sponsorship: H1B Transfer TN Visa
E3 Visa OPT
Green Card

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

Keywords: DB2 DBA in Chicago IL Required, Datawarehouse DBA in Chicago IL Required, DB2 DW Jobs, DB2 AIX DBA, Contract Jobs, DB2, AIX, HADR, AIX Scripting, Datawarehouse, DBA, UNIX, Contract jobs in IL, IT Staffing