Programmer/Developer-3 (DBA-DB2) – PDDBA201910001

Date Posted: 10-19-2019, Job Code: PDDBA201910001

Job Responsibilities:

• Create, maintain and alter DB2 objects as requested by departments to facilitate business requirements.
• Adhere to written guidelines and standards.
• Explain and tune application queries to meet performance requirements.
• Provide assistance in writing SQL queries and reports and execute queries to determine the need for production reorgs on a routine basis.
• Migrate database changes from one DB2 environment to another.
• Monitor storage capacity for non-SMS managed datasets.
• Copy entire databases from one environment to another.
• Decommission databases and perform clean up tasks as databases are removed from mainframe.
• Resolve abends in routine DBA utility jobs.
• Help developers resolve SQL error messages.
• Write and maintain JCL to perform routine database utility jobs.
• Schedule new utility jobs using CA7.
• Work with IBM to complete pre-installation requirements for new versions of DB2.
• Help install and test upgrades of vendor software.
• Create, maintain and document databases and processes.
• Participate in planned disaster recovery exercises.

Skills Requirement:

• Must possess a Bachelors degree in Computer Science/ Engineering/ Technology/ Information Systems or related field or equivalent degree.
• Others: CA Database Management Solutions for DB2 for z/OS, DB2 Connect, QMF, TSO/ISPF, DB2 z/OS version 11, IBM Data Studio, JCL, Roscoe, CA7.

Submit resume to: usitcareers@egrovesys.com