$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
MySQL DBA, specialising in Installation, Performance Tuning and Scaling
Andrew Moore
,
Maiden Newton, United Kingdom
Experience
Other titles
Skills
I'm offering
I’m a dedicated production DBA with a decade of MySQL experience and certification. I’ve worked with small deployments from one to two servers to large enterprise scale deployments of up to 100 instances. I have been exposed to a vast array of technologies from Solaris to Windows and many of the MySQL versions and alternatives such as Percona Server and MariaDB. I love MySQL as a technology due to the inherent flexibility and expansive ecosystem surrounding it. One of the most important aspects of MySQL for me is the community, the bloggers and the collective enthusiasm for open source.
I have delivered presentations on MySQL topics such as Replication, Backup and Recovery and Audit Logging at the North American and European MySQL conferences. I am a great communicator with the ability to adapt my communication style to the audience and situation at hand. I have a background in customer service and experience leading a team. I am a competent communicator with both internal and external customers and am able to convey my point clearly with team members and peers.
I have delivered presentations on MySQL topics such as Replication, Backup and Recovery and Audit Logging at the North American and European MySQL conferences. I am a great communicator with the ability to adapt my communication style to the audience and situation at hand. I have a background in customer service and experience leading a team. I am a competent communicator with both internal and external customers and am able to convey my point clearly with team members and peers.
Markets
United Kingdom
Language
English
Fluently
Ready for
Ongoing relation / part-time
Available
My experience
2013 - ?
job
Remote DBA
Oovavoo.
Specialising in MySQL and alternatives (Percona Server) in the role as remote DBA for multiple clients. Working on industry best practises with clients based around the world with focus in MySQL tuning, SQL query tuning, replication management through use of Percona Toolkit, deployment and monitoring. Security best practices, High availability setup and management through tools such as MHA, Orchestrator, ProxySQL.
Data-Sleek - Remote DBA (Contract)
Data-Sleek - Remote DBA (Contract)
Mysql, Sql, Deployment, Management, Security, Monitoring, Server, Tuning
2017 - 2017
temp
MySQL Database Engineer
DigitalOcean.
July present
Performing inhouse DBA role for the internal Digitalocean cloud database infrastructure.
Performing inhouse DBA role for the internal Digitalocean cloud database infrastructure.
Mysql, Database, Cloud, Infrastructure, Performing
2013 - 2017
freelance
MySQL Consultant
Percona LLC.
MySQL support, consultation and remote management of Percona's clients. Working as part of a team to provide round the clock managed services and support through both the classic support model and a best of breed remote managed services delivery. Performing and advising clients on every such quandary they may have when it comes to MySQL. Taking technical lead roles and regional manager roles during my time with one of the world's premier MySQL consulting companies.
Mysql, Management, Consulting, It, Support, Performing, Tech lead, Manager
2013 - 2013
freelance
MySQL Consultant
unknown.
consulting onsite with a small operations team providing national SIP and VOIP services to clients large abd small. Focussing primarily on liaising with the in-house development team to instill a culture of best practice around the database tier. System audit and configuration recommendations. Full overhaul of disaster recovery practices to introduce previously unseen tools to the company. Implementation of ansible for provisioning Percona Server 5.5 and 5.6 instances. Automation of legacy manual processes. Deployment of monitoring of MySQL specific checks. Other projects such as the conversion of the mysql backend of bind-dlz to powerdns. I also recommended the implementation of mediawiki, version control and graphite into the infrastructure.
Implementation, Backend, Processes, Audit, Server, SIP, Development, Monitoring, Infrastructure, Mysql, Voip, Consulting, Automation, Database, Deployment, Audit, Operations, Backend
2011 - 2013
job
MySQL DBA
The Pythian Group.
Working as part of a team delivering support to clients all over the globe. The clients I work closely with are mainly Linux environments but there also Windows and Solaris users dotted around too. MySQL versions also vary from client to client and we see everything from 4.1 to 5.6.11 across many forks (Percona Server, MariaDB and Oracle). A typical day would be a mixture of project work and support work with pager responsibility through monitoring alerts. Regular communication with clients to ensure that they are satisfied with ongoing work and that actions and tasks are being explained thoroughly to them at their level of understanding. Documentation of processes, procedures including escalation chains for incidents and the tuning of day-to-day tasks through automation or process analysis. This is all whilst collaborating with my team to provide top class support. Atypically of MySQL centric environments there are many 3rd party tools and applications to be familiar with which include but are not limited to
Percona Toolkit
pt-table-checksum
pt-table-sync
pt-query-digest
pt-stalk and sift
pt-online-schema-change
Xtrabackup 2.x
Common_schema
mha - Master High Availability
Linux-HA
Holland Backup Framework
Cacti monitoring
Nagios alerting
Zabbix monitoring
Percona Toolkit
pt-table-checksum
pt-table-sync
pt-query-digest
pt-stalk and sift
pt-online-schema-change
Xtrabackup 2.x
Common_schema
mha - Master High Availability
Linux-HA
Holland Backup Framework
Cacti monitoring
Nagios alerting
Zabbix monitoring
Mysql, Linux, Oracle, Automation, Windows, Mariadb, Support, Monitoring, Backup, Nagios, Online, Server, Tuning, Framework, Processes
2013 - 2013
freelance
Ireland- MySQL Consultant
SmartBox.
I spent a week with Smartbox in a consultant capacity. During the short spell there I identified concurrency issues with the version of MySQL running in production and we performed minimal downtime upgrades and provided performance enhancements through configuration tuning. I revamped the backup approach to cover disaster recovery requirements set by the business. I also delivered training sessions on many tools required by the MySQL DBA such as Percona Toolkit, Nagios and Cacti plugins for monitoring and trending.
Mysql, Training, Monitoring, Backup, Nagios, Production, Tuning
2008 - 2011
job
Production DBA
Nokia.
Supporting multiple, always-up, live environments spread across Linux, Windows, SQL Server and MySQL. Day-to-day DBA operations and project work. Areas of knowledge include;
MySQL 5.1 administration
Replication
Cluster
Enterprise Monitor
Xtrabackup
Linux (Red Hat Enterprise Linux, Fedora, Ubuntu Desktop and Server)
DRBD installation and configuration
Linux-HA installation and configuration (heartbeat)
RedHat/Centos Cluster Suite
BASH Scripting
SQL Server 2005 / 2008 administration
Mirroring
Replication
Reporting Services
Integration Services
Profiler
Other
Oracle Virtual Box
CSS
HTML
Some experience with PHP, Python and Ruby on Rails
MySQL 5.1 administration
Replication
Cluster
Enterprise Monitor
Xtrabackup
Linux (Red Hat Enterprise Linux, Fedora, Ubuntu Desktop and Server)
DRBD installation and configuration
Linux-HA installation and configuration (heartbeat)
RedHat/Centos Cluster Suite
BASH Scripting
SQL Server 2005 / 2008 administration
Mirroring
Replication
Reporting Services
Integration Services
Profiler
Other
Oracle Virtual Box
CSS
HTML
Some experience with PHP, Python and Ruby on Rails
Ruby on rails, Oracle Virtual Box, SQL Server 2005, UP, Enterprise, Production, Server, CentOS, Ubuntu, Windows, Integration, Bash, SoMe, Html, Scripting, SQL Server, Oracle, HTML/CSS/Javascript, Operations, Linux, Administration, Sql, Python, Mysql, Php, Css
2005 - 2007
job
Technical/Customer Support | Database Engineer
Civica Public Protection.
During my time at Civica I supported both internal customer and external customer infrastructure, providing 3rd line support for two database technologies, Sculptor and SQL Server 2000 across Unix, Linux and Windows Operating Systems. In a Technical Consultant role I was tasked with visiting customer sites for installation and maintenance.
Sql, Linux, SQL Server, Unix, Database, Windows, Support, Infrastructure, Server, Customer
2003 - 2005
job
Phone based technical support
Virgin Mobile.
for the Virgin Mobile Network. Technical assistance and account management centring around mobile phone usage, sales and services. During my time at Virgin Mobile I underwent training programmes on customer service and also learned about how mobile telephone infrastructure exists and operates through a CBT program named 'Osidian'.
Account management, Training, Management, Customer service, Sales, Service, Network, Support, Infrastructure, Customer
My education
Wiltshire College Trowbridge
Hndhncorequivalent, Marketing, Business Information Studies and Computational Methods
Hndhncorequivalent, Marketing, Business Information Studies and Computational Methods
St Augustines Catholic College
Secondary, English and Maths
Secondary, English and Maths
Andrew's reviews
Andrew has not received any reviews on Worksome.
Contact Andrew Moore
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Andrew directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark