PostgreSQL Database Engineer (Full-time)
-
NECS is looking for an experienced PostgreSQL database engineer to migrate our on-prem Windows based ERP, currently running on Sybase Advantage Database to the PostgreSQL platform. The Windows application is written in Delphi (pascal) and currently requires direct database access for most operations. Very little data is accessed through stored procedures and/or database functions. The primary responsibility will be to design a system to manage database migrations from version to version, create a migration/transfer utility to be used for migrating existing Sybase data to the Postgres database, and provide insight on performance tuning.
Responsibilities
-
Coordinate with the developers, managers, and leadership teams to build an effective database.
-
Collaborate with product managers to make sure database code meets the demand of the ERP as well as supporting applications.
-
Communicate with front-end developers to define plain yet dynamic APIs.
-
Keep a check on data structures and quality of data with DBAs.
-
Integrate and maintain database code in procedures, scripts, queries, and views.
Required Skills
-
Bachelor’s degree in computer science, IT, or equivalent experience.
-
Minimum of 5+ years of experience working with PostgreSQL.
-
Familiarity with PostgreSQL support for JSON.
-
Good Grasp of ETL concepts.
-
In-depth understanding of data management (e.g., permissions, recovery, security, and monitoring).
-
Strong written and verbal communication along with proven fluency of English
Preferred Skills
-
Experience writing Windows Applications in Delphi or C#.
-
Knowledge of message queuing, indexing, and high-performance data concepts
-
Familiarity with data structure and algorithms
-
Ability to profile databases.
-
Ability to write database queries and code while maintaining data quality, privacy, and security.
-
Assumes a flexible, dynamic, and proactive approach to all assigned tasks
-
Ability to work with others across various professions
-
Maintains an unwavering positive attitude and energy
-
Must be a self-starter, critical-thinker, solution-seeker, and problem-solver
Compensation and Benefits
-
Remote opportunity available after in-person Onboarding (2 weeks)
-
Salary range is $100,000-$120,000 a year based on experience
-
Health and Vision Insurance
-
PTO
-
Professional Development Assistance
About NECS
Founded in 1987, NECS is driven by its mission to produce top quality software for food service distributors. A true visionary, NECS President Chris Anatra possessed the foresight to recognize the then emerging technology market was severely lacking in specialized software to address the needs of wholesale food distributors and full line distributors. Over the years, the NECS software evolved into entrée, a comprehensive Windows application with more than 3 million lines of programming source code. To date, more than 2,000 wholesale food distributors have decided that the NECS entrée system is the best product to meet their demanding needs.
Company Culture
Focused on the world of fast-paced food distribution, NECS operates in the realm of high-value ERP software. We work to solve real problems instead of creating arbitrary “solutions” – ensuring the client is the hero, and we act as their guide to success.
NECS stays connected to our customer-centric values by maintaining a tight-knit, collaborative team even as we grow. Our fun, ‘work-hard, play-hard’ company environment encourages employees to share their best ideas and complete their most innovative work – whether at home or in the office.
We are the lead distribution software company in the world, due to our streamlined hiring process that recruits top talent. Our NECS team is committed to developing affordable software of such notable quality that our customers feel like they’re stealing it from us.