Our client has an exciting opportunity for a Database Administrator to join the team based in Hinxton, Cambridge. You will be on a full time permanent contract with a competitive salary of between £37,000 - £42,000 depending on skills and experience.
Our client is a world leading developer of genome-based discovery and diagnostic technologies, providing their Sapientia clinical decision software platform to UK NHS Regional Genetics Services and clinical, research and commercial customers nationally and internationally. They are also a clinical interpretation partner for the UK100K Genomes Project working with Genomics England. Our client’s main office is located at the Wellcome Genome Campus, with the Sanger Institute and the EBI. The entire Campus covers an area of 125 acres and provides those working there with a beautiful environment to enjoy.
They are looking for an enthusiastic, methodical, and analytical individual to join their Development team. The ideal candidate will have experience in Database Administration and Development, and are looking to widen and deepen their understanding of databases handling exponentially growing volumes of genomic data. You will help ensure large volumes of scientific and clinical data are stored appropriately, securely, and quickly accessible in order for our client’s customers, clinical, and innovation teams to gain insights.
Main Responsibilities of their Database Administrator
- Implement database software installations, upgrades, and patches
- Implement backup and recovery policies and procedures
- Monitor database performance and assist the Senior Database Administrator in analysing and optimising database performance and capacity planning
- Create and perform tests to verify the integrity, performance, and scalability of databases
- Maintain database security (create and maintain roles, assign privileges)
- Write Standard Operating Procedures, and to refine and develop standards where necessary
- Modelling of Logical and Physical Databases, maintaining design documents and diagrams
- Assist developers with SQL and procedural SQL (pl/pgsql)
- Create, maintain, and migrate database objects (tables, views, indexes)
- Develop and maintain good working relations with stakeholders and establish effective communication channels
- Be attentive and look to pro-actively detect and fix problems
Essential skills required to become their Database Administrator
- Bachelor’s degree in Computer Science, Engineering or related field or equivalent work experience in a Database Developer / Database Administrator role
- Knowledge of Relational Database Management Systems (RDBMS), specifically PostgreSQL
- Understand RBMS Concepts such as ACID, Normalisation, Referential integrity
- Understand Data Warehouse concepts; Fact & Dimension tables, ETL
- Proficient in RDBMS Programming Languages: SQL, PL/pgSQL
- Knowledge of Linux/Unix Operating systems and one or more scripting languages (e.g. bash, perl, python).
- Proficient in Database Backup and Recovery, Database Monitoring and Management
- Implement Database Tuning, understand SQL explain plans, column statistics, indexing strategies, and locking models
- Excellent numerical and analytical skills
- Evidence of a systematic, evidence ¬ based approach to database troubleshooting and tuning
- Evidence of well written SQL and procedural SQL (e.g. pl/pgsql,pl/sql, tsql) code
Benefits of becoming their Database Administrator
- 25 days of annual holiday
- Pension through Royal London with 6% company match
- Private healthcare coverage through AXA PPP, with the ability to add family members. The company pays the annual premium for the employee, but the employee is responsible for the full cost additional family members
- Income protection benefits (if employee is unable to work for 13 weeks, he/she will receive 75% of salary for up to 2 years)
- Life insurance at 4 times salary (lump sum payment)
- Subsidised gym membership on site at the Sanger Institute
- Free parking
- Employee can choose own laptop- Apple MacBook Pro or PC (typically Toshiba Portege)
- Flexible working schedule (ability to work from home as needed)
Shortlisting to begin week commencing 06/03/17.
If you feel you are the right candidate for the role as their Database Administrator then please click ‘apply’ now! They’d love to hear from you!