Database Architect/Engineer for DB2 (2076)

Vor Ort
12 Monate
flag_no Schweiz

Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.
For a project at our banking client site in Zurich, we are looking for a skilled

Database Architect/Engineer for DB2 (2076)

The team is responsible for all DB2 related service delivery, engineering und DB2 architecture tasks.
For this role with long-term experience in the DB2 & partially AIX Area we are looking for the following skillsets:

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 (e.g Star shema, snowflake…)
Knowledge in Data Architecture – Conceptual Model methods
Experience in Metadata Management

Database Architect skillset:

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

Analytical intellectual capacity as well as several years of field experience in the Unix area, AIX & deep skills in the DB2 LUW are prerequisite. Preferred are DB2 Architectural, DB2 Design and Engineering skills. Excellent Skills in creating and analyze SQL as well as experience in performance and Tuning.
Experience in the area system administration as well as engineering and programming skills are preferred.

Preferred is German and English, both written and spoken, English only is also possible.

Should you consider yourself the ideal candidate, we look forward to receiving your application in .doc format on