Position Details
Sql Database Developer Apply
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.
