Job Description
Job Description
Job Summary
We are seeking a versatile and skilled ERP & Application Developer to manage, maintain, and optimize our critical business systems. In this role, you will bridge the gap between our database infrastructure and day-to-day operations. Your primary responsibilities will include administering and optimizing Microsoft SQL Server databases, updating and supporting our proprietary legacy in-house applications built on Visual Basic (VB.NET / VB6), and maintaining our Epicor ERP platform to ensure seamless workflow automation, data integrity, and custom reporting.
Key Responsibilities
- ERP Management & Customization: Serve as the technical point person for Epicor ERP (including Kinetic/E10). Build and modify Business Activity Queries (BAQs), Business Process Management (BPM) directives, custom dashboards, and forms to match our operational workflows.
- Legacy Application Support: Maintain, troubleshoot, and upgrade proprietary, in-house business applications written in Visual Basic. Ensure continuity and safe integrations between these legacy apps, modern systems, and the ERP database.
- SQL Server Database Administration: Design, write, and optimize complex T-SQL queries, stored procedures, views, and functions. Monitor database health, manage indexing, tune query performance, and ensure secure, reliable data flows.
- Reporting & Analytics: Develop and modify internal business reports using SQL Server Reporting Services (SSRS) or Crystal Reports to assist departments with data-driven decision-making.
- System Integration & Support: Build data bridges or troubleshoot API/file-based integrations between in-house applications and Epicor modules. Provide technical tier 2/3 support to internal staff dealing with software bugs or data discrepancies.
Required Qualifications & Skills
- Education: Bachelor’s degree in computer science, Information Systems, or a related technical field (or equivalent hands-on experience).
- Experience: 3+ years of experience working closely with Epicor ERP environments (Epicor 10 or Kinetic preferred).
- Programming: Proficient in Visual Basic (VB.NET and/or legacy VB6 codebases) with a solid understanding of object-oriented programming.
- Database Management: Strong command of Microsoft SQL Server and SQL Server Management Studio (SSMS). Proven experience with relational database design.
- Problem Solving: A sharp analytical mindset with the ability to dig into old code, trace data lineage, and identify root causes behind system bugs.
Preferred Qualifications
- Prior background working in a manufacturing, distribution, or supply-chain environment where Epicor MRP modules are deployed.
- Experience handling database migrations or Epicor version upgrades.