Database Solutions
We have extensive experience developing database applications for enterprise database systems such as MS SQL Server, Oracle, and others. In addition, we can optimize your existing database applications so they perform at their fullest potential. If you have an application that uses a backend database, you need to ensure your database and data tier is reliable and efficient
Our staff has extensive experience developing client specific data driven web-based and client/server applications using n-tier design. We have developed large scale applications for multiple user environments using Microsoft development tools and technologies.
We can also provide Database Administrator (DBA) services for clients who don't have a need for fulltime DBA support. Services can include scheduled maintenance, job creation, data imports, table/index optimization, stored procedure creation, trigger creation, scripting, and more.
Types of Database Services
- Data Modeling
- SQL Profiling - Index optimization
- Complex Stored Procedures and Triggers
- MS Data Transformation Packages and Jobs
- Data Transformation and Integration using XML Web Services, Data Transformation Packages, and others
- Data Migration from legacy systems
- Administration, database security, and troubleshooting
- XML Web Services
Supported Databases
- Microsoft SQL Server (2005/2000/7.0/6.5)
- Oracle 7.x - 10.x
- MySQL
- PostgreSQL
- MS Access - All Versions
- Foxpro, Visual FoxPro datasources
- ODBC Compliant Datasources
