Beschreibung
DB2 LUW Data & Database Architect & Engineer
On behalf of our client, a leading global company within finance, we are looking for a DB2 LUW Data & Database Architect & Engineer. For this long-term contract position based in Zürich in Switzerland our client is looking for an English speaking candidate who can start as soon as possible.
Are you looking for an exciting new opportunity with a market leading global company then please have a look at the details:
Support Data Architect skill set:
- Knowledge in BI technology and Data Analysis
- Knowledge about/around Data Migration Tools
- Data Modeling - Enterprise Data Modeling with an emphasis on transactional enterprise data models meeting normalization rules
- Knowledge around Data Integration - disparate source systems and disparate data formats.
- Knowledge in Database Design - Structured methods for design (eg Star shema, snowflake )
- Knowledge in Data Architecture - Conceptual Model methods
- Experience in Metadata Management
Database Architect skill set:
- Security Architecture expert
- Database Engine in-depth especially in DB2 DPF (Database Partitioning Feature)
- ETL tools - Designing and implementing ETL processes
- Database Design Patterns - OLAP,DSS
- Database Usage Methods - OLAP, DSS
- New Technologies like Columnar based (DB2 Blu), Hadoop..
- Data Storage Techniques. Defining database server IO profiles and mapping to storage methods such as DAS, SAN, SSD, RAID levels,
- Database Optimization Techniques such as Partitioned Tables, Queues,SQL programming, Exceution Plans, Data File management to support different usage,full range of Backup & Restore strategies, Indexes, XML optimization
- Performance Tuning - Strategies for improved performance across the whole Performance Stack
- Disaster Recovery and High Availability - Techniques such as Linux Clustering, Tivoli Storage Automation, HADR SAN Replication, Global Mirroring
- Extending functionality, sometimes integrating with Legacy systems
- Warehouse experience (Banking)
- Experience with new Storage technologies like 'Flash storage', Storage tiring
- Experience with Column based Databases like Terradata, Neteeza..
- Programming (Perl, Shell)
- Integration with External Applications
- Capacity Planning
- Dataflow analysis for performance improvement to reduce physical IO in a complex environment
Mandatory Skills
- Great experience in DB2 LUW, relationally database, new DB technologies (Hadoop, Columnar...)
- Experience in the area performance and Tuning
- Good skills in creation and analyze/parse also from complex SQL's
- AIX Unix and pre supposed system administration experience
- Analytical for Data warehouses in Financial industry
- Database design (physical, logical)
- DB2 DPF (Database Partitioning Feature)
Apply today to secure your chances in this interesting opportunity for a Swiss fast growing Global Company.
Please don't hesitate to send your CV in English to Ms. Andra Weiland or if you should have any questions, please don't hesitate to call her.
Experis is Europe's leading IT&T recruitment agency with over 100 offices worldwide.