ERP Database Administrator (DBA)

Job Description

Job Description

ABOUT BANNER SOLUTIONS

Banner Solutions is a premier national wholesale distributor specializing in commercial door hardware, access control systems, and security products across CSI Divisions 8, 10, and 28. As a leader in the commercial door and security hardware industry, we represent more than 260 manufacturers and deliver industry-leading service with a 98%+ same-day ship rate.

Our customers include Contract Hardware Dealers, Glass & Glazing Dealers, Building Material Suppliers, Electronic Access Control Integrators, Locksmiths, Institutional End Users, e-tailers, and retailers nationwide. Through our nationwide distribution network, deep product expertise, and strong manufacturer partnerships, we help customers secure and complete buildings across the country.

Banner Solutions is built on a culture of ownership, collaboration, and accountability. Our team members are empowered to make an impact while delivering the expertise, service, and reliability our customers depend on.

CORE RESPONSIBILITIES

Database Management, Modeling and Development:

• Administer and maintain the P21 databases (SQL) to ensure optimal performance, availability, and security.
• Create and maintain logical and physical data models to ensure data integrity and efficient use of resources.
• Implement database structures based on application requirements and best practices.
• Monitor database performance, troubleshoot issues, and implement solutions to enhance efficiency.
• Collaborate with cross-functional teams to understand data requirements and provide effective database solutions.
• Manage user access and permissions to databases, ensuring compliance with security policies and regulatory requirements.
• Plan and execute database upgrades, patches, and migrations while minimizing downtime and impact on business operations.
• Oversee SQL Server Reporting Services (SSRS) to design, develop, and deploy reports for various stakeholders across the organization.
• Create/Maintain SSIS packages used for importing/exporting/updating data.

Data Security and Integrity:

• Implement and maintain robust security measures to protect sensitive data.
• Perform regular data integrity checks and implement measures to address any discrepancies.
• Implement and maintain database security measures to protect sensitive data.
• Regularly audit and update user permissions and access controls.

Performance Tuning & Query Optimization:

• Conduct regular performance tuning and optimization of database systems for efficient and fast query execution.
• Collaborate with the ERP and Application Development teams to optimize SQL queries and improve overall system performance.
• Write efficient, tuned, and well-documented SQL queries to extract, update, and manipulate data.

Backup, Recovery and Documentation:

• Collaborate with the technology team to develop and implement backup and recovery strategies to safeguard critical data.
• Test and verify backups to ensure the ability to restore systems in case of data loss.
• Maintain comprehensive documentation of database configurations, procedures, and troubleshooting steps.
• Develop and update documentation for database-related policies and best practices.

Critical Business Partner

• Work with end users to understand business requirements for reports/processes and be able to ‘assist’ users in defining those requirements.
• Work with outside vendors to develop/expand business solutions – SLIM4 and Salesforce
• Assist power users with queries against the data warehouse / data lake
• Lead a structured knowledge transfer from the incumbent DBA, ensuring institutional database knowledge, configurations, and undocumented processes are fully documented and transitioned

QUALIFICATIONS

Required

• Bachelor’s degree in computer science, Information Technology, or a related field.
• Strong proficiency in SQL and scripting languages.
• Solid understanding of database design principles, normalization, and optimization techniques.
• Experience with database security and data protection measures.

• 5+ years of experience as a Database Administrator in a distribution or wholesale ERP environment (e.g., Prophet 21, Epicor, DDI, Infor, or similar)
• Experience with distribution ERP strongly preferred, Prophet 21 (P21) experience a significant plus.
• Hands-on experience with SQL Server Reporting Services (SSRS) for report development and management.
• Excellent problem-solving and troubleshooting skills.

• In-depth knowledge of SQL Server database architecture, design, and performance optimization
• Demonstrated ability to inherit an undocumented or partially documented database environment and systematically build institutional knowledge
• Ability to collaborate effectively with cross-functional teams.
• Experience with Cloud Database (e.g. Azure) Administration a plus.

Cultural Fit & Attributes

• Driven, disciplined, and ownership-oriented — you treat the database like it’s yours.
• Committed to process excellence, accountability, and continuous improvement.
• Collaborative team player who leverages internal and external partnerships to win.
• Embodies Banner Solutions’ values of Courtesy, Respect, Quality, Professionalism, and Discipline .

COMPENSATION & BENEFITS

Competitive Base Salary

✓

Performance Bonus

✓

401(k) + Match

✓

Medical / Dental / Vision

✓

Remote-Friendly

✓

Paid Time Off

✓

The job description is not an exhaustive listing of all responsibilities and may be revised at any time.