DB2 Performance Engineer
A Contract position at a global financial services firm.
Pay Options: IC - Self Incorporated or w2.
Contact Maxim call (646)876-9538 or email email@example.com with the Job Code MN32507 or Click the Apply Now button ().
Location: Downtown, NYC - Financial District.
Skills required for the position: DB2, DATABASE ADMINISTRATOR, OLTP.
Detailed Info: to work closely with application development, Db2 Operations, and Mainframe Computing areas to ensure Morgan Stanley's database systems are performing and executing efficiently. The qualified candidate will proactively monitor Db2 database performance, guide the application team on performance & tuning, perform access path analysis and provide level 3 support to the Db2 Operations team. Analyze and trend performance of Db2 for z/OS systems. Proactively identify performance issues or concerns. Respond quickly to performance monitor alerts. Perform capacity planning to ensure all Db2 for z/OS database systems grow proactively with the business. Work with cross-functional teams providing required performance support and technical assistance. Continuously interface with the application development teams and make recommendations that will improve overall software and configuration. Interface with senior management. Train and mentor onshore and offshore DBA team members as appropriate. Participate in disaster recovery exercises or event as necessary.
Development/Computing Environment: 5+ years' experience as a Db2 for z/OS database administrator. 2+ years' experience in an extensive Db2 for z/OS performance & tuning role. Experience with Db2 for z/OS, version 10 or higher. Experience with supporting a multi-terabyte environment with high throughput OLTP applications. Proficiency in Db2 for z/OS systems performance tuning and capacity planning. Proficiency in application related performance & tuning, access path analysis including extensive SQL code tuning. Proficiency in the use of Db2 for z/OS monitoring tools (e.g. Sysview/DB2, Omegamon, CA Detector, RMF, etc.) Logical and physical database design skills. Knowledge and understanding of a System Development Life Cycle (SDLC) Knowledge of application development & debugging tools (e.g. Data Studio, Visual Explain, etc.) Ability to code in REXX, HTML and/or java. Excellent analytical and troubleshooting skills. Working knowledge of MS Office suite for management reporting purposes. Exhibit good time management skills, independent thinking and decision making capabilities. Self-motivated individual and a team player. Clear, concise and effective written and verbal communication skills. Desired: Experience with Computer Associates database administration tool suite. Experience with IBM Infosphere Data Replication and MQ. Experience working with distributed platforms and applications.
The position offers competitive rate.
Job Id: 32507