> Markdown version of [/jobs/ext/587159-microsoft-access-database-developer](https://www.wearedevelopers.com/jobs/ext/587159-microsoft-access-database-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Microsoft Access Database Developer

- **Company:** Raye IT Consulting LLC
- **Location:** Kansas City, MO, United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Microsoft Access, Microsoft Excel, Amazon Web Services, Cloud Database, Software Documentation, CompTIA Security+, Cyber Security, Information Technology Consulting, Databases, Data Validation, Data Integrity, Extract Transform Load (ETL), Database Applications, Database Design, Database Development, Database Queries, Identity and Access Management, Windows Communication Foundation, MariaDB, Microsoft Office, MySQL, Open Database Connectivity, Performance Tuning, Pivot Tables, Query Optimization, DataOps, Requirements Management, Microsoft SharePoint, Software Engineering, SQL Stored Procedures, Systems Integration, Web Content Accessibility Guidelines, 64bit, Macros, Backend, Vba Programming Language, Data Management, Front End Software Development
- **Published:** June 17, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=59141ea7b762f9e7

## About the Role

Do you have experience in VBA?, Prior experience supporting the USDA FPAC Business Operations Branch (BOB) Financial Management Tool (BOB FMT) or equivalent federal agency financial management database system

 * Familiarity with FPAC's multi-agency shared-cost IT budget model spanning FSA, NRCS, RMA, and FPAC-BC
 * Experience integrating MS Access applications with AWS-hosted cloud databases using Oracle MySQL ODBC driver (v8.0.x or higher)
 * Knowledge of USDA IT security and privacy policies, including FISMA compliance, NIST SP 800-53, and federal system Authority to Operate (ATO) requirements as they apply to database development
 * Experience with the USDA AgMAX capital planning tool and data loading processes for CPIC reporting
 * Familiarity with federal IT financial terminology including obligations, accruals, commitments, spend plans, Working Capital Fund (WCF), and inter-agency agreement (IAA) structures
 * Section 508 / WCAG 2.0 compliance awareness for database-integrated application development
 * CompTIA Security+, Microsoft Certified: Data Analyst Associate, or equivalent certification, * 8+ years of hands-on MS Access development experience, including forms, queries, macros, VBA automation, and table architecture in an Office 365 (64-bit) environment
 * Demonstrated expertise with MariaDB or MySQL, including database design, query optimization, stored procedures, and ODBC integration with MS Access front-end applications
 * Strong SQL skills; experience writing complex queries for reporting, data validation, and bulk data operations across large, multi-year datasets
 * Experience building and maintaining MS Excel reporting solutions using Pivot Tables with live ODBC connections to database back-ends
 * Proven ability to manage the full development lifecycle of a database application - from requirements gathering and design through testing, deployment, documentation, and ongoing support
 * Experience supporting federal IT financial data systems, including budget execution, obligations tracking, inter-agency agreement management, or similar financial workflows
 * Strong written communication skills; ability to produce clear technical documentation and present findings to both technical and non-technical federal stakeholders
 * Experience with SharePoint as a document repository and file distribution platform
 * U.S. Citizenship required; ability to obtain and maintain a federal Public Trust clearance and HSPD-12 credentials
 * Ability to complete mandatory federal training requirements, including annual Information Security Awareness Training (ISAT)

Desired/ Highly Preferred:

 * Prior experience supporting the USDA FPAC Business Operations Branch (BOB) Financial Management Tool (BOB FMT) or equivalent federal agency financial management database system
 * Familiarity with FPAC's multi-agency shared-cost IT budget model spanning FSA, NRCS, RMA, and FPAC-BC
 * Experience integrating MS Access applications with AWS-hosted cloud databases using Oracle MySQL ODBC driver (v8.0.x or higher)
 * Knowledge of USDA IT security and privacy policies, including FISMA compliance, NIST SP 800-53, and federal system Authority to Operate (ATO) requirements as they apply to database development
 * Experience with the USDA AgMAX capital planning tool and data loading processes for CPIC reporting
 * Familiarity with federal IT financial terminology including obligations, accruals, commitments, spend plans, Working Capital Fund (WCF), and inter-agency agreement (IAA) structures
 * Section 508 / WCAG 2.0 compliance awareness for database-integrated application development
 * CompTIA Security+, Microsoft Certified: Data Analyst Associate, or equivalent certification

## Description

Raye IT Consulting is seeking a Senior MS Access Database Developer to serve as the lead technical resource responsible for the maintenance, development, and optimization of a federal client's Financial Management Tool (FMT)., * Lead development and ongoing maintenance of the MS Access front-end application, including forms for data entry and retrieval, queries for reporting and data updates, local reporting tables, and automation of recurring data processes

 * Design and maintain the ODBC connectivity layer between the MS Access front end and the cloud-hosted MariaDB/MySQL backend, ensuring stable, performant communication between application tiers
 * Develop and maintain queries, stored procedures, and data workflows that support budget formulation, spend approvals, funding allotments, vendor and contract management, inter- and intra-agency agreement tracking, and obligation of funds
 * Perform bulk data loads and updates to maintain accurate financial data across multi-year budget cycles containing thousands of rows of plan data, contract records, agency agreements, and fund obligations
 * Build, maintain, and refresh MS Excel-based reports using Pivot Tables connected via ODBC to MS Access front-end queries; ensure daily refresh of standard reports and develop new reports as requirements evolve
 * Document all reporting processes, including data sources, query logic, refresh schedules, and output formats, to ensure continuity and auditability
 * Manage version and environment control for the MS Access file, ensuring changes are tracked, tested, and deployed in a controlled manner across the user community
 * Perform ongoing performance tuning, error resolution, and data integrity monitoring; respond to user-reported issues and proactively identify system anomalies
 * Maintain role-based access management across the user base; ensure appropriate permissions are assigned, documented, and audited
 * Store and distribute the MS Access file, Excel reports, and user documentation via a SharePoint site; maintain organized and accessible repositories for all tool-related materials
 * Produce and maintain technical documentation for all forms, queries, tables, automation processes, and data management procedures
 * Support requirements management by translating stakeholder needs into technical specifications and implementing changes in alignment with governance and budget timelines
 * Conduct new technology research to identify opportunities to improve tool performance, scalability, or functionality within the federal IT environment


## Related Videos

- [30 powerful AWS hacks in just 30 minutes: Boost your developer productivity](https://www.wearedevelopers.com/videos/1624-30-powerful-aws-hacks-in-just-30-minutes-boost-your-developer-productivity)
- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [RPA in the Public Sector](https://www.wearedevelopers.com/videos/86-rpa-in-the-public-sector)
- [Modularity: Let's dig deeper](https://www.wearedevelopers.com/videos/1200-modularity-let-s-dig-deeper)
- [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app)

## Related Articles

- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j)
- [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)