SQL Database Developer

DHS Access/SQL Database Developer

Job : 780772
Client: State of Arkansas - DHS Office of Internet Technology (OIT)
Duration: 6+ Months
Location: 700 Main Street, Little Rock, AR 72201

$40.00/yr - $45.00/yr

• MS Access Development
• Strong SQL Server experience (queries, stored procedures, debugging)
• Visual Basic for Applications
• Active
  
  X Data Objects

• 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.

• 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.

• MS Access Development
• Visual Basic for Applications
• Active
  
  X Data Objects
• MS Access SQL and Query design
• Experience splitting MS Access Databases into Front Ends and Back Ends
• Experience translating the business logic from macros/modules/queries to SQL
• Experience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server
• Experience converting MS Access Forms/ Reports to any Web based application
• Quick Base Rapid Application Development Platform

Entry level

Full-time

Information Technology

Staffing and Recruiting