Database Administrator

Description

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 fulfil 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.

Evaluation Table

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%

• 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.