Db2 Administrator
1 month 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 Administrator
7 months ago
Toronto, Canada Tekshapers Inc Full timeRole: DB2 Admin (Full time) Location: Toronto, ON Full-Time Role **Full Job Description**: **Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM...
-
Db2 Database Administrator
2 days ago
Toronto, Canada Q1 Technologies Full time**Role -DB2 Database Administrator** **Location - Toronto, ON** **Duration - Full Time** **Job Description-** "- 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,...
-
DB2 System Administrator
1 week ago
Toronto, Ontario, Canada Tata Consultancy Services Full timeIn a world where technology meets innovation, we're seeking an exceptional DB2 System Administrator to join our team at Tata Consultancy Services (TCS). Our commitment to diversity and inclusion is unwavering, and we're dedicated to creating a workplace that reflects the societies we operate in.About TCS:We're a leading IT services, consulting, and business...
-
Mainframe Db2
2 months ago
Toronto, Canada Atlantis IT Consulting Full time**Role**: Mainframe DB2 **Location**: Toronto, Hybrid **Relevant** : Minimum of 8 yrs in DB2 UDB on z/OS **Responsibilities: - ** Upgrade/Migrate DB2 Versions to newer versions Manage DB2 IVS Products and upgrade to supported versions if required. Managing system catalogs Offline utilities - DSNJLOGF, DSNJU004, DSNJU003 etc. Database and related...
-
Mainframe Db2
7 months 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 Database Administrator
2 weeks 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...
-
Db2 Database Administrator
1 week 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 Administrator
2 months ago
Toronto, Canada AstraNorth Full time**Essential Skills**: - DB2 on any OS : 10+ Experience (Senior) - DB2 running on AIX : 5+ - DB2 Performance tuning : 5+ - Data volume : experience with heavy ETL processing millions of records - Working knowledge of Linux / Unix commands. - Experience with Batch Jobs Automation : Autosys or CA7 - Experience with ITIL Processes **Job Types**: Full-time,...
-
Db2 Admin
6 months ago
Toronto, Canada Emonics Full timeRole - DB2 Admin Location - Toronto, ON " **Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM Replications - Monitor DATABASE Performance and tune...
-
Db2 Admin
6 months ago
Toronto, Canada Sapear Inc Full time**Job Title: DB2 Admin** **Job Location: Toronto, ON** **Job type: Fulltime** **Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM Replications -...
-
Dba Db2
1 month 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 Admin
7 months ago
Toronto, Canada Tekshapers Software Solutions Pvt Ltd Full timePosition: - DB2 Adimn Location: - Toronto Fulltime job description: - **Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM Replications - Monitor...
-
Db2 Admin
7 months ago
Toronto, Canada Esolutions Full time**Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM Replications - Monitor DATABASE Performance and tune as necessary. - Evaluate, Install and...
-
Db2 - Mongo Dba
4 weeks ago
Toronto, Canada AstraNorth Full time**RESPONSIBILITIES**: - Detail knowledge of IBM DB2 version 10.5 ,11.1 Administration. - Detailed knowledge of DB2 Replication Server Administration. - Detailed knowledge of DB2 server installations on standalone/DPF/HADR. - Install, upgrade, and manage database. - MongoDB - Manage database access. Adhere to best practices regarding access to and management...
-
Db2 Database Admin
2 weeks 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
2 weeks 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 Admin
7 months ago
Toronto, Canada Q1 Technologies Full time**Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM Replications - Monitor DATABASE Performance and tune as necessary. - Evaluate, Install and...
-
Db2 Admin
7 months ago
Toronto, Canada SkillThread Consultancy Services Full time**Required Skills**: - Database Administration, who cares deeply about the security, stability, and performance of databases (predominantly DB2 and Mongo) - Perform Database Installs and Upgrades and config changes. - Install IBM TSA /Pacemaker and manage IBM Replications - Monitor DATABASE Performance and tune as necessary. - Evaluate, Install and...
-
Database Administrator
7 months ago
Toronto, Canada Cloudvital Technologies Full timeWe are hiring Mainframe DB2 for one of the fast growing dynamic company Job Title: Database Administrator Job Location: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote **_ **Required skills**: - Extensive hands-on experience in the use of z/OS and related software packages and tools - Extensive experience...
-
Database Administrator
7 months ago
Toronto, Canada Rang Healthcare Full timeJob Title: Database Administrator Duration: 04 Month Contract Location: 125 Sir William Hearst, Toronto, ON M3M 0B5 (Position is 3 days onsite in a week) Must haves: Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database Experience with database development, e.g., stored procedure, PL/SQL,...