Looking for person to help with changing large, home-grown, desktop system to use a new database.
Quick Delivery Service, Inc. is a local, well-established delivery company founded in 1983 and located in Schaumburg, IL,. We are currently in the process of converting a 30-year old legacy desktop system to use a new database.
The current system is multi-functional and runs the entire company. It is written in Delphi (Pascal language) and uses FoxPro tables (.dbf). We are changing it to use a mySQL database. Will still be using Delphi platform, version 11 or 12. Programs will stay the same except for database connection (i.e., when conversion is finished screens will look the same to users except where database change has required some change to screen layout).
We are looking for person who can go into programs and make and test the necessary database connection changes. This involves about 25,000-30,000 lines of code.
There is no plan in the foreseeable future to move the system into “the Cloud.” Candidate must be able to work entirely with a large desktop system.
Coding Requirements:
Heavy Delphi experience, version XE6 or later. Must include use of FireDAC data manipulation components in a desktop environment. On the simplest level, what is required is to go into a program and change every interaction with a .dbf table (add, update, delete records) to an interaction with a myQSL table. On a practical level it usually involves more than that.
- Need to be able to work with and communicate with 3 other IT team members
- Need to be able to interface with end-users as they test your changes
- Need to be able to resolve bugs that arise in the course of converting
- Need to know where to look to find an answer to a problem if if something new arises
- Need to be able to follow coding standards which will be given to you
Database Requirements
Experience with any flavor of an SQL database is acceptable although mySQL is preferred. You will be expected to learn Oracle mySQL and mySQL Workbench if your experience is with a different flavor of SQL.
- Need to know design of SQL database and tables
- Need to know SQL data types and what type to use where
- Need to have in-depth knowledge of SQL queries, including the more complicated aspects and how to use them (JOINS, etc)
- Need to know the different ways SQL/FireDAC can arrive at the same result and pick the best and most efficient way for a given situation
Logistical Requirements
Candidate will be expected to be able to come to the office at least 20 hours a week for the first 6-8 weeks to learn our system, learn Delphi and/or mySQL if necessary, get trained in standards, get comfortable working with the rest of the team, etc. Candidate may be able to work remotely in the future depending on exact duties and our ability to accommodate.
We estimate the part of the project we are hiring for to last 6-8 months. Continuation of working relationship will be reevaluated upon completion.
Compensation for this position is currently commensurate with assigned duties and scale of role within project.
To be considered for this position, please apply to this posting directly via Indeed or email qdprogjob@gmail.com.
Thank you for your interest.
Job Type: Contract
Pay: Up to $58.00 per hour
Expected hours: 20 – 40 per week
Compensation package:
- 1099 contract
- Weekly pay
Schedule:
- 4 hour shift
- Choose your own hours
Application Question(s):
- Do you have experience working with large desktop systems?
- Please list any coding languages you have previously worked with, if not listed in resume.
- Please list any coding platforms you have previously worked with, if not listed in resume.
Experience:
- Delphi: 1 year (Required)
Ability to Commute:
- Schaumburg, IL 60193 (Required)
Work Location: In person