Connecting Technologies, People, and Processes
Access Database Developer
Location
United States
Posted
14 days ago
Salary
0
Seniority
Lead
Job Description
Access Database Developer
Raye IT Consulting
• 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
Job Requirements
- 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)
Benefits
- 401(k)
- 401(k) matching
- Health Insurance
- Dental Insurance
- Disability Insurance
- Flexible Spending Account (FSA)
- Life Insurance
- Paid Time Off
Related Guides
Related Job Pages
More Backend Engineer Jobs
• Estamos buscando desarrolladores con experiencia en Java (Jr y Sr) para sumarse a nuestro equipo en un proyecto para importante empresa estatal en Uruguay. • Este rol requiere una fuerte capacidad técnica y la habilidad para trabajar en un entorno ágil y dinámico. • La modalidad de trabajo es **Remoto**, con disponibilidad para reuniones presenciales en las oficinas de Montevideo.
Senior Software Engineer, Java
SoftExpert - Software for ExcellenceSoftware all-in-one para gestão da transformação digital, inovação e conformidade.
• Design, develop, and maintain robust, scalable, and secure integration solutions in Java • Define and review integration architectures (synchronous and asynchronous), communication patterns, and service contracts • Serve as the team's technical reference, guiding development best practices, code reviews, and design decisions • Lead technical refinement of requirements and break down complex solutions into viable deliverables • Support the team's technical development and growth through mentoring and pairing • Ensure delivery quality through automated testing, observability, and proper failure handling
Senior Laravel Developer
BnBerryEasy-to-use solutions to help increase your hotel’s revenues, bookings and guest satisfaction
* Design, develop, and maintain high-performance backend services using Laravel 10+. * Architect and implement scalable solutions following modern software engineering best practices. * Develop and optimize complex database structures and queries in MySQL. * Build and maintain containerized environments using Docker and deploy applications on Kubernetes. * Integrate and leverage AI-powered tools and technologies to improve development workflows and product capabilities. * Write clean, maintainable, and well-tested code. * Participate in architecture discussions, code reviews, and technical decision-making. * Collaborate with a remote international team in an Agile environment. * Ensure application reliability, security, and performance.
Fullstack Developer, Java/Kotlin, React.js, Specialist I
Grupo BoticárioCriamos oportunidades para a beleza transformar a vida das pessoas, e assim transformar o mundo ao nosso redor.
• You will join the team responsible for Grupo Boticário's Logistics Platform, supporting and evolving systems that manage millions of orders. • We are looking for a profile proficient in the Java/Kotlin/React ecosystem who has already integrated AI tools (such as GitHub Copilot, Cursor, or ChatGPT) into their workflow to accelerate code writing, test creation, and documentation, without sacrificing technical rigor and critical analysis. • Work with modern back-end and front-end frameworks, and develop/evolve backend applications in Java/Kotlin with Spring Boot, operating in both synchronous and asynchronous architectures; • Design and implement solutions aligned with the product architecture, contributing to the technical evolution of the systems; • Work with technical autonomy to resolve complex problems and define implementation approaches; • Ensure software quality through unit tests, development best practices, and code reviews; • Investigate and resolve performance, stability, and incident issues in distributed environments; • Conduct root cause analyses and contribute to continuous improvements in monitoring and service reliability; • Actively participate in technical and functional refinements, assessing risks and proposing solutions; • Collaborate with the team through code reviews, pair programming, and knowledge sharing, and support less-experienced developers in adopting best practices and development patterns; • Contribute to building secure, resilient, and scalable systems, and investigate and resolve complex technical issues in distributed cloud applications; • Monitor and remediate vulnerabilities, ensuring compliance with security standards; • Use AI development tools as productivity aids while maintaining critical review of the solutions they generate.
