Access/SQL Database Developer

DataStaff is seeking an Access/SQL Database Developer for a long-term contract opportunity with one of our direct clients located in Little Rock, AR.

*This position is on-site
Responsibilities:

• Provides stabilization and support for an existing Microsoft Access database application used in daily accounting operations.

• Diagnose issues, implement bug fixes, ensure reliability of daily workflows, and create documentation.

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

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

Required Skills:

• 5 Years - MS Access Development
• 5 Years - Visual Basic for Applications
• 5 Years - ActiveX Data Objects
• 5 Years - MS Access SQL and Query design
• 3 Years - Experience splitting MS Access Databases into Front Ends and Back Ends
• 4 Years - Experience translating the business logic from macros/modules/queries to SQL
• 4 Years - Experience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server
• 4 Years - Experience converting MS Access Forms/ Reports to any Web based application

Desired Skills:

• QuickBase Rapid Application Development Platform

This position is available as a W2 position with a competitive benefits package. DataStaff, Inc. offers medical, dental, and vision coverage options as well as paid vacation, sick, and holiday leave. As many of our opportunities are long-term, we also have a 401k program available for employees after 6 months.