Beschreibung
For our client in Zurich we are looking for a DB2 Database Architect & Engineer
Your responsibilities:
For this role as an DB2 LUW Data & Database Architect & Engineer with long-term experience in the DB2 & partially AIX Area we are looking for the following skillsets; Small Team with 7 - DB2 Sys Admins/Engineers & 4 - DBAs. The team is responsible for all DB2 related service delivery, engineering und DB2 architecture tasks.
For Sys Admin they deliver a 7x24H On Call and/or weekend Support Data Architect skill set:
As the ideal candidate you have the following qualifications and experience:
Knowledge in BI technology and Data Analysis Knowledge about/around Data Migration Tools Datamodelling - Enterprise Datamodelling 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 schema, snowflake ) Knowledge in Data Architecture - Conceptual Model methods Experience in Metadata ManagementDatabase 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 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 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 SQLs AIX Unix and pre supposed system administration experience Analytical for Data warehouses in Financial industry Database design (physical, logical) DB2 DPF (Database Partitioning Feature)
If you are interested in this position please do not hesitate to send us your CV electronically