Job Details

POSITION SUMMARY

Under the direction of the Supervisor, performs duties related to the creation and maintenance of computerized application systems. Responsible for all phases of the software development lifecycle using an Agile methodology. Duties include collaborating with the Application Support team and business users to define project objectives and interpreting those requirements to produce an appropriate physical database design and user interface. Codes and tests new applications, system enhancements, and bug fixes. Engineer is able to write functional code with a sharp eye for spotting defects. In addition, trains Application Support and key business user personnel on the use of new features and system modifications while providing ongoing support. A high degree of independence and autonomy is expected of employees when performing these tasks. Successful engineers should be detail oriented and possess excellent troubleshooting and communication skills.

Additionally, this position includes specialized responsibilities which may include: web server administrator or developer of specialized electronic data interchange (EDI) interfaces.

There are three (3) different levels:

• Full Stack Software Engineer
• Senior Full Stack Software Engineer
• Lead Full Stack Software Engineer

***Salary commensurate with experience***

ESSENTIAL DUTIES AND RESPONSIBILITIES

Key Responsibilities

1. Analysis & Design
   • Meets with Application Support team and business users to identify system, interface, and reporting requirements.
   • Creates and modifies Oracle database objects as appropriate to support system objectives. Maintains entity relationship diagrams and documentation to reflect changes to table structures.
   • Defines and implements scripts to create and manage data objects with the Snowflake data cloud.
2. Application Coding
   • Builds system prototypes early in the development lifecycle based on user specifications. Demonstrates prototypes to users to obtain feedback on the accuracy of the system requirements.
   • Creates advanced multi-user systems using a multi-tier application structure. Designs and develops user interfaces using the .NET Framework with Razor Pages, leveraging HTML, CSS, JavaScript, jQuery, and Kendo UI to deliver responsive web applications.
   • Develops RESTful APIs using C# and Microsoft Entity Framework to enable secure, scalable, and efficient data access and integration.
   • Builds and maintains public-facing websites using Angular for front-end development and Drupal as the content management system to deliver scalable, content-rich user experiences.
   • Performs server-side development using Oracle PL/SQL to implement complex business logic, optimize database performance, and manage data integrity.
   • Optimizes application performance through database tuning.
   • Designs, develops, and maintains data integration interfaces that load data into Salesforce using MuleSoft as the integration engine, ensuring seamless and reliable data flow across systems.
   • Develops and maintains Oracle data warehouses.
3. Unit and System Testing
   • Writes scripts to perform integration and unit testing to ensure accuracy of system changes.
   • Assists Application Support team and users in developing test plans and scenarios.
4. Training and User Support
   • Trains business analysts and key personnel on the use of new features and system enhancements.
   • Responds to questions from Application Support team and business users.
5. Documentation and Source Code Control
   • Creates program documentation to assist with future development and system maintenance. Writes deployment scripts used to move systems to production.
   • Follows departmental policies for program changes. Complies with HDS procedures to ensure that all modified source code is checked into the version control system.
6. Other specialized skills or functions (One or more of the following specialized responsibilities):
   • Web Administrator:
     • Creates, maintains, patches, and upgrades web servers.
     • Configures virtual machines for various operating systems including Windows and Linux.
   • EDI/Web Services Specialist:
     • Develops and maintains specialized applications which support interfaces with trading partners using standardized electronic data interchange (EDI) transactions.
     • Develops and maintains scripts which automate the transmission of EDI datasets between trading partners.
     • Devises strategies to ensure data remains secure as it is transmitted between trading partners.
     • Develops and maintains web service interfaces to allow external trading partners to utilize exposed services hosted on HDS's systems.
     • Develops and maintains applications which access web services provided by external trading partners to meet HDS's business requirements.
7. Other Duties and Responsibilities
   • Evaluates third party technologies to be integrated with new or existing applications.
   • Assists Information Technology department in answering and troubleshooting helpdesk calls as necessary during high volume periods or during periods of low staffing.
   • Other miscellaneous duties and responsibilities as assigned.

MINIMUM QUALIFICATIONS AND EXPERIENCE

Education

Bachelor's degree in Information Systems, Computer Science, or an equivalent combination of education, training, or work experience.

Experience

1. Two (2) to seven (7) years of experience in application development, or an equivalent combination of education, training, or work experience.
2. Knowledge of basic SQL query language and database design principles, preferably for Oracle.
3. Experience with Visual Studio, MVC, .NET, Entity Framework, Nuget packages, Oracle PL/SQL, and Git.
4. Familiarity with website design using HTML, JavaScript, CSS, C#, Kendo UI, Angular, and Drupal. Experience with Apache and Internet Information Services (IIS) is preferred.
5. Background working in an Agile environment using a project tracking tool such as Jira.
6. Familiarity using Windows and Microsoft Office (e.g. Outlook, Word, Excel, and PowerPoint).

Skills and Knowledge

1. Ability to organize, analyze and solve complex problems with attention to detail and accuracy.
2. Ability to handle multiple tasks and prioritize with some distractions.
3. Ability to handle information in a confidential manner and maintain compliance with HDS policies and federal/state laws.
4. Ability to communicate both orally and in writing with all levels of staff, customers, and vendors on sensitive matters.

Note: The above information in this description has been designed to indicate the general nature and level of work performed by an employee in this classification. It is not to be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications of employees assigned to this job. Hawaii Dental Service has the right to add to, revise, or delete information in this description. Reasonable accommodation will be made to enable qualified individuals with disabilities to perform the essential functions of this position.