Olga Sattler Recruiter - Technology osattler@lucasgroup.com Lucas Group

Looking specifically for candidates that want to convert to Full Time Employment. The EDW environment is a multi-terabyte DB2 on AIX installation. We use DB2 version 9.5 with partitioning. Experience in DB2 database administration, Unix and enterprise warehousing is required. Proficiency in Erwin is useful. This DBA position is distinct from a system DBA a focus on development is required We need a candidate who is well versed in DB2 UDB EEE. We are working on AIX with version 5.2. We use the data partitioning feature, MQTs, MDCs, compression, federation and more. The application DBA we are looking for will be knowledgeable about the features just mentioned, plus SQL tuning and data movement. Some Unix scripting and ERwin experience is helpful. Here is some additional information about the work this person will do: EDW Application Database Administrator Role1. Works with the EDW team in refining the conceptual system design into optimal physical database design. 2. Database performance tuning through database physical design, configurations and implementations of data aggregations, MQTs, MDCs, partitioning, indexing and related settings. Responsible for query performance optimization, tuning implementations, and production support.3. Provides database-related technical expertise.4. Works with the development team and the user community to optimize SQL statements.5. Populates development and test databases with sample data.6. Responsible for continuous improvement efforts through performance enhancements. 7. Maintains EDW database security in the development and test environments.8. Provide disk capacity estimates and database physical design information for EDW projects.9. Executes some queries on behalf of the development team and the business users.10. Monitor EDW resources including CPU usage and space utilization in the development and test environments.11. Provides supports for disaster recovery processes and procedures
Required Skills: DB2, Unix, enterprise warehousing, SQL