JOB PURPOSE
The Systems Administrator is responsible for day to day support of the Syspro (ERP/Financial)
application and MS SQL 2005 Server database
The ideal candidate will also be responsible for responding timeously to Syspro user requests
FUNCTIONS & RESPONSIBILITIES
- 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
WORKING HOURS
08h00 – 17h00 or 07h00 – 16h00
REQUIREMENTS
- Matric or Equivalent
- 5 – 7 years Syspro application administration with MS SQL Server Admin & 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
Required Knowledge & Skills:
- SYSPRO – essential
- Excel
- SQL – essential
- Bartender
- 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
Should you meet the above requirements, we urge you to please apply by forwarding your CV along with any supporting documents to tracy@glass-house.co.za
Contact will only be made with shortlisted candidates. Should you not hear from us within two weeks, please consider your application unsuccessful
More Information
- Address Cape Town
