ERP Administrator
HEXPOL
- Burton, OH
- Permanent
- Full-time
- Install, configure, and maintain IFS Cloud and APPS 10 databases on-premises Monitor database performance and perform tuning to ensure optimal performance
- Implement and manage database backups, restores, and disaster recovery plans
- Perform regular database maintenance tasks such as updates, patching, and upgrades
- Build and maintain user roles and permissions and event configuration
- Ensure data integrity and consistency across the database environment
- Manage user access and permissions to ensure security and compliance with policies and manage IFS license
- Optimize Oracle, SQL queries and troubleshoot performance issues
- Provide support for database-related issues and incidents, including on-call support as needed
- Collaborate with IFS Modules, with application developers and other IT staff to resolve issues and improve system performance. Creates and manages API’s
- Document database configurations, procedures, and issues for reference and compliance
- Implement and monitor security measures to safeguard sensitive data
- Ensure compliance with relevant regulations and industry standards
- Regularly review and update security protocols and access controls
- Continuously monitor database performance, conduct performance tuning, and resolve issues to ensure efficient operation
- Work closely with HEXPOL team and IFS consultants, developers, and other stakeholders to support database needs
- Communicate effectively with both technical and non-technical team members to address and resolve issues
- Implement and manage backup strategies, ensuring regular backups are taken and can be restored when needed
- Maintain database security by implementing access controls, encryption, and other security measures to protect sensitive data
- Generate and analyze database reports to support decision-making and business operations. Using IFS Cloud lobbies
- Maintain comprehensive documentation of database systems, configurations, and procedures
- May require occasional on-call support and after-hours work for maintenance or emergencies
- Bachelor’s degree in computer science, Information Technology, or a related field
- Minimum of 7 years of experience as a DBA, with specific experience in managing IFS Cloud on-premises and Azure hosted cloud database
- Proven experience with database installation, configuration, and maintenance
- Strong knowledge of Oracle, SQL, SSRS IFS Quick Reports, Lobbies and database performance tuning. Creating SQL Data Source
- Proficiency in database management tools and software
- Excellent problem-solving and troubleshooting skills
- Strong communication and interpersonal skills
- Ability to work independently and as part of a team
- Relevant certifications e.g., Oracle, Microsoft SQL Server, JSON/JASON Connectivity and IFS Cloud Certification, IFS Cloud Administrator are preferred.
- Competitive salary
- Annual variable bonus plan
- Generous benefits package: Health, Dental, Vision, STD, LTD, Life, 401k match
- Paid time off
- Paid holidays
- Employee assistance program