Database Architect & Engineer, DB2 LUW, AIX (Ref. PS2006)

Vor Ort
flag_no Schweiz

Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.

Database Architect & Engineer, DB2 LUW, AIX

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;

Data Architect skill set:

  • Knowledge in BI technology and Data Analysis (1)

  • Knowledge about/around Data Migration Tools (2)

  • Data Modeling - Enterprise Data Modeling with an emphasis on transactional enterprise data models meeting normalization rules (1)

  • Knowledge around Data Integration - disparate source systems and disparate data formats. (2)

  • Knowledge in Database Design - Structured methods for design (eg Star shema, snowflake ) (nearly same as Data Modeling)

  • Knowledge in Data Architecture - Conceptual Model methods

  • Experience in Metadata Management

Database Architect skill set:

  • Security Architecture expert (2)

  • Database Engine in-depth especially in DB2 DPF (Database Partitioning Feature) (1)

  • ETL tools - Designing and implementing ETL processes (2)

  • Database Design Patterns - OLAP,DSS

  • Database Usage Methods - OLAP, DSS

  • New Technologies like Columnar based (DB2 Blu), Hadoop.. (1)

  • Data Storage Techniques. Defining database server IO profiles and mapping to storage methods such as DAS, SAN, SSD, RAID levels, (2)

  • 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 (1)

  • Performance Tuning - Strategies for improved performance across the whole Performance Stack (1)

  • Disaster Recovery and High Availability - Techniques such as Linux Clustering, Tivoli Storage Automation, HADR SAN Replication, Global Mirroring (1)

  • Extending functionality, sometimes integrating with Legacy systems

    • Warehouse experience (Banking) (1)
    • Experience with new Storage technologies like 'Flash storage', Storage tiering (3)
    • Experience with Column based Databases like Terradata, Neteeza.. (2)
    • Programming (Perl, Shell) (1)
  • Integration with External Applications (2)

  • Capacity Planning (3)

    • Dataflow analysis for performance improvement to reduce physical IO in a complex environment

Work experience required

Self-employed person, target oriented, flexible and communicative personality, which one to estimate the cooperation in a small team. 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.. Efficient handling/experience of MS Office products (Word, Excel, PowerPoint) are prerequisite. Preferred German and English written and spoken

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)

To learn more about this opportunity please send your CV ASAP in Word format to Brine SA.

Work location: Zürich

Start: Asap

Duration: open

Permits required: EU citizen or valid work permit

Workload: 100%

Language: English & German

Ref: PS2006