MS Access / VBA developer (Must be local to Arkansas)

Client : State of AR

Job ID : 780772

Job Title : DHS Access / SQL Database Developer (780772)

Job Location : 700 Main Street, Littlel Rock, AR 72201

Duration : 6+ Months

Onsite - Candidates must be local.

Description

• The Arkansas Department of Human Services (DHS) is seeking a contractor to stabilize the current production Access / SQL system and create documentation so daily operations can continue reliably. This position is available for extensions.
• This Developer will work with DHS Office of Internet Technology (OIT) to maintain compliance with DHS, State and Federal requirements.
• This role provides stabilization and support for an existing Microsoft Access database application used in daily accounting operations. The application is currently in production and will remain in use until a modernization project is completed.
• The primary focus of this position is to diagnose issues, implement bug fixes, ensure reliability of daily workflows, and create documentation.

Responsibilities include :

Knowledge, Skills, and Abilities Requirements :

Skill

Required / Desired

Amount of Experience

MS Access Development

Required

5 Years

Visual Basic for Applications

Required

5 Years

ActiveX Data Objects

Required

5 Years

MS Access SQL and Query design

Required

5 Years

Experience splitting MS Access Databases into Front Ends and Back Ends

Required

3 Years

Experience translating the business logic from macros / modules / queries to SQL

Required

4 Years

Experience writing stored procedures, pl / sql and migrating tables from MS Access to SQL Server

Required

4 Years

Experience converting MS Access Forms / Reports to any Web based application

Required

4 Years

QuickBase Rapid Application Development Platform

Highly desired