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