Access/SQL Database Developer (LOCAL)

Overview

On Site
$40 - $40
Contract - Independent
Contract - W2

Skills

MSAccessDevelopment
VisualBasic
ActiveXDataObjectS
MSAccessSQL
Querydesign
FrontEndsandBackEnds
SQL
web-basedapplication

Job Details

Required Skills:
MS Access Development (5 Years)
Visual Basic for Applications (5 Years)
ActiveX Data Objects (5 Years)
MS Access SQL and Query design (5 Years)
Experience splitting MS Access Databases into Front Ends and Back Ends (3 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 (4 Years)
Desired Skills:
QuickBase Rapid Application Development Platform

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 the reliability of daily workflows, and create documentation
Job Responsibilities:
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 in 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

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.