Database Administration

Database design, implementation, security, stability, monitoring, performance, and scalability.

Overview

Managing databases is a key aspect to maintaining a stable application environment. TechPivot provides best-practice database services including design, implementation, security, monitoring, caching, and high availability. We specialize in relational databases including Microsoft SQL Server, MySQL, MariaDB, Oracle, as well as NoSQL based document-stores, key-value, and column stores. Our solutions typically involve lower cost cloud-based infrastructures with corresponding open-source database technology or bare bones solutions that involve low level kernel and application parameter tuning.

Cloud Database
Relational
  • MySQL / MariaDB
  • Oracle
  • Microsoft SQL Server
  • Postgres
NoSQL
  • MongoDB
  • DynamoDB
  • SimpleDB
Caching
  • Memcached
  • Redis
  • Elasticache
Drivers / Abstraction
  • mysqlnd
  • PDO
  • Phalcon PHQL
  • Doctrine
Infrastructure
  • Bare Metal
  • Cloud
  • AWS RDS
  • AWS Aurora
  • Rackspace Cloud Databases
Performance
  • Query Optimization
  • Slow Log Analysis
  • Application Caching Techniques
  • Infastructure Bottlenecks
Stability
  • High Availability / Multi AZ
  • Backup and Restore
  • Replication
  • Clustering
Security
  • Users / Permissions
  • Containers / VPC
  • Encryption — At Rest
  • Encryption — Row Level
  • Key Management