Associate Database Support Engineer
The Associate Database Support Engineer identifies, tests and deploys all database technologies and support tools. He/ She ensures system improvements are successfully implemented and is responsible for verifying all data to be entered into database meets set standards and requirements as well as installing, configuring and maintaining the database infrastructure within assigned span-of-control. He assists in project planning by establishing work plans, estimates, milestones and schedules. He is required to be on standby with on-call availability to resolve database related incidents. He works in a team setting and is proficient in database administration, database management-related tools and techniques. He is also familiar with the relevant software platforms on which the database is deployed. The Associate Database Support Engineer is able to quickly and effectively solve issues as they arise. He is able to methodically identify the cause of the issue, evaluate it and develop a solution in collaboration with the team. He is able to communicate effectively and displays high service level standards.
Skills and Competencies
Technical Skills & Competencies
Generic Skills & Competencies
Critical Work Functions and Key Tasks
• Assist in developing service-level objectives and targets
• Maintain log of service level performance metrics
• Suggest improvements for procedures and controls to enhance performance and client satisfaction
• Identify recurring incidents and potential issues for senior management
• 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
• 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
• 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
• 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