Internal medicine nurse

Participate in the review of maintenance release artifacts - Use Case, System Requirement Specification, ;

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

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

Requirements

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
  
• Experience with Oracle and SQL server stored procedure
  
• Experience with Azure build automation using Ansible, Terraform, Packer and
  
• Expert experience with git for source code version control, including branching, merging and pull
  
• Experience with Microsoft Azure technologies, including storage account, file share, Azure key vault, Azure portal, Azure monitoring
  
• Experience with CI/CD release pipeline
  

Mandatory Skills:

• Expert Oracle and Microsoft SQL Database administration experience
  
• Demonstrated experience with DACPAC
  
• Experience with Azure build automation using Ansible, Terraform, Packer and VSTS .