Database Administrator

Must Haves:

• 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