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.

Processes and Compliance:
· Documentation
· Data governance and architecture
· Data governance and architecture
· Sarbanes-Oxley, HIPAA and PCI compliance
· ITIL

Technologies:

· Mysql 3x, 4x, 5x.
· Mysql Replication (simple, master/master, tiered etc…)
· Mysql View, Triggers and Stored Procedures
· Oracle 8, 9 and 10.
· Oracle Real Application Clusters
· Oracle RMAN
· Oracle Enterprise Manager and Grid Control
· Oracle PL/SQL, triggers and stored procedures
· Scripting in shell, python, C and perl.
· Red Hat, Debian, Centos, Ubuntu, FreeBSD, Gentoo
· LVM
· Nagios
· Cacti
· Ganglia· Nagios
· Sphinx, Solr, Lucene
· Memcached
· Git, Puppet and SVN