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