History teacher

Description of Responsibilities:

Participate in the review of project artefacts - Use Case, System Requirement Specification, ;

Prepare a physical data model from logical data model in Power Generate Oracle/SQL server DDL using Power Designer;

Promote database changes through Development, Integration Testing, QA, UAT, Production environments in on-premise and Azure Cloud environments;

Develop Azure Cloud CI/CD pipeline and automation for database implementation;

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 housekeeping scripts

Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards;

Perform database monitoring and performance tuning on database objects and database instance levels

Document and resolve any database problems/issues

Provide effective knowledge transfer to Ministry staff at all stages of this assignment

Requirements

Skill Set Requirements:

• Extensive experience with Microsoft Azure technologies, including CI/CD pipeline, Azure devops, automation, storage account, file share, Azure key vault, Azure portal, Azure monitoring tools;
  
• Expert Oracle and Microsoft SQL Database administration experience;
  
• Extensive expert experience in designing/developing and implementing large OLTP/OLAP Oracle and Microsoft SQL databases;
  
• Knowledge of and experience with Oracle and Microsoft SQL DBMS and tools;
  
• Proven experience in designing and maintaining very large relational 7x24 availability database;
  
• Extensive experience with Oracle PLSQL coding;
  
• Experience with developing physical data model using Power Designer;
  
• Experience in application architecture, analysis, design, development and implementation of solutions in a multi-platform high volume transaction processing environment;
  
• Proven experience with UNIX shell scripting;
  

Experience and Skill Set Requirements

Azure Technologies

Extensive experience with Microsoft Azure technologies, including CI/CD pipeline, Azure devops, automation, storage account, file share, Azure key vault, Azure portal, Azure monitoring tools;

Database and Systems Development

Expert Oracle and Microsoft SQL Database administration experience;

Extensive expert experience in designing/developing and implementing large OLTP/OLAP Oracle and Microsoft SQL databases;

Knowledge of and experience with Oracle and Microsoft SQL DBMS and tools;

Proven experience in designing and maintaining very large relational 7x24 availability database;

Extensive experience with Oracle PLSQL coding;

Experience with developing physical data model using Power Designer;

Experience in application architecture, analysis, design, development and implementation of solutions in a multi-platform high volume transaction processing environment;

Proven experience with UNIX shell scripting;

Mandatory:

Expert Oracle and Microsoft SQL Database administration ;

Extensive experience with Microsoft Azure technologies, including CI/CD pipeline, Azure devops, automation, storage account, file share, Azure key vault, Azure portal, Azure monitoring tools