Mainframe DB2
基础设施技术基础设施服务是一个位于南非和非洲其他国家的团队。我们负责向客户，客户和同事提供弹性，安全的基础设施技术和服务，无论是在南非还是非洲其他地区。主机能力和性能团队 主机能力和绩效团队负责确保主机上的所有 z/Os 和 z/VM / z/Linux 系统都以组织及其客户均可接受的方式管理并支持。职位是作为工程师数据库专家，在主机基础设施团队工作，为 DB2数据库提供技术维护和支持。关键责任：对最终用户程序员和应用团队的支持。自然和 Cobol / Rexx 和组装器。编写和分析 SQL 语句。广泛的性能调整和改进。创建 DB2数据中心，表空间，表格，索引，字段，测试/ Dev / QA 和生产环境。分区。流程自动化。负责数据和保养和维护。回运/备份。过程自动化：数据和物体统计。数据库可用性：时间及稳定性。高可用性和 SYSPLEX 知识。数据库备份和环境恢复。高可用性 恢复程序 流程自动化。数据库结构支持。改变表格空间，表格，索引和字段。管理，监控和配置数据库安全.DCL （数据控制语言）RACF TWS 维护过程和时间表.DB2安装和升级。版本升级。补丁.ZParm 参数。所有所述任务包括日常运行功能来保持系统的运行以及项目参与。这些项目最终将进入日常运营中，并且提前必须制定设计标准和程序。通过运行，这些项目需要很少的时间来纠正。特别是那些高度专注的项目。与环境内的各利益相关者 （即操作系统，存储，网络等）的良好理解和工作关系也帮助提供一流支持给利益相关者和企业。软件产品和版本使用 DB2版 10 DB2版 11 (zOS 2.4) DB2版 12 不详细提到的是 zOS 操作系统知识。这种知识是基本的。
查看英文原文
About Infrastructure Technology
Infrastructure Services is a team based in South Africa and Rest of African countries. We are accountable for delivering and supporting resilient, secure infrastructure technology and services to customers, clients and colleagues, both in South Africa and Rest of Africa.
Mainframe Capacity and Performance Team
The mainframe Capacity and Performance team is responsible for ensuring that all z/Os and z/VM / z/Linux systems on the mainframe are managed in a way that is acceptable to both the organisation and their customers.
Overall Purpose of Role
The role is as an Engineer Database Specialist working in the Mainframe Infrastructure team to provide technical maintenance and support for DB2 Databases.
Key Responsibilities
Support for end user programmers and application teams.
Natural and Cobol / Rexx and Assembler.
Writing of and analyzing SQL statements.
Extensive performance tuning and enhancements.
Creating DB2 databases, table spaces, tables, indexes, fields, for Test / Dev / QA and Production environments.
Partitioning.
Automation of processes.
Responsible for data and object housekeeping and maintenance.
Reorg/Run stats/Backups.
Automation of processes.
Database availability: Uptime and stability.
High availability and SYSPLEX knowledge.
Database backups and environmental restores.
High availability
Recover procedures
Automation of processes.
Database structure support.
Altering table spaces, table, indexes, and fields.
Manage, monitor and configure database security.
DCL (Data Control Language)
RACF
TWS
Maintain processes and schedules.
DB2 Installation and upgrades.
Version upgrades.
Patching.
ZParm parameters.
All the mentioned duties included the daily operational functions to keep the systems running, as well as project involvement.
The projects would eventually slot into the daily operations and it was essential to get the design standards and procedures in place upfront. In doing this, operationally the projects would need very little down time to correct. Especially the high focused ones.
A good understanding and work relationship with the various stakeholders within the environment i.e. OS, Storage, Networks etc also assisted in delivering first class support to stakeholders and business.
Software Products and Versions Used
DB2 Version 10
DB2 Version 11 (zOS, 2.4)
DB2 Version 12
Not mentioned in detail is the zOS operating system knowledge. This knowledge is essential to maintain PDS, copy/create/edit files on zOS.
Key Accountabilities
System basic configuration
Version and RU (maintenance) level
zParms up to date
Logging setup
Bufferpools (size, hit ratio, alerts)
Locking, lock contention and deadlocks
Components: DRDA, IRLM
Memory pools and caches
Application databases, table spaces, sizes, invalid objects, fragmentation, extents and space usage
Bufferpools tables, page size, partitioning, indexing, constraints
Referential integrity and clustering
Maintenance runstats, reorg, backup, automation
Application plan/package binds, package usage, stored procedures, WLM integration
Security SysAdm, DbAdm, public grants
Problem diagnosis, performance issues, analytical support
Make and implement DB2 changes
Provide 24x7 standby support
Identify incidents and problems without backup support
Provide architecture solutions aligned with new technologies
Support implementation of new DB2 versions and features
Support implementation of new Mainframe/zOS software and identify impacts
Stakeholder Management and Leadership
Strong communication skills
Ability to articulate complex concepts to various audiences
Represent Mainframe area in project meetings
Communicate technical aspects to senior managers
Collaborate with project and programme managers
Decision-Making and Problem Solving
Excellent analytical skills
High attention to detail
Initiative and determination
Process-improvement mindset
Patience and resilience
Risk and Control Objective
Ensure full compliance with regulatory requirements, Enterprise Wide Risk Management Framework, and internal Policies and Standards.
Person Specification
Delivers on promises
Learns from mistakes and avoids repetition
Flexible and adaptable
Defines own performance objectives
Works without support
Produces documentation and manuals
Creates and pursues development plans
Acts as a mentor
Works under pressure while maintaining high quality
Can influence senior stakeholders
Demonstrates broad understanding of business issues
Essential Skills / Basic Qualifications
Able to communicate at all levels
Excellent understanding of Mainframe operating systems and hardware
Good understanding of IMS, DB2, MQ, CICS, VMAX disks, IBM VTS and tape
Able to work under pressure
Strong stakeholder management
Several years' practical DB2 engineering experience
Provide 24x7 standby support
Expert understanding of z/OS, hardware and memory usage
15 years mainframe experience
Desirable Skills / Preferred Qualifications
Broad understanding of business issues
Detailed understanding of technical architectures and work demand portfolio
Awareness of how own work impacts the organisation
Originally posted on Himalayas