What are the responsibilities and job description for the Database Administrator (IBM i) position at The H.T. Hackney Co. - Grand Rapids, MI?
Company Description:
The H.T. Hackney Co. is one of the largest wholesale grocery distribution companies in the country, with a distribution network of over 20,000 customers in 22 states. Our services include not only product distribution, but also retail space management, foodservice solutions, and vendor partner programs. Our customer base is primarily convenience stores as well as independent grocery stores, restaurants, and vending companies. If you are looking for a rewarding career, you have come to the right place. We have been serving customers with integrity and reliability for over 130 years and are looking for employees to join us in continuing our tradition of exceptional customer service.
Position Summary:
We are seeking an experienced Database Administrator (DBA) to join our Software Development team. This role is responsible for the administration, performance, security, and reliability of our IBM i (AS/400) Db2 database environment. The successful candidate will work closely with software developers to design, optimize, and maintain databases that support our enterprise applications while ensuring data integrity, performance, and long-term scalability.
Key Responsibilities:
- Administer, maintain, and optimize Db2 for i databases within an IBM i environment.
- Monitor database performance and identify opportunities for optimization.
- Develop and maintain backup, recovery, and disaster recovery strategies.
- Manage database security, user access, and data integrity.
- Review database designs, table structures, indexes, and SQL code to ensure best practices and performance standards are met.
- Collaborate with developers throughout the software development lifecycle to provide guidance on database design, SQL optimization, and application performance.
- Support database migrations between development, testing, and production environments.
- Troubleshoot database issues, locking conflicts, and performance bottlenecks.
Qualifications:
- 3 years of experience administering relational databases in an IBM i (AS/400) environment.
- Strong knowledge of IBM i operating system and Db2 for i.
- Experience writing and optimizing SQL.
- Understanding of database design principles, indexing, and performance tuning.
- Experience with backup, recovery, and high availability solutions.
- Strong analytical and troubleshooting skills.
- Excellent communication skills with the ability to collaborate effectively across technical teams.
Preferred Qualifications:
- Experience with database analysis and management tools such as X-Analysis or similar.
- Knowledge of DDL, DDS, stored procedures, triggers, and database security best practices.
- Experience supporting enterprise business applications.
What You'll Bring:
- A collaborative approach to problem solving.
- Strong attention to detail and commitment to data quality.
- The ability to balance technical excellence with practical business needs.
- A proactive mindset focused on continuous improvement and database performance.
Work Location: In person
If you're passionate about maintaining high-performing database environments and enjoy working closely with development teams to build reliable business applications, we'd love to hear from you.