Database Administrator (5+ years experience and Onsite required)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+9 more
Job description
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., 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.
Requirements
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., * 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., * Bachelor’s (Preferred), * Microsoft SQL Server: 5 years (Required)
- ERP systems: 5 years (Required)
- manufacturing environment: 3 years (Required)
Language:
- English (Required)
- Spanish (Preferred)
Benefits & conditions
Pulled from the full job description
- Referral program
- 401(k)
- Health insurance
- Retirement plan
- 401(k) matching
- Paid time off
- Vision insurance, 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, * 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Referral program
- Retirement plan
- Vision insurance
Application Question(s):
- Do you live in Miami-Dade or Broward County Florida?
- This position require daily full-time presence in our office. Will you be able to accommodate this requirement?
About the company
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Data Engineer Salary UK
Where To Find Software Engineering Jobs
The Most Popular IT Jobs on the Market
Fully Remote Software Engineer Jobs