Description

Maintain and develop database applications using T-SQL and MS Access.

This role is remote.

Responsibilities

• Develop and optimize T-SQL objects including stored procedures, views, triggers, and user-defined functions.
• Manage MS Access 10 (.mdb) applications using Windows Integrated Authentication for SQL Server access.
• Program within MS Access using VBA, DAO via ODBC API, and ADO via OLE DB API.
• Design and maintain reports using MS Access Report Designer.

Required Skills

• 5+ years of relevant database development experience.
• Advanced T-SQL proficiency (Stored Procedures, Views, Triggers, UDF).
• Hands-on experience with MS Access 10 (.mdb).
• Strong VBA programming skills.
• Experience with DAO (using ODBC API) and ADO (using OLE DB API).
• Proficiency with SQL Server integration.
• Experience using MS Access Report Designer.
• Degree in any field of study.

Key Skills

Education

Any Graduate