Nigel Wright are working exclusively with a national company whose HQ is located in Newcastle. They are looking to hire an experienced SQL DBA and an Oracle DBA to work on a large in house project.
- 12 Month FTC
- Newcastle location
- SQL DBA
They currently have an Oracle data warehouse and a multitude of legacy data bases and marts, the current data marts they set up were poorly built a long time ago they require each one to be evaluated and potentially re-built. You will work with the current reporting team to ensure the data they require is in the right place at the right time. Things they know which are wrong, none of the marts are indexed so performance is very slow, each night the entire database is copied and the mart re-created which can take between 6-8 hours every night and any minor error can cause failure which sometimes results in a full day without some of the reporting.
Some of the legacy systems are progress data bases some are SQL databases and they also have the Oracle database and warehouse. The end goal is to have all the data in one place, the evening runs should only bring in new data or changes to data, the data needs to be structured and indexed for more efficient queries, as the client does not have an expert onsite they want you to advise the on the best course of action.
We are looking to interview next week so suitable candidates will be contacted within 24 hours.