DB2 DBA Consultant L3

Roles and Responsibilities:

• Ensure integrity, availability and performance of DB2 for z/OS database systems by providing technical support and maintenance.
• Resource should have hands on Experience with Mainframe environment z/OS with JES2, TSO/E, ISPF, DFDSS, etc.
• Manages DB2 table changes to support application design and development efforts.
• Responsible for application database backups, reorgs, migration between environments.
• Supports Custom Archive purge procedures and jobs as required.
• Assist with SQL development with the Application group as required.
• Uses Change Control procedures for system changes that impact the DB2 database instances that support CICS, DB2 stored procedures or packages, or other environments, e.g. Batch job submission.
• Lead DB2 Application support for Disaster Recovery with the Outsourcer for database recovery and Outsourcer technical DBA's.
• Manage, review, and communicates database projects with Application, Infrastructure, and Outsourcer. e.g., required changes with outsourcer.
• Support and assist End Users for proper access and database security.
• Support and maintain production to test database downloads.
• Handles Reporting Tool Admin and support issues, e.g. CA, BMC.

Required Experience and Skills:

• Knowledge and longtime experience with DB2 for z/OS, DB2 Connect, BMC Utilities, CA Utilities, Compuware Products, DB2 Utility Suite, etc.
• Monitor database performance and recommend improvements for operational efficiency.
• Assist in capacity planning, space management and data maintenance activities for databases.
• Perform database enhancement and modification as per the requirements.
• Perform database recovery and backup tasks on as need basis.
• Identify and recommend database techniques to support business needs.
• Assist in implementation of new features and program fixes in databases.
• Maintain database security.
• Perform troubleshooting and maintenance of multiple databases.
• Resolve any database issues in accurate and timely fashion.
• Monitor databases regularly to check for any errors such as existing deadlocks and failed updates.
• Manage database application ids and their permissions.
• Testing for DB2 Upgrade/Migrate DB2 Versions to newer versions
• Manage application data and database environments, performing reorganizations when required to optimize performance
• Database objects creation and perform Online and Offline utilities.
• Monitoring – threads, table space and index spaces.
• Troubleshoot long running transactions.
• Migrate production data to test regions, as needed. Most test environments require obfuscation of certain data for security of customer data.
• Knowledge of IBM utilities, BMC utilities, FileAid Tools, CA Database Management Tools, Omegamon for DB2.

#J-18808-Ljbffr