The Senior Database Administrator will manage Oracle and Microsoft SQL databases, optimize performance, and handle database administration tasks including patching, maintenance, and developing complex PL/SQL programs. Responsibilities include participation in project reviews, implementing CI/CD pipelines, and ensuring effective database performance through tuning and monitoring.
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
Top Skills
Microsoft Sql
Oracle
Similar Jobs
Be an Early Applicant
The Database Admin III role involves managing RDBMS databases, ensuring their integrity, reliability, and performance through quality control, tuning, and upgrades. Responsibilities include database setup, maintenance, troubleshooting, backup and recovery, and technical support for SQL optimization.
The DB2 DBA position involves administering DB2 databases in a Linux environment, implementing DB2 HADR strategies, optimizing performance, and performing SQL tuning. Additionally, proficiency in Linux/Unix and scripting in Shell and PERL is required.
Be an Early Applicant
The Lead Database Administrator will manage and optimize Postgres databases, ensure effective data governance, collaborate across teams for performance enhancements, and automate database infrastructure. Responsibilities include providing expertise to engineering teams, monitoring database metrics, and establishing policies for data integrity.
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
