z/OS DB2 DBA

  • Competitive
  • Shanghai, Shanghai Shi, China
  • Permanent, Full time
  • Morgan Stanley
  • 27 Sep 16

See job description for details


Responsible for support services for DB2 on z/OS including database design, processing developers requests for database maintenance and migrations, application performance, troubleshooting and scheduled database maintenance.

职位:

z/OS DB2 DBA

工作内容:

为DB2 on z/OS提供支持,包括设计数据库,处理开发人员对于数据库维护迁移,应用程序性能的需求以及负责疑难解答和一些定期的系统维护。


Qualifications:


Experience with DB2 for z/OS, version 10 or higher
Experience supporting a multi-terabyte environment
Experience supporting high throughput OLTP applications
Experience supporting applications within a DB2 data sharing environment
Knowledge and conceptual understanding of a System Development Life Cycle (SDLC)
Logical and physical database design skills
Proficiency in application related performance and tuning, including extensive SQL coding tuning
Extensive Mainframe JCL experience
Detailed experience with DB2 utilities and database maintenance processing
Proficiency in the use of DB2 monitoring tools (Insight, Omegamon, Detector, Query Monitor, etc)
Proficiency in the use of DB2 object management tools (RC/Migrator, IBM Object Compare, etc)
Working knowledge of application development/debugging tools (Data Studio, Visual Explain, etc.)
Must have coding experience, preferably in REXX. Experience in java and/or html is a major plus
Knowledge of DB2 Connect and driver support
Working knowledge of DB2 stored procedures
Ability to resolve Production DB2 issues quickly and effectively
Working knowledge of Word, Excel and PowerPoint for management reporting purposes
Excellent analytical and troubleshooting skills
Off-hours oncall support required

Self-motivated individual and a team player
Good verbal and written English communications skills
8 years of relevant experience
Candidates with less experience but demonstrate strong growth potential will also be considered

技能和经验要求:

1. 具备DB2 for Z/OS, 版本10以及更高版本的经验

2. 有支持大型数据库系统(TB级别)的经验

3. 具备支持高吞吐量联机事务处理应用程序的经验

4. 具备DB2 数据共享环境(Data Sharing)下的应用程序支持经验

5. 具备对系统开发生命周期SDLC的概念和知识

6. 具备良好的数据库逻辑设计和物理设计能力

7. 熟悉应用程序相关的性能调优,以及对SQL语句的高级优化

8. 有丰富的Mainframe作业控制语言(JCL)经验

9. 有丰富的DB2工具(utility)和数据库维护的经验

10. 能熟练运用DB2 监控工具 (CA Insight和Detector, IBM OMEGAMON和Query Monitor等)

11. 能熟练运用DB2 对象管理工具 (CA RC/Migrator, IBM Object Compare等)

12. 能熟练使用应用开发和调试工具(IBM Data Studio和Visual Explain等)

13. 必须具备编程经验(REXX或其他)。 有JAVA或者HTML的经验更好

14. 有DB2 Connect驱动支持的知识

15. 有DB2存储过程的工作经验

16. 具备快速有效解决生产环境中DB2数据库故障的能力

17. 熟悉运用Word/Excel/PowerPoint

18. 出色的分析和解决问题的能力

19. 能提供正常工作时间以外的值班支持

应具有的特质:

1.有上进心并且是一个有团队精神的人

2. 至少有8年相关的工作经验——工作年限不到但是有发展潜力候选人也会被考虑;