Introduction

A leading company in the Meat/ Butchery industry based in Cullinan is looking for an experienced ERP & Process Analyst with excellent T-SQL Programming skills and 2 – 3 Years DBA experience to join their company as soon as possible.

Duties & Responsibilities

Responsibilities

Systems

• Implementations

• Technology Relevancy

• Meat Matrix Incidents / Tickets

• Meat Matrix Feature Implementations

• Meat Matrix Update Testing

• Meat Matrix Update Testing Model

• Meat Matrix Testing Automation

• Monthly Plant Walkthrough
• Successful Implementations
• At least 3 Software suggestions per Year
• Updated Meat Matrix Issue List with Regular follow Ups
• Implement new features with little to no issues
• No Downtime due to update issues or flaws

• Well Maintained Testing model with Version Control

• Automate some Models for testing

• Monthly feedback on process issues in plant

 

DBA

• DB Optimization

• DB Incident investigation and reporting

• DB Administration

• DB Job Scheduling

• Ensure Database is optimized and waiting times are low
• Investigate and report on DB Head Blocks and irregular waiting times
• Creation and maintain DB users and access
• Maintain and Create scheduled jobs

 

Processes

• Analyze , Create and Document Processes

• Revision Control

• Hand Over
• Procedure and Policies
• Logical , Business and Operational Processes
• Successful revision control of documentation
• Signed off Processes
• Ensure Policies and Procedures are kept up to date

 

Security

• Adhere to best security practices

• Assist IT Manager in identifying Security Risk

• Zero security incidents
• Alert Manager if there are Anti-virus and other security issues on local computers

 

Support

• Assist IT Manager with General IT related tasks when necessary
• After hours Support

• Willingness to assist other IT functions
• Reasonable expected availability to assist after hours

 

Reporting

• Data Accuracy

• Turnaround Time

• Report Definitions

• Presentation of Reports
• Version Control

• Stored Procedures / Views Comments

• Data must be valid and accurate
• On Time Delivery of reports
• Add Report Definitions to reports
• Neat Reports
• All SSRS Report Files and Scripts uploaded to Github
• All Views and Procedures have comments

 

Management

• Junior ERP Support Analyst management

• ERP Team Reporting

• ERP Team Efficiency / Efficacy

• Manage Junior ERP Support Analyst workload
• Provide Departmental information to IT Manager
  Ensure all ERP Tickets are assigned , Given Feedback on and closed according to IT SLA

 

Teamwork / Staff Engagement

• Living the Company values in an individual and team capacity aimed at building a cohesive working environment.
• Actively participate in all people development initiatives linked to the Human Resources Strategy including but not limited to: performance management; succession planning; talent management; change, process optimisation and engagement initiatives etc. to ensure the team’s performance meets the required standards.
• Build, support and maintain healthy diverse internal (peers / team members / managers) as well as external (service providers etc.) relationships and implement remedial actions when required to ensure achievement of organisational goals.
• Provide relevant and specialised technical support, where required, to peers and colleagues to ensure the achievement of objectives.
• All duties are performed according to the Company group Occupational Health and Safety guidelines and procedures.

• Team feedback
• Peer evaluations (360)

 

Desired Experience & Qualification

• Excellent T-SQL Programming skills.
• 2 – 3 Years DBA experience.
• Good understanding of ERP systems with 3+ experience.
• Own transport and valid driving license.
• Must have own reliable internet access at home.
• Must be able to prioritise and keep calm under stressful situations.
• Self-motivator.
• Organised.
• Would be a benefit if candidate could start 1 March 2022.

Package & Remuneration

• 2 Weekends per month standby (R1500 per weekend).
• CTC R420 000 (Negotiable)
• No leave between 15 Nov – 15 Jan.
• 18 Days leave per year.
• Can work from home 1 day per week.

Interested?

Please send your CV to hr1@peopledimension.co.za or hr2@peopledimension.co.za.