Database & Systems Administrator
PANELTRONICS,INC - Hialeah, FL
Apply NowJob Description
*Database & Systems Administrator*Like the look of this opportunity Make sure to apply fast, as a high volume of applications is expected Scroll down to read the complete job description.Reports to: Corporate ControllerLocation: 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-timePay: $75,000.00 - $90,000.00 per yearBenefits:* 401(k)* 401(k) matching* Dental insurance* Health insurance* Life insurance* Paid time off* Referral program* Vision insuranceExperience:* Microsoft SQL Server: 5 years (Required)* ERP systems: 5 years (Required)* manufacturing environment: 3 years (Required)Language:* English (Required)* Spanish (Preferred)Ability to Commute:* Hialeah Gdns, FL 33018 (Required)Work Location: In person
Created: 2025-12-01