The Services and Deliverables to be provided by the Vendor will include the following:
Define, document, and implement migration strategy with minimal downtime to migrate Oracle database 12c/18c on Solaris and AIX, Microsoft SQL Server to Microsoft Azure Tables, Azure SQL, or Oracle on RHEL.
Develop automation for database creation and migration with ansible/bash/terraform.
Design and implement infrastructure as code build automation using Terraform and immutable infrastructure with Ansible + Packer.
Practice "GitOps" with Azure DevOps.
Implement risk mitigation recommendations based on Threat Risk Assessment.
Plan, define and implement database high availability and disaster recovery solution in Microsoft Azure environment.
Develop Linux housekeeping shell scripts.
Build and test RMAN database backup/recovery scripts.
Support QA testing and User Acceptance Testing.
Perform database monitoring and performance tuning on database objects and database instance levels.
Assist in IT project management in the preparation of project plans as required.
Document and resolve any database problems/issues.
Provide effective knowledge transfer to Ministry staff at all stages of this assignment.
Experience and Skill Set Requirements:
Oracle and Microsoft SQL Server (40%):
Experience with planning, installation, maintenance, administration of Oracle 12c/18c database on AIX 7.1 and/or Solaris 10, RHEL on Microsoft Azure.
Experience with planning, installation, maintenance, administration of Microsoft SQL Server database, Microsoft Azure IaaS, and PaaS.
Extensive experience with Oracle database backup/recovery using RMAN.
Extensive experience in capacity planning, monitoring, tuning, and administration of Oracle and SQL Server database.
Microsoft Azure (40%):
Expert 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 a storage account, file share, Azure key vault, Azure portal, Azure monitoring tools.
Experience with Oracle database and Microsoft SQL Server database migration to Microsoft Azure.
Linux Administration (20%):
Experience with configuring Red Hat Enterprise Linux guest OS on Microsoft Azure.
Linux administration experience on Red Hat Enterprise Linux.
Extensive experience with Linux shell scripting to develop housekeeping scripts.