Senior Programmer - Lead, Large-Scale Systems & Data

Elite Enterprise Resources; City of Albany (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

Elite Enterprise Resources, LLC is seeking a Programmer to perform analysis, design, coding, testing and implementation of application software across a multi-tier system. The role includes production support, maintenance, enhancements and documentation.

The ideal candidate has strong experience with Oracle, PL/SQL, VB6, ER Studio and .NET, and a proven track record delivering large data set projects in a fast-paced environment, including HIPAA data handling for mental health services.

Qualifications

• 7 years demonstrated experience developing clinical and non-clinical applications for a mental health related agency, including ISP, patient assessments, and Medicaid reimbursement.
• 7 years demonstrated experience with HIPAA protected data related to mental healthcare and patient mental health records.
• 7 years demonstrated experience with Oracle 9i or higher, including ORACLE PL/SQL coding, stored procedures, packages, indexes, triggers, creating tables, etc., including the use of a tool to write and test SQL code and manipulate data (such as Toad).
• 72 Months Demonstrated experience with Visual Basic 6 (VB6).
• 7 years experience with ER Studio or similar product to design databases and create entity relationship diagrams.
• 4 years demonstrated experience with C#.Net.
• 3 years years experience with large data sets (> 10 million rows).

Responsibilities

• The selected candidate will be responsible for all phases of the System Development Life Cycle for a multi-tiered complex system.
• The responsibilities will include both new development as well as maintenance tasks.
• Specific tasks will included: assisting with technical design for new development and system enhancements.
• Coordinating the technical solutions among various technical support groups.
• Presentations of technical solutions to management and technical support areas.
• Implementing technical solutions.
• Assisting with requirements gathering sessions.
• Leading the analysis of requirements and system design work.
• Development of technical design documents and program specifications.
• Coding, unit and integration testing of programming assignments.
• Writing and tuning SQL
• Technical Support of user testing efforts.
• Performance tuning of new and existing applications.
• Production support tasks including analysis of issues, propose and implement solutions.
• Mentoring of less experienced staff would be required.
• The candidate must be able to work in a fast paced environment where legislative changes must be quickly implemented

Skills

HIPAA data handling

Medicaid HCBS/PROS knowledge

ISPs and patient assessments

System Development Life Cycle

Leadership / mentoring

Tools

Oracle 9i+

PL/SQL

Toad

VB6

ER Studio

C#.Net

Large data sets (>10M rows)

Job description

Elite Enterprise Resources, LLC is seeking a Programmer to perform analysis, design, coding, testing and implementation of application software across a multi-tier system. The role includes production support, maintenance, enhancements and documentation.

The ideal candidate has strong experience with Oracle, PL/SQL, VB6, ER Studio and .NET, and a proven track record delivering large data set projects in a fast-paced environment, including HIPAA data handling for mental health services.