Banner Image

All Services

Programming & Development

Database Administrator

$15/hr Starting at $25

I am a new bud to freelancing with around 5 years experience in Databases. I am currently employed and not disclosing my identity. I can manage, tune and maintain your database servers. I am good at migrating servers from one datacenter to other with least possible downtime. I could tune the configuration parameters of MyQL to suit the application. Including optimising the InnoDB engine for excellent performance. I could compress your database tables if there is a space crunch. The different compression techniques include InnoDB compression, converting the tables to TokuDB engine and finally the RocksDB engine implementation of WebscaleSQL which supports maximum compression. I could log all the slow queries, collect them and tune them to suggest perfect indices for them. I could identify unused, unwanted indexes and suggest to remove them as they take up unwanted space and slows down writes. I could help you migrate from MySQL to mariaDB, MySQL to percona and vice versa with zero or very minimal downtime. And even from one datacenter to another. I could help you with a good backup strategy including Percona XtraDB Backup, mysqldump and LVM snapshots. I could also automate them using scripts. And last but not the least I could help you with automating the day to day time consuming database and linux activities. My strong suggestion is that automation is the key to success. By automating your day to day activities you save a huge amount of time and avoid human errors.

About

$15/hr Ongoing

Download Resume

I am a new bud to freelancing with around 5 years experience in Databases. I am currently employed and not disclosing my identity. I can manage, tune and maintain your database servers. I am good at migrating servers from one datacenter to other with least possible downtime. I could tune the configuration parameters of MyQL to suit the application. Including optimising the InnoDB engine for excellent performance. I could compress your database tables if there is a space crunch. The different compression techniques include InnoDB compression, converting the tables to TokuDB engine and finally the RocksDB engine implementation of WebscaleSQL which supports maximum compression. I could log all the slow queries, collect them and tune them to suggest perfect indices for them. I could identify unused, unwanted indexes and suggest to remove them as they take up unwanted space and slows down writes. I could help you migrate from MySQL to mariaDB, MySQL to percona and vice versa with zero or very minimal downtime. And even from one datacenter to another. I could help you with a good backup strategy including Percona XtraDB Backup, mysqldump and LVM snapshots. I could also automate them using scripts. And last but not the least I could help you with automating the day to day time consuming database and linux activities. My strong suggestion is that automation is the key to success. By automating your day to day activities you save a huge amount of time and avoid human errors.

Skills & Expertise

BackupDatabase MaintenanceDatabase TuningHelpdeskLinuxLvmMariaDBMySQLMySQL ClusterPerconaSpace PlanningStrategyTable Design

0 Reviews

This Freelancer has not received any feedback.