RQ10464 Database Administrator Senior

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 7-10years

Posted on: 21 hours ago

Vacancies: 1 Vacancy

Job Summary

Deliverables:

The Services and Deliverables to be provided by the Vendor will include the following:

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. Oracle Microsoft Azure SQL Synapse and Mainframe IMS DB2 databases;
Provide database space calculations for the supported database environments;
Perform reference data administration as required;
Plan and co-ordinate implementation with developers ITS UNIX application support and other Data Management staff;
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;

Requirements

Experience and Skill Set Requirements:

Must have:

Expert Database administration experience e.g. Oracle Microsoft Azure SQL Synapse and Mainframe (IMS & DB2) databases.
Experience with database development e.g. PL/SQL and PL/I
10 years of experience

Skill Set Requirements:

Expert Database administration experience e.g. Oracle Microsoft Azure SQL Synapse and Mainframe (IMS & DB2) database
Extensive experience with large-scale database systems development capacity planning configuration maintenance performance tuning
Experience with database development e.g. stored procedure PL/SQL 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

Database Administration:

Expert Database administration experience e.g. Oracle Microsoft Azure SQL Synapse and Mainframe (IMS & DB2) databases.
Experience with Microsoft Azure technologies including storage account file share Azure key vault Azure portal Azure monitoring tools
Experience with Mainframe z/OS Operating system tools and technologies

Systems Development:

Extensive experience with large-scale database systems development capacity planning configuration maintenance performance tuning
Experience with database development e.g. stored procedure PL/SQL PL/I Cobol Assembler

Data Replication:

Experience with IMS/DB2 to Oracle replication

Required Skills:

Experience and Skill Set Requirements: Must have: Expert Database administration experience e.g. Oracle Microsoft Azure SQL Synapse and Mainframe (IMS & DB2) databases. Experience with database development e.g. PL/SQL and PL/I 10 years of experience Skill Set Requirements: Expert Database administration experience e.g. Oracle Microsoft Azure SQL Synapse and Mainframe (IMS & DB2) database Extensive experience with large-scale database systems development capacity planning configuration maintenance performance tuning Experience with database development e.g. stored procedure PL/SQL 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 Database Administration: Expert Database administration experience e.g. Oracle Microsoft Azure SQL Synapse and Mainframe (IMS & DB2) databases. Experience with Microsoft Azure technologies including storage account file share Azure key vault Azure portal Azure monitoring tools Experience with Mainframe z/OS Operating system tools and technologies Systems Development: Extensive experience with large-scale database systems development capacity planning configuration maintenance performance tuning Experience with database development e.g. stored procedure PL/SQL PL/I Cobol Assembler Data Replication: Experience with IMS/DB2 to Oracle replication

Deliverables:The Services and Deliverables to be provided by the Vendor will include the following: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 chang...