Db2 Administrator

1 week ago


Toronto, Canada Stir Consulting Inc. Full time

Term: Contract - 12-24 months

Rate: $70/hr

Location: Downtown Toronto

Environment: Hybrid, 2 days onsite

**Must be legally able to work in Canada**

**Key Responsibilities**:

- **DB2 Administration**: Install, configure, monitor, and maintain DB2 databases on Unix environments.
- **Performance Tuning**: Optimize database performance, troubleshoot slow-running queries, and implement improvements to enhance efficiency.
- **ETL Operations**: Manage and process large datasets through ETL tools and pipelines. Design, develop, and support ETL workflows for data migration and integration.
- **Batch Automation**: Develop, maintain, and optimize batch jobs using AutoSys to ensure smooth scheduling and execution of tasks.
- **Data Integrity & Security**: Ensure data is securely stored, backed up, and recovered as needed. Implement best practices for database security and access control.
- **Documentation**: Maintain detailed documentation of database configurations, processes, and troubleshooting steps.

**Qualifications and Skills**:

- Proven experience as a DB2 Administrator on Unix platforms.
- Expertise in handling and processing large datasets using ETL tools and techniques.
- Strong skills in database performance tuning and query optimization.
- Hands-on experience with AutoSys for batch automation.
- Solid understanding of Unix shell scripting for database maintenance and automation tasks.
- Familiarity with database backup, recovery, and disaster recovery strategies.
- Strong problem-solving skills and ability to work under pressure.
- Excellent communication skills to interact with technical and non-technical teams.

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

Pay: $70.00-$75.00 per hour

Expected hours: 40 per week

Schedule:

- Monday to Friday

Ability to commute/relocate:

- Toronto, ON: reliably commute or plan to relocate before starting work (required)

**Experience**:

- DB2: 7 years (required)
- UNIX: 3 years (required)
- ETL: 3 years (required)

Work Location: Hybrid remote in Toronto, ON

Expected start date: 2024-12-16



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


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


  • Toronto, Canada AstraNorth Full time

    5+ years experience in a database administration role, with primary focus on DB2 and the ability to manage Oracle or PostgreSQL - Completion of a post-secondary college diploma or university degree in a related discipline or a combination of education, training and experience deemed to be equivalent - Certificate from IBM or Oracle on Database Administration...


  • Toronto, Canada Kyndryl Full time

    Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The Role Your...

  • Mainframe Db2

    1 week ago


    Toronto, Canada iPartner Staffing Full time

    Responsibilities: - Upgrade/Migrate DB2 Versions to newer versions Manage DB2 IVS Products and upgrade to supported versions if required. Managing system catalogs optimize performance Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc. Database and related object security - manage user ids, rights and privileges DB2 administration on z/OS, SQL creation,...

  • DB2 DBA

    4 weeks ago


    Toronto, Canada EROS Technologies Inc. Full time

    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 client as the top...

  • DB2 DBA

    4 weeks ago


    Toronto, Canada EROS Technologies Inc. Full time

    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 client as the top...

  • 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 Database Admin

    6 days ago


    Toronto, Canada Q1 Technologies Full time

    "- 3+ years experience in a database administration role, with primary focus on DB2 and the ability to manage Oracle or PostgreSQL - Completion of a post-secondary college diploma or university degree in a related discipline or a combination of education, training and experience deemed to be equivalent - Certificate from IBM or Oracle on Database...

  • Db2 Database Admin

    6 days ago


    Toronto, Canada Q1 Technologies Full time

    "- 3+ years experience in a database administration role, with primary focus on DB2 and the ability to manage Oracle or PostgreSQL - Completion of a post-secondary college diploma or university degree in a related discipline or a combination of education, training and experience deemed to be equivalent - Certificate from IBM or Oracle on Database...