Job Title or Location
RECENT SEARCHES

Database Administrator - Senior (SQL)

S M Software Solutions Inc - 5 Jobs
Toronto, ON
Full-time
Management
Posted 2 days ago

If interested, kindly share your updated resume to [email protected]
Job Title: Database Administrator - Senior
Client: One of the Ministry of Ontario
Work Location: Toronto, Ontario, Hybrid
Hours per day or Week: 7.25 hours per day
Security Level: No Clearance Required
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
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 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, 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
  • 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%
  • 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

Oracle PL/SQL Development – 30%
  • 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
Azure Technologies - 20%
  • 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
  • Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools
  • Experience with CI/CD release pipeline

Powered by JazzHR

CVM4xciTGS

Share This Job: