[Remote] Database Developer

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