Under the direction of Technology Manager – IT Systems Support, the Database Administrator is responsible for capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.
Key Duties and Responsibilities
Installing and upgrading the enterprise databases (Oracle, MySQl, MS-SQL) and application tools
Allocating system storage and planning future storage requirements for the database system and servers
Creating primary database storage structures after application developers have designed an application
Creating primary objects (tables, views, indexes) once application developers have designed an application
Modifying the database structure, as necessary, from information given by application developers
Ensuring compliance with Oracle and MSSQL license agreement
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database
Maintaining archived data on tape or EMC Data Domain Backup system
Work as part of a team and provide 7x24 support when required
Patch Management and Version Control
Provisioning storage to servers
Check performance of some key, custom, long running reports and processes.
Check some key Oracle statistics like buffer hits, dictionary hits, sorts to memory/disk.
Knowledge of the telecommunications industry will be an added advantage
Networking skills to form collaborative partnerships
Backup and recovery
Good analytical skills
Strong interpersonal skills
The ability to plan and prioritise own and team’s work