Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Under Development Features: Talent Bank/Pool, VMS, Analytics, Social/API Integration, Company Admin

 Access Database Developer  (973 views)

Little Rock, AR
January 31, 2020

** Direct Client Requirement ****

Title:   Access Database Developer 

Location: Little Rock, AR

Duration: 10 Months

Rate: DOE

Interview Type:  Skype or Phone

Work Status:  Successful applicants must be legally authorized to work in the U.S.

Job Type: C2C,C2H ,W2,

Experience: 6 YEARS

The Arkansas Department of Human Services (DHS) is seeking a  contractor to modify existing Access systems to work with 64-bit Office 365 environment.

This Developer will work with DHS Office of Internet Technology (OIT) to maintain compliance with DHS, State and Federal requirements.

Responsibilities include: Serve as the lead developer for an existing Microsoft Access database/application. Will perform ongoing database and form maintenance, develop future enhancements, and support potential migration to a Commercial-Off-The-Shelf solution. Participates in working groups to refine new requirements, develop and test solutions, and to identify short and long-term product modification strategies.

The successful candidate would be familiar with all aspects of Microsoft Access development including Forms, Visual Basic for Applications (VBA), ActiveX Data Objects, MS Access SQL and Query design, and advanced methods for exporting\importing data in CSV, Text and XML formats. Ability to use and create ODBC connections.

.

Knowledge, Skills, and Abilities Requirements. .

•Significant experience (5-7 years) in the design, development, and documentation of MS Access-based applications.

•Split MS Access Databases into Front Ends and Back Ends for multi user functionality. Back Ends (BE) to be converted to SQL tables for security and stability.

•Translating the business logic from macros/modules/queries to SQL and other programming language so that the GUI can work flawlessly.

•Strong in SQL Server with writing stored procedures, pl/sql  and migration of tables from MS Access to SQL Server.

•Converting MS Access Forms/ Reports to any Web based application.

•Database design, implementation, and documentation.

•Able to work independently to achieve outcomes in an expedient and professional manner

•Flexibility and positive attitude.

•Exception oral, written and interpersonal communication skills

•Knowledge of SharePoint and SharePoint development would be a plus.

Required / Desired Skills

MS Access Development

Required 5 Years

Visual Basic for Applications

Required 5 Years

ActiveX Data Objects

Required 5 Years

MS Access SQL and Query design

Required 5 Years

Experience splitting MS Access Databases into Front Ends and Back Ends

Required 3 Years

Experience translating the business logic from macros/modules/queries to SQL

Required 4 Years

Experience writing stored procedures, pl/sql and migrating tables from MS Access to SQL Server

Required 4 Years

Experience converting MS Access Forms/ Reports to any Web based application

Required 4Years

Experience with SharePoint and SharePoint development

Highly desired

  QuickBase Rapid Application Development Platform

Highly desired

Thanks

Siva

siva@sohanit.com

PH:402-241-9606

Apply here or Please send to resumes@sohanit.com

Position Keywords: Query design , XML formats , ODBC , MS Access , Visual Basic , Data Objects , SQL Server , SQL , queries , modules , MS Access SQL , SharePoint

Pay Rate: DOE

Job Duration: 12 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: 620245

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox