Role Overview
We are seeking a skilled and communicative MS Access Database Developer to modernize and optimize a critical legacy system. In this role, you will analyze our existing database architecture, redesign and normalize tables, and improve overall system performance.
Because this system directly supports our day-to-day operations, you will work closely with end-users to understand their pain points, gather requirements, and translate them into technical solutions. Excellent written and verbal communication skills are absolute non-negotiables for this position.
Schedule, Hours & Remote Work
Location:100% Fully Remote
Core Hours: Monday through Friday, 8:00 AM 11:00 AM Mountain Time (MT). Attendance during this specific window is required for remote team alignment, live video/audio calls, and user collaboration.
Flexible Hours: The remaining hours can be worked at your convenience from your home office.
Weekly Commitment: Minimum of 20 hours per week, with the potential to scale up to 40 hours per week depending on project load.
Key Responsibilities
Database Restructuring: Evaluate the architecture of an existing legacy MS Access database; redesign and update tables, relationships, and queries to improve efficiency and data integrity.
Remote User Collaboration: Interface directly with non-technical end-users via video calls, chat, and email to troubleshoot issues, gather feedback, and define system requirements.
Optimization & Maintenance: Refactor legacy VBA code, optimize complex SQL queries, and build user-friendly forms and reports.
Migration Readiness: Ensure data cleanliness and structured architecture to help pave the way for potential future migrations to SQL Server or cloud platforms.
Documentation: Create clear, concise documentation for the updated database schema, user workflows, and technical updates.
Qualifications & Skills Technical Requirements:
Advanced MS Access Expertise: Deep understanding of MS Access (forms, reports, macros, and advanced query design).
Database Architecture: Strong experience in relational database design, data normalization, and indexing.
VBA & SQL: Proficiency in writing/debugging Visual Basic for Applications (VBA) and structured SQL queries within Access.
Legacy Systems: Proven experience auditing, refactoring, and updating older, messy database structures without disrupting current operations.
Soft Skills & Remote Work Basics:
Communication: Exceptional verbal and written English communication skills. You must be able to explain technical concepts simply to end-users and collaborate smoothly across digital channels.
Remote Independence: High self-motivation and a reliable, quiet home office setup with high-speed internet.
Problem-Solving: Strong analytical mindset with a knack for reverse-engineering legacy systems.
Self-Management: Highly organized and disciplined enough to manage a split/flexible schedule effectively without direct supervision.
Numbers & Facts
Location
Arvada, CO (Remote)
Skills
Analysis Skillsunmatched
Auditingunmatched
Broadbandunmatched
Cloud Computingunmatched
Communication Skillsunmatched
Data Qualityunmatched
Database Analysisunmatched
Database Architectureunmatched
Database Designunmatched
Database Programmingunmatched
Database Technologyunmatched
Debugging Skillsunmatched
Documentationunmatched
English Languageunmatched
Identify Issuesunmatched
Microsoft Access Databaseunmatched
Microsoft SQL Serverunmatched
Microsoft Visual Basic for Applications (VBA)unmatched
Organizational Skillsunmatched
Performance Managementunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Query Optimizationunmatched
Refactoringunmatched
Relational Databases (RDBMS)unmatched
Requirements Managementunmatched
Reverse Engineeringunmatched
SQL (Structured Query Language)unmatched
Schedule Developmentunmatched
System Migrationunmatched
Video Chatunmatched
Work From Homeunmatched
Writing Skillsunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.