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.