Database Administrator - Toronto, Canada - Rang Healthcare
Rang Healthcare
Toronto, Canada
Verified Company
2 weeks ago
Description
Job 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, PL/I, Cobol, Assembler
Experience with IMS/DB2 to Oracle replication
Experience and
Skill Set Requirements:
Evaluation Table
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/SQL, PL/I, Cobol, Assembler
Data Replication 20%
Experience with IMS/DB2 to Oracle replication
Description
Deliverables section:
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., 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;
Skill Set 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/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.
We are an equal-opportunity employer.
It is our policy to provide employment, compensation, and other benefits related to employment without regard to race, color, religion, sex, gender, national or ethnic origin, disability, veteran status, age, genetic information, citizenship, or any other basis prohibited by applicable federal, state, or local law.
IND_CASalary:
$80.00-$85.00 per hour
Expected hours: 7.5 per week
Schedule:
Monday to Friday
Application question(s):
Do you have experience working with IMS, DB2, Oracle, Microsoft Azure SQL database and Synapse database?
Will you be comfortable working 3 days on site at Toronto, ON M3M 0B5 ?
Work Location:
In person