
Senior Enterprise Application Developer to support, enhance, and modernize a portfolio of mission-critical business applications. This role is responsible for maintaining a suite of integrated Microsoft Access/VBA applications supported by SQL Server databases and an enterprise-wide normalized data model. The ideal candidate combines application development expertise, database architecture knowledge, business systems analysis, and production support experience. This individual will play a key role in ensuring system reliability while helping guide future modernization initiatives. Key Responsibilities:
Maintain, troubleshoot, and enhance a portfolio of integrated Microsoft Access/VBA applications.
Design, develop, and optimize SQL Server databases, tables, views, stored procedures, and queries.
Perform cross-application and cross-database impact analysis for system enhancements and changes.
Develop and maintain enterprise data models, ensuring data integrity and consistency across systems.
Support data imports, exports, reporting solutions, and workflow automation processes.
Investigate and resolve production issues, data quality concerns, and application defects.
Document system architecture, data structures, and application dependencies.
Identify opportunities for process improvements and legacy system modernization.
Ensure adherence to data governance, security, and best practices. Required Skills:
10 years of experience developing and supporting Microsoft Access applications using VBA.
10 years of experience with Microsoft SQL Server.
Experience integrating Microsoft Access solutions with enterprise SQL Server environments.
Strong expertise in T-SQL, stored procedures, views, triggers, and database performance tuning.
Knowledge of ETL processes, data integration, and reporting solutions.
Extensive experience with relational database design and normalized data models.
Hands-on experience with ADO, DAO, and ODBC connectivity.
Strong troubleshooting and production support experience.