Database Developer

Celebrating the 39th year of serving our equipment dealership customers in the Agriculture, Construction, Material Handling, Equipment Rental, Aggregate, and Industrial industries with our web-based dealership management software, we have the rock-solid foundation of an industry leader with the passion and the spirit of a start-up. We believe in an entrepreneurial workplace, where ideas are encouraged and initiative is rewarded.

HBS Systems offers a generous compensation package including the following:

• Open PTO policy

• Remote working flexibility

• Career growth

• Employee rewards program

• Paid holidays

• Medical, dental, vision insurance with dependent paid coverage

• 100% company-paid life insurance, short-term and long-term disability benefits

• 401(k) retirement plan 

Job Description:

The Database Developer DBA will contribute to development and administration efforts in the Database layer of our dealer management software application. This role requires an in-depth knowledge of PostgreSQL (or similar DBMS) in a Linux environment and SQL and database programming skills. Ideal candidates will demonstrate the ability to quickly grasp domain knowledge and requirements.

Location: This is a fully remote position.

Salary: $70,000.00 to $90,000.00 per year

Job Duties:

·          Migration project to move data from legacy ISAM files to the PostgreSQL database cluster

·          Participate in all aspects of migration and post-migration

• Data modeling and creation of database schema design

• Creation of CRUD-related functions to process data sets

• PostgreSQL database infrastructure design

• Performance tuning of database post migration

Job Qualifications:

1.     At least 1-2 years developing with PostgreSQL and Linux, with an emphasis on SQL, PL/pgSQL, and other scripting languages.

2.     Bachelor's degree in computer science or information systems

3.     SQL proficiency and building DDL and DML objects

·         Experience with PostgreSQL and its specific features, i.e. - PL/pgSQL. Experience with other RDBMS platforms is a plus.

·         Understand SQL queries, data manipulation, and database design.

·         Creating CRUD routines for database applications

4.     Database schema design

·         Proficiency in designing relational database schemas. Create efficient and normalized database schemas.

·         Understanding relationships (such as one-to-many, many-to-many) and indexing strategies

5.     Performance tuning

·         Optimize query performance by analyzing execution plans, indexing, and query optimization techniques

6.     Database administration

·         Know how to manage PostgreSQL instances, handle backups, and perform routine maintenance tasks, specifically with PostgreSQL

·         Backup and recovery. Proficiency in setting up and managing database backup and recovery processes

7.     Security

·         Understand authentication, authorization, and encryption mechanisms to secure the Database. Familiarity with multitenancy a plus.

8.     Nice-to-have skills include

·         Familiarity with Git or other version control systems for managing database code.

·         Familiarity with C++ is a bonus

9.     Problem-solving skills

·         Debugging, troubleshooting, and resolving issues efficiently.

·         Ability to troubleshoot and resolve database issues.

10.   Data analysis

·         Ability to perform data analysis and generate insights from complex data sets

11.   Communication

·         Excellent verbal and written skills

·         Ability to explain technical concepts to non-technical stakeholders

12.   Collaboration

·         Experience in working with cross-functional teams

·         Ability to collaborate effectively with developers, analysts, and business users

Why Join Us?

·         Innovative Projects: Work on high-impact, enterprise-level web applications that drive real business value.

·         Career Growth: Opportunities for professional development and career advancement.