Description

You will manage DB2 z/OS database administration, performance optimization, and production support in an MVS-z/OS environment.

Responsibilities

• Design physical data models optimized for DB2/zOS environments based on logical models and project requirements.
• Collaborate with Java, .NET, and SQL development teams to handle detailed database design, implementation, testing, and deployment.
• Perform SQL performance tuning for both OLTP and Data Warehouse environments by tuning static and dynamic queries and recommending indexes.
• Manage database maintenance, monitoring, disaster recovery, and the development of backup and archiving solutions.
• Provide 24/7 on-call rotational incident response to database alerts from production monitoring tools.

Required Skills

• 6 years of heavy DB2 z/OS database administration and production support experience in an MVS-z/OS environment.
• Technical expertise in DB2 V8 and above.
• Deep knowledge of logical and physical DB design, performance monitoring, and tuning.
• Experience with stored procedures (COBOL and NATIVE), triggers, and UDFs.
• Proficiency with RMF and use of SMF data.
• Hands-on experience with DB2 Utilities, SPUFI, QMF, OSC, BMC-DB2Mon, and PowerDesigner.
• Ability to work with Java, .NET, and SQL-based applications.
• Experience in data mining, application error analysis, and query execution for data repair.

Preferred Skills

• Experience in J2EE environments.
• Experience with DB2 UDB on LUW.

Key Skills

Education

Any Graduate