I am a flexible and experienced software developer and database administrator working with MySQL and PostgreSQL on Linux to solve large-scale data processing and management challenges, with a strong commitment to user support. I have worked with MySQL since 2001 as a database administrator and as a database application developer.In my current role, I am responsible for the management of 300 MySQL instances and 80 PostgreSQL clusters which support the high-throughput scientific workflows and web-based public data services of the Sanger Institute. Together, they represent three-quarters of the scientific database capacity at the Institute.I have many years of practical experience in:- Management and monitoring of high-availability database services;- Automation of backup, restoration and disaster-recovery procedures;- Design, development and optimisation of database schemas;- Configuration and performance tuning of InnoDB;- SQL query optimisation to improve the performance of database client software;- Linux system management and performance tuning;- Automation of tasks on Linux systems using Bash, Python and Perl scripting;- Application development on Linux in C, Java, Python and Perl.I began working with computers 40 years ago. I have developed significant projects using eleven programming languages and seven major operating systems. I have experience of systems administration and software installation on Linux, Windows and OS X.Specialties: MySQL, PostgreSQL, Python, Perl, Linux, Bash, Unix, LDAP, Java, C, Fortran, dynamical astronomy, user interface design, project managementNOTE TO RECRUITERS:1. Please do not send requests to join my network. I only add people who are known personally to me.2. Please do not send job ads for DBA roles that require SQL Server expertise. I have never worked with SQL Server, and my MySQL and PostgreSQL skills are not readily transferable.
Listed skills include Perl, Unix, Linux, Mysql, and 35 others.