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

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6+ month(s)

Skills

SQL
Troubleshoot
VBA
Stored procedures
MS Access
Queries
Test.

Job Details

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:

  • Troubleshoot and resolve defects in the existing Access front end and SQL Server back end. Ensure daily operational workflows function consistently and accurately. Document business logic, database relationships, and application workflows to enable internal support. Provide knowledge transfer to OIT Staff. Collaborate professionally with business stakeholders to clarify issues and confirm successful resolutions. Coordinate with the modernization project team to ensure continued alignment, without performing modernization work.

Knowledge, Skills, and Abilities Requirements:

  • Proficiency in Microsoft Access / VBA for debugging and maintenance of existing forms, queries, and modules.
  • Strong SQL Server experience (queries, stored procedures, debugging).
  • Experience reverse-engineering and maintaining legacy systems without redesigning them.
  • Ability to follow change control, documentation, and testing processes.
  • Comfortable working within existing architecture and constraints.
  • Understanding of accounting or financial workflow systems preferred.
  • Prior experience stabilizing legacy applications during transition to new platforms.
  • Strong written and verbal communication skills for documentation and knowledge transfer.

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


Cleo Consulting is an equal opportunity employer (Minorities/Women/Veterans/Disabled)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.