Role : SQL Server DBA/Developer Location: Dayton, OH Term: 6months - 1year Interview Mode: Phone or Skype Description: Information directly from the hiring manager:
- We have developers on staff (and some that have left) that have designed, indexed, etc. all our databases, so they aren’t good, but they aren’t bad either.
We need a smart individual with good communication skills and strong SQL Server DBA experience.
SWCE DB Conversions
- MS SQL Server … 2000 / 2003 and up still in use at customer sites
- We are not responsible for maintaining the DBs, customers do that themselves
- We have hundreds of DBs installed at customer sites … and we need to create an automated way to upgrade them to the most recent version of our software
- our biggest problem with this is that the oldest DBs have been customized (or maybe a better way to say is that everyone is a slightly newer version the last)
- today, our answer is to manually convert them as the orders come in (this would instantly be given to them as an assignment)
- Ideally … we would end up having something we could use to take a customer offline for a short period of time and the end result would be a DB ready to run against the newest software … today they have to install a new copy of the DBs and the process takes days or weeks
- These DBs could probably use some optimization, but they are on the way out, and would need someone to figure out how to migrate them to a new architecture
iMed Consent Databases
- MS SQL Server … 2000 / 2003 and up still in use at customer sites
- We are not responsible for maintaining the DBs, customers do that themselves
- We need to find a way to install and populate these DBs easily … today we give the customer a copy of the DB … this is difficult due to the sheer volume of information that needs to be pre-loaded (thousands of rows of data)
- Again, these DBs could use some optimization, but are on the way out, and the need to be figured out
CareWall/PFF
- I know the least about this product and these DBs
- It was designed and built by an offshore team in India and my team is taking it over this year
- This is still in a pilot phase so most likely we will need someone to optimize the DB Thanks. Kevin *Patel* Ph No:- 980-819-0687 E-mail:- kevin@riderconsultinginc.com G-Talk : kevinpatel.rider@gmail.com Web Site :- www.riderconsultinginc.com ...(More..) | 