Intechgra offers a number of database engineering and administrative services. In the case of many of the more common tasks, we use proprietary processes and tools we have developed to streamline the task. These well documented procedures save time and money and lead to an increase in final deliverable quality. From simple one time tasks to long term projects, Intechgra provides high-quality, cost-effective solutions.

Pre-Purchase Planning

Intechgra will analyze your software, hardware, business, and budgetary requirements and assist you in choosing the right Relational Database Management System (RDBMS) at the most cost effective price. We will deliver a document detailing your requirements, the available systems that most closely match those requirements, and our recommendation.

[ return to top ]

Physical Layout and Operations Planning

Intechgra will assist in planning the physical layout of the databases on your system to optimize performance by minimizing I/O contention. We will analyze your existing system and database metrics to understand your usage patterns and identify bottlenecks. If you are implementing a new system we will work with you to design a layout plan to meet your expected usage patterns. The deliverable from this service is a Physical Layout Plan document.

[ return to top ]


Database Migration

Intechgra will configure a set of tools and processes to migrate your data from a database on one platform to another platform with minimal impact to your business. We will consider your source and target databases to determine the safest and least disruptive migration strategy. We will establish requirements for all aspects of the project including hardware, database, and timeline. The resulting plan will fully describe the chosen migration methodology and include a detailed implementation plan. The plan identifies each task in the migration process, including who is responsible to perform each task and when.

Deliverables for this service include:

• Migration Requirements Document
• Migration Plan
• Test Acceptance Plan
• Execution of Installation Plan
• Cerification of Test Acceptance Plan

[ return to top ]


SQL Consulting

In a complex database, getting a SQL statement that can dig out the required information can be a vexing task. This can be especially true when the statement must contain multiple outer joins, data based calculations, and data transformations. Making that statement run in an acceptable amount of time without making the lights dim in a three city block radius can be even more challenging. No matter which SQL dialect your database speaks, Intechgra's SQL craftsmen can tame even the most complex SQL problem.

We can provide help with performance tuning of existing SQL, objects and scripts to optimize reports, Electronic Data Interchanges, data warehouse population and batch processing jobs to name but a few applications.

[ return to top ]


Data Warehousing and Acquisition

Intechgra's database engineers provide a wide range of assistance in data warehouse and data mining operations. Our services include physical and logical warehouse design, implementation, initial load strategies and scripts and operations, update process design and development, and data transformations and optimizations.

We can also assist your development of warehouse access tools, reports, and processes.

[ return to top ]


Hot Standby and Failover Databases

Business continuity requirements sometimes call for specialized system configurations. Intechgra will assist you in configuring and implementing a hot standby or failover database to ensure continuous operation of your business in the event of system failure. We will provide all documentation and tools required to implement and maintain your standby database.

Deliverables for this service include:

• Failover Database Implementation Plan
• Test Acceptance Plan
• Execution of Implementation Plan
• Certification of Test Acceptance Plan

[ return to top ]