VBA/MS Access/SQL Server Programmer

Job Title: VBA/MS Access/SQL Server Programmer

Location: Remote

Type: 6+Month contract

Job Description:
• Responsible for working with the current development team to support and upgrade the current portfolio of critical agency applications with the potential to transition into the development leadership role.
• Work closely with the current agency development team to update the portfolio of applications from the MS Access project file format (ADP) to MS Access database file(ACCDB) and from MS SQL Server 2008 to MS SQL Server 2016 or higher.
• Contribute to the determination of the future technical path for the agency application portfolio.
• Help maintain best practices for documentation and code management.
• Work closely with our internal developers and service providers to ensure the applications are stable and reliable. Work to provide our customers with the best transformation experience possible.
• Strong technical skills in MS Access and MS SQL Server based application development and support, to include end user support of applications.
• Skills in developing complex VBA scripts.
• Strong communication and collaboration with both IT peers and agency personnel of varying levels of technical knowledge.
• Previous experience supporting application database migrations involving MS Access and MS SQL Server Previous experience developing VBA application scripts
• Strong understanding of test processes especially user acceptance testing
• Hands on experience migrating from legacy database applications for both on premise and cloud environments

Required Skills
• Database and database application upgrade and support experience - front-end applications and back-end support
• Database and database application upgrade and support experience - front-end applications and back-end support
• Experience developing and supporting MS Access Applications, MS Access Database (ACCDB), MS Access ADP
• Experience with MS SQL Server development (TSQL)
• Experience with MS SQL Server administration
• Visual Basic for Applications (VBA) - Experience developing complex VBA scripts.
• Exceptional communication is required as resource will collaborate with both IT peers and agency personnel of varying levels of technical knowledge.

Desired Skills

Salesforce PSS, Apex, SharePoint, Power BI, PowerApps