Distributed DB2 UBD Architect (AIX)

Prestigious Fortune 500 Company located in Chicago’s Western Suburbs is currently seeking a Senior Distributed DB2 DBA Architect who has experience in a Unix (AIX preferred) environment. Candidates will develops integrated data and process models, process flows, and logical database designs, and transforms logical designs into physical designs. Candidates will design, test, implement, maintain and control the organization's databases across multiple platforms, technologies and computing environments. Candidates will develop and maintain the department's documentation standards and development process guidelines and tools. Candidates responsibilities are as follows.
ESSENTIAL RESPONSIBILITIES
•Analyzes and designs data and process models, logical databases and physical data base definitions.
•Designs, implements and maintains databases and database support tools.
•Conducts performance and tuning reviews for improvements to large and complex databases.
•Develops alternative solutions to complex and conflicting requirements for logical models and physical databases.
•Participates in model integration and convergence activities.
•Participates in the development, implementation, communication and maintenance of the corporate data architecture, and of data management standards and conventions.
•Assists in the development of project estimates, plans, and timetables.
•Provides technical support and training and acts as mentor to data administration team members.
•Provides data element naming consistent with standards and conventions and ensures that data dictionaries are maintained across multiple computing environments.
•Works closely with architects on the design and implementation of the database.
•Provides technical support and training.
•Provides mentoring and leadership to department staff.
•Serves as team lead on large projects. Performs other duties as required.
REQUIREMENTS
•Bachelor's degree in Computer Science or related field or equivalent work experience.
•Significant (usually 5+ years) data processing experience including data/process analysis, systems analysis, and programming in DB2 UDB/Oracle 9i/10g with at least 5 years of SQL programming.
•In-depth knowledge of the causes of and remedies of performance issues in large databases from a SQL and SQL coding perspective.
•5+ year's experience working in a Unix environment as well as operating system specific scripting and executions. AIX experience a plus.
•Strong understanding of the systems development process and its relationship to the needs of the business.
•Thorough knowledge of data and process analysis and data base development technologies and tools.
•Excellent analytical ability, consultative, communication skills, strong judgment and the ability to work effectively with clients, data processing managers and staff.