Analysis Skills, Broadband, Cloud Computing, Communication Skills, Data Quality, Database Analysis, Database Architecture, Database Design, Database Programming, Database Technology, Documentation, English Language, Identify Issues, Microsoft Access Database, Microsoft SQL Server, Microsoft Visual Basic for Applications (VBA), Organizational Skills, Performance Management, Presentation/Verbal Skills, Problem Solving Skills, Query Optimization, Refactoring, Relational Databases (RDBMS), Requirements Management, Reverse Engineering, SQL (Structured Query Language), Schedule Development, System Migration, Video Chat, Work From Home, Writing Skills
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.
P
PRI India IT Services Pvt Ltd