Principal Database Administrator
CurrentI manage the MySQL and PostgreSQL databases which store the scientific data which are generated, analysed and shared with the world by the Sanger Institute.- Managing and monitoring 300 MySQL instances and 80 PostgreSQL clusters.- Designing and implementing strategies to ensure the high availability of databases which support mission-critical services such as 24x7 laboratory pipelines and high-profile public web sites.- Analysing and optimising the performance of the database servers, including tuning of the host operating system and back-end block storage.- Identifying performance bottlenecks in database client code and advising on optimisation of SQL queries.- Developing and implementing procedures to automate the monitoring and testing of daily backups.- Liaising with software development teams to advise them on best practices for database client software.- Creating and presenting training courses for colleagues to help them make effective use of databases.- Learning and applying new ideas and techniques in MySQL and PostgreSQL by studying best-practice blogs and attending conferences.RECRUITERS PLEASE NOTE: I don't do SQL Server. Please don't contact me about SQL Server jobs. I also don't add connections who are not known to me personally. Please don't be offended; use LinkedIn messaging instead.
