252 Database and Network Professionals

Database designers and administrators design, develop, control, maintain and support the optimal performance and security of databases. Tasks include - (a) designing and developing database architecture, data structures, tables, dictionaries and naming conventions for information systems projects; (b) designing, constructing, modifying, integrating, implementing and testing database management systems; (c) conducting research and providing advice on the selection, application and implementation of database management tools; (d) developing and implementing data administration policy, documentation, standards and models; (e) developing policies and procedures for database access and usage and for the backup and recovery of data; (f) performing the operational establishment and preventive maintenance of backups, recovery procedures, and enforcing security and integrity controls. Examples of the occupations classified here: - Data administrator - Database administrator - Database analyst - Database architect Some related occupations classified elsewhere: - Network administrator - 2522 - Systems administrator (computers) - 2522 - Webmaster - 3514 - Website administrator - 3514.

Systems administrators develop, control, maintain and support the optimal performance and security of information technology systems. Tasks include - (a) maintaining and administering computer networks and related computing environments, including computer hardware, systems software, applications software and all configurations; (b) recommending changes to improve systems and network configurations, and determining hardware or software requirements related to such changes; (c) diagnosing hardware and software problems; (d) performing data backups and disaster recovery operations; (e) operating master consoles to monitor the performance of computer systems and networks, and to coordinate computer network access and use. Examples of the occupations classified here: - Network administrator - Systems administrator (computers) Some related occupations classified elsewhere: - Database administrator - 2521 - Network analyst - 2523 - Webmaster - 3514 - Website administrator - 3514 - Website technician - 3514.

Computer network professionals research, analyse, design, test and recommend strategies for network architecture and development. They implement, manage, maintain and configure network hardware and software, and monitor, troubleshoot and optimize performance. Tasks include - (a) analysing, developing, interpreting and evaluating complex system design and architecture specifications, data models and diagrams in the development, configuration and integration of computer systems; (b) researching, analysing, evaluating and monitoring network infrastructure to ensure that networks are configured to operate at optimal performance; (c) assessing and recommending improvements to network operations and integrated hardware, software, communications and operating systems; (d) providing specialist skills in supporting and troubleshooting network problems and emergencies; (e) installing, configuring, testing, maintaining and administering new and upgraded networks, software database applications, servers and workstations; (f) preparing and maintaining procedures and documentation for network inventory, and recording diagnosis and resolution of network faults, enhancements and modifications to networks and maintenance instructions; (g) monitoring network traffic and activity, capacity and usage to ensure continued integrity and optimal network performance. Examples of the occupations classified here: - Communications analyst (computers) - Network analyst Some related occupations classified elsewhere: - Systems analysts - 2511 - Network administrator - 2522.

This unit group includes database and network professionals not classified elsewhere in Minor Group 252: Database and Network Professionals. For instance, the group includes information and communications technology security specialists. In such cases tasks would include - (a) developing plans to safeguard computer files against accidental or unauthorized modification, destruction or disclosure and to meet emergency data processing needs; (b) training users and promoting security awareness to ensure system security and to improve server and network efficiency; (c) conferring with users to discuss issues such as computer data access needs, security violations and programming changes; (d) monitoring current reports of computer viruses to determine when to update virus protection systems; (e) modifying computer security files to incorporate new software, correct errors or change individual access status; (f) monitoring use of data files and regulate access to safeguard information in computer files; (g) performing risk assessments and executing tests of data processing system to ensure functioning of data processing activities and security measures; (h) encrypting data transmissions and erecting firewalls to conceal confidential information as it is being transmitted and to keep out tainted digital transfers. Examples of the occupations classified here: - Data miner - Digital forensic specialist - Security specialist (ICT).