> Markdown version of [/jobs/ext/1277824-manufacturing-systems-administrator](https://www.wearedevelopers.com/jobs/ext/1277824-manufacturing-systems-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Manufacturing Systems Administrator - **Company:** TP Orthodontics Inc - **Location:** La Porte, IN, United States - **Contract:** Permanent contract - **Skills:** IBM System I, Backup Devices, Business Systems, Software Documentation, Databases, Data Infrastructure, Data Integrity, IBM DB2, Relational Databases, Inventory Management Software, Operational Databases, Regression Testing, Systems Integration, Tools for Reporting - **Published:** July 15, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=d946b2b87c1c580f ## About the Role * Demonstrated experience supporting ERP systems in a manufacturing environment. * Working knowledge of relational databases, with the ability to write and troubleshoot queries. * Strong PC, networking, and general IT troubleshooting skills. * Ability to communicate effectively with both production and office personnel. * Strong organizational skills with the ability to manage recurring deadlines (month-end, year-end). Preferred / Strongly Desired * Experience with IBM iSeries (AS400) and DB2 database. * Familiarity with LANSA ERP framework. * Experience with parts/inventory database administration in a manufacturing context. * Exposure to pricing, order management, or costing workflows within an ERP. ## Description We are looking for a hands-on ERP and database professional to own the reliability, integrity, and continuous improvement of our ERP system and supporting data infrastructure across our manufacturing environment. This is an operational role - you will be in the system daily, not just triaging tickets. You'll work directly with Operations, Finance, Engineering, and Quality to keep production data accurate and business processes running efficiently., ERP & Database Administration * Serve as the primary administrator for our LANSA-based ERP environment, including configuration, permissions, and module support. * Perform ongoing DB2 database maintenance on IBM iSeries (AS400), including parts and inventory data, order management, backups and system health. * Execute and audit order price adjustments and price releases, ensuring data accuracy across transactions. * Troubleshoot issues related to work orders, BOMs, inventory transactions, MRP, and costing. * Maintain system documentation, SOPs, and user guides; assist with upgrades, patches, and regression testing. Month-End & Year-End Operations * Support and help streamline recurring business-critical processes including physical inventory counts, budget entry, and custom pricing entry. * Identify and implement process improvements to reduce manual effort and error during close periods. * Ensure data integrity across inventory, WIP, labor reporting, and financial transactions at period close. Reporting & Integrations * Develop and maintain queries, reports, and dashboards for Operations, Finance, and Quality using DB2 and available reporting tools. * Monitor data accuracy and support integrations between manufacturing, accounting, and business systems. Cross-Functional Collaboration * Partner with production, accounting, engineering, and management to improve processes and system efficiency. * Lead user training and onboarding; serve as the go-to resource for ERP questions across the organization. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Enabling intelligent logistics automation: home-grown Industrial IoT platform at Austrian Post](https://www.wearedevelopers.com/videos/2018-enabling-intelligent-logistics-automation-home-grown-industrial-iot-platform-at-austrian-post) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Hands-on Journey to Quantum Computing with IBM](https://www.wearedevelopers.com/videos/137-hands-on-journey-to-quantum-computing-with-ibm) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Now is the time for industrialized software development](https://www.wearedevelopers.com/magazine/601-now-is-the-time-for-industrialized-software-development) - [Best Companies to Work For in Austria: Top 25 Companies in 2023 ](https://www.wearedevelopers.com/magazine/192-best-companies-to-work-for-in-austria-top-25-companies-in-2023) - [Software Developer Salary in Switzerland [2023]](https://www.wearedevelopers.com/magazine/215-software-developer-salary-in-switzerland-2023) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Software Developer Salary in Austria [2023]](https://www.wearedevelopers.com/magazine/213-software-developer-salary-in-austria-2023)