Syspro Systems Administrator

at Job Link Placement
Location Cape Town, South Africa
Date Posted December 22, 2019
Category General
Job Type Full-time

Description

(Experienced Syspro Systems Administrator with some technical experience)

MAIN PURPOSE OF THE JOB/ROLE:

Responsible for day to day support of the Syspro (ERP/Financial) application and MS SQL 2005 Server database. Responsible for responding timeously to Syspro user requests.

DESIRED QUALIFICATIONS/FORMAL EDUCATION:

Matric or Equivalent

5 – 7 years Syspro application administration with MS SQL Server administration and development

Syspro

SQL server

SSRS experience integrate Syspro with other databases

Excellent technical and non-technical communication

Excellent problem-solving skills

End to end project management and issue resolution experience

 

DUTIES & RESPONSIBILITIES – KEY FOCUS OUTPUTS:

End User SYSPRO Support

Troubleshooting SYSPRO related problems

Create and maintain customized reports using MS SQL, SYSPRO reporting services, EXCEL

Maintaining SYSPRO Documents formats using Crystal Designer

Involved in setting up business processes and procedures

Documenting and administration of SYSPRO

Training of Staff on Syspro Processes and Procedures

Experience in Barcode Printing, Barcode Design

Experience in scanner set up and operations

Basic technical experience with regards to PC’s, scanners, printers

Support of Syspro environment including Application Server, database and client PCs operating in a production environment.

Strong understanding of financial and production concepts.

Syspro functional experience including financial, distribution and manufacturing modules.

Ad Hoc reporting and development as needed including Syspro and SQL Server

End user training at all levels with version upgrades.

Make up training/reference manuals for Syspro ERP modules in use.

Work directly with accounting department and production control staff to streamline processes and correct impediments.

Perform function of SQL2005 database admin, SQL backups, user security, database maintenance etc.

Write complex queries using T-SQL combining data from multiple companies and Servers.

Optimize T-SQL code and stored procedures.

SQL Server Reporting services (SSRS) to write reports not possible using Syspro Report Writer, users can print reports or export to Excel or PDF format.

Maintain a suitable helpdesk solution with timeous response

Oversee and attend to helpdesk requests from users across all departments

 

KNOWLEDGE & SKILLS:

SYSPRO

Excel

SQL

riteSCAN Responds and works well under pressure

Always maintain a sense of humour

Ability to complete tasks timeously and work until the job is done

Shows initiative and ability to self-motivate and work alone frequently

Own transport

Find solutions to problems