Database Administrator (5+ Years Experience and Full-time Onsite required)

Paneltronics Incorporated
Hialeah Gardens, United States of America
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English, Spanish
Experience level
Intermediate
Compensation
$ 90K

Job location

Hialeah Gardens, United States of America

Tech stack

Microsoft Excel
Backup Devices
Computer Programming
Databases
Data Security
Relational Databases
Database Development
Microsoft SQL Server
Operational Data Store
Performance Tuning
Pivot Tables
SQL Stored Procedures
SQL Databases
Backup and Restore
Scripting (Bash/Python/Go/Ruby)
Enterprise Software Applications
Macros
System Availability
Information Technology
Vba Programming Language
Infor

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 (Required), * 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 Gardens, FL 33018 (Required)

Benefits & conditions

Referral program, 401(k), Health insurance, 401(k) matching, Paid time off, Vision insurance, Dental insurance, Life 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
  • 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