VBA Developer

Job Title: vBA Developer

Job Description

We are seeking a Visual Basic / VBA Developer to support and enhance a set of business-critical legacy applications built on Microsoft Access with Visual Basic code, integrated with SQL Server and other legacy databases. The role primarily focuses on maintenance, stability, and incremental improvement, aiming for pragmatic modernization over time. This is a hands-on role ideal for someone comfortable working with older technology stacks while bringing a modernization mindset to reduce risk and technical debt.

Responsibilities

• Support and maintain legacy Microsoft Access applications written in Visual Basic / VBA.
• Troubleshoot, fix, and enhance existing VBA code, forms, and reports.
• Manage and optimize ODBC connections to SQL Server and other legacy databases, such as Progress.
• Work with business users to resolve defects, implement small enhancements, and improve usability.
• Provide Business As Usual (BAU) support for applications accessed via RDP in a data-centre-hosted environment.
• Document application logic, dependencies, and risks to improve knowledge retention.
• Identify opportunities for low-risk modernization, such as refactoring and data access improvements.

Essential Skills

• Strong experience with Visual Basic / VBA.
• Hands-on development experience with older versions of Microsoft Access.
• Solid working knowledge of SQL Server, including queries, stored procedures, and schema understanding.
• experience using ODBC to connect applications to external databases.
• Comfortable supporting legacy systems in production environments.
• Strong troubleshooting and problem-solving skills.

Additional Skills & Qualifications

• experience with SQL, Oracle, and Visual Basic.

Work Environment

You will be working in a data-centre-hosted environment, accessing applications via RDP. The position involves maintaining and modernizing older technology stacks, offering a unique opportunity to innovate within a legacy system framework.

Brockworth, UK

400.00 - 450.00 GBP Daily

Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. (phone number removed). Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at (url removed)>

To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go to (url removed)>

We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice at (url removed)/en-gb/privacy-notices for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. If you are resident in the UK, EEA or Switzerland, we will process any access request you make in accordance with our commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.