Title: Senior ERP Administrator
Department Name: Information Technology
Reports to: Director of Information Technology
Summary: Responsible for maintaining and developing the Infor Visual ERP system as well as supporting end users.
KEY ACTIVITIES
Essential Duties and Responsibilities:
- Provide support to end-users/troubleshoot issues related to the ERP System
- Document and report problems to Infor related to the ERP System
- Maintain users/profiles within the ERP System and SQL
- Perform version and patch level upgrades / implementation of the new versions of ERP Software
- Create customizations for the ERP System using SQL, Macros, & other 3rd party tools
- Monitor, document, and report on changes to the SQL database and ERP System for audit compliance.
- Maintain and monitor ERP System backups
- Create reports using a combination of SQL, Crystal Reports, SSRS & Power BI to extract data from the ERP System as needed
Qualifications:
- Bachelor’s degree in Computer Science or equivalent.
Experience/Skills:
- Strong SQL Experience
- Writing queries/stored procedures/triggers/functions
- Experience with creation of SQL jobs and backups/restore
- Maintain security and SQL user accounts
- Crytal Reports
- Microsoft Power BI
- Strong Microsoft Excel skills
- Create documentation to describe usage of new or existing processes.
- Communicate with all levels of company staff regarding project status and system changes.
- High bias for action, strong organizational skills and high attention to detail
- Excellent verbal, written, analytical, and interpersonal skills
- Strong team player, strong cross-group collaboration skills
Bonus Experience/Skills:
- Experience with Infor Visual Manufacturing or equivalent ERP system.
- Exposure to manufacturing and/or finance/accounting
- Automate by Fortra
- Crystal Reports
- MS Active Directory (Maintain Users)