Data Engineer Mainframe Db2 z/OS DBA
(m/f/d)
Ticino Start date: asap Reference number: 848980/1
Diesen Job teilen oder drucken
Responsibilities
1. Support Db2 Environments; Integrate external vendor products and interfaces into the Mainframe landscape;Establish recovery routines for infrastructure and business data using products suites from IBM and BMC; Assist and advise database object design to business applications
2. Design models and templates to provide best practices in data migration efforts
3. Review logical models and provide physical database designs in support of Business initiatives
4. Database object installations across all application landscapes (Development, QA, Production)
5. SQL performance reviews and approvals for all application release packages utilizing Changeman Approvals line-item sign-off
6. Incident and Problem Management related to Db2 usage for Business applications and Operations
7. Identify and introduce new Db2 functions to Business applications for possible integration into their respective mainframe software environments
8. Support the implementation of Db2 Certificate-based security for technical accounts connecting to Db2 environments (QA and Production)
9. Implement and support ESL Data layer components such as SQLJ Java Stored Procedures within Changeman SCM
10. Assist TDM (Test Data Management) team in populating QA environments with obfuscated data; Db2 support for Content Manager (IBM Document Management System) and assist in regular software updates
Profile
11. Solid experience Db2 for z/OS V11 thru v13
12. Knowledge in COBOL Db2 programming interfaces
13. IBM Utilities Suite: Image Copies, Reorgs, Runstats, Load, Unload
14. BMC Utilities and Toolsets: Image Copies, Reorgs, Runstats, Load,Unload
15. CATALOG MANAGER for Db2 - Execute DDL or query Db2 Catalog,, CHANGE MANAGER for Db2 - Manage changes to Db2 objects/structures, DASD MANAGER for Db2 - Manage or monitor Db2 physical object, RECOVERY MANAGER for Db2, CHANGE ACCUM for Db2, LOG MASTER for Db2
16. SYSTEM and SQL PERFORMANCE for Db, MAINVIEW Db2
17. SQL Knowledge and Performance Tuning
18. Db2 PSQL Native Stored Procedures
19. IBM z/OS, TSO
20. IBM JCL
Benefits
21. A highly motivated team and an open way of communication
22. A very renowned company
23. Fascinating, innovative environment in an international atmosphere