DB2 LUW Data & Database Architect / Engineer (f/m)

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

Schlagworte

Beschreibung

Bosshard & Partner is looking with Mandate 2488

for a DB2 LUW Data & Database Architect / Engineer (f/m)


Project environment

As a DB2 LUW Data & Database Architect / Engineer with long-term experience in the DB2 & partially AIX Area, you will work in a global Swiss Bank in a small Team of seven DB2 Sys Admins / Engineers and four DBAs.

Tasks

• As part of the team, you are responsible for all DB2 related service delivery, engineering and DB2 architecture tasks.
• Delivery of a 7x24H On Call and/or weekend Support.

Requirements

• Several years of field experience in the Unix & AIX area.
• Great experience in DB2 LUW, relational databases and new DB technologies (Hadoop, Columnar etc.).
• Experience in the area Performance Tuning– Strategies for improved performance across the whole Performance Stack.
• Good skills in creation and analysis of complex SQL's.
• AIX, Unix and System Administration experience.
• Analysis of Data Warehouses in Financial industry.
• Knowledge in Database Design (physical & logical, e.g. Star Schema, Snowflake…).
• Knowledge of Database Engine, especially in DB2 DPF (Database Partitioning Feature).
• Efficient handling / experience of MS Office products (Word, Excel, PowerPoint)

Nice to have:
• Skills in DB2 Architecture, DB2 Design and Engineering.
• Experience in the area System Administration, Engineering and Programming (Perl, shell).

Data Architect Skillset

• Knowledge in BI technology and Data Analysis.
• Knowledge about / around Data Migration Tools.
• Data Modelling – Enterprise Data Modelling with an emphasis on transactional enterprise data models meeting normalization rules.
• Knowledge around Data Integration - disparate source systems and disparate data formats.
• Knowledge in Data Architecture – Conceptual Model methods.
• Experience in Metadata Management.

Database Architect Skillset

• Security Architecture expert.
• ETL tools – Designing and implementing ETL processes.
• Database Design Patterns and Usage Methods – OLAP, DSS.
• Data Storage Techniques: Defining database server IO profiles and mapping to storage methods such as DAS, SAN, SSD & RAID levels; Experience with new Storage technologies like 'Flash storage' and Storage tiring.
• Storage Automation, HADR SAN Replication, Global Mirroring.
• Database Optimization Techniques such as Partitioned Tables, Queues, SQL programming, Execution 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
• Extending functionality, sometimes integrating with legacy systems.
• Experience with Column based Databases like Terradata, Neteeza etc.
• Integration with External Applications, Capacity Planning.
• Dataflow analysis for performance improvement to reduce physical IO in a complex environment.

Soft Skills

• Autonomous and target oriented.
• Flexible and communicative personality.
• German and English speaking (written and spoken).


Workload: 100%
Start Date: asap
Duration: 12 months
Workplace: Zurich

Did we gain your interest? Please do not hesitate to contact Mr. Thomas Bigler at or
Start
07.2014
Dauer
12 Monate
Von
Bosshard & Partner Unternehmensberatung AG
Eingestellt
16.06.2014
Ansprechpartner:
Cloé Maglie
Projekt-ID:
726833
Vertragsart
Freiberuflich
Um sich auf dieses Projekt zu bewerben müssen Sie sich einloggen.
Registrieren