Database Administrator - Senior (Toronto, Ontario)

Hello,

Hope you are doing well.

If you are open in the job market, kindly share the below documents to proceed accordingly:

• Updated Resume in word format.
• Expected hourly rate.

Job Title:

Database Administrator - Senior

Client:

One of the Ministry's in Ontario

Work Location:

Toronto, Ontario, Hybrid

Hours per day or Week:

7.25 hours per day

Mandatory Requirements:

• Expert Oracle and Microsoft SQL Database administration experience;
• Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database;
• Demonstrated experience with DACPAC;
• Expert experience in Oracle PL/SQL performance tuning;
• Experience with CI/CD release pipeline.

Description

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 database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC;
• Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
• Plan, configure, maintain, administrate, tune performance of Oracle, Microsoft Azure SQL database and Synapse database;
• Develop complex Oracle PL/SQL program to fulfill project, work request, maintenance requirements;
• Optimize performance of PL/SQL program;
• Monitor and analyze incident, provide timely resolution;
• Debug Oracle PL/SQL program to investigate and fix defects;
• Provide database space calculations for the supported database environments;
• Perform reference data administration as required;
• Plan and co-ordinate implementation with developers, UNIX and .NET application support and other Data Management staff;
• Design and write data loading and/or conversion scripts/stored procedures;
• 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;
• Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, archiving, etc.;
• Document and resolve any database problems/issues;
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

Skill Set Requirements:

• Expert Oracle and Microsoft SQL Database administration experience;
• Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database;
• Demonstrated experience with DACPAC;
• Extensive expert experience in designing and developing complex Oracle PL/SQL programs;
• Expert experience in Oracle PL/SQL performance tuning;
• Experience with Oracle database features supporting PL/SQL development;
• Demonstrated experience participating in large scale complex software solution development;
• Experience with Azure build automation using Ansible, Terraform, Packer and VSTS;
• Expert experience with git for source code version control, including branching, merging and pull requests;
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools;
• Experience with CI/CD release pipeline.

Experience and Skill Set Requirements:

• Oracle and Microsoft SQL Database - 50%
• Oracle PL/SQL Development – 30%
• Azure Technologies- 20%