Participate in thereview of maintenance release artifacts - Use Case, SystemRequirement Specification,;
Preparedatabase change in DACPAC and develop Azure CI/CD release pipelineto promoteDACPAC
Promote database changes through Development, Integration Testing,QA, UAT, Productionenvironments;
Plan, configure, maintain, administrate, tune performance ofOracle, Microsoft Azure SQL database and Synapsedatabase
Provide database space calculations for the supported databaseenvironments;
Perform reference data administration asrequired;
Plan and co-ordinate implementation with developers, UNIX and .NETapplication support and other Data Managementstaff;
Design and write data loading and/or conversion scripts/storedprocedures;
Build and test database backup/recoveryscripts;
Build and test database automationscripts
Deliver detailed system design documents and any other supportingdocumentation conforming to Ministrystandards;
Perform database administration, including patching/upgrade,monitoring, performance tuning, partitioning, capacity planning,OEM upgrade/enhancement, achieving,etc
Documentand resolve any databaseproblems/issues
Provide effective knowledge transfer to Ministry staff at allstages of this assignment
Requirements
SkillSetRequirements:
- ExpertOracle and Microsoft SQL Database administrationexperience
- Expertexperience with planning, configuring, maintenance, administration,performance tuning of Microsoft Azure SQL database and Synapsedatabase
- Demonstratedexperience withDACPAC
- Experiencewith Oracle and SQL server stored procedure
- Experiencewith Azure build automation using Ansible, Terraform, Packer and
- Expertexperience with git for source code version control, includingbranching, merging and pull
- Experiencewith Microsoft Azure technologies, including storage account, fileshare, Azure key vault, Azure portal, Azure monitoring
- Experiencewith CI/CD releasepipeline
MandatorySkills:
- ExpertOracle and Microsoft SQL Database administration experience
- Demonstratedexperience with DACPAC
- Experiencewith Azure build automation using Ansible, Terraform, Packer andVSTS.
Skill Set Requirements: Expert Oracle and Microsoft SQL Databaseadministration experience Expert experience with planning,configuring, maintenance, administration, performance tuning ofMicrosoft Azure SQL database and Synapse database Demonstratedexperience with DACPAC Experience with Oracle and SQL server storedprocedure Experience with Azure build automation using Ansible,Terraform, Packer and Expert experience with git for source codeversion control, including branching, merging and pull Experiencewith Microsoft Azure technologies, including storage account, fileshare, Azure key vault, Azure portal, Azure monitoring Experiencewith CI/CD release pipeline Mandatory Skills: Expert Oracle andMicrosoft SQL Database administration experience Demonstratedexperience with DACPAC Experience with Azure build automation usingAnsible, Terraform, Packer and VSTS .