Description:The client is seeking a contractor to stabilize the current production Access/SQL system and create documentation so daily operations can continue reliably.This Developer will work with client to maintain compliance with the client 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 ExperienceMS Access Development - Required - 5 YearsVisual Basic for Applications - Required - 5 YearsActiveX Data Objects - Required - 5 YearsMS Access SQL and Query design - Required - 5 YearsExperience splitting MS Access Databases into Front Ends and Back Ends - Required - 3 YearsExperience translating the business logic from macros/modules/queries to SQL - Required - 4 YearsExperience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server - Required - 4 YearsExperience converting MS Access Forms/ Reports to any Web based application - Required - 4 YearsQuickBase Rapid Application Development Platform - Highly desired Notes:Onsite VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status
Description:The client is seeking a contractor to stabilize the current production Access/SQL system and create documentation so daily operations can continue reliably.This Developer will work with client to maintain compliance with the client 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 ExperienceMS Access Development - Required - 5 YearsVisual Basic for Applications - Required - 5 YearsActiveX Data Objects - Required - 5 YearsMS Access SQL and Query design - Required - 5 YearsExperience splitting MS Access Databases into Front Ends and Back Ends - Required - 3 YearsExperience translating the business logic from macros/modules/queries to SQL - Required - 4 YearsExperience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server - Required - 4 YearsExperience converting MS Access Forms/ Reports to any Web based application - Required - 4 YearsQuickBase Rapid Application Development Platform - Highly desired
Notes:Onsite
(Please ensure email matches your resume email)
(document types allowed: doc/docx/rtf/pdf/txt) (max 2MB)
By submitting this form, you are consenting to the VIVA team contacting you via Phone/Email