Db2 Dba/progammer with Ims Db

1 week ago

Toronto, Canada Tekcogno Full time

**Database Systems Programmer**

**Location: Toronto, ON & other locations in CANADA**

**Key Responsibilities**:
**Database Administration & Maintenance**:

- Manage and maintain IBM DB2 databases on the z/OS mainframe platform.
- Create and manage database objects, such as tables, indexes, and table spaces.
- Perform data manipulation operations like loading, unloading, and reorganizing data using DB2 utilities.
- Implement database backup and recovery strategies to ensure data availability and disaster recovery.

**Performance Monitoring & Optimization**:

- Monitor database performance metrics to identify and resolve bottlenecks.
- Perform database tuning to enhance query performance and maintain optimal system functioning.
- Utilize tools like RUNSTATS to maintain accurate database statistics for query optimization.

**Collaboration & Consultation**:
**Software & System Management**:

- Oversee external DBA teams and systems programmers during the installation and support of mainframe database software.
- Facilitate service level management, including change management, incident, and problem management.
- Work with external vendor teams to ensure smooth conversions during software updates and releases.
- Proactively monitor database platforms for high availability, identifying root causes and correcting issues.

**Risk Management & Compliance**:

- Keep management informed of risks and develop mitigation strategies to reduce potential risks.
- Participate in audit reviews, including completing quarterly SOX audits and ensuring compliance with regulations.

**Disaster Recovery & Business Continuity**:

- Participate in disaster recovery planning and testing, ensuring database resilience in case of system failures.

**Technology Strategy & Lifecycle Management**:

- Stay up-to-date on advancements in database technologies and lifecycle management, particularly focusing on deprecated features and mitigation planning.

**Required Skills & Knowledge**:

- Minimum of 8 years of experience with zDb2, IMS DB/DC, and/or ADABAS.
- Proficiency with replication software such as IIDR - IBM Infosphere Data Replication Suite.
- Strong understanding of zConnect Enterprise Edition (zCEE) API framework.
- Expertise in IBM DB2 database administration on z/OS mainframe platforms.
- In-depth knowledge of SQL, DB2 partitioning, indexing, data sharing, and performance tuning techniques.
- Experience with mainframe operating system concepts and Job Control Language (JCL).
- Familiarity with data security best practices and compliance regulations.
- Ability to troubleshoot and resolve complex database-related issues.
- Strong experience in managing database backups, recovery procedures, and disaster recovery planning.

**Preferred Qualifications**:

- Knowledge of IBM DB2, IMS DB/DC, and ADABAS database products.
- Familiarity with service level management, change management, and incident resolution.
- Experience working with external vendors and managing software upgrades.

**Education & Certification Requirements**:

- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- Relevant certifications in DB2 or related database technologies are a plus.

**Work Environment**:

- Collaboration with various internal and external teams to ensure high performance and availability of database systems.

**Job Types**: Full-time, Permanent, Fixed term contract
Contract length: 12 months

Pay: $59,188.67-$120,000.00 per year

  • Software Developer

    3 days ago

    Toronto, Canada Scotiabank Full time

    Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) – Scotiabank Join to apply for the Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) role at Scotiabank. Requisition ID: 244097 Join a purpose‑driven winning team, committed to results, in an inclusive and high‑performing culture. The Role Contributes to the overall success of the Transaction Services...

  • Software Developer

    4 days ago

    Toronto, Canada Scotiabank Full time

    Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) – Scotiabank Join to apply for the Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) role at Scotiabank. Requisition ID: 244097 Join a purpose‑driven winning team, committed to results, in an inclusive and high‑performing culture. The Role Contributes to the overall success of the Transaction Services...

  • Software Developer

    2 days ago

    Toronto, Canada Scotiabank Full time

    Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) – Scotiabank Join to apply for the Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) role at Scotiabank . Requisition ID: Join a purpose‑driven winning team, committed to results, in an inclusive and high‑performing culture. The Role Contributes to the overall success of the Transaction Services...

  • Dba Db2

    3 days ago

    Toronto, Canada Atlantis IT group Full time

    DB2 DBA - MongoDB Toronto Hybrid 1yr contract / Fulltime - MongoDB - Administer and maintain DB2 and MongoDB databases in production and development environments. - Perform performance tuning, backup, recovery, and disaster recovery planning. - Design and implement database schemas, indexing, and optimization strategies. - Monitor database performance and...

  • Db2 Dba

    1 week ago

    Toronto, Ontario, Canada EROS Technologies Full time

    Company Description EROS Technologies was founded with a simple motive of offering the clients exactly what they want, how they want and when they want it. By leveraging for its clients its technological edge and right-sourcing advantage, EROS in a short period of time has grown to become one of the most trusted strategic technology partners. Treating every...

  • DB2 Mainframe IMS Administrator

    4 days ago

    Toronto, Canada CloudVital Full time

    We are looking for a highly skilled DB2 Mainframe professional for one of the leading firms. Job Title DB2 Mainframe IMS Administrator Job Type Full-Time/Contract Responsibilities Participate in review of project and maintenance release artefacts – Use Case, System Prepare and implement database changes according to design Promote database changes through...

  • DB2 Mainframe IMS Administrator

    5 days ago

    Toronto, Canada CloudVital Full time

    We are looking for a highly skilled DB2 Mainframe professional for one of the leading firms. Job Title DB2 Mainframe IMS Administrator Job Type Full-Time/Contract Responsibilities Participate in review of project and maintenance release artefacts – Use Case, System Prepare and implement database changes according to design Promote database changes through...

  • DB2 Mainframe IMS Administrator

    5 days ago

    Toronto, Canada CloudVital Full time

    We are looking for a highly skilled DB2 Mainframe professional for one of the leading firms. Job Title DB2 Mainframe IMS Administrator Job Type Full-Time/Contract Responsibilities Participate in review of project and maintenance release artefacts – Use Case, System Prepare and implement database changes according to design Promote database changes through...

  • Software Developer

    2 weeks ago

    Toronto, Canada Scotiabank Full time

    Select how often (in days) to receive an alert: Title: Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) Requisition ID: Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Role Contributes to the overall success of the Transaction Services Canadian Banking Engineering team, ensuring specific individual...

  • Software Developer

    2 weeks ago

    Toronto, Canada Scotiabank Full time

    Select how often (in days) to receive an alert: Title: Software Developer (Cobol, JCL, DB2, IMS DB, VSAM) Requisition ID: 244097 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Role Contributes to the overall success of the Transaction Services Canadian Banking Engineering team, ensuring specific...