Database Administrator - Senior (SQL)

If interested, kindly share your updated resume to ajandekar@thethinkbeyond.com

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:

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

Description

Deliverables section:

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

1. Participate in the review of project and maintenance release artefacts - Use Case, System Requirement Specification, etc.;
2. Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC;
3. Promote database changes through Development, Integration Testing, QA, UAT, Production environments;
4. Plan, configure, maintain, administrate, tune performance of Oracle, Microsoft Azure SQL database and Synapse database;
5. Develop complex Oracle PL/SQL program to fulfill project, work request, maintenance requirements;
6. Optimize performance of PL/SQL program;
7. Monitor and analyze incident, provide timely resolution;
8. Debug Oracle PL/SQL program to investigate and fix defects;
9. Provide database space calculations for the supported database environments;
10. Perform reference data administration as required;
11. Plan and co-ordinate implementation with developers, UNIX and .NET application support and other Data Management staff;
12. Design and write data loading and/or conversion scripts/stored procedures;
13. Build and test database backup/recovery scripts;
14. Build and test database automation scripts;
15. Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;
16. Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc.;
17. Document and resolve any database problems/issues;
18. Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

Skill Set Requirements:

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

Experience and Skill Set Requirements

Oracle and Microsoft SQL Database - 50%

1. Expert Oracle and Microsoft SQL Database administration experience;
2. Expert experience with planning, configuring, maintenance, administration, performance tuning of Microsoft Azure SQL database and Synapse database;
3. Demonstrated experience with DACPAC;

Oracle PL/SQL Development – 30%

1. Extensive expert experience in designing and developing complex Oracle PL/SQL programs;
2. Expert experience in Oracle PL/SQL performance tuning;
3. Experience with Oracle database features supporting PL/SQL development;
4. Demonstrated experience participating in large scale complex software solution development;

Azure Technologies- 20%

1. Experience with Azure build automation using Ansible, Terraform, Packer and VSTS;
2. Expert experience with git for source code version control, including branching, merging and pull requests;
3. Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring tools;
4. Experience with CI/CD release pipeline.