[Remote] Database Developer

🌍 Remote, USA 🚀 Full-time 🕐 Posted Recently

Job Description

Note: The job is a remote job and is open to candidates in USA. HBS Systems is an industry leader in providing web-based dealership management software for various sectors. They are seeking a Database Developer to contribute to the development and administration of their database layer, focusing on PostgreSQL and SQL programming.

Responsibilities

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

Skills

SQL proficiency and building DDL and DML objects
Experience with PostgreSQL and its specific features, i.e. - PL/pgSQL
Understand SQL queries, data manipulation, and database design
Creating CRUD routines for database applications
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
Performance tuning
Optimize query performance by analyzing execution plans, indexing, and query optimization techniques
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
Security
Understand authentication, authorization, and encryption mechanisms to secure the Database
Familiarity with multitenancy a plus
Problem-solving skills
Debugging, troubleshooting, and resolving issues efficiently
Ability to troubleshoot and resolve database issues
Data analysis
Ability to perform data analysis and generate insights from complex data sets
Communication
Excellent verbal and written skills
Ability to explain technical concepts to non-technical stakeholders
Collaboration
Experience in working with cross-functional teams
Ability to collaborate effectively with developers, analysts, and business users
At least 1-2 years developing with PostgreSQL and Linux, with an emphasis on SQL, PL/pgSQL, and other scripting languages
Bachelor's degree in computer science or information systems
Experience with other RDBMS platforms is a plus
Familiarity with Git or other version control systems for managing database code
Familiarity with C++ is a bonus

Benefits

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

Company Overview

Equipment dealer management solutions and rental software backed by award-winning customer support. Inventory/Sales/Parts/Service/Accounting It was founded in 1985, and is headquartered in Richardson, Texas, USA, with a workforce of 51-200 employees. Its website is http://hbssystems.com.

Apply To This Job