Job Description
Role & Responsibilities
Oversee database administration
• Maintain development, production and multiple testing environments
• Assist in upgrades of databases, new structures or elements
• Assist in installation, configuration and maintenance of database management systems software
• Implement database back-up and recovery procedures
Design and develop new database
• Assist in business needs analysis for database design
• Assist with testing of new database procedures and protocols
• Assist in establishing database system flows
• Maintain data documentation and metadata models
• Code, edit and install stored procedures and functions for accessing, maintaining and populating databases
Optimise database perfomance
• Perform ongoing optimisation of database components to ensure availability, reliability, scalability, and security
• Assist with database audits and maintenance activities
• Maintain documentation of database optimisation activities
• Track key operational metrics, performance, utilisation, throughput and capacity for reporting
• Ensure optimal database performance and availability
Resolve Database Incidents
• Identify and resolve database issues
• Determines appropriate course of action for resolving database issues, identify and mitigate risks
• Escalate unresolved database issues
• Ensure adherence to organisational database procedures, policies and protocols
Manage databse security
• Implement database security and data integrity controls
• Control privileges and permissions to database users
• Adhere to information security policies, procedures and protocols in all tasks
Security and Compliance
• Ensure systems meet top security standards and comply with regulations.
• Conduct security audits and implement corrective actions.