remote
Sr. MS Access Database Developer - Lead Contingent - Aretum
Software Engineer
Lead Senior MS Access Database Developer responsible for designing, optimizing, and maintaining complex Access solutions for defense and homeland security clients, leveraging SQL, VBA, and advanced database design techniques.
About the role
Key Responsibilities
- Lead the design, development, and deployment of large‑scale MS Access databases, ensuring scalability and reliability for mission‑critical applications.
- Write and maintain complex SQL queries, stored procedures, and VBA code to automate data workflows and enhance user functionality.
- Perform performance tuning, indexing, and query optimization to achieve sub‑second response times for high‑volume datasets.
- Collaborate with cross‑functional teams to migrate legacy data, integrate with external systems, and implement robust data validation and security controls.
- Document database architecture, data models, and best practices; provide mentorship to junior developers and conduct code reviews.
Requirements
- 10+ years of experience in MS Access development with deep knowledge of SQL Server integration.
- Proficient in VBA, database design, and performance optimization techniques.
- Strong analytical skills and ability to troubleshoot complex data issues.
- Experience working in regulated environments (defense, homeland security) and familiarity with security clearance processes.
- Excellent communication skills and a collaborative mindset.