Duties and Responsibilities
The objective of this assignment is to provide operational and technical support to Director IME that would ensure the timely assistance to DTCE Directorates on designing and implementation of IME Database Systems. The database administrator (DBA) is responsible for the planning, development and maintenance of the IME database. The Database Administrator would be responsible for the following tasks:
To carry out requirements analysis for DTCE’s Database system.
To design and implement the DTCE Database system, which includes:
-Establishing the needs of users.
-Builds the physical data structures.
-Mapping out the 'conceptual design' for a planned database in outline.
-Further refining the 'physical design' to meet system storage requirements.
-Refining the 'logical design' so that it can be translated into a specific data model.
-Makes Database design modifications.
-Troubleshoot problem queries and updates
-Planning data flows for new or revised databases.
To prepare and maintain Database documentation, including data standards, procedures and definitions for the data dictionary.
Maintaining data standards, including data Protection.
Identify user roles within and outside the organization and controlling access permissions and privileges accordingly.
Training users on how to use the database system.
Meeting users' access requirements and resolving their problems.
Ensuring data storage, archiving, backup and recovery procedures are functioning correctly.
Working closely with IME Director, IME Manager and IME Professional.
Communicating regularly with technical, applications, and operational staff, to ensure the database integrity and security.
Monitor database activity and performance.
Carry out day-to-day Database administration, integration, multi-tier configuration, security and the applications environment
Commissioning and installing new applications.
Ensuring connectivity of the database system to DTCE website for real-time availability of information on the DTCE website.