Senior IT Database Administrator

**AVI LIMITED** is home to many of South Africa’s leading and best-loved brands Listed on the Johannesburg Stock Exchange and centred on the FMCG market, AVI’s extensive brand portfolio includes more than 50 brands. Our brands span a range of categories including hot beverages, sweet and savoury biscuits and snacks, frozen convenience foods, out-of-home ranges, personal care products, cosmetics, footwear, accessories, and fashion apparel. We have a well-developed Shared Services structure spanning: International, IT, Finance, Logistics, Marketing, Procurement and Field Marketing, which allows us to take advantage of our scale. Our single-minded purpose is our brand growth and development.

An exciting opportunity exists for a **SENIOR IT DATABASE ADMINISTRATOR (DBA) **at **AVI LIMITED IT SHARED SERVICES **in either **Waterfront, Cape Town** or **Bryanston**, **Johannesburg**. The purpose of the Senior DBA is to be responsible for the design, installation, configuration and maintenance of AVI’s system databases on both SAP and non-SAP systems. As the successful incumbent, you will work as part of the SAP Basis team and collaborate closely with the Systems Engineering and Systems and Enabling Technology teams. You will also act as an escalation point for database-related problems from the various ITSS teams.

**Line Manager**: SAP Basis Team Lead

**Number of Direct Reports**: 0

**Job Specification**:
**Key Performance Areas**:

- Installing, configuring, maintaining, and optimizing all SAP and other business critical systems’ databases (SAP ERP, Solution Manager, MSBI etc.) as well as the supporting software and tools.
- Perform close monitoring of the databases and react quickly to resolve complex problems as they occur.
- Analysing the performance, capacity and trends of AVI’s system databases
- Implement new databases, changes and/or upgrades where appropriate in line with the ITSS Infrastructure Change Management procedures in place
- Diagnose and resolve complex problems relating to database performance
- Maintain the database lifecycles
- Administer and maintain the database and associated system monitoring and management platforms
- Mentor and cross-skill members of the SAP Basis team
- Document database Infrastructure
- Provide input into database strategy and architecture
- Provide database guidance in ITSS technical projects
- Provide input into relevant processes, procedures and standards in conjunction with the SAP Basis Technical Lead and the Technical Manager

**Minimum Requirements**:
**Experience**:

- Minimum of 5 years’ experience in MS SQL administration in an SAP environment - ERP, PO and Ancillary SAP systems
- At least 3 years’ experience in MS SQL Business Intelligence administration
- At least 5 years’ experience in Microsoft Systems administration
- 5 years’ SAP HANA implementation and maintenance experience would be highly advantageous

**Other Experience**:
**At least 3 years’ experience in**:

- Data management and data processing flowcharting techniques
- Reporting and query tools and practices
- High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server e.g. Storage Replication and Log shipping
- Database indexes, index management, and statistics
- MS SQL SSAS SSRS, and SSIS
- Database / Application inventory
- Database Patching and Upgrades
- Performance monitoring and tuning
- MS SQL Server monitoring utilities
- Deployment of database change scripts
- Good understanding of:

- Enterprise storage systems
- Enterprise server systems
- Enterprise Virtualisation platforms (VMWare)

**Qualifications**:

- Matric/Grade 12/NQF Level 4
- Tertiary Degree or Diploma in IT and/or Engineering
- BSc in Computer Science, Information Technology would be highly advantageous

**Additional requirements**:
**Certifications**:
**Minimum**:

- MS SQL Architecture and Programming SQL
- MCSA: SQL 2020/2018/2016/2014

**Ideal**:

- Valid MCSE: Data Management and Analytics
- Valid MCSE: Data Platform
- Valid MCSE: Business Intelligence
- Valid SAP HANA certification

**Competencies**:

- Thinking analytically
- Thinking rationally
- Thinking conceptually
- Articulating Information
- Staying Composed
- Embracing Change
- Planning and organising
- Keeping commitments
- Taking initiatives
- Developing Personally