This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Do you have experience with database development, e.g., PL/SQL and PL/I? Are you expert in Database administration experience, e.g., Oracle, Microsoft Azure SQL, Synapse and Mainframe (IMS & DB2) databases If so, this would be a great opportunity for you! Our client is looking for a Senior Database Administrator for a 12 month contract in North York. This is an onsite role.
Job Responsibility:
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 and .NET 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 standards
Document and resolve any database problems/issues
Provide effective knowledge transfer to staff at all stages of this assignment
Requirements:
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