Posted 1d ago

Database Engineer

@ HBS Systems
United States
$70k-$90k/yrRemoteFull Time
Responsibilities:migrate data, design schemas, process data
Requirements Summary:3+ years PostgreSQL/Linux with SQL/PL/pgSQL; Bachelor's in CS or Information Systems; SQL proficiency; relational schema design; data modeling; migration and backup/restore experience.
Technical Tools Mentioned:PostgreSQL, Linux, SQL, PL/pgSQL, Git, C++
Save
Mark Applied
Hide Job
Report & Hide
Job Description

Celebrating the 41st 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 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:

  1. Migration project to move data from legacy ISAM files to the PostgreSQL database cluster
  2. Participate in all aspects of migration and post-migration
  3. Data modeling and creation of database schema design
  4. Creation of CRUD-related functions to process data sets
  5. PostgreSQL database infrastructure design
  6. Performance tuning of database post migration

Required Job Qualifications:

  1. At least 3 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
  4. Understand SQL queries, data manipulation, and database design.
  5. Creating CRUD routines for database applications
  6. Proficiency in designing relational database schemas. Create efficient and normalized database schemas.
  7. Understanding relationships (such as one-to-many, many-to-many) and indexing strategies
  8. Ability to optimize query performance by analyzing execution plans, indexing, and query optimization techniques
  9. Experience managing PostgreSQL instances, handle backups, and perform routine maintenance tasks, specifically with PostgreSQL
  10. Proficiency in setting up and managing database backup and recovery processes
  11. Understand authentication, authorization, and encryption mechanisms to secure the Database. Familiarity with multitenancy a plus.

Preferred Qualifications: 

  1. Familiarity with Git or other version control systems for managing database code.
  2. Familiarity with C++ is a bonus
  3. Debugging, troubleshooting, and resolving issues efficiently.
  4.  Ability to perform data analysis and generate insights from complex data sets

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.
  • Flexible Work: 100% remote position.
  • Collaborative Culture: Join a team that values ownership, collaboration, and continuous improvement.

EEO Employer

Must be legally authorized to work in the United States. Candidate must not require HBS to commence ("sponsor") an immigration case to employ candidate (H-1B or other employment-based immigration cases)