DSSI provides world-class database support and consulting services that are customized according to the needs of your company. Our employees have extensive production experience with Oracle, Sybase, Sybase IQ, Microsoft SQL Server, and Informix. We can help with every facet of a database project, from initial design and interface development, to installation, to on-going preventative maintenance and problem solving.

We're known for our experience and leadership in quickly connecting large, intricate databases to web based applications, as well as for constructing solid database foundations for information management systems. We are proficient in the tools we use and experienced in our development methodologies. Once in production our ongoing support services can be deployed to monitor your system, respond to emergencies, and fix small problems before they become big ones.

Our role as an independent, objective consultant combined with our major account "maturity" assures you that turf battles amongst data owners will not prevail over a design that meets the business need. The right database design can put an end to tasks that waste your limited resources. The right design eliminates having to enter the same information multiple times into separate, disparate computer systems, or having to look up information in multiple places to complete a task.

In addition to design, development and initial setup, we can provide on-going preventative maintenance services like upgrade management and tuning. Our problem detection techniques and DSSI developed tools have made us successful in supporting some of the most complex and sophisticated databases with minimal downtime. Our ability to automate Oracle and Sybase database administration tasks allows our highly-trained developers and DBAs to constantly monitor your databases, identifying problems and installing fixes before they affect your end-users. Our staff can work at your site or do the job remotely from ours.

 
 

DSSI Database Offerings:

DSSI provides database services across multiple products and platforms. We currently support mission critical applications for the financial sector and also provide complete Oracle, and Sybase support for a media company based in Phoenix. DSSI typically combines a sophisticated set of proprietary scripts and code that can completely automate reporting, capacity planning and issue proactive alerts with our experience to apply them appropriately in each customer situation. By addressing the conditions that cause an outage before your database crashes, the probability of a databases outage is dramatically reduced. The functions that we administer include the following:

  • Database design and modeling
  • Hardware and software evaluation, sizing, and recommendations
  • Data import and export
  • Backups
  • Restores
  • Disaster Recovery
  • Full, upgrade, and patch installation
  • Monitoring (up to 24 x 7)
    • Error logs and files
    • Processes
    • Events
  • Proactive maintenance
    • Thresholds including transaction logs, rollback segments, and data segments
    • Object space allocation
    • Monitor the growth of tables, indexes, and tablespaces/databases
    • Monitor and ensure the validity of objects
  • Troubleshooting
  • User and account maintenance
  • Security and permissions management
  • Object creation and migration
  • Re-indexing and rebuilding indexes
  • Performance Tuning
    • Monitor SGA usage and recommending tuning actions (Oracle)
    • Monitor key performance indicators and recommending tuning actions
    • Monitor sort performance
    • Monitor Server (Sybase)
  • Capacity Planning
  • Database copying and cloning
  • System audits
  • Fault management and HA
  • Replication
  • Analyze and update statistics
  • Virtual DBA services via Virtual Private Networking (VPN) hardware installation and support
  • Mentoring and training