Database Administration

We can provide substantial improvements in system performance without making changes to existing applications or underlying hardware.

Whether the database feeds a website, an application, or a traditional ERP system—we can make it better!

We also assist with automated report generation, professional and accurate data analysis, cross-database migrations, scheduled backups, security, access auditing, and clustering for high-availability.

Database Development

Development

  • Schema Development
  • Database Normalization
  • Triggers
  • SQL Queries
  • Stored Procedures
  • Database Conversion
Database Reporting

Reporting

  • Crystal Reports
  • Jasper Reports
  • Microsoft Access Reporting
  • Microsoft Reporting Services
  • Automatic PDF Generation
Database Administration

Administration

  • Automated Verification and Backup
  • Clustering
  • Installation
  • SQL Server Integration Services (SSIS)
  • Oracle Recovery Manager (RMAN)
  • Upgrades
MySQL

MySQL

  • Native Full Text Search
  • Native Geospatial Support
  • Powers the Web
  • Platform Independent: Runs on Linux, Solaris, Windows, Apple OS X, BSD Unix, AIX, HP-UX...
  • Supports Database Clustering
  • Free Open Source (GPL)
Microsoft Access

Microsoft Access

  • Integrated Forms
  • Built-in Reporting
  • Easy Upgrade Path to Microsoft SQL Server
  • Scriptable with Microsoft Visual Basic (VB)
  • Integrates Seamlessly with Microsoft Office
  • Perfect for single-user database applications
  • Ideal for Light Database Work
Microsoft SQL Server

Microsoft SQL Server

  • Native Full Text Search
  • Native Geospatial Support
  • No need for Crystal Reports with SQL Server's web-based reporting server: Microsoft Reporting Services
  • Simplify maintenance tasks such as backup and notifications with SQL Server Integration Services (SSIS)
Oracle Database

Oracle Database

  • Native Full Text Search
  • Platform Independent: Runs on Linux, Solaris, AIX, HP-UX, and Windows.
  • Oracle Data Guard Stand-By Databases
  • Oracle Recovery Manager (RMAN) Automated Backup and Recovery
  • Powerful Query Language and Rapid Application Development Using PL/SQL
  • Oracle Application Express (APEX) Rapid Web-Based Application Development
  • Oracle Real Application Clusters
  • Vendor Support Options
MariaDB

MariaDB

  • Native Full Text Search
  • Native Geospatial Support
  • Platform Independent: Runs on Linux, Solaris, Windows, Apple OS X, BSD Unix, AIX, HP-UX...
  • Supports Database Clustering
  • Free Open Source (GPL)
PostgreSQL

PostgreSQL

  • Native Full Text Search
  • Native Geospatial Support
  • Platform Independent: Runs on Linux, Solaris, Windows, Apple OS X, BSD Unix, AIX, HP-UX...
  • Supports Database Clustering
  • Free Open Source (PostgreSQL License)