Database Administrator - Toronto, Canada - iPartner Staffing

iPartner Staffing

Verified Company

Toronto, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

3 days per week in the office

Expert Oracle and Microsoft SQL Database administration experience

Demonstrated experience with DACPAC

Experience with Azure build automation using Ansible, Terraform, Packer and VSTS

Description

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

Participate in the review of 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
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;
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, achieving, 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
Experience with Oracle and SQL server stored procedure 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