262111 — Database Administrator

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.

• 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; analysing, 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