Senior Microsoft Access / SQL Server / VBA Developer

Urgent

Required Skills

SQL (5)Microsoft Access (4)

Additional Skills

Visual Basic for Applications (VBA) (2)

Job Description

We are seeking a highly skilled and experienced Senior MS Access Developer to join our team. The ideal candidate will have extensive expertise in developing and maintaining MS Access applications, with a strong focus on VBA programming and ADO (ActiveX Data Objects) for data access. 

This role requires proficiency in optimizing database performance, particularly in migrating data from Access backend to SQL Server and enhancing forms and reports for efficient data retrieval.

Key Responsibilities:

  • Develop, enhance, and maintain MS Access applications, including forms and reports, utilizing advanced VBA programming techniques.
  • Perform data migration from Access backend to SQL Server, ensuring seamless integration and optimal performance.
  • Optimize database performance by writing efficient SQL queries, utilizing SQL Server views, and implementing stored procedures where necessary.
  • Inherit and modernize legacy applications, some dating back to 1995, while also contributing to the development of new applications from scratch.
  • Collaborate with cross-functional teams to gather requirements, design solutions, and deliver high-quality software products.
  • Provide technical leadership and mentorship to junior developers, sharing best practices and guiding them in adopting efficient development methodologies.
  • Stay updated on industry trends and emerging technologies related to MS Access, SQL Server, and database development, and propose innovative solutions to enhance our systems.

Qualifications

  • Bachelor's degree in Computer Science, Engineering, or related field.

  • Strong professional experience as an MS Access Developer, with a focus on VBA programming, DAO and ADO.

  • Proficiency in SQL Server database development, including data migration, optimization, and stored procedures.

  • Strong analytical and problem-solving skills, with the ability to troubleshoot complex issues and propose effective solutions.

  • Experience in inheriting and modernizing legacy applications, while also developing new applications from scratch.

  • Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.

  • Proven track record of delivering high-quality software products on time and within budget.

Additional Information

This role ONLY considers Senior and up level of experience. Basis for Senior experience are written under Key Responsibilities of the JD. 

Benefits

A great talent deserves even greater compensation. CoDev provides several benefits that you can enjoy as soon as you join our growing team. We take pride in delighting you with what you deserve.