Db2 Administrator
1 week ago
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
-
DB2 Mainframe IMS Administrator
7 hours ago
Toronto, Canada CloudVital Full timeWe 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
9 hours ago
Toronto, Canada CloudVital Full timeWe 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 Database Administrator
6 days ago
Toronto, Canada AstraNorth Full time5+ 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...
-
Mainframe DB2 System Administrator
1 hour ago
Toronto, Canada Kyndryl Full timeWho 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 timeResponsibilities: - 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 timeEROS 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 timeEROS 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 timeDB2 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...