Paktolus - MS Access Developer - VBA Scripting

Job Title : MS Access Developer

Experience : Min 7-15 years (Below 7 years experienced candidates please refrain from applying)

Location : Permanent remote

Notice period : Immediate joiners only (Max 7 days)

Note : Proficiency in English communication is crucial

Mandatory Skills :

- Access Forms

- .NET

- VBA

- SQL

- SSRS/Crystal Reports

- Git

Job Summary :

We are seeking an experienced MS Access Developer with strong expertise in building and maintaining Access forms, VBA scripting, and database development. The ideal candidate should be proficient in SQL and SSRS for report development and have a solid understanding of data flow and integration across systems.

Key Responsibilities :

- Utilize VBA (Visual Basic for Applications) to automate tasks and enhance user interaction.

- Create and manage relational database structures within Access or linked to SQL Server.

- Develop custom solutions based on business requirements and ensure efficient data handling.

- Design and implement SSRS reports, pulling data from MS Access or SQL Server databases.

- Troubleshoot and resolve issues related to Access applications and database performance.

- Collaborate with stakeholders and cross-functional teams to gather requirements and deliver user-friendly solutions.

- Ensure documentation and version control of all database and code changes.

Required Skills :

- Proficient in VBA (Visual Basic for Applications) for scripting and automation

- Expertise in SQL, including complex queries and database management

- Experience with SSRS (SQL Server Reporting Services) report design and deployment

- Good understanding of database normalization and relational database principles

- Excellent problem-solving and communication skills

Preferred Skills (Nice to Have) :

- Exposure to other reporting tools or BI platforms

- Basic knowledge of Access-to-SQL Server migration strategies

Education :