Database Technician

Job description / Role

Imperial College London (ICL) and Qatar Foundation (QF) formed a joint venture to design and develop Qatar Biobank (QBB). The Pilot Phase is complete and ICL is in the process of handing over to QBB.

One significant aspect of this handover is the transfer of Participant data collected during the Pilot Phase from the ICL database to a new data base being developed by QBB.

To assist and facilitate in this data transfer ICL wish to appoint a person on a temporary basis (3 to 4 months) to work with the ICL Team and the QBB team.

This is a ‘hands-on’ role; the appointee will be expected to extract the data from the ICL database, transform the data sets to suit the new data base and help load the data into the new database. This is not a role where the appointee will be managing others.

The ICL database is an SQL Server database, the new database is MySQL.

Requirements

- A bachelor’s degree or professional/vocational equivalent in computer science or information technology.
- Microsoft / Oracle Database certification is desirable.
- Excellent spoken and written English.
- 3+years of experience in the design, development and testing of client-server or web based database systems.
- Understanding of 'relational database management systems' (RDBMS), 'object oriented database management systems' (OODBMS) and XML database management systems.
- Development skills: solid SQL Server and PL/SQL or T-SQL coding techniques; ability to create and maintain tables, constraints, triggers, views, stored procedures and functions, packages, and types;
- Extensive and strong understanding of SQL tuning practices and indexing and partitioning strategies.
- Familiar with best practice in regard to Data Architecture, Data Modeling, Database Design etc
- Experience in Extract - Transfer - Load.
- Experience in Data Warehousing and Business Intelligence
- Experience with modeling tools such as: Visio, ERWIN, Oracle SQL Developer etc.
- Knowledge of SSIS
- Experience in data integration projects and data migration projects.

Advantageous experience/knowledge:
- Java/J2EE development experience, and experience in ‘R’
- Proficiency in OR mapping tools such as Hibernate/iBatis
- Experience in creating scripts, testing in QA and implementing large data updates into production databases.
- Experience of archive recovery

About the Company

Imperial College London is a science-based university with an international reputation for excellence in teaching and research.

Consistently rated amongst the world's best universities, Imperial is committed to developing the next generation of researchers, scientists and academics through collaboration across disciplines.

Located in the heart of London, Imperial is a multidisciplinary space for education, research, translation and commercialisation, harnessing science and innovation to tackle global challenges.