Job Description:
Primary Purpose: The Business Applications Specialist – ERP is responsible for providing the full range of maintenance, knowledge, and troubleshooting of company database systems & implementations. They will assist companywide with users and vendors of these programs.
Essential Functions:
- Maintenance and troubleshooting of Deltek Costpoint ERP application
- Maintenance and troubleshooting of IBM Cognos Reporting application
- Perform installation, administration, maintenance and troubleshooting of Microsoft SQL databases
- Develop SQL queries and scripts as needed
- Program in Transact-SQL and other database languages
- Define users and enable security and permissions to the right user in Costpoint & Cognos
- Proactively identify, diagnose, and resolve system alerts that could impact system availability
- Actively manage system patching, routine maintenance, and database backups
- Minimize database downtime and manage parameters to provide fast query responses
- Provide proactive & reactive data management support and training users
- Determine, enforce, and document database policies, procedures & standards
- Perform test and evaluations regularly to ensure data security, privacy & integrity
- Monitor database performance, implement changes, and apply new patches & versions when required
- Identify automation improvements to enhance the operation of the ERP system
- Support OnBase application developers as needed
- Identify reporting requirements and work with business to generate reports in Cognos or Power BI
- Maintaining documentation, data maps and network diagrams
- Work with and provide third tier support for client & end users
- Participate in disaster recovery planning and recovery exercises
- Performs other duties as assigned or required
Technologies:
Deltek Costpoint, Deltek Time & Expense, IBM Cognos, Hyland OnBase, Microsoft SQL Server, Microsoft Power BI, SSRS, Microsoft Office 365, Windows Server 2016+, Transact-SQL, PowerShell scripting
Job Requirements:
- Bachelor of Science in Database Administration, Computer Programming, Computer Technology, Computer Science, or similar degree.
- Three or more years’ experience OnBase support. OnBase development desired
- Five or more years’ experience with Deltek Costpoint System desired
- A plus to have Cognos or Power BI report development, Azure Cloud, or AWS Cloud
- Excellent verbal and written communication skills with the ability to effectively present and communicate with individuals at all levels
- Must be computer literate, and proficient with the MS Office Suite & software/programs listed
- Must be able to work independently and meet deadlines under pressure in a fast pace environment as well as in a team
Physical Requirements:
Must be able to satisfactorily pass a pre-employment drug screen & background check. Regularly requires intermittent sitting, standing & walking. Must have physical strength and dexterity sufficient to perform the required task. Must occasionally lift and/or move up to 50 pounds or more with assistance.
Working conditions:
Business Applications Specialist will work both at headquarters in a typical office environment and at on-site project locations which typically include any of HEPACO service locations as needed. Some travel will be required throughout the year to HEPACO offices or vendor sites.
This position is exempt from overtime