Senior Specialist Database Administrator at The South African Revenue Service (SARS)

Job Purpose

• To co-ordinate, prepare, collect and compile information required to facilitate analysis, management review, decision making or reporting requirements of the functional area. To support production databases during online day and after hours. To support developers with database related software and development.

Education and Experience

Minimum Qualification & Experience Required

• Bachelor's Degree / Advanced Diploma (NQF 7) in Information Technology or Computer Science AND minimum 8-10 years' experience in a DB2 environment, of which 3-4 years’ experience at operational specialist level

OR

• Senior Certificate (NQF 4) AND Relevant IT Qualification / Certification AND  8-10 years’ experience in a DB2 environment, of which 3-4 years’ experience at operational specialist level

ALTERNATIVE 

• Senior Certificate (NQF 4) AND 15 years’ experience in a DB2 environment, of which 3-4 years’ experience at operational specialist level

Minimum Functional Requirements:

Relevant technical experience:

• Advanced administration experience in latest version of DB2 LUW
• Experience with large, high volume transaction environments
• Query troubleshooting and optimisation
• Performance tuning
• Backup/Recovery of databases
• Clustering/High Availability experience

In the following technologies:

• IBM DB2 LUW

Relevant certification

• Advanced AIX/Linux scripting
• Extensive HADR experience
• Advanced query creation
• Extensive experience with advanced RDBMS functions such as partitioning, Q replication, compression and XML / JSON
• Extensive experience with development practices and processes
• Deep architectural understanding of DB2 and related tooling
• Ability to develop automated processes

Job Outputs:

• Analyse and make recommendations about improvements to specialist systems, procedures and associated area's practice.
• Contribute to the optimum utilisation of org. resources, advising on effective planning and development of area of specialisation resource plans.
• Develop a single practice area in alignment with operational activity and procedural frameworks and ensure tactical implementation.
• Draw on own technical or professional expertise, knowledge & experience to identify & recommend tactical solutions to defined problems in practices.
• Integrate business information, compare, analyse & produce reports to identify trends, discrepancies & inconsistencies for decision making purposes.
• Optimise goal achievement through tactical strategy implementation and optimisation of practises, processes & systems across an internal value chain.
• Plan for value-added, continuous practice & system improvements to deliver on objectives to enhance tactical implementation and excellence.
• Proactively identify interconnected problems, determine its impact and use to develop best fit alternatives, best practice implementation solutions.
• Translate top-down policy in relation to own practice area and communicate impact to relevant stakeholders.
• Recommend changes to optimise processes, systems, practice area and associated procedures and execute the implementation of change and innovation.
• Define and review data requirements for management of the function.
• Conduct assessments and use information to advise, make recommendations and facilitate improvement

Governance

• Develop and/or align governance and compliance policies for own practice area to identify and manage risk exposure liability.

People

• Integrate new knowledge and transfer skills attained through formal and informal learning opportunities in the execution of your job.
• Provide specialist know-how, support, advice and practice throught leadership in area of expertise.

Finance

• Implement and monitor financial control, management of costs and corporate governance in area of specialisation.

Client

• Develop & ensure implementation of a practice that builds service delivery excellence & encourage others to provide exceptional stakeholder service.
• Participate in the specialist practice community and contribute positively to organisation knowledge management.
• Provide authoritative, specialist expertise and advice to internal and external stakeholders.

Behavioural competencies

• Accountability
• Analytical Thinking  
• Attention to Detail
• Adaptability
• Building Sustainability 
• Commitment to Continuous Learning 
• Conceptual Ability
• Customer Service 
• Fairness and Transparency
• Honesty and Integrity
• Trust (V)
• Organisational Awareness
• Respect

Technical competencies

• Computer Literacy
• Functional Policy and Procedure
• IT Knowledge
• Customer Relationship Management
• System Thinking
• Problem Solving
• Verbal Communication