At a Glance
- Tasks: Ensure DB2 database integrity and performance while providing technical support and maintenance.
- Company: Join a leading tech firm focused on innovative database solutions.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Other info: Exciting environment with potential for career advancement and skill development.
- Why this job: Be part of a dynamic team that drives impactful database projects.
- Qualifications: Experience with DB2 for z/OS and strong problem-solving skills required.
The predicted salary is between 81000 - 99000 $ per year.
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, File Aid Tools, CA Database Management Tools, Omegamon for DB2.
- #J-18808-Ljbffr
DB2 DBA Consultant L3 in Toronto employer: TechDigital Group
Join a leading technology firm in Canada that prioritizes innovation and employee development. With a collaborative work culture, comprehensive training programs, and opportunities for career advancement, this company is dedicated to fostering a supportive environment where your contributions are valued. Enjoy the unique advantage of working in a dynamic industry while being part of a team that drives meaningful change through strategic sourcing initiatives.
We think you need these skills to ace DB2 DBA Consultant L3 in Toronto
DB2 for z/OS
Mainframe Environment
JES2
TSO/E
ISPF
DFDSS
SQL Development
