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.