Lab IT Support Specialist

Title: Lab IT Analyst

Location: Montgomery, AL

Duration: 12 months contract with possible extension.

Position Description:

Tasks Specification: The requirements for this position must meet the following requirements or possess an equivalent combination of education and experience:

• Provides end user system support for Laboratory Information Management Systems (LIMS)
• Troubleshoots data issues within the LIMS and data exchange messages
• Assess current LIMS for ability to meet project and user/program requirements
• Facilitates discussions between program staff and system vendor
• Makes recommendations for necessary software and workflow enhancements
• Enacts enhancements approved by program staff and IT Manager
• Designs computer programs for end users within the public health lab community
• Develops/modifies simple to complex SQL, computer programs, and operator instructions so that systems operate as defined within the specifications
• Configuring/updating/maintaining tables, queries, reports, letters, documents, data marts, and other parameters so that systems operate as defined within the specifications
• Testing computer programs, SQL, configurations, table changes, queries, reports, letters, data marts, and other parameters so that systems application(s) operate substantially error free
• Analyzes file structures, relationships and develop system designs
• Documentation of all programs
• Configures hardware and software with the vendor provided guidelines
• Analyzes the data stored in the databases and makes recommendations relating to performance and efficiency of stored data.
• Database design and data modeling/optimization
• Programs routes within Rhapsody Electronic Data Interchange engine for parsing. processing, modifying and storing appropriate message data
• Programs TSQL stored procedures, triggers, and user defined functions.

Skills Required:

• Knowledge of the organization, functions, responsibilities and procedures of the Alabama Department of Public Health.
• Knowledge of personal computer hardware and related equipment.
• Ability to establish and maintain effective working relationships with public health managers, disease surveillance staff and newborn screening staff as well as other public health trading partners.
• Knowledge of JavaScript.
• Knowledge of Oracle 12c or higher in a production setting with tables of over 1 million records in size.
• Experience with TSQL, queries, stored procedures and triggers.
• Knowledge of a Windows environment and operating system, Windows 2012 R2 Server and Windows 10.
• Excellent communication skills, both oral and written.
• Ability to work independently, under pressure and self-motivated.

Skills Preferred:

• Any combination of training and experience equivalent to: Graduation from an accredited two-year college or university with major course work in computer science, engineering, or closely related field, with a minimum of two years of programming experience using the following languages/tools: C#; SQL; JavaScript; Microsoft Visual Studio; Microsoft Reporting Services.
• This person must have the ability to work on multiple assignments and to work collaboratively within a team..

Experience Required:

• Any combination of training and experience equivalent to: Graduation from an accredited two-year college or university.
• One to two years of experience in systems and programming.
• Working knowledge of EDI translation software, Integration Engines, JavaScript and Oracle SQL.
• 3 Years in JavaScript.
• 3 years in Oracle 12c or higher in a production setting with tables of over 1 million records in size.
• 3 years in Experience with TSQL, queries, stored procedures and triggers.
• 3 Years in end user system support.
• 1 Year in Rhapsody Electronic Data Interchange.

Education Required:

• Graduation from an accredited two-year college or university with major course work in computer science, engineering, or closely related field.

Job Type: Contract

Salary: $50.00 per hour

Schedule:

• 8 hour shift

Experience:

• TSQL: 3 years (Preferred)

Work Location: In person

Speak with the employer
91 9876543210