S M Software Solutions Inc -
7 Jobs
Toronto, ON
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.
- 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
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
- 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:
