Database Consulting

databaseWe have extensive expertise in designing and implementing solutions on multiple database platforms, for enterprises ranging from small businesses using 4D (4th Dimension) to multinational corporations using Oracle. In the early stages, we’ll develop a database architecture that details systems requirements, hardware specifications, disk assets and allocation, and backup strategies. We’ll perform tuning on new and existing database servers to assure optimal performance across your enterprise as well as manage the full suite of database and systems administration requirements.

 

Examples of the issues we can help you manage:

  • How many database machines and what networking configuration will be required to provide support for multiple locations?
  • What type of replication/redundancy plan will be necessary to ensure non-stop operation?
  • How much disk capacity will be required to meet operational needs this fiscal year given your company’s growth rate? Two years out? What is the best disk configuration to maximize I/O performance?
  • What disaster recovery strategy should you use to minimize the effect of a catastrophic failure?
  • How much and what types of monitoring is useful for database systems?

 

We’ll help implement a database strategy tuned to your specific business and application requirements that will help you better utilize data, optimize system resources, ensure required performance, and grow as your business grows.

 

Our expertise includes:
  • Oracle Certified Professional (OCP) (Oracle 7 through Oracle 9i)
  • Oracle 9i, 8i, 8, 7
  • Oracle Parallel Server
  • Oracle Enterprise Manager
  • Oracle RMAN
  • Oracle Infrastructure
  • MySQL 3.x to current
  • PostgreSQL current
  • Sybase 4.x
  • 4D Server
  • Specification
  • Installation
  • I/O tuning
  • SQL tuning
  • Monitoring
  • Backup
  • Standby
  • Replication
  • Stored procedures