Job Description
Reporting to the Manager ICT Projects, the Principal ICT Officer- Database Administration and Management will be responsible for the daily management of the Authority’s databases for high service availability, integrity, and security. The Database Administrator (DBA) will keep the database up and running smoothly. The goal is to provide a seamless flow of information throughout the Authority, considering both backend data structure and frontend accessibility for end-users.
Key Duties and Responsibilities
• Build database systems of high availability and quality depending on each end user’s specialized role;
• Design and implement database in accordance to end users information needs and views;
• Define users and enable data distribution to the right user, in appropriate format and in a timely manner;
• Use high-speed transaction recovery techniques and backup data;
• Minimize database downtime and manage parameters to provide fast query responses;
• Provide proactive and reactive data management support and training to users;
• Determine, enforce and document database policies, procedures and standards;
• Perform tests and evaluations regularly to ensure data security, privacy and integrity;
• Monitor database performance, implement changes and apply new patches and versions when required;
• Develop database solutions to store and retrieve company information;
• Install and configure information systems to ensure functionality;
• Analyze structural requirements for new software and applications;
• Migrate data from legacy systems to new solutions;
• Design conceptual and logical data models and flowcharts;
• Improve system performance by conducting tests, troubleshooting and integrating new elements;
• Optimize new and current database systems;
• Define security and backup procedures;
• Coordinate with the Data Science department to identify future needs and requirements; and
• Provide operational support for Management Information Systems (MIS).
Key Qualifications and Experience:
For appointment to this position, a candidate must have:
• At least (8) years general work experience, three (3) of which must be in database administration and management based on Oracle/SQL systems;
• Bachelor of Science Degree in Computer Science or relevant field;
• Proven work experience as a Database Administrator, Databases Manager, Data Architect, Data Scientist, Data Analyst or similar role;
• In-depth understanding of database structure principles;
• Experience in gathering and analyzing system requirements;
• Knowledge of data mining and segmentation techniques;
• Expertise in SQL and Oracle;
• 11g Oracle Certified professional or Microsoft SQL Certification is a MUST;
• Experience in Database administration with MySQL, MS-SQL Server, PostgreSQL, Oracle RDBMS 11g/12c is a must;
• Proven analytical skills;
• Problem-solving attitude;
• Minimum of 3 years specific experience in database administration