[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.ResponsibilitiesMigration project to move data from legacy ISAM files to the PostgreSQL database clusterParticipate in all aspects of migration and post-migrationData modeling and creation of database schema designCreation of CRUD-related functions to process data setsPostgreSQL database infrastructure designPerformance tuning of database post migrationSkillsSQL proficiency and building DDL and DML objectsExperience with PostgreSQL and its specific features, i.e. - PL/pgSQLUnderstand SQL queries, data manipulation, and database designCreating CRUD routines for database applicationsDatabase schema designProficiency in designing relational database schemasCreate efficient and normalized database schemasUnderstanding relationships (such as one-to-many, many-to-many) and indexing strategiesPerformance tuningOptimize query performance by analyzing execution plans, indexing, and query optimization techniquesDatabase administrationKnow how to manage PostgreSQL instances, handle backups, and perform routine maintenance tasks, specifically with PostgreSQLBackup and recoveryProficiency in setting up and managing database backup and recovery processesSecurityUnderstand authentication, authorization, and encryption mechanisms to secure the DatabaseFamiliarity with multitenancy a plusProblem-solving skillsDebugging, troubleshooting, and resolving issues efficientlyAbility to troubleshoot and resolve database issuesData analysisAbility to perform data analysis and generate insights from complex data setsCommunicationExcellent verbal and written skillsAbility to explain technical concepts to non-technical stakeholdersCollaborationExperience in working with cross-functional teamsAbility to collaborate effectively with developers, analysts, and business usersAt least 1-2 years developing with PostgreSQL and Linux, with an emphasis on SQL, PL/pgSQL, and other scripting languagesBachelor's degree in computer science or information systemsExperience with other RDBMS platforms is a plusFamiliarity with Git or other version control systems for managing database codeFamiliarity with C++ is a bonusBenefitsOpen PTO policyRemote working flexibilityCareer growthEmployee rewards programPaid holidaysMedical, dental, vision insurance with dependent paid coverage100% company-paid life insurance, short-term and long-term disability benefits401(k) retirement planCompany OverviewEquipment 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