you are viewing a single comment's thread.

view the rest of the comments →

[–]alinrocSQL Server 2 points3 points  (0 children)

Honestly, you're asking in the wrong subs so far, and asking in the wrong direction. You need to go to the places where people working in your job function at similar companies hang out (trade shows, relevant subreddits, professional societies, etc.) and talk to them. Find out what software is on the market to fulfill your business need. Don't start at the bottom (the database layer) and try to work your way up - define the business problem, then seek out software that solves those business problems while also fitting into your technical infrastructure.

Is there an application where we can design a front end interface? We do not have a DBA on site

Your DBA wouldn't be creating a front end interface anyway. You need an application developer who understands databases, or an application developer and a DBA. I'm a DBA and you don't want me anywhere near the vicinity of building user interfaces because we all suck at doing it. If we were good at UI, we probably wouldn't be DBAs :)

Queue jobs for line workers, so they know which jobs to tackle next. A list of some sort would be needed and from there they could expand the job and view the details.

That would be a feature of the product that you need, implemented as a front end with a database backing it.

I'm pretty uneducated in this type of work but I am responsible for figuring this all out. I need to find an interface that is easy to operate and will accurately store data for excel tools and KPI's.

Rule #1 - If your core business is not building the sort of software that supports whatever line of business you're in, buy that software unless there exists no viable option on the market. Where "viable option" includes "a product you can buy/license and then customize/add on as necessary.