Technology - Mainframe DB2 Database Administrator, Associate, Shanghai

  • Competitive
  • Shanghai, Shanghai Shi, China
  • Permanent, Full time
  • Morgan Stanley
  • 22 Oct 18

See job description for details

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services. The Firm's employees serve clients worldwide including corporations, governments and individuals from more than 747 offices in 42 countries.

In Morgan Stanley, Technology works as a strategic partner with Morgan Stanley business units and the world's leading technology companies to redefine how we do business in ever more global, complex, and dynamic financial markets. Morgan Stanley's sizeable investment in technology results in quantitative trading systems, cutting-edge modelling and simulation software, comprehensive risk and security systems, and robust client-relationship capabilities, plus the worldwide infrastructure that forms the backbone of these systems and tools. Our insights, our applications and infrastructure give a competitive edge to clients' businesses—and to our own.

Job Description

The DB2 Database Administrator will be part of a team of experienced DB2 DBAs who provide critical support services for DB2 on z/OS including database design, processing requests for database maintenance and migrations, application performance, troubleshooting, disaster recovery, scheduled database maintenance in addition to Production support.


The DB2 DBA will be a member of the global technology team working on database projects and requested workload.

Provide complete database life cycle support for mission critical databases using various DB2 tools and techniques.

Participate in regular database capacity planning related to database growth and system utilization, trend analysis and predicting future database resource requirements

Understanding of regulatory, legal and compliances issues for SOX and audit functions

Provide proper guidance and standards to application development teams

Interface with senior management




Minimum 5 Years' experience administering Db2 for z/OS databases in an enterprise environment

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

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

Clear, concise and effective written and verbal communication skills

Exhibit good time management skills, independent thinking and decision making capabilities

Off-hours on-call support


Experience with Computer Associates database tool suite

Experience with IBM Infosphere Data Replication and MQ

Experience working with Java, distributed platforms and applications