Job Description :
In this role you will report to our Senior Database Engineer and develop and maintain database applications by completing software programming and related software
development tasks. Develop programs including coding, testing and deploying and supporting a variety of software solutions managing operational data, improving
decision making and improve operational processes. Analyze data processing systems, design and implement improvements. Analyze user requirements, business requirements, and system capabilities to recommend, design, program, test, and release new and improved capabilities. Maintain and monitor existing systems supporting the business. Contribute to the implementation of a program of systems changes, assist in software selection and configuration. Program automation scripts, queries, middleware and tools to support test and production environments. Nordic Naturals uses numerous technologies, and this position will initially be focused on developing and supporting PostgreSQL based programs but will also work with numerous other technologies in the mid to longer term.
In this role you will:
Responsible for coding, developing, maintaining and enhancing Nordic Naturals corporate database applications focused on programming in PL/pgSQL (Procedural PostgreSQL) , xTuple ERP PostgreSQL databases, and also MySQL and other database systems, and applications including Salesforce, and other web based data technologies, depending on skills.
Responsible for designing and developing integrations between systems.
Responsible to develop and support complex database queries and integrations between systems
Responsible for ensuring data integrity between corporate databases
Design with focus on end user maintainability
Work with user teams to understand requirements and translate those into software user interface and database capabilities.
Design, build, test, deploy and document new and existing applications
Provide technical expertise and data analysis to teams.
Develop and integrate our applications and expand our business process capabilities.
Provide technical support to our help desk staff and end users when required
Qualifications:
Bachelor’s Degree or Higher in Computer Science or related field, or equivalent education and experience
4-5 years of professional experience in database application programming and application development in structured and agile development methodologies / work environments
Experience in relational database design, data modeling, and in developing database applications
Experience writing advanced SQL, scripting languages, and integration platforms
Strong Agile Development experience, Github or Bitbucket, Jira, Confluence are all a plus
Experience in PostgreSQL database administration a plus
Experience in Unix/Linux
Experience with ERP systems a plus
Experience with Filemaker is a plus
Experience with Salesforce is a plus
Computer Skills:
Programming:
Excellent Procedural PgSQL Programming skills or strong general SQL programming skills and a passion for relational database work
Demonstrable skills in scripting languages, very skilled in at least one scripting language
Demonstrable skills in GIT and source code management
Experience with middleware and EAI / ETL Platforms a strong plus
Administration:
Experience with PostgreSQL server administration, web server administration nginx, node.js all are considered a plus.
Networking:
Knowledge of computer networking is considered a plus
Computer Programming Languages:
Required:
Strong PL/pgSQL / SQL
Strong Javascript
Strong Linux / Unix Shell Scripting
Additional considered a plus
HTML/CSS/Javascript Frameworks / REACT
o XML
C++
Java
PHP
Python
Web Services
Salesforce SOQL and APEX
Certifications &Licenses:
Certifications related to database programming skills or database administration skills are not required but are a strong plus