I am an IT director for a company that heavily relies on several online database applications. These applications were made by outside consultant firm, and certain issues came up, and I am trying to bring them in house.
Even though I have designed, created, and maintained several database systems in my past jobs, I do not have any experience in creating online database application that gets very heavy traffic, and I wanted to ask for your expertise.
I do not plan to port the existing applications, as they are written in older language, and exist on older technology. I want to start brand new.
Obviously, I need to hire some workers to work with me, because I would like to keep development and maintenance in house, but I am considering data hosting company that specializes in cluster or VM technology to ensure no downtime. (almost none, anyway)
Here are my questions:
1. What is the recommended platform/language? I am versed in MySQL, VBA, Java, C++, but that doesn't really matter, because I can always learn, and I will hire someone that is already comfortable with that language and platform.
2. Can you give me some pointers to how to find a good data hosting company that supports 24/7 solution?
3. Given a database schema, am I reasonable to assume that this is an undertaking that I will manage, or because of my lack of experience with online database application development, I should hire an expert just for that? Of course, with budget in mind, I am not able to freely hire the best candidate for all of the components.
I know I am quite vague in my questions, but I see this problem as a big, nebulous cloud of potential problems, that I really need to tackle, so any advise is appreciated.