Services

Planning:

Capacity planning, schema design, server design, security and growth plans.

Performance:

Performance analysis, query tuning, server tuning and process tuning.

Scale:

Horizontal and vertical strategies, replication, sharding and clustering solutions.

Availability:

Backup and recovery, clustering, standby and failover solutions with a focus on simplicity and process.

Monitoring and Trending:

Commercial, open source and bespoke solutions including Nagios, Cacti, Ganglia and Oracle Enterprise Manager/Grid Control.

Migration:

• Oracle to MySQL
• MySQL to Oracle
• PostgreSQL to MySQL
• MySQL to PostgreSQL

Processes and Compliance:

• Documentation
• Data governance and architecture
• Sarbanes-Oxley, HIPAA and PCI compliance
• ITIL

Databases:

• MySQL community and enterprise, MariaDB and Percona XtraDB
• PostgreSQL 8 and 9
• Cassandra
• MongoDB
• Hbase/Hadoop
• Couchbase

Technologies:

• Scripting in shell, python, C and perl.
• Red Hat, Debian, Centos, Ubuntu, FreeBSD, Gentoo
• Amazon EC2, EBS, RDS
• Rightscale hosted
• LVM, XFS
• Nagios, Cacti, Ganglia and Zabbix
• Text searching with Sphinx, Solr, Lucene
• Memcached and Membase
• Configuration management with Git, Puppet and SVN