Database Administrator - Senior

The Services and Deliverables to be provided by the Vendor will include the following:

• Participate in the review of project and 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 of Oracle Microsoft Azure SQL database and Synapse database
  
• Develop complex Oracle PL/SQL program to fulfill project work request maintenance requirements
  
• Optimize performance of PL/SQL program
  
• Monitor and analyze incident provide timely resolution
  
• Debug Oracle PL/SQL program to investigate and fix defects
  
• Provide database space calculations for the supported database environments.
  
• Perform reference data administration as required.
  
• Plan and coordinate 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 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
  
• Provide effective knowledge transfer to Ministry staff at all stages of this assignment
  

Requirements