Database Administrator

2 weeks ago

Toronto, Canada Softline Technology Inc. Full time

**Note: 3 days a week in the office**

**Must Have**:Expert Database administration experience in IMS/DB2/PL1/COBOL Assembler

Description

**The Data Management Office (DMO) is seeking to hire two (2) Mainframe Database Administrator to deliver**:

- Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade:

- Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.;
- Prepare and implement database changes according to design;
- Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
- Prepare, install, configure Operating Systems, databases and database patches;
- Maintain, administrate, tune performance of databases, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database;
- Provide database space calculations for the supported database environments;
- Perform reference data administration as required;
- Design and write data loading and/or conversion scripts/stored procedures;
- Maintain and enhance Mainframe to Oracle data replication utilizing Tibco IMS Data Replicator, Oracle stored procedures and GoldenGate;
- Build and test database backup/recovery scripts;
- Build and test database automation scripts;
- Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
- Document and resolve any database problems/issues;
Provide effective knowledge transfer to Ministry staff at all stages of this assignment;
**Skills Requirements**:

- Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
- Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
- Experience with database development, e.g., stored procedure, PL/I, Cobol, Assembler
- Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools

Experience with IMS/DB2 to Oracle replication

**Experience Evaluation**

**Database Administration 50%**
- Expert Database administration experience, e.g., IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database
- Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools

**Systems Development 30%**
- Extensive experience with large-scale database systems development, capacity planning, configuration, maintenance, performance tuning
- Experience with database development, e.g., stored procedure, PL/I, Cobol, Assembler

**Data Replication 20%**
- Experience with GoldenGate & IMS/DB2 to Oracle replication

**Job Types**: Full-time, Fixed term contract

**Salary**: $75.00 per hour

Schedule:

- Monday to Friday

**Experience**:

- Ontario government/MTO: 4 years (preferred)
- IMS: 4 years (preferred)
- PL1/COBOL Assembler: 5 years (preferred)
- DB2/IMS Database Administrator: 5 years (preferred)
- Oracle Database Administrator: 5 years (preferred)

Work Location: Hybrid remote in Toronto, ON

Expected start date: 2021-04-01

  • Database Administrator

    6 days ago

    Toronto, Canada Infotek Consulting Services Full time

    Support on preparation, installation, configuration and user test of mainframe z/OS, IMS and DB2 version upgrade: - Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.; - Prepare and implement database changes according to design; - Promote database changes through Development,...

  • Database Administrator

    1 month ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Job Title: Database Administrator - Senior** **Location: Toronto, Ontario (Onsite)** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS...

  • Database Administrator

    1 month ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    **Position: Database Administrator - Senior** **Location: 595 Bay Street,, Toronto, Ontario** **Duration: Long Term Contract** **MUST HAVES**: **MANDATORY REQUIREMENTS**: At least 5 years of experience with: - Oracle RDBMS 11-12 in a Windows environment and SQL Server RDBMS 2008-2019 - Database installation, upgrade, monitoring, troubleshooting,...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Interac Corp. Full time

    Database Administrator At Interac, we design and deliver products and solutions that give Canadians control over their money so they can get more out of life. But that’s not all. Whether we’re leading real-time money movement, driving innovative commerce solutions like open payments for transit systems, or making advancements in new areas like...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Atlantis IT group Full time

    **JD**: **Role - Database Administrator** **Location-** **Toronto, ON(Hybrid)** **Duration - Contract** Desirable Skills: Experience in Agile product development in Scrum or Kanban would be an assetAWS certification(s) such as AWS Certified Database Specialty would be an asset. Thanks & regards, Jack **Apptoza Inc.** Phone: (678)-869-5418 Ext 5003

  • Oracle Database Administrator

    2 days ago

    Toronto, Canada Procom Full time

    Oracle Database Administrator On behalf of our client in the Banking Sector, PROCOM is looking for an Oracle Database Administrator. Oracle Database Administrator - Job DescriptionEnhanced performance due to Database Offload in ExadataReduced size of database without compromising performance by leveraging compression technologyProvided trustworthy data from...

  • Database Administrator

    3 days ago

    Toronto, Canada YouthCare Full time

    Most Important - At least 10 years of experience - Experience in database replication / Real-Time data delivery with either MSSQL or Oracle - products (5+ years)RequirementsGeneral Skills - Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL - Create, test and implement safeguards to maintain data integrity and protect...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Canadian Institute of Plumbing & Heating Full time

    The Canadian Institute of Plumbing & Heating is looking for a database administrator to complete a data clean up for our organization. - Excellent technical skills - Meticulous attention to detail - A logical approach to work - The ability to prioritize tasks - Problem solving skills - Good organizational skills - Previous work in the database "Your...

  • Database Administrator

    6 days ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Position: Database Administrator - Senior** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must haves**: - 10+ years of demonstrated experience supporting/managing Oracle DB, including...

  • Database Administrator

    4 days ago

    Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...

  • Database Administrator

    4 days ago

    Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...

  • Database Administrator

    5 days ago

    Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full time

    Friday, May 10, 2024 Term: Permanent, Full-Time Division/Branch: Information and Information Technology (IIT) Division / Digital Platforms and Cybersecurity Branch Application Deadline: May 24, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office, Toronto, ON; Hybrid The Alcohol and Gaming Commission of Ontario (AGCO)...

  • SQL Database Administrator

    2 weeks ago

    Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...

  • Manager, Database Administration

    5 days ago

    Toronto, Canada LCBO Full time

    LCBO Location Address: 100 Queens Quay East, 9th Floor, Toronto Nombre de postes à pourvoir: 1 Pay $71,490.00 - $128,724.00 Description du poste: Manager, Database Administration The Manager, Database Administration is responsible for overseeing the selection, implementation, enhancement, and support of the LCBO database to help meet the...

  • SQL Database Administrator

    2 weeks ago

    Toronto, Canada Breakdown Services, Ltd. Full time

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. This position works together with the Production DBA and the Senior Software...

  • Oracle Database Administrator

    7 days ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Position: Database Administrator - Senior** **Location: Toronto, Ontario (Hybrid)** **Must haves**: - Support data migration activities from external data sources into source Oracle/Siebel database - Maintain and...

  • Oracle Database Administrator

    4 weeks ago

    Toronto, Canada iPartner Staffing Full time

    Role: Database Administrator - Senior Location: Toronto, ON Contract Description **Senior Database Administrator**: 1. Perform day-to-day operations, maintenance, and support, including: 1.1 Database Error/Alert Monitoring & Troubleshooting 1.2 Database Logs Review and Troubleshooting 1.3 Database Backup/Recovery jobs/tasks review 1.4 Performance...

  • Oracle Database Administrator

    1 month ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Senior** **Database Administrator **for one of our clients. **Position: Senior Database Administrator** **Location: Toronto, Ontario (Hybrid)** **Duration: Long Term Contract** **Must Have** - More than 10 yrs. Oracle DBA experience - Approved experience with Oracle 12c & 19c...

  • Database Administrator

    4 weeks ago

    Toronto, Canada Spruce InfoTech Full time

    **Responsibilities**: - Install, configure and maintain database systems - Develop, enhance and optimize database schemas and queries - Prepare and execute database backup and recovery plans - Monitor system performance and tune databases to optimize responsiveness and efficiency - Provide technical support and troubleshooting assistance to customers -...

  • Oracle Database Administrator

    7 days ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Database Administrator - Senior** for one of our clients. **Position: Database Administrator - Senior** **Location: 40 St. Clair Ave. W, Toronto, Ontario (Hybrid)** **Duration: Long Term** **Employment: Contract** **Must haves**: - Support data migration activities from...