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

Business Needs Analysis
Proficiency Level
"Document business requirements and identify basic needs as well as potential solutions"
2
Configuration Tracking
Proficiency Level
"Label, track and document all configuration items and changes to software projects using standard tools and templates "
1
"Verify accuracy, completeness and currency of information in configuration logs and review unauthorized changes, diversions or inappropriate use of software assets "
2
Cyber and Data Breach Incident Management
Proficiency Level
"Provide real-time incident and status reporting, and identify affected systems and user groups "
2
Data Engineering
Proficiency Level
Utilise appropriate tools, systems and techniques to collect, store, extract, transform and load data according to set guidelines.
2
Data Migration
Proficiency Level
Prepare data and perform manual or automated data migration, troubleshoot database errors faced, and validate migrated data postmigration to ensure accuracy.
3

Generic Skills & Competencies

Communication
Proficiency Level
"Communicate information with others to respond to general inquiries and to obtain specific information. "
Basic
Interpersonal Skills
Proficiency Level
Recognize own internal feelings and emotional states to manage interpersonal relationships in social situations.
Basic
Service Orientation
Proficiency Level
Exceed customer needs and expectations and handle service challenges with a positive mindset. Demonstrate an understanding of the organisation’s service vision, mission and values.
Basic
Problem Solving
Proficiency Level
Identify easily perceivable problems and follow given guidelines and procedures to solve the problems.
Basic
Teamwork
Proficiency Level
Contribute to a positive and cooperative working environment by fulfilling own responsibilities and providing support to co-workers to achieve team goals.
Basic

Critical Work Functions and Key Tasks

Oversee service level agreements and service improvements

• 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

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 performance

• 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

More Information

Related Occupations

Get yourself a new skill

In this Path

Coming soon...