Senior Enterprise Application Developer
Y & L Consulting Inc.
Dice Job Match Score™
👾 Reticulating splines...
Job Details
Skills
- ADO
- Application Development
- Business Analysis
- DAO
- Data Governance
- Data Integration
- Data Integrity
- Data Modeling
- Data Quality
- Data Structure
- Database
- Database Architecture
- Database Design
- Database Performance Tuning
- Enterprise Software
- Extract
- Transform
- Load
- Impact Analysis
- Legacy Systems
- Microsoft Access
- Microsoft SQL Server
- ODBC
- Process Improvement
- Systems Architecture
- Production Support
- Reliability Engineering
- Software Design
- Stored Procedures
- Technical Support
- Transact-SQL
- VBA
- Reporting
- Workflow
Summary
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.
- Dice Id: ylcon
- Position Id: 8992243
- Posted 2 hours ago
Company Info
About Y & L Consulting Inc.
Y&L Consulting is a provider of the highest-caliber local and international IT professionals, positioned to help you maximize profitability and growth.
As a global corporation with local presence and sensitivity, Y&L offers IT services and support primarily to medium and large companies. Knowledgeable and proficient in all primary technologies, we customize programs to fit your current business needs while maintaining the flexibility to ramp up or down as your situations change. By avoiding stringent service provider contracts and rigid methodologies, you enjoy flexible capabilities, local relationships, international resources, and significant cost savings.
IT Consulting San Antonio Expertise
Design, architecture, development, and maintenance of custom applications using ATG, MS, .NET, Java/J2EE, and other popular technologies
Implementation, upgrade, and maintenance for packaged application solutions SAP, PeopleSoft, Oracle Apps, Cognos, and Actuate
Quality Assurance and Testing Services Mercury partner
Programmers and Database Administrators
In addition, we have a number of highly-qualified Project Managers, Business Analysts, and Technical Writers on our bench.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs