Job description

Database & Systems Administrator Reports to: Corporate Controller Location: Paneltronics, Inc. Company Overview Paneltronics is a leading designer and manufacturer of high-quality electrical control panels, power distribution units, instrument panels, and switch panels. As a vertically integrated manufacturer, we excel in supporting both OEM and aftermarket needs. Our products are trusted across a wide range of industries, including industrial equipment, specialty vehicles, marine, and military applications worldwide. Position Summary The Database & Systems Administrator plays a vital role in designing, implementing, and supporting robust database systems and enterprise applications. Utilizing expertise in SQL architecture, the role encompasses database development, integration, support, testing, and performance optimization within a multi-tiered RDBMS environment. Responsibilities also include overseeing backup/recovery, production staging, application rollout, capacity planning, and cross-functional user support. Key Responsibilities ERP System Analyst • Maintain expert knowledge of INFOR Visual Enterprise (VE) and ALEXYS TEAM systems. • Integrate existing applications into a VE-centric ecosystem. • Audit security policies and practices for VISUAL & TEAM applications. • Create and verify system backups for VE and TEAM platforms. • Develop and support applications that integrate VE, Team, VCRM, and DS systems. • Support and program the Master Product Configurator (MPC). • Maintain legacy scheduling functionality integrated with VE. • Define and enforce business rules based on management directives. • Train users and recommend procedures and policy improvements to management. • Analyze and improve system usability; provide actionable recommendations. • Diagnose and troubleshoot user/system-level errors. • Monitor software license usage and compliance. • Create extended and customized reporting using various tools. • Conduct workflow research in preparation for business rule development. • Perform ad-hoc operational data analysis as requested. SQL Programming • Manage all aspects of Microsoft SQL relational databases including schema extensions, integrity, and performance tuning. • Design and implement stored procedures, triggers, views, and tables. • Export summary data into the Corporate Performance Management system. Database Administration (DBA) • Create and maintain backup databases for testing and reporting environments. • Monitor and plan for system capacity and storage needs. • Implement and oversee data backup and recovery strategies. • Ensure data security, consistency, and high availability. Qualifications Technical Skills • Extensive hands-on experience with ERP and MRP systems, especially INFOR Visual and • MS SQL Server. • Strong background in logical and physical data modeling and relational database design. • Comprehensive understanding of relational theory and normalization. • Experience developing stored procedures, triggers, views, and performance-optimized schemas. • Advanced proficiency in Microsoft Excel (pivot tables, VBA, macros). • Familiarity with programming or scripting for application support is helpful. • Proven experience integrating enterprise systems in a manufacturing environment. • Ability to define and enforce database naming conventions and programming standards. Professional Skills • Effective communication, training, and people skills. • Detail-oriented, dependable, and self-motivated. • High ethical standards and professional integrity. • Able to thrive under pressure and meet tight deadlines. • Strong sense of ownership, urgency, and accountability. • Bilingual (English and Spanish) is a plus. Experience & Education • Minimum of 5 years of experience as a Database Administrator or Systems Analyst with SQL Server. • Bachelor’s degree in Computer Science or related field. Why Join Paneltronics? We offer competitive salaries and a comprehensive benefits package, including medical, dental, vision, and a 401(k) retirement plan. Paneltronics is proud to be an Equal Opportunity Employer. Job Type: Full-time Pay: $75,000.00 - $90,000.00 per year Benefits: • 401(k) • 401(k) matching • Dental insurance • Health insurance • Life insurance • Paid time off • Referral program • Vision insurance People with a criminal record are encouraged to apply Experience: • Microsoft SQL Server: 5 years (Required) • manufacturing environment: 1 year (Required) • ERP systems: 5 years (Required) Language: • English (Required) • Spanish (Required) Security clearance: • Confidential (Preferred) Ability to Commute: • Hialeah Gdns, FL 33018 (Required) Work Location: In person

Requirements