SQL Database Developer

Overview

On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 7 month(s)

Skills

SQL
PL/SQL
SQL Server
Troubleshoot
VBA
ADO
ActiveX
Bug

Job Details

Location & Work Arrangement

  • Location: Little Rock, Arkansas
  • Work Arrangement: Onsite (Required 5 days a week).
  • Contract: This is a Contract position available for extensions.
  • Mode of Interview: Either Webcam or Onsite/In-person.
  • Candidate Requirement: Candidate must be local Day 1 to start and continue this position.

Key Responsibilities

  • Defect Resolution & Stabilization: Troubleshoot and resolve defects in the existing Access front end and SQL Server back end. Ensure daily operational workflows function consistently and accurately, especially for the accounting system.
  • Documentation & Reverse-Engineering: Create comprehensive documentation covering business logic, database relationships, and application workflows to enable reliable internal support. This involves reverse-engineering and maintaining the existing architecture without redesigning it.
  • Technical Migration Focus: Utilize expertise in VBA, SQL, and ADO (ActiveX Data Objects) to debug existing forms, queries, and modules. Translate business logic from macros/modules/queries to SQL.
  • Support & Knowledge Transfer: Provide crucial knowledge transfer to internal Office of Internet Technology (OIT) staff. Coordinate professionally with business stakeholders to clarify issues and confirm successful resolutions.
  • Compliance: Adhere strictly to change control, documentation, and testing processes to maintain compliance with DHS, State, and Federal requirements.

Required Technical Expertise

Skill Area

Minimum Experience

Key Expertise & Knowledge

MS Access

5 Years

MS Access Development, VBA (Visual Basic for Applications) for forms, queries, and modules.

Data Access

5 Years

ActiveX Data Objects (ADO) and MS Access SQL and Query design.

Database Migration

4 Years

Experience writing Stored Procedures, PL/SQL, and migrating tables from MS Access to SQL Server.

Architecture

3 Years

Experience splitting MS Access Databases into Front Ends and Back Ends.

Legacy/Logic

4 Years

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

Modernization Path

4 Years

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

Highly Desired Skills

  • Understanding of accounting or financial workflow systems.
  • Experience with the QuickBase Rapid Application Development Platform.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Stellar Professionals LLC