Technology - Mainframe DB2 Database Administrator, Associate, Shanghai
- 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.
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