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, Ganglia and Oracle Enterprise Manager/Grid Control.

Technologies:

· Mysql 3x, 4x, 5x.
· Mysql Replication
· 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 and perl.
· Red Hat, Debian, Centos
· LVM
· Nagios
· Ganglia