Plans, develops, configures, maintains and supports an organisation’s database management system in accordance with user requirements ensuring optimal database integrity, security, backup, reliability and performance.
Description of Employment Duties:
-
designing and maintaining database architecture, data structures, tables, dictionaries and naming conventions to ensure the accuracy and completeness of all data master files
-
performing the operational establishment and preventive maintenance of backups, recovery procedures, and enforcing security and integrity controls
-
implementing and administering database documentation, guidelines, policies and procedures
-
testing database systems and upgrades, such as debugging, tracking, reproduction, logging and resolving all identified problems, according to approved quality testing scripts, procedures and processes
-
accepting responsibility for the processes, procedures and operational management associated with system security and disaster recovery planning
-
liaising with security vendors, suppliers, service providers and external resources; analyzing, recommending, installing and maintaining software security applications; and monitoring contractual obligations, performance delivery and service level agreements
-
troubleshooting and providing service support in diagnosing, resolving and repairing server-related hardware and software malfunctions, encompassing workstations and communication infrastructure
-
preparing and maintaining documentation, policies and instructions, and recording and detailing operational procedures and system logs
-
ensuring that the design of computer sites allows all components to fit together and work properly, and monitoring and adjusting the performance of networks
-
continually surveying the current computer site to determine future network needs and making recommendations for enhancements in the implementation of future servers and networks
Description of Closely Related Core ICT Units:
-
Data modeling
-
Data structures
-
Database administration
-
Database design
-
Database implementation
-
Database languages – (e.g. SQL)
-
Database Management Systems – (Relational Database, Object Oriented Database, RDBMS)
-
Entity relationship modeling
-
Operating systems – (Unix, Linux, Xenix, Network OS)
Description of Additional Closely Related ICT Units:
-
Backup and Recovery
-
Client Server Technology
-
Critical Path Method
-
Data policy
-
Data security
-
Distributed Systems
-
File Processing
-
Introduction to ICT – (Introduction to Computer Science, Computer Theory, Introduction to Business Computing, Computer Science I)
-
Project Management
-
Quality management – (Quality Assurance, Software Quality)
-
Testing strategies and methods
