Über
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
Application Question(s):
* Do you live in Miami-Dade or Broward County Florida?
Education:
* Associate (Required)
Experience:
* 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
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klicken Sie auf „Jetzt Bewerben“, um Ihre Bewerbung direkt auf deren Website einzureichen.