SQL Server Access Developer

SA TECHNOLOGIES; Minneapolis (MN); On-site; USD 70,000 - 90,000; Full time

Job summary

A leading IT consulting firm located in Minneapolis is looking for a SQL Server Access Developer to work on multiple projects involving database merging and MS Access user interface development. The ideal candidate will have at least 5 years of experience with MS Access and SQL Server, demonstrating strong skills in ADO data exchange and creating tables, views, and procedures. This is a 6-month contract role requiring advanced technical expertise and problem-solving abilities.

Qualifications

• 5 years of experience in MS Access / SQL Server ADO data exchange.
• 5 years of experience in MS Access UI development for SQL Server back end.
• 5 years of experience in developing MS SQL Server Tables, Views, and procedures.

Responsibilities

• Assess and resolve SQL Server/user interface issues.
• Implement the merger of multiple databases into a single database.
• Develop new MS Access user interfaces for the merged database.
• Design and implement a system for tracking enforcement actions.
• Assist in the development of testing plans for all database systems.

Skills

MS Access / SQL Server ADO data exchange

MS Access UI development for SQL Server back end

Develop MS SQL Server Tables, Views, procedures

Job description

SA Technologies Inc. (www.satincorp.com) is a market leader and one of the fastest growing IT consulting firms with operations in US, Canada, Mexico & India. SAT is an Oracle Gold Partner, SAP Services Partner & IBM Certified enterprise.

All SA Technologies requirements are Direct Client Requirements from IT Hiring Managers. We guarantee you the best rate for your skills and performance.

Job Description

Position: SQL Server Access Developer

Location: Minneapolis, MN

Duration: 6 Months +

Engagement Description:

Task One. In a MS SQL Server 2014 environment with MS Access 2007 as the front end, assess and resolve specific SQL Server / user interface issues as directed by the agency.

Task Two: Implement the merger of multiple databases with similar, but not identical structures into a single database. The successor database has been designed and created. The merger will require development of SQL queries, views, and procedures and MS Access code.

Task Three: Develop new MS Access user interfaces into the merged database to replace legacy interfaces. Requires a high degree ofexperience in MS Access and Access VBA.

Task Four: Design, develop, test, and implement a system for tracking enforcement actions in all programs. This project will require the contractor to designdatabase changes, add tables and fields to implement violation tracking. This will include the design of data structures for the storage of for PDF documents that constitute the enforcement record with links to the record fr0m the primary agency database. The project will also require the design and development of additional features and functionality, including a user interface using MS Access 2007 forthe input and editing of enforcement data.

Task Five: Assist in the development and implementation of testing plans for all database systems. For all tasks, support by Board staff will be provided to aid in understanding the design and implementation of the current databases.

MUST HAVE SKILLS:

MS Access / SQL Server ADO data exchange- 5 years

MS Access UI development for SQL Server back end - 5 years

Develop MS SQL Server Tables, Views, procedures - 5 years

Additional Information

All your information will be kept confidential according to EEO guidelines.