Enterprise Application Developer

Y & L Consulting Inc.

United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Microsoft Access Microsoft Azure Business Software Business Systems Databases Data Governance Data Integration Data Integrity Extract Transform Load (ETL) Data Structures Relational Databases Document Management Systems

+11 more

Microsoft SQL Server Open Database Connectivity Software Engineering SQL Stored Procedures Systems Integration Transact-SQL Enterprise Software Applications Database Optimization Reliability of Systems Vba Programming Language Tools for Reporting

Job description

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

Requirements

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.