Database Management

 

Database Management

 

USAccess, in collaboration with its Database Management Services Partner, will lead your company in the design, build and management of a custom database solution.  In conjunction with our database management services, we also offer hosting of large-scale mission critical database application systems in our privately owned secure data center. Our development team has over 100 experienced professionals with engineering skill sets in all of the major database technologies.  Our group will provide your company with all the logical and physical design choices, and physical storage parameters needed to create an efficient cost effective database. The database design will incorporate growth metrics to meet future demands for scalability, best practices to underwrite business security risks, and legal requirements for protection of data integrity.

 

Example Project for Replication / Hosting / Warehouse Construction

 

Phase I Tasks – Oracle Database Replication and Hosting

  • Configure Network Environment
  • Establish Secure WAN Connections
  • Configure Oracle Database Environment
  • Configure Hardware Environment
  • Replicate Current Database in Hosted Environment
  • Audit Replicated Database Hosted Environment
  • Establish Replication/Update Methodology for Oracle Database
  • Test and Measure Performance of Hosted Oracle Database
  • Establish User Connectivity with Hosted Oracle Database
  • Acquire Necessary Software Licenses
  • Establish User Support Processes and Operational Documentation

 

Phase II Tasks – MySQL Data Warehouse Construction

  • Establish Data Warehouse Tables
  • Establish Schema
  • Build ETL Processes for Loading Data
  • Establish Update Methodologies
  • Audit Data Warehouse Environment
  • Analyze User Query Requirements
  • Test and Measure Performance of Data Warehouse Environment
  • Establish Aggregations & Materialized Views
  • Configure User Tools – Business Objects
  • Finalize User Support Processes and Operational Documentation
a
Secure Datacenter Environment
  • SLA – 99.9% Production & Development Server Up-time
  • SLA – 100% Network Up-time
  • Hardware Maintenance (1 Hour Replacement)
  • Technical Support
  • Operations (Data Backup, Retention)
  • Security (WAN, Firewall, IDS, Virus Protection, Data Encryption)