Senior Database Administrator

Yoush Consulting; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A consulting firm in Toronto is seeking four Senior Database Administrators for a 1-year hybrid contract. Responsibilities include preparing and configuring mainframe systems, maintaining large-scale databases like IMS and DB2, and implementing database changes. Ideal candidates will have expertise in Oracle and Microsoft Azure, with extensive experience in database development and replication. This role involves collaborating with various IT teams to ensure effective database management and performance tuning.

Qualifications

• Expert Database administration experience with IMS, DB2, Oracle, Microsoft Azure SQL database, and Synapse database.
• Extensive experience in large-scale database systems development, capacity planning, and performance tuning.
• Experience with database development, including PL/I, Cobol, and Assembler.

Responsibilities

• Prepare, install, and configure mainframe z/OS, IMS, and DB2 version upgrades.
• Maintain and tune performance of IMS, DB2, Oracle, and Microsoft Azure SQL databases.
• Design and write data loading and conversion scripts/stored procedures.

Skills

Database administration

Microsoft Azure technologies

Large-scale database systems development

Data replication

Tools

IMS

DB2

Oracle

Microsoft Azure SQL database

GoldenGate

Job description

Welcometo Yoush Consulting. Are you an independent IT Consultant or wish to becomeone?

Areyou looking to partner with an organization that presents you to consultingopportunities and supports you as a partner?

4318 - Database Administrator - Senior - 1 Year Contract - Hybrid Work - Toronto

We are seeking the services of four (4) Senior Database Administrator.

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

Responsibilities

• 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
• 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 Ministry standards
• Document and resolve any database problems/issues
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment

Skills

• 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

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