Access/SQL Database Developer

Agama Solutions • Little Rock, AR

2d

About The Position

This role involves troubleshooting and fixing issues in Microsoft Access (front-end) and SQL Server (back-end) databases. The developer will ensure the reliable and accurate operation of daily workflows, reverse-engineer and document business logic, queries, forms, and workflows. Responsibilities include debugging and maintaining Access objects (forms, queries, modules, macros, VBA code), writing and debugging SQL queries, stored procedures, ADO, and integrations. The position also supports accounting/financial workflow processes, provides knowledge transfer and documentation to OIT teams, and collaborates with business users and the modernization team.

Requirements

• 5+ years Microsoft Access Development.
• 5+ years VBA (Visual Basic for Applications).
• 5+ years ActiveX Data Objects (ADO).
• 5+ years MS Access SQL & Query Design.
• 3+ years splitting Access DB into front-end/back-end.
• 4+ years translating business logic from Access objects → SQL.
• 4+ years writing stored procedures & migrating tables to SQL Server.
• 4+ years converting Access forms/reports to web-based apps.

Nice To Haves

• Experience with QuickBase RAD platform.
• Accounting/Financial workflow experience.
• Experience stabilizing legacy applications during modernization.

Responsibilities

• Troubleshoot and fix issues in Microsoft Access (front-end) and SQL Server (back-end).
• Ensure daily operational workflows run reliably and accurately.
• Reverse-engineer and document business logic, queries, forms, and workflows.
• Debug and maintain forms, queries, modules, macros, and VBA code.
• Write and debug SQL queries, stored procedures, ADO, and integrations.
• Support accounting/financial workflow processes.
• Provide knowledge transfer and documentation to OIT teams.
• Collaborate with business users and modernization team.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed