- Expert Oracle and Microsoft SQL Database administration experience Azure experience
Responsibilites:
- Participate in the review of maintenance release artefacts - Use Case System Requirement Specification etc.;
- 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 ofMicrosoft Azure SQL database and Synapse database
- Provide database space calculations for the supported database environments;
- Perform reference data administration as required;
- Migrate Oracle 12.1 databases to multi-tenant databases;
- Plan and co-ordinate implementation with developers UNIX 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