MEDISOLV PROFESSIONAL SERVICES  


Report writing services
Virtual SQL DBA Implementation Services
Virtual SQL DBA Remote Administration Services


Virtual Report and Indicator Writing Services

Medisolv RAPID and IndiGo both permit you to develop your own adhoc reports and indicators using Microsoft SQL Reporting Services or Advanced Indicator Builder respectively. While these powerful tools enable you to generate reports and indicators from any ODBC compliant data source, often clients can't find skilled resources locally to hire, don't have budget for a full time person in this position, or simply need help with more complex reports and indicators. If you have purchased RAPID or IndiGo, Medisolv is always ready to help. Our report and indicator developers are highly skilled at using Reporting Services and Advanced Indicator Builder to meet the needs of our clients in generating reports from the Data Repository and other sources. Chances are they have already built a custom report similar to the one you need enabling them to generate your report more quickly than you could ever hope to do on your own.

Virtual Report Writing Services can be purchased in a number of ways:

• You may purchase hours of service on a time and materials basis.
• You may have already purchased a block of hours as part of your RAPID and IndiGo license agreement.
• You may purchase additional blocks of hours of service at a discounted rate starting with blocks as small as 20 hours.
• You may purchase report writing on a subscription basis starting with 20% of an FTE for a 12 month minimum contract term.

Virtual SQL DBA Services for the MEDITECH Data Repository

Hospitals everywhere are finding it difficult to attract and retained good IT staff. If you are implementing the MEDITECH Data Repository or the MEDISOLV Datamart, someone on your team needs SQL skills to support and administer the database, yet it may not be a full time job.

With MEDISOLV's Virtual SQL DBA services you can be assured that your SQL database is being implemented and supported by competent professionals who are thoroughly familiar with your MEDITECH Data Repository making it easier and faster for you to move forward with Data Repository implementation:

• No need to pay a recruiter to find someone with the right technical skills
• No relocation costs to move someone to your area
• No time lost waiting for someone to start before you can move forward with implementation
• No training costs to teach them about MEDITECH or the Data Repository
• And you don't have to hire an entire person when you only need a fraction of an FTE

With MEDISOLV's Virtual SQL DBAs and remote SQL Server support services, you can be assured that your SQL database is receiving proactive attention from highly skilled resources that are responsive to your needs. Client will be responsible for installing all servers with remote VPN access for MEDISOLV and will be required to load physical media for the SQL database so that MEDISOLV can install and configure SQL remotely. MEDISOLV provides the following comprehensive database support services during standard business hours.



Virtual SQL DBA Implementation Services

The following services will be provided during your MEDITECH Data Repository configuration and throughout your Test and Live Initial Loads (Ils).

• Install and configure the MEDITECH Data Repository SQL server instance for Test and Live or for Medisolv installations configure the Medisolv Datamart SQL server instance in live.
  
  
• Set up initial security including:
  • Users
  • Roles
  • Privileges
• Provide initial monitoring and validation of performance:
  • CPU and Disk Utilization
  • Memory usage
  • Services and Processes
  • Event Log
• Provide reports as required covering:
  • Server Availability
  • Server Health
  • Database Statistics
  • Alert Summaries

Virtual SQL DBA Annual Maintenance and Support Services

The wealth of information in your MEDITECH Data Repository can bring great value to your enterprise only if it remains available and accessible. After initial SQL database implementation, clients need ongoing proactive management of their databases. MEDISOLV will provide ongoing support of the following functions related to the SQL database that the MEDITECH Data Repository resides in:

• Review and Assessment of existing backup and recovery plans
• Review and Assessment of existing disaster recovery plans
• Review and Assessment of SQL security including:
  • Users
  • Roles
  • Privileges
• Perform SQL Server Database Conversions from SQL 2000/2005 to 2008
• Implement all patches as made available to eliminate security vulnerabilities and known errors
• Assist in production and test database recoveries
• Provide ongoing proactive remote monitoring and alert notification services for:
  • CPU and Disk Utilization
  • Memory usage
  • Services and Processes
  • Event Log
• Provide ongoing database health management:
  • Indexes
  • Statistics
  • Fragmentation
  • File size
• Provide comprehensive monthly reviews and reports (i.e. Server Availability and Health, Downtime History, Server Utilization, Database Stats)
• Manage security changes including users, roles and privileges
• Assist in coordination and implementation of MEDITECH upgrades

If you have interest in these services, please contact sales@medisolv.com or dial 443-539-0505 x30 if you are a new client; or call your support coordinator if you are an existing client.