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 current 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.

📌 DBA Consultant (Toronto)
🏢 TechDigital Group
📍 Toronto